April 15, 2010 at 11:57 am
Problem: cannot connect to Oracle thru OLE DB, but posting here because seems related to SSIS.
I wasn't able to start BIDS (classic "devenv.exe" not found), found that I had to run 'vs_setup.msi' from the SS2K5 install DVD. Did so, was able to open BIDS, but found that my EXISTING connections to Oracle thru Linked Servers all broke:
ORA-12154: TNS: could not resolve the connect identifier specified.
Again, these were working before the vs_setup run.
Restarted my SQL Server service, no success. Found that SSIS service was not running, started it. Linked Servers came back, was able to access my current ones and add a new one.
None of the Control Flow objects were available in SSIS. I tried:
regsvr32 oledbdest.dll
to get them to appear. Finally just manually added the object.
Tried creating an 'OLE DB source' to 'OLE DB Destination' package in SSIS, couldn't connect to Oracle again. Found that I couldn't connect to my Linked Servers, either.
I know that the connection to Oracle is valid, as I've tested thru 'sqlplus' at the command line.
I tried un-installing and re-installing SSIS, no dice. Research suggests that this is a problem with the OLE DB dlls, so I unregistered the oledbdest.dll. Still unable to access my Linked Servers.
Hopefully someone else has seen this. No event viewer errors, when I trace OLE DB events in Profiler, get an unspecified error.
TIA.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 15, 2010 at 3:55 pm
It appears that a re-install of the Oracle client software solved this problem.
Sorry this was posted in the wrong forum.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply