| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-04-04 : 01:14:03
|
| hi i have a oracle linked server i am able to access it bySELECT * FROM PMBS..MBS.T006_SUBSCRIBER (pmbs is linked server,MBS is owner)i have another linked server SQL2000 SELECT * FROM DNADEV..dbo.BILL_PROCESS (dnadev is linked server and dbo is owner)it gives me a error...Server: Msg 7313, Level 16, State 1, Line 1Invalid schema or catalog specified for provider 'SQLOLEDB'. how do i access sql linked server======================================Ask to your self before u ask someone |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-04 : 01:18:18
|
| I think you havent specified the database you want to querySELECT * FROM DNADEV.databasebasename.dbo.BILL_PROCESS HTH-------------------------------------------------------------- |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 01:19:34
|
| When you created the linked server, did you specify an particular database (initial catalog) or did you leave it blank?If you left it blank, then including the database name in the 4-part reference should fix the problem:SELECT * FROM DNADEV.databaseName.dbo.BILL_PROCESS |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-04 : 01:33:09
|
| thanks a lot it works..great going guys...======================================Ask to your self before u ask someone |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-04 : 03:45:33
|
| hi guys... i was able o link sql 7 server to sql2000 server but now i need to link sql2000 to sql 7 it givessqloledb provider error.....is it possible to link sql2000 to sql7======================================Ask to your self before u ask someone |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-04 : 22:41:38
|
| hi guys... backwards is supported....?i.e. creating a linked server on sql2000 to sql7 please answer it... thanks======================================Ask to your self before u ask someone |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 23:17:11
|
quote:
Ask to your self before u ask someone
Did you look in Books Online about this? The answer is in there. |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-05 : 00:30:59
|
hey hey... no hard feeling... may be my time zone... not much happening in forums... may be... can't help it... cool manyea the best thing is to go to bol.. i have been doing it... and keeping the time constraint a short cut or a direct answer will help ... right...he hee ha haaa  ======================================Ask to your self before u ask someone |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-06 : 00:38:35
|
khalik, when Rob asked you to check BOL. he was teaching you how to fish. unfortunately , you want us to fish and cook everyday's meal . this wouldnt help you much in long run. its not that we shy away from answering. but if you put your own efforts and learn things, it always pays off. As Rob has already told you. i will repeat it again ]b] Take your signature seriously , Try helping yourself first[/b] . Dont depend on others to do your job. And this isnt a Rant , its a sincere advice. Dont worry about what is happening in Forums. if you can follow the threads and read the answers . you will learn a lot and will feel lot is happening  quote:
not much happening in forums... may be... can't help it... cool man
-------------------------------------------------------------- |
|
|
|
|
Linked servers...