Informix Error 1338
is defined in none. http://www.oninit.com/errorcode/index.php?pageid=-1338 If you are using the Programmer's Environment, possibly one module was not defined as part of a multimodule program. If you are working at the command line, possibly one or more compiled .4go modules were omitted when the program files were concatenated to form the .4gi file. Copyright Privacy
Communities Support Products Solutions Buy Trials Support Technical DocumentationNetVault Backup 11.1 Download this document Print Bookmark NetVault Backup Plug-in for Informix http://documents.software.dell.com/netvault-backup-plug-in-for-informix/4.2/user-guide/troubleshooting/troubleshooting?ParentProduct=1338 4.2 – User Guide Troubleshooting Last revised: 7/1/2014 Previous http://stackoverflow.com/questions/17350841/date-values-from-sql-server-to-informix-linked-server Next Contents Troubleshooting Troubleshooting This section describes some common errors and their solutions. Table 2. Troubleshooting Symptom Error Explanation NetVault Backup 10.x service (netvault-pgsql) will not start on Windows®. Check the Windows Event Viewer to see informix error if it displays the following message: PDT FATAL: lock file “postmaster.pid” already exists NetVault Backup 10.x uses a PostgreSQL database. If the PostgreSQL database does not start, NetVault Backup cannot start. To correct this issue, delete the “postmaster.pid” file from the location referenced in the log and informix error 1338 restart the NetVault Backup Server. For more information, refer to https://support.software.dell.com/netvault-backup/kb/122475. Backup fails to run (Activity Log indicates that ON‑Bar did not run) PATH system variable does not include INFORMIX/bin. ON‑Bar executable did not run. OnBar executable name is incorrect. Correct ON‑Bar executable did not run. Environment variables are not set correctly. Unable to determine and provide correct environment for ON‑Bar to run. “bar_act.log” contains this message: Error: You must be Informix user to run OnBar Incorrect Informix® user name and/or password. “bar_act.log” contains this message: Error: Unable to open connection to server: Informix Dynamic Server Stopped Informix must be online to enable backup or browsing. Restores require Informix to be offline. “bar_act.log” contains this message: Error: There are no DB/BLOB spaces to backup/restore Verify that you can use the NetVault Backup WebUI to browse the selected server
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss 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 Date values from SQL Server to Informix linked server up vote 1 down vote favorite I have a linked server setup in SQL Server 2008R2 (10.5) connecting to an Informix (Atomix) database using the Microsoft OLE DB Provider for ODBC Drivers (which is really pointing at a DSN that uses an ODBC driver). Through this, I can insert records as long as the record I'm inserting does not try to insert a date value. It doesn't matter the delimiter I use around the date value nor the SQL syntax I attempt -- see examples: INSERT INTO [linkedinformix]...[tablename](daterequested) VALUES (2013-06-27) SELECT * FROM OPENQUERY(linkedinformix,'INSERT INTO tablename (daterequested) VALUES (2013-06-21)) The above will give syntax error or a type clash error (or in other cases, if I don't run the provider out of process, will crash SQL Server). I've tried using {}, #, |, and other delimiters around the date value I'm passing and also tried different date formats (06/27/2013, etc.). If I point Microsoft Access at that same DSN to create a linked table, I can manually write dates to the table, so I know the ODBC driver can handle it. There must be a simple answer... sql-server informix share|improve this question edited Jul 3 '13 at 18:21 asked Jun 27 '13 at 18:40 Daryl 6029 What is the value of the Informix DBDATE environment variable? –Frank R. Jul 14 '13 at 5:08 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Informix and DATE types — a fun (complicated) topic. Actually, it is fairly simple from within the Informix world; it is when other systems get involv