• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 922
  • Last Modified:

driver's sqlsetconnectattr failed

Hi,

I have an application running on 32-Bit OS and pointing to a 64bit Oracle and i encounter the driver's sqlsetconnectattr failed error. is it due to the drivier being 32-bit? It make the connection fine but when trying to retrieve (SELECT) data to a screen in the apllication it throws this error. any ideas?

Thanks!
0
crishna1
Asked:
crishna1
  • 6
  • 5
1 Solution
 
crishna1Author Commented:
I just looked at the dll on both the machines. The application which has Oracle 32-bit running has the driver dll as SQORA32.DLL. suprisingly the 64-bit Oracle also has the same driver. so i guess the driver is not the problem?
0
 
slightwv (䄆 Netminder) Commented:
The application and database bit versions really don't matter.

The application bit version and the oracle client bit version it uses does matter.

That doesn't look like an Oracle error message.

What is the application written in?
What data access provider does it use?  I assume odbc?

Oracle's odbc or Microsoft's?

There are two versions of the Microsoft ODBC administrator.  One in syswow32, on mobile and cannot think of the other one.  Google odbc and syswow32 and you will find it.

Make sure the oracle client is 32 bit and has odbc installed.


0
 
crishna1Author Commented:
The application server has 32-bit Oracle installed. yes, it is using ODBC. The app is written in Visual C++. It is using Oracle odbc. But it is not the driver that was installed by client , this server originally had Oracle db server (which is shutdown now) and the driver is from that install.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
slightwv (䄆 Netminder) Commented:
I saw that from your other related question.

Not sure about the driver that 'is not the driver' versus 'from that install' means.

Not a C++ person but I wonder if the versions from the old working server does not match the new app server.

This is an issue in the .Net world once an app is compiled.  Different Oracle clients normally need a recompile.  Might be different in the C++/ODBC world.

Check with the app developers.
0
 
crishna1Author Commented:
1) there is no new app server
2) previosuly the app and database were on the same server ( since you refered to the other question you already know this)
3) the database has been moved to a new 64-bit server ( which you already know from the other  question) The database on the old server has been shutdown.
4) the above is issue is the app connceting using ODBC to the new database.
     The ODBC driver on teh app server was from teh install of the database that existed there before. there is no Oracle client on teh app server since teh driver is already there

can be any more eloberate? let me know.
0
 
slightwv (䄆 Netminder) Commented:
Got it.

Not sure on this one.  There should be no problems I can see if the tnsnames.ora file is pointing to the new server.

That looks like an odbc error.  It will have to wait for tomorrow for me to get on a real computer.

Hopefully another Expert will have an answer before then.
0
 
crishna1Author Commented:
sure, no problem, can wait. thnx!

It is making the connection , i can see that cause it is writing the data to the database ( i check a table data time stamp). It is one of the screen where it reteives database (select) from the database.
0
 
slightwv (䄆 Netminder) Commented:
For grins and future Experts:

What are the Oracle client and new database versions?

Please use all 4 numbers.  For example:10.2.0.4
0
 
crishna1Author Commented:
sorry for the delayed reply, was out for couple of days.

sys@meterboth client and server are 11.2.0.1
0
 
slightwv (䄆 Netminder) Commented:
I'm unable to locate anything specific with just that fragment of the error.

Can you get the entire stack trace form the app?  I'm looking for a more descriptive error message or Oracle error number.
0
 
crishna1Author Commented:
None.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now