Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: SQL Server ODBC Connection Mysterious Fails

07 Jul 2016   #1
OrbikDevelopmen

Windows 7 32 bit Ultimate
 
 
SQL Server ODBC Connection Mysterious Fails

Bonjour!

We are moving an old Access project from XP too Windows 7 32 and .Net.

However there is something wrong with Windows 7! When I try and create an ODBC link via ODBC Administrator to allow the software to access data tables on SQL Server on the Windows 2003 Server it just keeps producing a message saying the TCP/IP port does not exist or access is denied.

Having tried the same experiment with an XP computer it worked fine, no issues, but Windows 7 strangely doesn't???

The SQL Server is on standard port 1433, I tried turning the firewall off in Windows 7 but that made no difference, when installing Windows 7 and connecting it too the network it complained it needed a DNS address so I put one on the server and set that in the Windows 7 client.

The XP client never needed one, could that be linked to this odd issue?

My first experience of Windows 7 this is and it seems like Microsoft have struck again by taking something that works and making it unnecessarily difficult...

Of course I could be wrong


My System SpecsSystem Spec
.
Reply

 SQL Server ODBC Connection Mysterious Fails




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
IE 11 fails to install on my SErver 08 R2 SP1
It is wired that I cannot put IE 11 on my system. The system has default IE8. And IE 11 is offered from WU so it should be applicable to my system. WU installation failed so I downloaded standalone and tried it again from an elevated prompt. The errors seems to be that some component seems to be...
Browsers & Mail
Access & ODBC connection issue on W7 Home, State 11
I have two laptops at my company that have Windows 7 Home - thus cannot login to AD/Domain as a specific user. They in-turn use a local administrative account setup on those laptops. We have a database setup with linked connections to our SQL Server 2005. Whenever we're trying to access those...
Microsoft Office
Mysterious internet connection issue
Okay, I've had this issue for a while and I'm going to try and explain everything I can recall about it, but please feel free to request any relevant information that I may have missed out. The issue is the following: At some point for some reason, my PC loses the ability to establish NEW...
Network & Sharing
how to establish a ODBC connection in Windows 7 64 bit ?
Hello, I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows : ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access...
Network & Sharing
ODBC connection problem
I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would...
Network & Sharing
Mysterious Connection to Internet Requests
Every day I encounter a similar popup message from my Firewall. A Windows something (i.e. Company: Microsoft) is trying to connect to the internet. The source executable, while usually different each day, is always located in C:\Users\Me\AppData\Local\Temp. Since it's Microsoft, I assume it has...
System Security


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 20:05.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App