I have a program that does multiple database connections to multiple database servers. Language is C++. I use CDatabase OpenEx ( "DSN=DSNName;UID=SQLUserName;PWD=SQLUserPasswoard;Trusted_Connection=No", CDatabase::noOdbcDialog );
Updating the program to windows 7. Running on a Win 7 x64 box. Use C:\Windows\SysWOW64\odbcad32.exe to configure DSN. There are two DSNs - primary and secondary. The primary gets connected first. If the primary DSN has a network name instead of an IP address I get a login timeout. The secondary DSN can have either a network name or an IP address to connect successfully. I can switch what SQLServer box is the primary and secondary and get the same result so I do not believe this is a SQLserver box issue. Application has been running fine since 1997 with updates over the years. When running this app on XP box works fine (No IP address needed). Can duplicate problem on 2 different win 7 x64 boxes. Tried with firewall off UAC at lowest level with no change in outcome.
tim van asselt 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.