wileyt
Posts: 3
|
| Posted: 10/04/2007, 5:26 PM |
|
I am currently running a trial of CodeCharge, however i have run into a brick wall.
Another app that i have developed uses a MySQL database hosted on an separate server to my personal machine where i am running the test.
I have setup a connection to the database using the "MySQL ODBC 3.51Driver"
The server details are correct, and when i use the "Test Connection" feature the connection passes. I assume this means the database is being accessed.
However, when i go to a "Grid Builder" (regardless of the application development platform eg JSP, ASP etc...) I select the connection, however on the next page no DataSources are available. Also when i try to use the "Build Query" function, none of the tables in the database appear. (Yes there are tables, and yes the tables all contain data).
My search have so-far proved futile, and i cannot find a solution to this problem.
Any advice would be greatly appreciated.
|
 |
|
peterr
Posts: 5971
|
| Posted: 10/04/2007, 5:52 PM |
|
Hi,
Which specific version of MySQL ODBC Driver are you using?
(3.51...)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wileyt
Posts: 3
|
| Posted: 10/04/2007, 5:55 PM |
|
I obtained the windows diver from the MySQL site http://dev.mysql.com/downloads/connector/odbc/3.51.html
The version is 3.51-20 (using the setup.exe download - if that is at all relevant)
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/04/2007, 6:20 PM |
|
Recently I've seen such problem and it was resolved by upgrading to MyODBC 3.51.20 from a previous version. Possibly you can try re-installing it and recreating your ODBC/DSN definitions. Or also try MyODBC MSI installer instead of .exe installer, or vice-versa.
Additionaly, you can try selecting in CCS Connection the option:
Use Connection String -> Build -> Microsoft OLE DB Provider for ODBC Drivers -> Next -> Use data source name -> (select your ODBC/DSN)
AFAIK this issue is unusual and may be due to some conflicts with another driver or software on the computer, or incomplete driver installation, etc.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wileyt
Posts: 3
|
| Posted: 10/04/2007, 9:10 PM |
|
Well I'm not sure what is was, but i uninstalled, and then reinstalled the ODBC connector, this time using the MSI.
Now it works.
Thanks for your time and help
|
|
|
|
|
 |
|
|
|
