jthillier
Posts: 4
|
| Posted: 09/11/2004, 9:48 PM |
|
Hi everyone,
I am trying to design CCS PHP pages to access DBase files.
I have setup an ODBC connection (Microsoft DBase Driver 4.00.6019) which works fine at design time since I can pick my tables and fields to work with. When I go to "live page", I get the following message :
Warning: odbc_pconnect(): SQL error: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié, SQL state IM002 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.
Anyone can help on that matter ?
OS : Win XP Pro SP1
CCS : 2.3.2.24
Thanks in advance
Jacques THILLIER
Athos Informatique
New Caledonia
|
 |
 |
peterr
Posts: 5971
|
| Posted: 09/11/2004, 10:07 PM |
|
It looks to me like wrong settings are specified in Connection -> Server, although I'm not sure.
This is not a CodeCharge Studio error, therefore you can search for this error message on Google:
http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=%22So...A9cifi%C3%A9%22
http://groups.google.com/groups?q=%22Source%20de%20donn...F-8&sa=N&tab=wg
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
jthillier
Posts: 4
|
| Posted: 09/13/2004, 4:14 PM |
|
By looking at this Google link, I have read 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
|
|
|
|
|
