haneef
Posts: 2
|
| Posted: 01/26/2009, 2:28 AM |
|
I am using asp in the front end and mysql in the backend.
I configured DSN. I am able to see only 3 tables from that specific database. I have 8 tables in this db. I tried all the possibilities. I reinstalled ODBC connector with no luck. I suspected that it may be problem with connector, however i am able to pull the data using the same DSN using Excel.
I tried the same in XP it working fine. Also tried with another mysql database with some 10 tables, code charge displays only 4 tables...
I feel this is the problem codecharge studio in Vista ? Can anyone help me to sort this problem.
_________________
Why the things the way ther are !!! |
 |
 |
Oper
Posts: 1195
|
| Posted: 01/26/2009, 3:25 AM |
|
Contact Support they have the solutions.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
mljonzs
Posts: 124
|
| Posted: 01/26/2009, 7:26 AM |
|
I don't know much about MySQL but this problem can occur with SQL Server if you don't have permissions set correctly for the tables in the database - ie Your CodeCharge application has the Connection set to a user that is not given permission to the table in the database?
Just a thought...
_________________
What does not begin WITH God, will end in failure!
|
|
|
|
haneef
Posts: 2
|
| Posted: 01/26/2009, 11:46 PM |
|
I checked the previlages. In fact I created all 8 tables together with same previlages.. Still no luck...
I even tried giving the root credentials for test purpose ... !!! but codecharge displays only 3 tables..
Any other suggestions?
_________________
Why the things the way ther are !!! |
|
|
|
Chris__T
Posts: 339
|
| Posted: 01/27/2009, 6:12 AM |
|
What version of MySQL are you running? Also, what version of MySQL ODBC connector are you running?
|
|
|
|
