ODBC connection to Oracle

• shailendra-251422

  Ten Centuries

  Points: 1111

  More actions

  January 30, 2006 at 10:53 pm

  #67861

  I am using an ODBC connection to connect to an Oracle source from a DTS package. What is the "Server" on the connection properties screen? Is it the DSN name , or is it actually the server name where the database exists?

  Further, I want this to be dynamic as it could be different in the production environment. The dynamic properties task has a field called "Data Source". The value I provide in the  DataSource does not replace the "Server" at run time. The dynamic properties task however, replaces the user id and password at run time. With this user id and password, it tries to connect to the "Server" that I provided at the time of coding.

  How do I make the "Server" dynamic? Am I setting the wrong property through the dynamic properties task?

  Thanks!

• db2l

  Ten Centuries

  Points: 1386

  More actions

  February 1, 2006 at 3:43 pm

  #618238

  Hi,

  How are you building your package?  Are you selecting the "Other Connection" to connect to Oracle?  You should get an option "User/System DSN".