Working with ACCESS databases

[arlequin]

Hi people!!

I know I can work with MS ACCESS databases using the ODBC or using the name and the path of the MDB file.

How can I work with the ADODB.Connection properties?



Many Thanks!!! Arlequín
arlequin@montevideo.com.uy

http://www.arlequinadas.com

 

[palbano]

Arlequin,

You put the same connection information in the Connection.Open() method then use the 'Connection' object as the parameter to Recordset.Open(), i.e.,

var conn = Server.CreateObject("ADODB.Connection"
conn.Open( connectString);
var rs = Server.CreateObject("ADODB.Recordset"
rs.Open( "Select * from Authors", conn, .....);

Hope this helps
-pete

 

[culshaja]

I would use explicit setting of properties rather than passing the information as parameters to methods. It means writing a few extra lines of code, but it is more efficient and more maintainable.
Try:

dim cnDBCon, rsResults
 
SET cnDBCon = Server.CreateObject("ADODB.Connection")
cnDBCon.ConnectionString = "DSN=myDSN;"
cnDBCon.CursorLocation = 3
cnDBCon.Open

Set rsResults = Server.CreateObject("ADODB.Recordset")
Set rsResults.ActiveConnection = cnDBCon
rsResults.Source = "SELECT * FROM myTable"
rsResults.Open

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[arlequin]

MANY THANKS
BOTH OF YOU GUYS...


but...

so.. in the DNS I put my DNS name that points to my Access database?

Arlequín
arlequin@montevideo.com.uy

http://www.arlequinadas.com

 

[culshaja]

Yes, thats correct.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[palbano]

> so.. in the DNS I put my DNS name that points to my Access database?


Well you probably just typoed but to make sure: ;-)

DNS (Domain Name Server)
DSN (Data Source Name)

You are using a DSN

-pete

 

[arlequin]

hahahahahaa...
thanks pete....

I'm always getting confused with Domain NAme Server and Data Source Name...

LOL...

OK...
let's say that I have to point to my DSN...

ok? Arlequín
arlequin@montevideo.com.uy

http://www.arlequinadas.com