Hi all,
I've created a php that runs a simple query on a pervasive sql database, located on a windows 2000 server.
I configured the iis with php on the same server, and ran the php from another workstation on the network, and it worked fine.
I then wanted to keep the database files on that server (let's call it server1), but run the webserver on another win2000 server (server2) on the same network.
Sertver2 would get pervasive odbc client interface installed, aswell as iis configured.
Now all this seems fine in theory, but when I open the php page from a workstation on server2, I get the following error:
Warning: SQL error: [Pervasive][Pervasive ODBC Client Interface][Pervasive ODBC Client Interface][Pervasive ODBC Client Interface LNA]No available transport protocol for the Pervasive Network Services Layer., SQL state 08S01 in SQLConnect in d:\inetpub\wwwroot\sql\1stquery.php3 on line 7
line 7 contains the following :
$connect = odbc_connect("name", "user", "password");
any help would be greatly appreciated.
Regards,
Tobie
