Connecting to SQL Server DB in Windows 7

[RSteph]

I've got an Access Front end program that connects to a SQL Database back
end. Everything works in Windows XP; but on the one computer running Windows
7 I cannot get the Access application to connect to the SQL Database. My ODBC
Connection string looks something like this:

ODBC;DSN=MyConnection;APP=My
App;Database=bedb;UID=sa;PWD=MyPassword;TABLE=dbo.tblFirstTable

I've tried going into Admin Tools, and creating the datasource first, it
connects without any problem. Is there something that has changed in Windows
7, that requires me to either alter a setting somewhere, or change my
connection string?

I'm running Windows 7 professional, with Microsoft Office 2007, and SQL
Server 2005. Currently I'm connecting to a DB hosted locally - for testing
purposes.

Any help would be greatly appreciated.

Thank you.

 

[Armen Stein]

I've tried going into Admin Tools, and creating the datasource first, it
connects without any problem. Is there something that has changed in Windows
7, that requires me to either alter a setting somewhere, or change my
connection string?

It's odd that you can connect one way but not another - that would
seem to indicate that it isn't an overall firewall issue. But it
might be application-specific. What anti-virus software are you
running? Some (like Norton) require you to specifically allow Office
applications to communicate outside your PC. There's often a setting
like "Keep Office Documents Protected" that you need to turn Off.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com