This content has been marked as final. Show 5 replies
I just realized one of my problems and I think it is about sql server authetication. I need to use a SQL Server username and password to create the database link in order to make it possible to connect to SQL Server database, but I am only connected via Windows authetication - no sql server username and password. My question now is - is it possible to create a database link to connect to sql server without a username and password or by using only Windows authetication?
You'd want to post this in one of the database forums, as this forum deals with questions regarding Oracle's ODBC driver, and your question is regarding Heterogeneous Services which is a database product.
However, to throw in a random 2 cents that may or may not help... I'd think 12154 would indicate you dont have HSODBC configured properly on the Oracle database and you're not even making it to the SQLServer database to be able to run into an authentication problem. If you made it to the SQLServer database but then had a problem with uid/pwd, you'd get some kind of SQLServer error indicating such.
With respect to your question regarding authentication, I'd ASSUME it would probably work but you'd have to change the Oracle database and or listener service to run as the OS account you're trying to authenticate to SQLServer as. Thats just a WAG though, I dont know much about configuring HSODBC or what limitations it may have.
Hope it helps,
Looks like your HSODBC layer is not configured/initialized correctly, please refer to the following document for details on configuration:
OpenLink Software have a document on HSODBC configuration for our suite of ODBC Driver you may also want to consider trying:
The OpenLink ODBC Drivers can be downloaded from:
The Connect for ODBC driver for SQL Server from Progress DataDirect not only supports Windows Authentication on UNIX and Linux platforms, but it also is the driver of choice for many customers who seek to use Oracle Heterogeneous Services (Generic Connectivity) and the Oracle Database Gateway for ODBC. Below are some helpful resources to help you out:
Here is an overview of the driver and its features:
Here are links to help you configure the driver for Oracle Heterogeneous Services or the Database Gateway for ODBC:
Here is a link to download a free 15-day evaluation of the driver so that you can try it for yourself: