newattitude
Posts: 18
|
| Posted: 06/01/2006, 3:27 PM |
|
Hello,
I have downloaded mysql odbc driver and it works great to connect to the mysql db with access, etc. HOWEVER, when i try to connect with code charge I get
http://susanmjustice.com/Error_Mysql.bmp
Please help me
thanks,
Susan
_________________
More Later,
Susan Justice |
 |
 |
newattitude
Posts: 18
|
| Posted: 06/01/2006, 3:34 PM |
|
I don't understand why it is trying to say the user is odbc@......
with the password to NO this is NOT what I have set up and it works perfectly and even in code charge when I go to 'use odbc data source name and click new and then set up the mysql and click test it works just after I click OK in the add new connection I get the problem
The mysql database is on a remote ISP server (hostmonster) and code charge is on my local computer.
in the design tab of the add new connection I am using the odbc and then I am wondering if I am making a mistake on the server tab? right now I have ODBC database MySql
PLEASE any help MOST appreciated this has driven me nuts for two days
_________________
More Later,
Susan Justice |
|
|
|
newattitude
Posts: 18
|
| Posted: 06/01/2006, 3:55 PM |
|
I uploaded the errors and settings I have to help anyone see exactly what I have going on:
http://susanmjustice.com/cc_issue.htm
_________________
More Later,
Susan Justice |
|
|
|
newattitude
Posts: 18
|
| Posted: 06/01/2006, 5:59 PM |
|
I got it figured out and it works like a DREAM :)
First I used a connection string instead of odbc datasource
second on the server tab I called the db name, the user@localhost login and left host/port empty!
I have it working PERFECTLY :) Thank you Code Charge - I was nervous as I have been using CCS for a couple years to build my .asp and changing to .php wasn't sure if it would be as easy NO PROBLEMS :)
_________________
More Later,
Susan Justice |
|
|
|
guest
|
| Posted: 06/02/2006, 12:16 AM |
|
Quote newattitude:
I was nervous as I have been using CCS for a couple years to build my .asp and changing to .php wasn't sure if it would be as easy NO PROBLEMS :)
As a matter of interest why have you decided to change from asp to php?
|
|
|
|
newattitude
Posts: 18
|
| Posted: 06/02/2006, 7:02 AM |
|
We moved to a unix server and we were told that we needed to utilize .php instead of .asp on that platform.
I didn't try the .asp but went by what the techs told me.
_________________
More Later,
Susan Justice |
|
|
|
