Connecting to Oracle Source Via Connection Manager
Hi,
I am new to SSIS...I am trying to connect to Oracle Sample Schema HR through the SSIS connection manager ...but I get the following error :
"Test connection failed because of an error in initializing provider. ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
I tried to research on the error ...but could not get more information. ...
Please advice what could be the error about..
Thank you,EVA05
July 11th, 2011 10:28pm
See if this forum is helpful:
http://www.orafaq.com/forum/t/38079/0/Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2011 10:34pm
why you used ODBC to connect to oracle,
I suggest ODP.Net which provides faster and more reliable connection :
http://www.oracle.com/technetwork/topics/dotnet/index-085163.htmlhttp://www.rad.pasfu.com
My Submitted sessions at sqlbits.com
July 12th, 2011 1:29am
You can also try an OLE DB connection to Oracle.
You can download the Attunity drivers here:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11180MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2011 2:21am
This topic is archived. No further replies will be accepted.
Other recent topics
