Unable to connect to SQL Server Database using Data Direct ODBC connection
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].].