Connecting to MS SQL 2005 from FWH (32bit) on Win7 (64bit)

[cdmmaui]

Hello,

I cannot connect to MS SQL 2005 from my FWH application running on Windows 7 (64 bit). I have no problems connecting from WIndows 7 (32 bit) and other Windows OS (XP, Server 2003). Do I need to install different drivers (software) on the 64 bit OS to get it to connect to MS SQL?

Thank you,

[Rick Lipkin]

Darrell

I wish I had a 64bit machine here and a sql server to test your problem. I no longer work for SC State gov but many of my ADO Sql Server apps live on in that environment.

I Googled the subject

sqloledb for windows 7 64 bit

and got several ideas .. From what I can tell SQLOLEDB should work with your app on 32 or 64 bit Windows 7 platforms .. some suggestions were to right click on the app and "run as administrator" .. or possibly your Windows user needs to be an administrator of their box and not a Std or limited user.

Or try using the Native SQLOLEDB
Provider=SQLNCLI11
http://msdn.microsoft.com/en-us/library/ms130978.aspx

If it were me, I would find a 64 bit W7 machine and load the ( tools ) Sql Server Studio to test the client connectivity to your Sql Server.

I would be most curious how you solve this.

Rick Lipkin

[cdmmaui]

Thank you Rick, I will try that

[Rick Lipkin]

Darrell

Just did a quick test using the oledb Jet engine for Ms Access in a current app I am working on. I put the .exe on a 32 bit network share and ran the program from a W7 64 bit desktop and I did NOT have any issues.

The W7 desktop user was an administrator of his box .. so your issue still may be a rights problem if your users are Std or Limited users .. I just don't know

I realize Ms Access is not Sql Server, however the Jet Engine is an ole provider from Microsoft the same as SqlOleDb is for SQL Server.

Let me know if you solve your problem.

Thanks
Rick Lipkin

[cdmmaui]

Hi Rick,

I could not connect by changing PROVIDER. I also downloaded and installed a third party application to connect to SQL server and received errors. I am wondering if I am missing SQL drivers on the Windows 7 workstations???

Also, can you send me an e-mail at Darrell.Ortiz@cdmsoft.com when you can?

Thank you,