Forums

This topic is locked

DSN-less connections to mySQL - how?

Posted 19 Apr 2001 05:41:27
1
has voted
19 Apr 2001 05:41:27 Steve Davis posted:
Hey,

Just getting the hang of mySQL. Got it running under Win2000 running Apache/Chili!soft.

Using Access, a DSN-less connection string looks like: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/db/database.mdb"

Can anyone give me the string for a mySQL DSN-less connection?

Just for my own enlightenment, where do you find this info?

Me? I can't even spell ASP!

Replies

Replied 20 Apr 2001 13:42:49
20 Apr 2001 13:42:49 Bjorn Fripon replied:
Hi down-under,

Q1 :
Try this ...
MySQL DSNless connection

driver={mysql}; database=yourdatabase;uid=username;pwd=password;option=16386;

Q2 : where
Try this ...

www.basic-ultradev.com/articles/ADOConnections/


greetz,

Jezter/Bjorn

PS : their book is also cewl

Replied 24 Apr 2001 04:48:13
24 Apr 2001 04:48:13 Steve Davis replied:
Thanks for that and I had already found the answer.

Me? I can't even spell ASP!

Reply to this topic