ODBC connection to remote SQL srver failed

Hi all,
Here is the scenario.
I installed SQL server 2000 on a NT server which already has SQL
server 6.5. This is because I want to upgrade the 6.5 to 2K. The 6.5
is the default instance, and the 2K is in a named instance.
Everything went well up to this point. I can bring up both instances
and transfer database over.
Now, the 6.5 server has been brought down due to not in use. I have a
Access mdb file with linked tables to the SQL 2K server by using a
created file DSN in ODBC manager. Everything works fine. I can open
tables and see data. But if I try to open the same Access mdb file
from remote machines, Win 95s & Win 98s, (using shortcuts points to it
on the NT machine), I get error "ODBC connection to SQL server
<my2Kserver>\<my2Kinstance> failed".
So, opening it from same machine works, opening it from remote does
not. Any ideas? By the way, I tested the network connection and it
works. Becuase I can see the shared drive and files of NT server from
other remote machines.
HansHello Hans,
H> So, opening it from same machine works, opening it from remote does
H> not. Any ideas? By the way, I tested the network connection and it
H> works. Becuase I can see the shared drive and files of NT server
H> from other remote machines.
I think, your 95's or 98's account have not enough access rights for file
operations with MDB files on the server.
Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC support|||As noted above, since you are using an ODBC file DSN, check to make sure you
r client systems have read permissions on the file DSN folder.
Another thing you might try doing is updating to the latest version of MDAC
on all of your client systems that will be using the SQL Server. I know tha
t I've had serious connectivity issues with Win95 and Win98 systems to my SQ
L 2K server before installing the latest updates, particularly after the app
earance of the SQL Slammer virus last year, since MSSQL SP3 significantly ch
anged the connection protocol that SQL Server uses.
You can find the installation information for MDAC 2.7 here:
http://support.microsoft.com/defaul...10&Product=mdac
Note that MDAC 2.7 is the version that is installed with SQL Server 2000 SP3
.
If you want the latest and greatest, MDAC 2.8 is also available.
http://www.microsoft.com/downloads/...&displaylang=en
Hope this helps.
Jimsql