terjul
|
Posted: 01/10/2002, 6:31 AM |
|
I hope someone can help me. I have just started using CodeCharge, in order to learn php :)
My problem is as follows :
1. I have MySQL running on a remote server, and have created a database called test via Webmin on this server.
2. I am attempting to set up a database connection to this server from my work machine.
3. I have installed the MySQL ODBC driver on my local machine
4. I have also installed the MDAC drivers on my local machine
5. My publishing options are via FTP
6. WHen I click the Database tab in CodeCharge, I am presented with the following options :
a. Design Type : Custom
My problem lies in setting up the COnnection String. I have set it to the following :
a. Provider : Microsoft OLE DB Provider for ODBC drivers
b. On the connection tab : Use Data Source Name : this is set to test-MySQL (obtained from the drop down list)
I then enter my username and password to connect to the MySQL server, but when I test the connection, I get an error that says : Test connection failed because of an error in initialising provider
Can anyone help me please ???
My connection string looks like this :
Provider=MSDASQL.1;Persist Security Info=False;User ID=sian;Data Source=test-MySQL;Mode=ReadWrite
Thanks
Terjul
|
|
|
Alex Alexapolsky
|
Posted: 01/10/2002, 7:45 AM |
|
1) Your ODBC datasource in Control Panel mut be properly set up to point to a
host,database with set up login and password.
2) Make sure that you have latest MDAC
|
|
|
Terjul
|
Posted: 01/11/2002, 1:15 AM |
|
Thanks Alex - I will check that out and see if it works.
Terjul
|
|
|
Ron Borkent
|
Posted: 01/11/2002, 3:31 AM |
|
1) Your ODBC datasource in Control Panel mut be properly set up to point to a
host,database with set up login and password.
Also you have to make sure you do not use custom but the dns that you created using the mysql odbc driver.
Ron
|
|
|
terjul
|
Posted: 01/11/2002, 5:04 AM |
|
Thanks guys - it was my port setting in the User DSN and System DSN settings - I had this set to the same port number as my FTP access (10000 instead of 3306)- now its working, I can start using CodeCharge :)
|
|
|
|