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

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

Postby cdmmaui » Fri Sep 21, 2012 1:06 pm

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,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

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

Postby Rick Lipkin » Fri Sep 21, 2012 2:18 pm

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
User avatar
Rick Lipkin
 
Posts: 2638
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Postby cdmmaui » Fri Sep 21, 2012 3:52 pm

Thank you Rick, I will try that
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

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

Postby Rick Lipkin » Sat Sep 22, 2012 1:48 pm

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
User avatar
Rick Lipkin
 
Posts: 2638
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Postby cdmmaui » Mon Sep 24, 2012 1:42 pm

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,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot], Otto and 31 guests