Error 42000 Informix Informix Odbc Driver
Contents |
here for a quick overview of the site Help Center Detailed informix odbc driver system error occurred in network function answers to any questions you might have Meta Discuss informix odbc driver read error occurred during connection attempt the workings and policies of this site About Us Learn more about Stack Overflow the informix odbc driver download company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss informix odbc driver windows Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL query error with ODBC connection in R using Informix driver up vote 1 down vote favorite With functionality from
Ibm Informix Odbc Driver Download
the RODBC package, I have successfully created an ODBC but receive error messages when I try to query the database. I am using the INFORMIX 3.31 32 bit driver (version 3.31.00.10287). channel <- odbcConnect("exampleDSN") unclass(channel) [1] 3 attr(,"connection.string") [1] "DSN=exampleDSN;UID=user;PWD=****;DB=exampleDB;HOST=exampleHOST;SRVR=exampleSRVR;SERV=exampleSERV;PRO=onsoctcp ... (more parameters)" attr(,"handle_ptr")
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked https://social.msdn.microsoft.com/Forums/sqlserver/en-US/17df1f96-960e-4167-a0ba-292f1db628d6/import-data-from-informix-db-to-sql-server-2012?forum=sqlintegrationservices by: Import data from Informix DB to SQL Server 2012 SQL Server > SQL Server Integration Services Question 0 Sign in to vote I am trying to use the SSIS Import and Export Wizard in SQL Server Data Tools to migrate an Informix database to SQL Server 2012. I go through informix odbc the steps & when I hit Finish I get an error message that says: TITLE: SQL Server Import and Export Wizard ------------------------------ Could not connect source component. Error 0xc0047062: Source - material [1]: System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) informix odbc driver at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.ReinitializeMetaData() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper) ------------------------------ ADDITIONAL INFORMATION: ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. (iclit09b.dll) ------------------------------ BUTTONS: OK ------------------------------ I am getting this error when I use the "Copy data from one or more tables or views" option. I am able to migrate a single table with no problem when I use the "Write a query to specify the data to transfer" option. This is my first time using SSIS so I am not sure what to do. Can anyone help me out? Thanks... Monday, December 30, 2013 3:35 PM Reply | Quote All replies 0 Sign in to vote The following link explains the steps/processes requires to perform this in SSIS: http://davidbridge.wordpress.com/2012/05/30/extraction