connection string

[s4dadmin]

I have just installed mysql and I am getting an error with my connection string. Using W2K Pro. I have downloaded myodbc but I would like to use a dsn less connection.

In global.asa this is the code
Sub Application_OnStart
Application("DBCONN&quot="Driver={MySQL);SERVER=localhost;DATABASE=test;UID=cuexxx;PWD=xxxxxx;Extended Properties='OPTION=16387'"
Application("AllHits&quot = 0
End Sub

and in the page it is

Sey myConn = Server.CreateObject("ADODB.Connection&quot
myConn.open("Application("DBCONN&quot)

Here is the error

Error Type:
Microsoft OLE DB Service Components (0x80040E73)
Format of the initialization string does not conform to the OLE DB specification.
/includes/stat_track.asp, line 11

 

[sleipnir214]

Part of it might be your mis-matched brace/parenthesis combination in your connection string.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[s4dadmin]

How should it be coded?

 

[ianrobson]

I had a similar problem. Have you tried changing the "localhost" to your ip address?

 

[ianrobson]

Sorry, I should have said

Have you tried changing "localhost" to the ip address of your mysql server?

 

[QatQat]

Here is the correct string


if you want to use a DSN


<%
Set MyConn = Server.CreateObject(&quot;ADODB.Connection&quot
MyConn.Open &quot;DSN_name&quot; , &quot;user&quot;, &quot;password&quot;
%>


if you want a DSNLess connection

<%
Set myConn = Server.CreateObject(&quot;ADODB.Connection&quot
myConn.Open (&quot;Driver={MySQL}; SERVER=192.168.x.x; DATABASE=DBname; UID=username; PASSWORD=password&quot
%>


and forget about global.asa
You only need global file if you are planning on using InterDev connection features which I don't recommend.


Bye


Qatqat



The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[s4dadmin]

I tried using the I.P. address of mysql server instead of localhost, but it didn't work at first. I created a DSN and it worked fine. Now I will go back and try the DSNless connection QatQat. Thanks!