creating a link from oracle 10g to sqlserver 8

[Ghazal222]

I am trying to create a link and connect remotly to my SQL server but I am getting 933 error code , can anybody help me?


create database link mysqlserverdsn
connect to sa identified by using 'MYSQLSERVERDSN';


connect to sa identified by using 'MYSQLSERVERDSN'
*

ERROR at line 2:
ORA-00933: SQL command not properly ended

 

[SantaMufasa]

Ghazal,

Oracle is looking for a password value at the point of your error message. If your SQL Server "sa" login has no password, then try using two successive single quotes to represent a NULL password:

create database link mysqlserverdsn 
connect to sa identified by '' using 'MYSQLSERVERDSN';

I have not tried this myself, so I make no guarantees, but it is more likely to work than the original code.

Since leaving a system administrator (sa) login without a password is rather risky, I recommend your giving an explicit password to the "sa" login. At that point, your code, above, would entail the password between the single quotes.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Ghazal222]

I have set my HS parameter in my Oracle10g and I know I have set the connect info but when I want to run a simple SQL connecting to a remote server with SQLSERVER 8.0 I am getting the below message, can anybody help me on that?


SQL> select * from mg5@mysqlserverdsn;
select * from mg5@mysqlserverdsn
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][H006] The init parameter
<HS_FDS_CONNECT_INFO> is not set. Please set it in init<orasid>.ora file.
ORA-02063: preceding 2 lines from MYSQLSERVERDSN