Hi Friends,

Can you help me find docs on how to configure generic connectivity (HS)
specific for MS SQLSERVER pls.

I have found the following docs but not so complete one. It says:
========
Oracle RDBMS 9.0.1.x on WIN2K using Heterogenuous Service (HSODBC) connect
to MS SQLSERVER 2000


Symptom(s)
~~~~~~~~~~

Setting up HSODBC connect from Oracle 9.0.1 database to SQL Server 2000


When query a valid table from SQL 2000, get:
select * from @hsodbc;
ORA-1005 "null password given; logon denied"


Change(s)
~~~~~~~~~~

ODBC test from WIN2K shows connection via ODBC to SQL SERVER 2000 works
fine. In ODBC test, the username connect to SQL Server is "sa", password
is blank.


Cause
~~~~~~~

Oracle database link require a valid user name and password


Fix
~~~~

Setup password at SQL Server side for user "sa", then recreate the database
link in step 9:

create database link hsodbc connect to "sa" identified by "sa"
using 'sqlsvr_db.world';

select count(*) from employees@hsodbc;

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: preceding 2 lines from HSODBC
========

but still the above error :(
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width