I've recently upgraded to Windows 7 64-bit and now I'm stuck with the following problem:
I'm runnning a local application developed in Microsoft Access which is accessing our SQL Server 2000 through ODBC. Everything works fine though I had to put the ODBC-connection in the User-DSN tab instead of the System-DSN tab because it's only the User-DSN's that seems to be visible in Access 2007. (This is not a big problem, just a remark)
Anyway, I also connect to a customers network through a regular Windows VPN-connection (PPTP) and to be able to communicate with our local network at the same time I have deselected the option for using "Remote gateway" on the Network tab for TCP/IP v4. This also works fine with Internet Explorer, browsing local network shares and running Outlook to our Exchange server.
What DOESN'T work is ODBC to our local SQL Server when the VPN-connection is up! I get the following error message both i the Access application and when testing the ODBC-connection from the ODBC control panel:
SQLState: "HY000"
SQL Server error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
Any ideas? I've searched the knowledge base here at EE but cannot find anything related.
