top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

microsoft odbc driver manager the specified dsn contains an architecture miss match between driver and application

+1 vote
52 views

in my case, i have an expression transformation which uses the default function ERROR('transformation') to skip the records in which date value coming inside is not in the correct format. In this, the skipped rows are not written to the reject files, so that we are getting the reconcilation problem. I need the skipped rows to be written to the bad files.Please help me how can i achieve this.

posted Nov 21, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

I think you are using the 64 bit ODBC driver. Remove the DSN from 64 bit and add it in the 32-bit (odbcad32.exe).

answer Nov 24, 2014 by Shweta Singh
Similar Questions
0 votes

I have designed a mapping where i have flat file as source and teradata as target. I am using MS Windows Latin 1(super set of latin 1) code page.

Can anyone help me to find it out?

+1 vote

I want to know how to rename the ODBC data source in informatica.

0 votes

When i try to create a repository service i am getting the below error.

Domain setting:

jdbc:informatica:oracle://localhost:1521;ServiceName=orcl;
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true

Error:

REP_51002
Failed to logon to Databse Server
Database driver error
Function Name : Logon
ORA-12154: TNS:could not resolve the connect identifier specified
Database driver error
Function Name : Connect

Database Error: Failed to connect to database using user [apps] and connection string [orcl.world].

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...