Hi,

I have a DTS package pointing to a database using an ODBC for Oracle. The
server field is actually the database name and there is no reference to the
actual server it is on. The database has been copied with the same name to
another server so now there are two instances of it. I have not been able to
connect to the database on the new server.

How can I do this within DTS?

I have asked if the old database can be taken down but it is still being
used.

Many thanks,

Nathan

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.

On Sep 15, 11:08*am, NathanG <Nath... (AT) discussions (DOT) microsoft.com>
wrote:
Hi Nathan, i did some tests on my server:
- if I use the Microsoft ODBC Driver for Oracle (yellow-doubleDB icon)
it won't work, don't ask me why
- if I use the original Oracle Drivers (for ODBC you should see the
odbc folder in your Oracle Installation folder) that is, in my case,
Oracle in Ora92Home (earth-upon-a-table icon) it connects. In conn
properties you should then choose your DSN previously created with
odbcad32.exe and set other parameters.

but... I suggest you to use the OleDb drivers (Oracle OleDb Driver,
folder oledb in your ora installation folder)

HTH,
M.