klwillis
Posts: 428
|
| Posted: 05/08/2004, 7:59 PM |
|
I've configured both the local ODBC connection
(for a local copy of MySQL) and the remote connection
settings correctly.
However, when I publish the source to my webserver,
it indicates it cannot locate the table, but the table is
there and I can access it just fine using PHP scripting commands that I write myself.
Here's the message I receive after publishing the
CodeCharge Studio project to the webserver and
attempting to run the application...
Database error: Invalid SQL: SELECT COUNT(*) FROM members
MySQL Error: 1146 (Table '<dbname>.members' doesn't exist)
Session halted.
The table 'members' is there - this is very puzzling.
I'm using CodeCharge Studio with PHP4 and MySQL.
Has anyone experienced similar errors and how was
the problem resolved.
BTW:
Since my own PHP scripts work when accessing this
same table remotely, it appears this is a bug with the
server code generated by CodeCharge Studio.
Any assistance is greatly appreciated.
Regards,
Kevin Willis
klwillis.dsl@verizon.net
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
 |
 |
klwillis
Posts: 428
|
| Posted: 05/08/2004, 9:35 PM |
|
I was able to resolve this when I noticed the tables on UNIX where a different case then those on my local PC workstation.
I just converted the table source names in Code Charge
studio to upper case and everything works now. 
Case-sensitivity can byte you.
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
|
