"Arnie" wrote:

> "HelpInRS" <HelpInRS@discussions.microsoft.com> wrote in message
> news:E51B8327-CCA7-435D-99EA-66686990C68C@microsoft.com...
> >I have a windows 2003 server with sql server 2000
> > I run daily jobs that delete contents of sql tables an insert data from an
> > oracle9 database using
> > SELECT
> > *
> > INTO
> > DBname
> > FROM
> > OPENROWSET
> > (
> > 'MSDASQL',
> > 'DSN=ODBCOracleAccount;UID=oracleuser;PWD=password;',
> > 'SELECT
> > *
> > FROM
> > OracleDBName'
> > )
> >
> > This worked until the oracle9 database was upgraded to oracle10. The new
> > oracle10 server is running windows 2003 server.
> >
> > On the sql server I created a new service name in oracle client and tested
> > the connection it works but when I try to run the jobs-stored procedures
> > this
> > is the following error
> >
> > OLE DB provider "MSDASQL" for linked server "(null)" returned message
> > "[Microsoft][ODBC Driver Manager] Data source name not found and no
> > default
> > driver specified".
> > Msg 7303, Level 16, State 1, Line 2
> > Cannot initialize the data source object of OLE DB provider "MSDASQL" for
> > linked server "(null)".
> >
> > The Microsoft ODBC for Oracle is version 2.576.1830.00 the file is
> > MSORCL32.dll dated 3/24/2005.
> >
> > Appreciate any help I can get.
> >
>
> Silly questions. Did you set up an ODBC system DSN for the Oracle server?

> Can you test it and connect? Is 10g perhaps in a different home than 9i
> was?

>
> - Arnie
>
>