Groups | Blog | Home
all groups > sql server connect > september 2003 >

sql server connect : mysql and ASP


Dinesh.T.K
9/3/2003 11:40:08 AM
Passero,

See

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForMySQL

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]

Dinesh.T.K
9/3/2003 1:01:39 PM
Passero,

This is a SQL Server forum and you may want to post at a MySQL
site(http://www.mysql.com/support-and-consulting.html)

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]

Derek Shi
9/3/2003 1:33:24 PM

Try creating a .udl file on your computer (create any txt
file and change the extension '.txt' to '.udl'). Then
open Property of this file and click on Connection page.
Fill out the page and connect the database. If it
works, you can open the udl file as txt file and the
connection string should be on the first line of the
file. Replace your current connection string with this
new line.

Hope it works.

Derek

[quoted text, click to view]
{MySQL};SERVER=mysqlhost;DATABASE=myDB;UID=userID;PASSWORD
=pasword"
[quoted text, click to view]
Passero
9/3/2003 4:29:33 PM
Hi all, i've just set up an mysql server on my computer and now i want to
connect to a mysql database with an ASP page but i can't find the correct
connection string. I always get an error that the datasource can not be
found.

ConnString =
"Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID=userID;PASSWORD=pasword"

What's wrong with it?

Passero
9/3/2003 5:00:22 PM

"Dinesh.T.K" <tkdinesh@nospam.mail.tkdinesh.com> schreef in bericht
news:uXSeKojcDHA.3520@tk2msftngp13.phx.gbl...
[quoted text, click to view]
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriv
erForMySQL
[quoted text, click to view]

It doesn't work. That's my string:

ConnString = "Driver={mySQL};" & _
"Server=localhost;" & _
"Option=16834;" & _
"Database=digipen"

the database exists and the surver is running....

[quoted text, click to view]

Erland Sommarskog
9/3/2003 9:59:13 PM
[posted and mailed]

Passero (yanongena@pandora.be) writes:

[quoted text, click to view]

No idea, but you are probably more successful in getting an answer if
you ask in a forum devoted to MySQL. You posted your question in groups
related to MS SQL Server.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
AddThis Social Bookmark Button