?
Solved

SQL Database connection error

Posted on 2011-10-27
7
Medium Priority
?
2,191 Views
Last Modified: 2013-01-24
I have an application that talks to a backend SQL 2008 server.  This application used to be on a SQL 2005 server, and was moved to a SQL 2008 server.  When I moved it, I did not have all of the users created on the SQL 2008 server so my database had some orphaned users.  I have since resolved that, and everything is working as expected for the most part, EXCEPT:

This database is connected to by a client program called ServiceCEO (Insight Direct).  The SQL server is defined using a system DSN in the client OS ODBC.  For all systems that were previously connected to the application, we were able to change the DSN to the new server and the database connected without any issue.

HOWEVER, for NEW clients (clients that never had the program installed), after we set the DSN to the correct server and try to connect, we get the following error:

ADODB.Command Error: Requested operation requires an OLE DB Session object, which is not supported by the current provider. (3709)

All existing clients are able to connect without any issue, but all new clients get this error.  Does anyone know what I can do to resolve this?  
0
Comment
Question by:jkeegan123
  • 4
  • 3
7 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 37041854
Hi,

What OS are the new clients vs the existing clients running?

Regards
  David
0
 
LVL 5

Author Comment

by:jkeegan123
ID: 37041883
A mix of Windows 7 and Windows XP, with it working on both.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 37043244
Hi,

Have you got the correct version of the netlibrary installed? It used to be the MDAC. Now some comes with the OS. It occurs to me that maybe the new clients need an old driver/netlib/whatever.

Regards
  David
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
LVL 5

Author Comment

by:jkeegan123
ID: 37050901
Where do I get the netlibrary from?  I tried installing the SQL 2008 client tools, and that did not fix it.  What's more, I installed a blank version of the SQL application from the vendor using their default configurations (since this all started with a database move to another server) with a blank DB, etc...I was able to connect to it fine from existing PCs in the office, but new Windows 7 PCs not at all.

SO...is there a client connectivity pack that comes with Windows XP, or with earlier vesrions of Windows 7, that I would be missing on this new Windows 7 factory default x64 PC?  Is it even worth mentioning that it's Windows 7 X64 and all of the other PCs in the office are x86?
0
 
LVL 5

Accepted Solution

by:
jkeegan123 earned 0 total points
ID: 37053269
I figured this issue out,it ended up being the fact that these PC's are x64. Apparently odbc configured in windows 7 64bit is not seen by legacy (32 bit) applications. To fix this,I just ran the 32 bit odbc configurator,duplicated the settings and dsn 's ,and we were set.

The 32 bit configurator is at:
C:\windows\syswow64\odbcad32.exe
1
 
LVL 35

Expert Comment

by:David Todd
ID: 37053489
Hi,

x64 is great if you can get the drivers.

We have a few legacy systems which only have 32bit odbc drivers. So our x64 SQL needs to go through a x86 32bit instance to connect.

Regards
  David
0
 
LVL 5

Author Closing Comment

by:jkeegan123
ID: 37199894
This was the correct answer.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Loops Section Overview

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question