Alright,
Heres a fairly simple question with an answer I just can't seem to find.
Is there anyway to open a connection to a REMOTE MS-SQL DB using just odbc_connect?
The remote server is win2k with a System DSN (SQL Driver) for the SQL database.
If so, what is the proper connection string format? Is it:
odbc_connect("REMOTE_HOST:dsnMYDB","","")
odbc_connect("\\REMOTE_HOST\dsnMYDB","","")
or something else...
If not, what alternative mod (PEAR, ADODB, myODBC) is best and where can I find an e xample?
Lets say the specs are:
Username: testuser
Password: testpw
Host: REMOTE_HOST
DB/DSN: RemoteDB
Thanks a bunch.
-Jeff
