Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error accessing SQLBase from PHP

Status
Not open for further replies.

eeha0120

Programmer
Jun 3, 2003
2
VE
Hello.

I'm writing a Website using PHP, and I need to access a SQLBase database.

I'm running Windows 2000 Pro SP3, SQLBase Server 7.5.1 (1 user), and I'm writing my page in PHP 4.3.2.

I can access de database from MS Access trough ODBC when the server is running (of course), but when I try to access it from PHP, I get the following error:

Warning: SQL error: [Gupta][ODBC Driver][SQLBase]00909 PRS INC Invalid character, SQL state 42000 in SQLExecDirect in D:\Inetpub\ on line 26

So, I made a link from MS Access to the SQLBase database trough ODBC, then I access the MS Access file from PHP, and everything goes right, but only when the SQLBase Server (the main window) is not running. When accessing it this way, Windows creates a service for the SQLBase Server (which is not visible), and I can access the database with no problem, but if I'm running the SQLBase Server Window, I got another error, the database "disappears" form the database list, and the application crashes.

Any help / idea on what could be happening and how could I solve it ?

I'm using the SQLBase ODBC 8.1 driver from Centura and Access 2002.

Note: My system is in Spanish (I'm in Venezuela)
 
I forgot to write I'm running Internet Information Services, and my DB is configured as a System DSN.

I have the proper user rights for PHP folders/files (I hope).

Any help will be REALLY appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top