OrbikDevelopment
New Member
Hello,
I am moving an Access 2007 project to Visual Studio 2013 Net which means I am having to use Windows 7 where currently the clients are on XP.
Everything seems to be ok except for one strange issue. For some reason Windows 7 will not create an ODBC connection to SQL Server 2000 (which is running on a 32 bit Windows 2003 server). it keeps saying "the server does not exist or access denied"???
XP computer connect using the same ODBC connection settings with no issues.
Have tried setting access to ports "1433" and "1434" in the firewall and even turning it off still no connection, the Windows 7 computer can see and ping the 2003 server and vice versa, so I am confused as to why Windows 7 can't connect when XP can.
Is there something simple I am missing such as Windows 7 is not compatible with SQL server 2000??
The Windows 2003 server has active directory and DNS on it (the Windows 7 client seemed to need a DNS address to connect to the server).
All computers are 32 bit.
I am moving an Access 2007 project to Visual Studio 2013 Net which means I am having to use Windows 7 where currently the clients are on XP.
Everything seems to be ok except for one strange issue. For some reason Windows 7 will not create an ODBC connection to SQL Server 2000 (which is running on a 32 bit Windows 2003 server). it keeps saying "the server does not exist or access denied"???
XP computer connect using the same ODBC connection settings with no issues.
Have tried setting access to ports "1433" and "1434" in the firewall and even turning it off still no connection, the Windows 7 computer can see and ping the 2003 server and vice versa, so I am confused as to why Windows 7 can't connect when XP can.
Is there something simple I am missing such as Windows 7 is not compatible with SQL server 2000??
The Windows 2003 server has active directory and DNS on it (the Windows 7 client seemed to need a DNS address to connect to the server).
All computers are 32 bit.