odbc connection in windows 7

[focus10]

with access 2007 on windows 7 Passthrough queries dose not connect to sql server. for waking up the connection i must first link manualy an sql table and then alll Passthrough queries are live.
the odbc string i use is: "ODBC;DSN=Focus;APP=2007 Microsoft Office system;DATABASE=mydb;uid=sa;pwd=123"

is there any security metter? i have to define something in access or in wondows 7?

thanks

 

[boblarson]

1. Are you using 32 bit Win7 or 64 bit Win7?

2. Which version of SQL Server are you using and

3. Which ODBC driver did you select when setting up your DSN?

 

[focus10]

1. i am using 32 bit Win7
2. SQL Server version is 2005 express
3. ODBC driver DSN=sql server