Connecting to Remote SQL7 Server via ADO 
Author Message
 Connecting to Remote SQL7 Server via ADO

Hi. I'm trying to connect to an SQL7 Server running on Windows 2000 Adv
Server. When I try connecting to SQL7 via ADO 2.1 on the Windows2000
machine, I have absolutely no problems connecting using either WinNT
Authentication or SQL Authentication (w/ user name "sa" and no pw). When I
try the same thing from a remote computer on the same lan either attempting
to connect to the server's IPs or computer name, it doen't work. It says
that it failed to connect. Anyone have any ideas? Ideally I want to be able
to connect over TCP/IP so that my client applications can run from anywhere.

Thank you,
Nathan Blecharczyk

Wed, 26 Jun 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. NEED HELP - Can't connect to SQL7 Via ADO

2. Connecting to remote SQL server via Internet using ASP page and Comm object

3. Connecting to SQL Server via VBScript from Outlook using ADO

4. timer module: connect to SQL7.0 server

5. vb6 connecting to a sql7 server??? help

6. Connecting to a remote oracle database via the Internet

7. Client app connect to remote database via Internet?

8. connect to a remote database via Vbasic

9. RDS? Connecting via Internet to remote database

10. Connecting to remote database via Internet

11. How to create a COM object at a remote PC ( both connected via LAN )

12. SQL7 Linked Server and ADO


Powered by phpBB® Forum Software