ODBC connection using a remote database?

[Anon]

Hi!
I'm building a site at a web hosting service and the database I want to reach is on another server. It has ODBC connection so how would I define the odbc_connect statement to connect to a remote db? Is the DSN entered as first parameter only for local DBs? Thanks!

[deshpande]

Hi Yan,

If you have the Access database on a shared network location you can create a DSN on the web server using the UNC path to it. Then that DSN u can use with ip of the sever mentioned as dbhost in odbc_connect.
Just try this.

--Shashank

[Anon]

Thanks for the info, unfortunately, I'll have to talk to the client since we don't even know on what DB he's working but we know it's ODBC compliant. I'll get more info and repost then. Thx!