How to Connect to SQL Server via ODBC over Internet?

[smedvid]

New to SQL Server... Played with Oracle which requires a listener on server side and properly configured TSNAMES.ORA file on client side to establish ODBC connectivity. So...

How do we do that with SQL Server? I have SQL Server located on a box that is setup as a web server at a client site.

Any help is appreciated. Thanks! Steve [sig][/sig]

 

[darwinh]

To connect to a SQL Server data source using ODBC over the Internet. You need to
setup the system DSN on the SQL Server / Web Server if they are the same machine.
The client requesting the web does not need to know about the DSN source.

Microsoft has a reference article to help. Using ADO (oledb) to connect to the database
within the Web page codes (ASP).

http://msdn.microsoft.com/workshop/languages/vinterdev/bin/Inet/INET1.asp

[sig][/sig]

 

[foxdev]

Steve, you won't need to go through the TNS gyrations like with Oracle. If you've setup your server to support TCP/IP, all you'll need for your DSN is the IP address and user/password. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]