can't link oracle server

SGVsbG8sIEkgaGF2ZSBwcm9ibGVtcyBsaW5raW5nIG9yYWNsZS A4IGRhdGFiYXNlIHRvIG1zIHNx
bCBzZXJ2ZXIsIEkgaW5zdGFsbGVkIG9yYWNsZSA4IGNsaWVudC wgd2hlbiBJIHVzZSBkYXRhIGlt
cG9ydCBpdJJzIHdvcmtpbmcgZmluZSwgYnV0IGFmdGVyOg0KDQ oNCg0Kc3BfYWRkbGlua2Vkc2Vy
dmVyICdsaW5rZWRfc2VydmVyaXMnLCAnT3JhY2xlJywgDQoNCi dNU0RBT1JBJywgJ29hcmtsZV9z
ZXJ2ZXJpbyBwYXZhZGluaW1hcycNCg0KZ28NCg0KZXhlYyBzcF 9hZGRsaW5rZWRzcnZsb2dpbiAn
bGlua2VkX3NlcnZlcmlzJywgDQoNCiAgZmFsc2UsICdzYScsIC d1c2VybmFtZScsICdwYXNzJw0K
DQogDQoNCkkgcmVjZWl2ZSBlcnJvciBtZXNzYWdlOiBvbGUgZG IgZXJyb3IgdHJhY2UgW09MRS9E
QiBwcm92aWRlciBPTEVEQiBJREJpbml0aWFsaXplOjogaW5pdG lhbGl6ZSByZXR1cm5lZCBzdGF0
dXMgIDB4ODAwMDQwMDUNCg0KIA0KDQpNeWJlIHByb2JsZW0gaX MgdGhhdCBvcmFjbGUgcnVubmlu
ZyBvbiBub24gc3RhbmRhcmQgcG9ydD8/DQoNCg0KDQpTb3JyeSBmb3IgbXkgRW5nbGlzaCBpcyBu
b3QgbXkgZmlyc3QgbGFuZ3VhZ2UNCg0KDQoNCg0KLS0NCkRpYX ZvbG8NCnd3dy5uZXdzLm11bXMu
bHQgLSB2aXNrYXMgYXBpZSBuYXVqaWVu+CBncnVwZXMNCnd3dy 50aW5rbGFpLnRlbi5sdCAtIGxp
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 its 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 lokals 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...
>
>
|||SGVsbG8sIErpaukhDQoNCmluIHRuc25hbWVzLm9yYSBJIGhhdm UNCg0KS0FEQS54eHguY29tID0N
CiAgKERFU0NSSVBUSU9OID0NCiAgICAoQUREUkVTU19MSVNUID 0NCiAgICAgIChBRERSRVNTID0g
KFBST1RPQ09MID0gVENQKShIT1NUID0gMTk1Lnh4Lnh4Lnh4eC koUE9SVCA9IDE1MjIpKQ0KICAg
ICkNCiAgICAoQ09OTkVDVF9EQVRBID0NCiAgICAgIChTSUQgPS BTVEQpDQogICAgKQ0KICApDQoN
Cg0KdG8gY29ubmVjdCBsaW5rZWQgc2VydmVyIEkgdXNlDQoNCm V4ZWMgc3BfYWRkbGlua2Vkc2Vy
dmVyICdLQURBJywgDQogICdPcmFjbGUnLCAnTVNEQU9SQScsIE tBREEueHh4LmNvbScNCg0KSXQn
cyByaWdodGggb3Igbm90Pw0KDQotLQ0KRGlhdm9sbw0Kd3d3Lm 5ld3MubXVtcy5sdCAtIHZpc2th
cyBhcGllIG5hdWppZW74IGdydXBlcw0Kd3d3LnRpbmtsYWkudG VuLmx0IC0gbGlldHV2b3MgbG9r
YWz7cyB0aW5rbGFp
|||SGVsbG8sIGpycG0hDQpZb3Ugd3JvdGUgIG9uIE1vbiwgMTEgT2 N0IDIwMDQgMTI6MDE6MDQgLTA3
MDA6DQoNCiA+IE9yYWNsZSBubyBsb25nZXIgc3VwcG9ydHMgVj gsIHdoaWNoIGlzIE1EQUMgMiBv
ciBsb3dlciwgSSBiZWxpZXZlLg0KDQogPiBUaGUgY3VycmVudC ByZWxlYXNlIHRoYXQgYm90aCBN
aWNyb3NvZnQgYW5kIE9yYWNsZSBzdXBwb3J0cyBpcyB0aGUgT3 JhY2xlDQogPiA4aSBjbGllbnQg
KDguMS43LnggaW5zdGVhZCBvZiA4LjAueCkNCg0KDQpUaGUgZG FiYXNlIEkgd2FudCBjb25uZWN0
IHRvIGlzIFY4LiBJbiBteSBjb21wdWV0ciBJIGhhdmUgbGFzdG V0IE1EQUMgb3IgYWJvdXQuIFdo
YXQgY2FuIEkgZG8/DQotLQ0KRGlhdm9sbw0Kd3d3Lm5ld3MubXVtcy5sdCAtIHZpc2 thcyBhcGll
IG5hdWppZW7FsyBncnVwZXMNCnd3dy50aW5rbGFpLnRlbi5sdC AtIGxpZXR1dm9zIGxva2Fsxatz
IHRpbmtsYWk=
|||Okay, you're my last one... I just talked to Microsoft, and this is how 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 have following
entries.
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
I hope this helps.
Carrie