can't link oracle server

SGVsbG8sIEkgaGF2ZSBwcm9ibGVtcyBsaW5raW5n
IG9yYWNsZSA4IGRhdGFiYXNlIHRvIG1zIHNx
bCBzZXJ2ZXIsIEkgaW5zdGFsbGVkIG9yYWNsZSA4
IGNsaWVudCwgd2hlbiBJIHVzZSBkYXRhIGlt
cG9ydCBpdJJzIHdvcmtpbmcgZmluZSwgYnV0IGFm
dGVyOg0KDQoNCg0Kc3BfYWRkbGlua2Vkc2Vy
dmVyICdsaW5rZWRfc2VydmVyaXMnLCAnT3JhY2xl
JywgDQoNCidNU0RBT1JBJywgJ29hcmtsZV9z
ZXJ2ZXJpbyBwYXZhZGluaW1hcycNCg0KZ28NCg0K
ZXhlYyBzcF9hZGRsaW5rZWRzcnZsb2dpbiAn
bGlua2VkX3NlcnZlcmlzJywgDQoNCiAgZmFsc2Us
ICdzYScsICd1c2VybmFtZScsICdwYXNzJw0K
DQogDQoNCkkgcmVjZWl2ZSBlcnJvciBtZXNzYWdl
OiBvbGUgZGIgZXJyb3IgdHJhY2UgW09MRS9E
QiBwcm92aWRlciBPTEVEQiBJREJpbml0aWFsaXpl
OjogaW5pdGlhbGl6ZSByZXR1cm5lZCBzdGF0
dXMgIDB4ODAwMDQwMDUNCg0KIA0KDQpNeWJlIHBy
b2JsZW0gaXMgdGhhdCBvcmFjbGUgcnVubmlu
ZyBvbiBub24gc3RhbmRhcmQgcG9ydD8/ DQoNCg0KDQpTb3JyeSBmb3IgbXkgRW5nbGlzaCBp
cyBu
b3QgbXkgZmlyc3QgbGFuZ3VhZ2UNCg0KDQoNCg0K
LS0NCkRpYXZvbG8NCnd3dy5uZXdzLm11bXMu
bHQgLSB2aXNrYXMgYXBpZSBuYXVqaWVu+CBncnVw
ZXMNCnd3dy50aW5rbGFpLnRlbi5sdCAtIGxp
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 yo
u
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...
>
>|||SGVsbG8sIErpaukhDQoNCmluIHRuc25hbWVzLm9y
YSBJIGhhdmUNCg0KS0FEQS54eHguY29tID0N
CiAgKERFU0NSSVBUSU9OID0NCiAgICAoQUREUkVT
U19MSVNUID0NCiAgICAgIChBRERSRVNTID0g
KFBST1RPQ09MID0gVENQKShIT1NUID0gMTk1Lnh4
Lnh4Lnh4eCkoUE9SVCA9IDE1MjIpKQ0KICAg
ICkNCiAgICAoQ09OTkVDVF9EQVRBID0NCiAgICAg
IChTSUQgPSBTVEQpDQogICAgKQ0KICApDQoN
Cg0KdG8gY29ubmVjdCBsaW5rZWQgc2VydmVyIEkg
dXNlDQoNCmV4ZWMgc3BfYWRkbGlua2Vkc2Vy
dmVyICdLQURBJywgDQogICdPcmFjbGUnLCAnTVNE
QU9SQScsIEtBREEueHh4LmNvbScNCg0KSXQn
cyByaWdodGggb3Igbm90Pw0KDQotLQ0KRGlhdm9s
bw0Kd3d3Lm5ld3MubXVtcy5sdCAtIHZpc2th
cyBhcGllIG5hdWppZW74IGdydXBlcw0Kd3d3LnRp
bmtsYWkudGVuLmx0IC0gbGlldHV2b3MgbG9r
YWz7cyB0aW5rbGFp|||SGVsbG8sIGpycG0hDQpZb3Ugd3JvdGUgIG9uIE1v
biwgMTEgT2N0IDIwMDQgMTI6MDE6MDQgLTA3
MDA6DQoNCiA+IE9yYWNsZSBubyBsb25nZXIgc3Vw
cG9ydHMgVjgsIHdoaWNoIGlzIE1EQUMgMiBv
ciBsb3dlciwgSSBiZWxpZXZlLg0KDQogPiBUaGUg
Y3VycmVudCByZWxlYXNlIHRoYXQgYm90aCBN
aWNyb3NvZnQgYW5kIE9yYWNsZSBzdXBwb3J0cyBp
cyB0aGUgT3JhY2xlDQogPiA4aSBjbGllbnQg
KDguMS43LnggaW5zdGVhZCBvZiA4LjAueCkNCg0K
DQpUaGUgZGFiYXNlIEkgd2FudCBjb25uZWN0
IHRvIGlzIFY4LiBJbiBteSBjb21wdWV0ciBJIGhh
dmUgbGFzdGV0IE1EQUMgb3IgYWJvdXQuIFdo
YXQgY2FuIEkgZG8/ DQotLQ0KRGlhdm9sbw0Kd3d3Lm5ld3MubXVtcy5s
dCAtIHZpc2thcyBhcGll
IG5hdWppZW7FsyBncnVwZXMNCnd3dy50aW5rbGFp
LnRlbi5sdCAtIGxpZXR1dm9zIGxva2Fsxatz
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 "
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSDTC\MTxOCI] " should have
following
entries.
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
I hope this helps.
Carrie
carrieortiz
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1142930.html