E
Evan
Hi guys... I am developing an application and need some advice while
the application is still in its infancy.
1. Set Conn = Server.CreateObject("ADODB.Connection")
2. Conn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("documents.mdb")
3. Set rs = Server.CreateObject("ADODB.Recordset")
4. SQL="SELECT * FROM users"
6. rs.close
7. set rs=nothing
My question is... is this the most efficient way to connect to the DB
and shouldnt I be closing my Conn... cause when I try the system says
that the obj doesnt exist...
Any advice would be appreciated !
Evan
the application is still in its infancy.
1. Set Conn = Server.CreateObject("ADODB.Connection")
2. Conn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("documents.mdb")
3. Set rs = Server.CreateObject("ADODB.Recordset")
4. SQL="SELECT * FROM users"
6. rs.close
7. set rs=nothing
My question is... is this the most efficient way to connect to the DB
and shouldnt I be closing my Conn... cause when I try the system says
that the obj doesnt exist...
Any advice would be appreciated !
Evan