|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how to connect sql server to oracleha
i am facing the problem that i am unable to connect sql server to oracle i have sqlserver in my system and oracle server is in remote i want to access that database with using DTS so that ,mmy memory will bw save could any one please help for this please yaar i am waitinf fro urs reply Configure it as a linked server. To create linked server , open
EM->Security->Linked Server. vinu Show quote "dev" <d**@discussions.microsoft.com> wrote in message news:50B38365-9030-4810-9753-D58C5FAD591E@microsoft.com... > ha > i am facing the problem that > i am unable to connect sql server to oracle > i have sqlserver in my system and oracle server is in remote > i want to access that database with using DTS > so that ,mmy memory will bw save > > could any one please help for this > > > please yaar i am waitinf fro urs reply > hi
vinu i did that EM->Security->Linked Server. but when ever i am trying to acess the table it gives a message that ERROR 7399:OLEDB provider 'MSDAORA' reported an error could u please clarify about this Show quote "vinu" wrote: > > Configure it as a linked server. To create linked server , open > EM->Security->Linked Server. > > vinu > > > > "dev" <d**@discussions.microsoft.com> wrote in message > news:50B38365-9030-4810-9753-D58C5FAD591E@microsoft.com... > > ha > > i am facing the problem that > > i am unable to connect sql server to oracle > > i have sqlserver in my system and oracle server is in remote > > i want to access that database with using DTS > > so that ,mmy memory will bw save > > > > could any one please help for this > > > > > > please yaar i am waitinf fro urs reply > > > > > This might be helpful
http://support.microsoft.com/kb/280106 vinu Show quote "dev" <d**@discussions.microsoft.com> wrote in message news:4A97A14E-04C8-4460-9688-2A4FAD4697FB@microsoft.com... > hi > vinu > i did that > EM->Security->Linked Server. > but when ever i am trying to acess the table it gives a message that > ERROR 7399:OLEDB provider 'MSDAORA' reported an error > > could u please clarify about this > > > "vinu" wrote: > >> >> Configure it as a linked server. To create linked server , open >> EM->Security->Linked Server. >> >> vinu >> >> >> >> "dev" <d**@discussions.microsoft.com> wrote in message >> news:50B38365-9030-4810-9753-D58C5FAD591E@microsoft.com... >> > ha >> > i am facing the problem that >> > i am unable to connect sql server to oracle >> > i have sqlserver in my system and oracle server is in remote >> > i want to access that database with using DTS >> > so that ,mmy memory will bw save >> > >> > could any one please help for this >> > >> > >> > please yaar i am waitinf fro urs reply >> > >> >> >> hi vinu
let me try this it will take some time it has some work with registry fro that it s late thanks fro giviing this suggestion if nothing i will get back to you thanks yaar Show quote "vt" wrote: > This might be helpful > > http://support.microsoft.com/kb/280106 > > > vinu > > > "dev" <d**@discussions.microsoft.com> wrote in message > news:4A97A14E-04C8-4460-9688-2A4FAD4697FB@microsoft.com... > > hi > > vinu > > i did that > > EM->Security->Linked Server. > > but when ever i am trying to acess the table it gives a message that > > ERROR 7399:OLEDB provider 'MSDAORA' reported an error > > > > could u please clarify about this > > > > > > "vinu" wrote: > > > >> > >> Configure it as a linked server. To create linked server , open > >> EM->Security->Linked Server. > >> > >> vinu > >> > >> > >> > >> "dev" <d**@discussions.microsoft.com> wrote in message > >> news:50B38365-9030-4810-9753-D58C5FAD591E@microsoft.com... > >> > ha > >> > i am facing the problem that > >> > i am unable to connect sql server to oracle > >> > i have sqlserver in my system and oracle server is in remote > >> > i want to access that database with using DTS > >> > so that ,mmy memory will bw save > >> > > >> > could any one please help for this > >> > > >> > > >> > please yaar i am waitinf fro urs reply > >> > > >> > >> > >> > > > Hi
Remember that you have to install the Oracle client on the server - otherwise it won't work. It's not clear from your post if you've done this or not. -- Regards Steen Schlüter Persson Database Administrator / System Administrator dev wrote: Show quote > hi vinu > let me try this it will take some time it has some work with registry > fro that it s late > thanks fro giviing this suggestion > > if nothing i will get back to you > thanks yaar > > > "vt" wrote: > >> This might be helpful >> >> http://support.microsoft.com/kb/280106 >> >> >> vinu >> >> >> "dev" <d**@discussions.microsoft.com> wrote in message >> news:4A97A14E-04C8-4460-9688-2A4FAD4697FB@microsoft.com... >>> hi >>> vinu >>> i did that >>> EM->Security->Linked Server. >>> but when ever i am trying to acess the table it gives a message that >>> ERROR 7399:OLEDB provider 'MSDAORA' reported an error >>> >>> could u please clarify about this >>> >>> >>> "vinu" wrote: >>> >>>> Configure it as a linked server. To create linked server , open >>>> EM->Security->Linked Server. >>>> >>>> vinu >>>> >>>> >>>> >>>> "dev" <d**@discussions.microsoft.com> wrote in message >>>> news:50B38365-9030-4810-9753-D58C5FAD591E@microsoft.com... >>>>> ha >>>>> i am facing the problem that >>>>> i am unable to connect sql server to oracle >>>>> i have sqlserver in my system and oracle server is in remote >>>>> i want to access that database with using DTS >>>>> so that ,mmy memory will bw save >>>>> >>>>> could any one please help for this >>>>> >>>>> >>>>> please yaar i am waitinf fro urs reply >>>>> >>>> >>>> >> >> Can you connect using the native Oracle tools? net Configuration Assistant
provides a means of testing the connection, and SQL+ will also do the same. This is the first step and the most often missed step - to check that you have a valid TNS entry and the firewall is correctly configured. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com .  |
|||||||||||||||||||||||
Other interesting topics