RE: [cobalt-users] RAQ4: ASP + MySql

["Ervin Tarkhanian" <ervin@xxxxxxxxxx>]

Hi Jackson,

You're probably better off just using a connection string without the DSN.
A DSN-less connection to your database eliminates the entire ODBC layer,
resulting in higher performance under heavy loads.

Try this in place of your DSN in your ASP code:

MyDSN =
"driver={MySQL};server=Server.IP.Address;UID=MyUserName;Password=MyPassword;
database=MyDatabaseName;"

Obviously replace the above placeholders with your valid info.

This works fine for me.  I couldn't get the DSN to work either, but it
cleared up after one of the patches I installed, sorry I don't remember
which one.

Best regards,
Ervin Tarkhanian

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of jtsai@xxxxxxxxxxxxx
Sent: Wednesday, September 26, 2001 6:25 PM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: [cobalt-users] RAQ4: ASP + MySql


Hi Sir,

I have problem of my RAQ4 with ASP(ChiliSoft)+ MySql.

I follow "ASP+MySql HowTo" step bye step, at the end of testing DSN, I get
error.
errot message as:
/**********************


server - default Test DSN - TestDSN-mysql


----------------------------------------------------------------------------
----




Test connecton failed


Error: -2147418113 Description: Can not load OBDC driver


*******************************/


Please, if anyone know about it?


Jackson Tsai

_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users