Connecting to remote ODBC source

Coruba67

Hi Guys,

Found a bunch of stuff which was really close to what I was looking for but couldn't quite get it to work...

Am trying to connect to a remote datasource using the Microsoft Visual FoxPro Driver...

Here's the code

<?php

$myDSN = "DRIVER={ODBC Visual FoxPro Driver};SERVER=203.12.160.35;DATABASE=DATA";
$connect = odbc_connect("$myDSN","USER","PASSWORD") or die("Couldn't connect to datasource.");

//--form query statement
$query = "SELECT * FROM table";
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result))
{
echo "row[field]";
}
odbc_close($connect);

Getting this error

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\webroot\website\test.php on line 4
Couldn't connect to datasource.

Any idea's?? Can this be done?

Thanks heaps for any help in advance.

stevesweetland

ever find a solution for this?

Coruba67

No... either the users here were unwilling to help on this issue or did not know! 🙁 I'd say the latter as normally everyone here is awesome!!

So for the time being I have just been connecting locally.

stevesweetland

okeydokey.

im gonna presume that there is currently no answer to this.

when i find a solution (because ill have to) ill post up a reply on this post.... iv tried posting on all the others about this subject!

thanks for the reply.

Coruba67

that would be awesome... still no answer on this one is really not making life very easy on this topic....

If you find anything out that would be awesome

Roger_Ramjet

Instead of trying to use ODBC have a go at connecting with COM and ADODB . There is an example in the user notes at that link that is for Foxpro and should work for you. ADO is in any case far superior to ODBC having greater functionality and speed.

And if you are using PHP 5 then you could use .NET