can't link oracle server

SGVsbG8sIEkgaGF2ZSBwcm9ibGVtcyBsaW5raW5nIG9yYWNsZSA4IGRhdGFiYXNlIHRvIG1zIHNx
bCBzZXJ2ZXIsIEkgaW5zdGFsbGVkIG9yYWNsZSA4IGNsaWVudCwgd2hlbiBJIHVzZSBkYXRhIGlt
cG9ydCBpdJJzIHdvcmtpbmcgZmluZSwgYnV0IGFmdGVyOg0KDQoNCg0Kc3BfYWRkbGlua2Vkc2Vy
dmVyICdsaW5rZWRfc2VydmVyaXMnLCAnT3JhY2xlJywgDQoNCidNU0RBT1JBJywgJ29hcmtsZV9z
ZXJ2ZXJpbyBwYXZhZGluaW1hcycNCg0KZ28NCg0KZXhlYyBzcF9hZGRsaW5rZWRzcnZsb2dpbiAn
bGlua2VkX3NlcnZlcmlzJywgDQoNCiAgZmFsc2UsICdzYScsICd1c2VybmFtZScsICdwYXNzJw0K
DQogDQoNCkkgcmVjZWl2ZSBlcnJvciBtZXNzYWdlOiBvbGUgZGIgZXJyb3IgdHJhY2UgW09MRS9E
QiBwcm92aWRlciBPTEVEQiBJREJpbml0aWFsaXplOjogaW5pdGlhbGl6ZSByZXR1cm5lZCBzdGF0
dXMgIDB4ODAwMDQwMDUNCg0KIA0KDQpNeWJlIHByb2JsZW0gaXMgdGhhdCBvcmFjbGUgcnVubmlu
ZyBvbiBub24gc3RhbmRhcmQgcG9ydD8/DQoNCg0KDQpTb3JyeSBmb3IgbXkgRW5nbGlzaCBpcyBu
b3QgbXkgZmlyc3QgbGFuZ3VhZ2UNCg0KDQoNCg0KLS0NCkRpYXZvbG8NCnd3dy5uZXdzLm11bXMu
bHQgLSB2aXNrYXMgYXBpZSBuYXVqaWVu+CBncnVwZXMNCnd3dy50aW5rbGFpLnRlbi5sdCAtIGxp
ZXR1dm9zIGxva2Fs+3MgdGlua2xhaQ==have you setup a TNS Name under the oracle manager tool?
"Diavolo" <azuolas@.email.lt> a écrit dans le message de news:
u6XuN46rEHA.3748@.TK2MSFTNGP09.phx.gbl...
> Hello, I have problems linking oracle 8 database to ms sql server, I
> installed oracle 8 client, when I use data import it?s working fine, but
> after:
>
> sp_addlinkedserver 'linked_serveris', 'Oracle',
> 'MSDAORA', 'oarkle_serverio pavadinimas'
> go
> exec sp_addlinkedsrvlogin 'linked_serveris',
> false, 'sa', 'username', 'pass'
>
> I receive error message: ole db error trace [OLE/DB provider OLEDB
> IDBinitialize:: initialize returned status 0x80004005
>
> Mybe problem is that oracle running on non standard port'
>
> Sorry for my English is not my first language
>
>
> --
> Diavolo
> www.news.mums.lt - viskas apie naujienø grupes
> www.tinklai.ten.lt - lietuvos lokalûs tinklai|||Two things: What is your MDAC level and what is the level of the database you
want to talk to.
Oracle no longer supports V8, which is MDAC 2 or lower, I believe.
The current release that both Microsoft and Oracle supports is the Oracle 8i
client (8.1.7.x instead of 8.0.x)
"Jéjé" wrote:
> have you setup a TNS Name under the oracle manager tool?
>
> "Diavolo" <azuolas@.email.lt> a écrit dans le message de news:
> u6XuN46rEHA.3748@.TK2MSFTNGP09.phx.gbl...
> > Hello, I have problems linking oracle 8 database to ms sql server, I
> > installed oracle 8 client, when I use data import itâ's working fine, but
> > after:
> >
> >
> >
> > sp_addlinkedserver 'linked_serveris', 'Oracle',
> >
> > 'MSDAORA', 'oarkle_serverio pavadinimas'
> >
> > go
> >
> > exec sp_addlinkedsrvlogin 'linked_serveris',
> >
> > false, 'sa', 'username', 'pass'
> >
> >
> >
> > I receive error message: ole db error trace [OLE/DB provider OLEDB
> > IDBinitialize:: initialize returned status 0x80004005
> >
> >
> >
> > Mybe problem is that oracle running on non standard port'
> >
> >
> >
> > Sorry for my English is not my first language
> >
> >
> >
> >
> > --
> > Diavolo
> > www.news.mums.lt - viskas apie naujienø grupes
> > www.tinklai.ten.lt - lietuvos lokalûs tinklai
>
>|||SGVsbG8sIErpaukhDQoNCmluIHRuc25hbWVzLm9yYSBJIGhhdmUNCg0KS0FEQS54eHguY29tID0N
CiAgKERFU0NSSVBUSU9OID0NCiAgICAoQUREUkVTU19MSVNUID0NCiAgICAgIChBRERSRVNTID0g
KFBST1RPQ09MID0gVENQKShIT1NUID0gMTk1Lnh4Lnh4Lnh4eCkoUE9SVCA9IDE1MjIpKQ0KICAg
ICkNCiAgICAoQ09OTkVDVF9EQVRBID0NCiAgICAgIChTSUQgPSBTVEQpDQogICAgKQ0KICApDQoN
Cg0KdG8gY29ubmVjdCBsaW5rZWQgc2VydmVyIEkgdXNlDQoNCmV4ZWMgc3BfYWRkbGlua2Vkc2Vy
dmVyICdLQURBJywgDQogICdPcmFjbGUnLCAnTVNEQU9SQScsIEtBREEueHh4LmNvbScNCg0KSXQn
cyByaWdodGggb3Igbm90Pw0KDQotLQ0KRGlhdm9sbw0Kd3d3Lm5ld3MubXVtcy5sdCAtIHZpc2th
cyBhcGllIG5hdWppZW74IGdydXBlcw0Kd3d3LnRpbmtsYWkudGVuLmx0IC0gbGlldHV2b3MgbG9r
YWz7cyB0aW5rbGFp|||SGVsbG8sIGpycG0hDQpZb3Ugd3JvdGUgIG9uIE1vbiwgMTEgT2N0IDIwMDQgMTI6MDE6MDQgLTA3
MDA6DQoNCiA+IE9yYWNsZSBubyBsb25nZXIgc3VwcG9ydHMgVjgsIHdoaWNoIGlzIE1EQUMgMiBv
ciBsb3dlciwgSSBiZWxpZXZlLg0KDQogPiBUaGUgY3VycmVudCByZWxlYXNlIHRoYXQgYm90aCBN
aWNyb3NvZnQgYW5kIE9yYWNsZSBzdXBwb3J0cyBpcyB0aGUgT3JhY2xlDQogPiA4aSBjbGllbnQg
KDguMS43LnggaW5zdGVhZCBvZiA4LjAueCkNCg0KDQpUaGUgZGFiYXNlIEkgd2FudCBjb25uZWN0
IHRvIGlzIFY4LiBJbiBteSBjb21wdWV0ciBJIGhhdmUgbGFzdGV0IE1EQUMgb3IgYWJvdXQuIFdo
YXQgY2FuIEkgZG8/DQotLQ0KRGlhdm9sbw0Kd3d3Lm5ld3MubXVtcy5sdCAtIHZpc2thcyBhcGll
IG5hdWppZW7FsyBncnVwZXMNCnd3dy50aW5rbGFpLnRlbi5sdCAtIGxpZXR1dm9zIGxva2Fsxatz
IHRpbmtsYWk=|||Okay, you're my last one... I just talked to Microsoft, and this is ho
to fix it with Windows 2003, SQL 2000, and Oracle 9i:
This is discussed in Q193893 and according to this the registry key "
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI] " should hav
following
entries.
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
I hope this helps.
Carri
-
carrieorti
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message1142930.htm