-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: FrontBigJunn
Message 1 in Discussion
Help on this...Please.
I have SQL server 2000 and Oracle 9i
I want to link my oracle database to my SQL 2000
This is what I did
exec sp_addlinkedserver @server='appdb',
@srvproduct = 'Oracle',
@provider = 'OraOLEDB.Oracle.1'
my database is - APPDB
username - junnm
password - jjlove
exec sp_addlinkedsrvlogin
@rmtsrvname = 'appdb',
@useself = 'false',
@locallogin = NULL,
@rmtuser = 'junnm',
@rmtpassword = 'jjlove'
but I received an error-
Error 7399 : OLE DB provider 'OraOLEDB.Oracle.1' reported an error.
I already tried this in my VB.NET oleconnection
OracleConn = "Provider=OraOLEDB.Oracle.1;Password=jjlove;Persist Security
Info=True;User ID=junnm;Data Source=appdb;Extended Properties=''"
and it works smooth and fine.
HELP on this please.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
