Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Microsoft SQL-DMO (ODBC SQL State 42000)

Author  Topic 

naveenmehta20
Starting Member

3 Posts

Posted - 2004-05-14 : 10:11:54
Hi,

I get an error-- Microsoft SQL-DMO (ODBC SQL State 42000) ---
while restoring the complete backup on a different machine.

Is it due to some logins not existing in this new sql server which were there on the sql servre i had the backup done..

Pl. help

Thanks,
Naveen

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-05-14 : 10:14:50
No, but it could be to do with the service pack or mdac levels being different between the two machines...
Go to Top of Page

naveenmehta20
Starting Member

3 Posts

Posted - 2004-05-14 : 10:17:33
Well how to find out which version is intalled on a PC

Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-05-14 : 10:22:00
For the Mdac component checker:-

http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

And do a
select @@version
to find if the sp level is different...
Go to Top of Page

azizi47
Starting Member

2 Posts

Posted - 2010-08-27 : 17:24:31
I am also getting this error when I am trying to restore a database on my new hosting server. :( what should I do?

When it comes to Professional - Love it or Leave it.

http://www.thecurrentaffairs.com
http://www.traveljin.com
Go to Top of Page
   

- Advertisement -