staalet
Posts: 1
|
Posted: 05/07/2004, 6:55 AM |
|
I have tried to connect to a Visual Foxpro database. Im acessing trough MS access with ODBC driver to the .dbc file for foxpro database. This workes fine. When i try to connect with CSS trough the same ODBC connection i get this error:
Warning: odbc_pconnect(): SQL error: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file c:\gurudata.dbc., SQL state S1000 in SQLConnect in C:\Inetpub\wwwroot\Kundeinfo\db_odbc.php on line 52
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.
Line 52 Look like this:
if ( 0 == $this->Link_ID )
{
if ($this->Persistent)
$this->Link_ID=odbc_pconnect($this->DBDatabase, $this->DBUser, $this->DBPassword, $this->UseODBCCursor);
else
$this->Link_ID=odbc_connect($this->DBDatabase, $this->DBUser, $this->DBPassword, $this->UseODBCCursor);
I have set up in the project connection that it uses ODBC has Boolean Tru;false and date yyyy-mm-dd HH:nn:ss using ansi sql -92, no host orp port and no user password. Using persistent connection.
is there somthing i can do to fix this problem.
_________________
Best regard Ståle Tollefsen |
|
|
peterr
Posts: 5971
|
Posted: 05/07/2004, 9:22 AM |
|
You wrote that you have a problem connecting to ODBC from CCS, but the error message you shown talks about PHP.
CCS doesn't need PHP to use ODBC. So, is this CCS that cannot connect to ODBC or is this a PHP program?
If this is PHP program then how are you connecting to your FoxPro from CCS?
Generally the core of error is "Cannot open file c:\gurudata.dbc", therefore this could be a permisions problem.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|