Connect to Hosted SQL Server from Access 97

[Adamxxx]

Hi,

I am trying to connect to the SQL2000 database which is used as the backend to a CMS hosted on the internet.

I would like to connect to this database via ODBC (using SQLSRV32.DLL) from Access 97... but am having difficulty. I try to establish a dsn which prompts for the SQL Server I want to connect to, I am not sure what to put here.

My webhost has provided me the IP Address for the SQL Server as a DNS entry (sql323.mysite4now.com). To connect to the database do I specify the server as sql323.mysite4now.com\databasename.

Also, do I need to change the 'Client Configuration' properties when trying to connect.

Thanks in advance.

Adam

 

[mrdenny]

You would enter in the dns name sql323.mysite4now.com. However either they or your ISP or your IT staff may block the connection to the SQL Server. Ever since the SQL Slammer worm ran around reaking havok on SQL Servers a few years ago it's become common practice to deny access to SQL Servers accross the internet by default.

This can be tested by opening a command prompt and running the following.

telnet sql323.mysite4now.com 1433

If you get a blank window with a flashing cursor you connected. If you get an error message in the window the connection failed.

If the telnet connection works then you should be able to log into the database via access. If the telnet connection doesn't work then you'll need to speak to your IT staff about getting network access setup.

Please keep in mind that accessing a SQL Server over the internet is NOT secure and someone could sniff your network traffic and get the username and password that you use to log into the SQL Server with.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com