Re: Linked Server in SQL Server 2000 Evaluation Version

How do I get more info on the error or the exact error ? any log file ?

As it complaint about MSDAORA, I installed the latest MDAC 2.8. But it gave
the same error.

This is the script which I run to create linked server and id :
EXEC sp_addlinkedserver @server = 'DEVTEST', @srvproduct = 'Oracle',
@provider = 'MSDAORA', @datasrc = 'devtest'

sp_addlinkedsrvlogin 'DEVTEST', false, 'sa', 'ora_id', 'ora_pwd'

In fact, I have another SQL Server and it is working fine with the above
scripts.

Your help is much much appreciated. Thanks in advance.

"Erland Sommarskog" wrote:

> LittleBee (LittleBee@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> > Is Linked Server in SQL Server 2000 Evaluation Version supported ?
>
> Yes.
>
> > I got this error "Error 7399: OLE DB provider 'MSDAORA' reported an
> > error."
>
> Which could be anything. You need to provide more details.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: Scripting Databases
    ... Basically, if I want to script a number of tables, I can right hand ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Scripting a SQL database
    ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package) ... that you'll want to select the "copy database objects and data" ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL Security
    ... except I'm having problems making it work in a script. ... ;Set properties of DB objects and open connection to database ... > from Books Online (within the SQL Server program group): ... > communicate with SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Scripting a SQL database
    ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package) ... that you'll want to select the "copy database objects and data" ...
    (microsoft.public.sqlserver.server)
Loading