error connect remote foxpro DB thru ODBC

valen53

is OK to connect foxpro DB thru ODBC in local pc.
but when i connect remote foxpro DB thru ODBC, it occur error.

Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Server, SQL state 01S00 in SQLConnect in C:\Apache Group\Apache...

i search this warning quite many time already, but still can't get the answer.

anybody know how to solve it?

$dsn = "Driver={Microsoft Visual FoxProDriver}; Server=bca_server; Database=dw" ;
$pr=odbc_pconnect($dsn,"root","");

Roger_Ramjet

Have you created the remote db as a datasource in ODBC. Check also to see if the Foxpro driver is in system dns and not user dns. Definitely sounds like a dns error, SQLconnect can't find the data source to connect to.

valen53

Thank u for reply.

datasource in ODBC already Created. Datasource name i put as "dw" also.

another problem is how to set the password to the foxpro DB? it doesn't like mysql can set user access. if cannot set password, DB was easy access by public.

$dsn = "Driver={Microsoft Visual FoxProDriver}; Server=bca_server; Database=dw" ; 
$pr=odbc_pconnect($dsn,"root","");