jthillier
Posts: 4
|
| Posted: 09/16/2004, 4:46 PM |
|
I am still trying to access DBase files from CCS (PHP). I have read on Google that the Dbase DSN should also be added to the "System DSN" (it was only in "User DSN"). The error message I get now in "live page" is :
Warning: odbc_pconnect(): SQL error: , SQL state 00000 in SQLConnect in c:\program files\easyphp1-7\www\test\db_odbc.php on line 55
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.
In my connection-> server, I have "ODBC" in PHP Database Library and "ANSI SQL-92" in Database. There is no Dbase choice at this stage. Maybe it is the problem because it seems to me that DBase files don't need an SQL connect ...
Thank you for your cooperation
|
 |
 |
peterr
Posts: 5971
|
| Posted: 09/16/2004, 5:33 PM |
|
Hi,
When using a DSN the ODBC driver is responsible for connecting and to the database and executing SQL commands. It should interpret SQL and send to the database whatever instructions are needed.
In your case I recommend that you create a small PHP program (1 line of code: http://www.phpbuilder.com/manual/function.odbc-pconnect.php ) that connects to DBase via ODBC, without using CodeCharge Studio. Once this is working, then CCS should work the same way as well. Otherwise you may be limiting yourself to trying to troubleshoot CCS, while the problem isn't there. CodeCharge Studio utilizes the same method of connecting to a database as any other program.
Here are a few Google links that may help:
http://php.us.themoes.org/manual/en/ref.uodbc.php
Quote :Drivers exists or example Interbase, VisualFoxPro, DBase III,IV,V etc, many drivers are part of Win98 installation, other can be obtained from companies like EasySoft and Merant. I don't know which ODBC driver you are using, thus you may first need to verify that this is a DBASE ODBC driver, and that it works with PHP. You may contact the vendor of your driver for support.
Other related discussions on the net:
http://groups.google.com/groups?q=php%20odbc%20dbase
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&q=php+dbase+dsn
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&q=dbase+odbc_pconnect
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
