invision
08-19-2008, 05:28 PM
Hi,
I am moving a site over to a new host and have created the MySQL database on the new host. Site displays fine, but I get an error when trying to connect to the db.
Now I need to insert the correct information in the following, but not sure what to enter:
str_conn = "Provider=MSDASQL;DRIVER={MySQL ODBC 3.51 Driver};Server=xxxx;UID=xxxxx;PWD=xxxx;Database=xxxxx;Option=16387;"
I'm pretty 99% sure I know my server, uid, pwd and database values, but how do I get the info on my Provider and Driver ?
When I try to use(what I think is the right info), I get the error:
ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
I'm sure that's the missing link and as soon as I've got them,I'm in business! :D
Many thanks for any suggestions. :thumbs:
I am moving a site over to a new host and have created the MySQL database on the new host. Site displays fine, but I get an error when trying to connect to the db.
Now I need to insert the correct information in the following, but not sure what to enter:
str_conn = "Provider=MSDASQL;DRIVER={MySQL ODBC 3.51 Driver};Server=xxxx;UID=xxxxx;PWD=xxxx;Database=xxxxx;Option=16387;"
I'm pretty 99% sure I know my server, uid, pwd and database values, but how do I get the info on my Provider and Driver ?
When I try to use(what I think is the right info), I get the error:
ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
I'm sure that's the missing link and as soon as I've got them,I'm in business! :D
Many thanks for any suggestions. :thumbs: