Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Error while connecting to a source

已答复 Error while connecting to a source

  • Tuesday, May 01, 2012 6:54 PM
     
     
    Sign In to Vote
    0

    Good Afternoon,

    I'm new to SQL SERVER andi hope this is the right place to ask my SSIS question. I'm trying to create a new package, the source is oracle and when i right click on the data source, in the drop down i select "oracle provider for OLE db"

    i enter the server name, user id and password and i'm getting the following error: ora-12154 couldnot resolve the connect identifier specified. Please can any one advice me where i'm going wrong?

    Thanks

     

All Replies

  • Tuesday, May 01, 2012 7:01 PM
     
     
    Sign In to Vote
    0
    Have you got a tnsnames.ora file in your path that includes the server you are connecting to?

    Chuck

     
  • Tuesday, May 01, 2012 7:08 PM
     
     
    Sign In to Vote
    0

    Can you please explain in detail? i have tns names.ora file and the server details i'm trying to connect are in the tns names if thats what you meant.

    Thanks

    SV

     
  • Tuesday, May 01, 2012 7:11 PM
     
     
    Sign In to Vote
    0

    Just look here for the various reasons you will get that error from the driver

    http://ora-12154.ora-code.com/

    Chuck

     
  • Tuesday, May 01, 2012 7:37 PM
     
     
    Sign In to Vote
    0

    Chuck,

    I followed all the options in that link, but still no luck :-(

    Thanks

    SV

     
  • Tuesday, May 01, 2012 8:12 PM
     
     
    Sign In to Vote
    0

    Chuck i renamed the sqlnet.ora file and tried to connect and this time i'm getting a different ora error, ORA-06413 :Connection not open error. Any advice?

    Thanks

    SV

     
  • Tuesday, May 01, 2012 9:38 PM
     
     Answered
    Sign In to Vote
    0

    In order to have Oracle OLE DB connection in SSIS, one need to install the correct Oracle client for the version of Oracle you are connecting to and you need a TNS.ORA file with your connection info and permissions. The placement of this TNS.ORA file is important. It should be in ‘ADMIN’ folder.

    Ex: C:\oracle\product\10.2.0\client_1\NETWORK\ ADMIN

    Also this TNS file must be updated one.

    Second thing is that it’s better to first install the instances/ database and then install the Clients tools. It is advisable to do a custom installation since there is always a chance that it doesn’t get installed properly.

    BR, AWM