Cannot Connect to SQL Server 2008 Express From VFP 9 Program (exe) 2

[carolx]

I installed SQL Server 2008 Express R2 on a computer with windows 7 Home Premium OS. Created the DSN

(ODBC). The connection is OK when you test it. When I try to access the database using a VFP 9 program

(exe) on the same computer I get the message SQL Server does not exist or access denied.

I get the same message when I turn off UAC and the firewall.

All the protocols for SQL Server 2008 Express R2 are enabled.

Both SQL Server and SQL Server Browser services are started during the run.

The connection string is sqlstringconnect([dsn=Mortgage;trusted_connection=yes]). It works OK with SQL

Server on Windows XP.

 

[markros]

Did you create this DSN using SysWow64/obdcad.exe ? You can only use 32 bit version of ODBC with VFP.

PluralSight Learning Library

 

[carolx]

I used the utility in Windows 7. Any idea on how to create the 32 bit version in windows 7. I had included it in the installation package for VFP 9, but unfortunately it was not created. I had to do it manually.

 

[markros]

If your Windows 7 version is 64 bit, you need to run odbcad32.exe from c:\Windows\SysWow64 folder.

PluralSight Learning Library

 

[Olaf Doschke]

Maybe you'll see your dsn, once you open c:\windows\SysWow64\odbcad32.exe

You of course need the 32bit ODBC drivers installed.

Bye, Olaf.

 

[carolx]

Thank you guys. The DSN from the installation package showed up when I ran odbcad32.exe. I can connect now.