February 23, 2011 at 9:13 am
Hi,
I have SQL 2005 Standard sp4 32 bit running on a Windows 2003 R2 64 bit OS. I have a 32 bit odbc driver for another database that is installed as a system DSN (with odbcad32.exe) and works when used via SSIS to import data.
I try to create a linked server using Microsoft OLE DB Provider for ODBC Drivers and the DSN but get "Cannot initialize data source" and "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" error 7303. Any ideas how I can get this to work or am I out of luck?
I installed the driver and SQL 2005 Express on a 32 bit server and was able to create a linked server and query the database using OPENQUERY
Thanks.
February 23, 2011 at 12:26 pm
Find a copy of the ODBC32.dll file and replace it on the affected machine. More than likely it got overwritten.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 23, 2011 at 2:15 pm
I found two versions of odbc32.dll, identical apart from file size, one in C:\Windows\system32 and one in C:\WINDOWS\SysWOW64. Tried both in each location and still got the same error. One of the files is the same size and version as on my other test server but still no luck.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply