Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect to SQL Server Database using Data Direct ODBC connection

bebedi123Apr 20 2010
I posted a thread a few days ago about being unable to connect. Didn't get any responses ;-))

Now I've moved a step closer or forward. Now it finds my ODBC driver but bombs out at the next stage.

I've configured my odbc.ini as follows:
**********************************************

[MSS_DB]
Driver=/oracle/Informatica/PowerCenter8.6.0/ODBC5.2/lib/DWmsss22.so
Description=DataDirect 5.2 SQL Server Wire Protocol
Address=MssServer.xxx.co.uk,1433
AlternateServers=
AnsiNPW=Yes
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=MIS_Report_DB
LoadBalancing=0
LogonID=myuser
Password=mypwd
QuotedId=No
ReportCodePageConversionErrors=0
InstallDir=/oracle/Informatica/PowerCenter8.6.0/ODBC5.2

************************************************

I've created a Relational Connection exactly the same as above. Using DSN on the Windows desktop with the same credentials it connects fine but it fails while running the workflow


I've copied it to my $INFA_HOME
$ cp $ODBC_HOME/odbc.ini $INFA_HOME/.odbc.ini

Now I get the the following Error
*************************************
Severity Timestamp Node Thread Message Code Message
ERROR 20/04/2010 17:35:39 node1_luna2_dev READER_1_1_1 RR_4036 Error connecting to database [
523 174
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [myuser] and connection string [MssServer@MIS_Report_DB].].
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2010
Added on Apr 20 2010
0 comments
1,736 views