ODBC and internet access

We are trying to restict internet access from certin computers but, it's still in place because we need to process credit cards. Is it possible to remove internet access and allow our SQL based program to still run credit cards because of the ODBC connection to the SQL server which has internet access?

ODBC connects via SQL Native Client which takes in the server name/ip address of the machine to connect. As long as your app can connect to sql server via an intranet connection, you do not need to have internet connection. However, if the only link between your app and the server is the internet, then you can't disable internet on the ODBC connection.

HTH

|||I don′t know if I got the situation described, is it like the following: ?

App -- Internet SQLServer

What is your actual concern here ? That the SQL Server is exposed to the internet ? Or that the app has internet access ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

In the case where you're trying to restrict access to the server to clients from specific IP address, you can do so using TDS endpoints. Please take a look at http://msdn2.microsoft.com/en-us/library/ms191220.aspx.

Thanks,

Il-Sung.