December 29, 2010 at 7:11 pm
the 32 bit app was fine connecting to 32 bit sql through sqlsrv32.dll driver.
now the upgraded sql box also has the same dll, but its version is higher, also perhaps for 64 bits.
the app is not able to utilize the oledb driver.
is there any option to make this work?
Appreciate any help on this...
-Dan.
January 2, 2011 at 10:20 pm
Is the application running on the SQL Server that is now 64 bit or are the application machine and the SQL Server machine separate machines?
January 3, 2011 at 9:21 am
I would think that the 32 v 64 doesn't matter for most clients. There are some drivers on the server that might have an issue, but not the client.
Can you be more specific about this drivers and versions are being used? Your post doesn't have much information in it.
January 4, 2011 at 1:57 pm
Ben,
the application machine (OS 2003 32 bit) and the SQL Server machine(64 bit R2) are hosted in separate boxes
January 4, 2011 at 1:57 pm
Steve
The sqlsrv32.dll (OLEDB) version in the OS 2003 box is 2000.86.3959.00 and in the 64 bit R2, it is 6.01.7600.16385.
But now the 2003 box is able to connect to SQL on R2 with ODBC, though. is there any other pertinent info that i am missing?
January 4, 2011 at 2:12 pm
Well, the client OLEDB is going to always be separate than the Server DLL, so it will not matter as much that the Server dll is newer. It will be because you have installed SQL Server on it.
If you wanted to upgrade the client, all you would do is to run the SQL Server install and choose the Connectivity Components only and my belief is that the connectivity would be restored. The application usually does not designate the dll that it uses, it just specifies a provider (SQLOLEDB.1 or something) so whatever the version is on the machine wins.
So that is my recommendation to you is to run SQL Server install on the application machine and choose the Connectivity components and try the connectivity again.
January 4, 2011 at 8:40 pm
I think Ben has some good advice here. I don't know that those two versions conflict anywhere, but the client version is what really matters. The server drivers matter at times when you have a server trying to connect to another space.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply