December 24, 2007 at 6:36 pm
Linking slqserver 2000 with oracle9i on windows XP Professional platform
7399:OLEDB provider'MSDORA' reported an error
EXEC sp_addlinkedserver
@server = 'DDDD_sql',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'testlink'
GO
Able to create the object when trying to open the table or view i receive an error
7399:OLEDB provider'MSDORA' reported an error.
Let me know, if i need to make changes in sqlnet.ora file
December 25, 2007 at 6:40 am
1) You will have to set up an Oracle client on your Database server
2) Check with the Oracle DBA to set up a user name for you to use when attempting to access the Oracle database.
3) You need to ask them to grant access to the tables that you wish to access from SQL server.
4) Now create the linked server and add remote logins.(Use the remote login specified in Step 2)
5) Now obtain the tnsnames entry from the Oracle DBA and append that to the tnsnames on your datbase server that hosts the Oracle client.
6) Once this is done you can access the Oracle database
You can follow this document:
December 26, 2007 at 1:32 pm
Also, you should be weary of the database server. ORACLE 9i has problems connecting to a 64 bit server, as the client tools drivers are not supported.
December 29, 2007 at 1:50 pm
Thanks
December 30, 2007 at 10:49 am
7399:OLEDB provider'MSDORA' reported an error
EXEC sp_addlinkedserver
@server = 'DDDD_sql', using --- Priovder
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'ORCL'
GO
Done but still facing the issue.
EXEC sp_addlinkedserver using -- ODBC
@server = 'ORC_DSNNA',
'',
@provider = 'MSDASQL',
@datasrc = 'testlink'
GO
December 30, 2007 at 10:57 am
The issue is something else?I will figured out the cause.
Thanks for yor reply
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply