Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Connection Issues over TCP/IP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-08 : 22:23:19
Richard writes "Dear Sir,

I have recently installed SQL 7 with SP3 on NT 4 Server. I have remote PC's that connect to the SQL over an on demand ISDN using TCP/IP. They do not logon to any NT4 Servers. An application using VB6 has been written for us and runs through Access 2000 front end. The application automatically logs onto the SQL fine, however we are unable to get any data from the SQL server. Error logs say connection is successful. I have found that if I map a drive to the route of the NT Server all is well. SQL is set to validate in Mixed mode. Any help would be grateful.

Many thanks

Richard Adgie"
   

- Advertisement -