garycrunk
Posts: 23
|
| Posted: 04/23/2007, 11:10 AM |
|
I currently run several websites using Codecharge Studio, ASP and MS-Access Databases. They all work very well.
I am now trying to work now with the same but using a MySql Database. I CAN connect to the database at Design-Time and design the pages. But after I upload / publish the files, and try to use them onine, I get:
Unable to establish connection to database.
* Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
In my COMMON.ASP file, I have the connection as:
ConnectionString = "Provider=MSDASQL.1;Password=mypassword;Persist Security Info=True;User ID=myuserid;Data Source=databasename"
User = "myuserid"
Password = "mypassword"
Set Converter = New clsConverter
Converter.DateFormat = Array("mm", "/", "dd", "/", "yyyy", " ", "HH", ":", "nn", ":", "ss")
Converter.BooleanFormat = Array("true", "false", Empty)
Set objConnection = Server.CreateObject("ADODB.Connection")
Set Errors = New clsErrors
Can anyone give me a clue as to what I should change my Connection String to so it will connect to my Database. For examiner, my server name is mysql11.myhost.com
Am I using the wrong Provider??? I am new with Mysql ( I have used PHP connection schemes before, but I've not been successful with ASP and MySql...)
Thanks in advance
Gary Crunk
_________________
Gary Crunk
Job Examiner |
 |
 |
garycrunk
Posts: 23
|
| Posted: 04/26/2007, 12:33 PM |
|
I've found my own solution.
Here is the Connection Sting I've used:
ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=mysql.servername; DATABASE=mysql_databasename; UID=mydatabaseusername;PASSWORD=mypassword; OPTION=3"
This option works well.
_________________
Gary Crunk
Job Examiner |
|
|
|
|
