Error Codes for SQL Toolkit (Version 2.0 and Earlier)Primary Software: LabVIEW Toolkits>>Enterprise Connectivity ToolsetPrimary Software Version: 3.0.1 Primary Software Fixed Version: N/A Secondary Software: N/A
Problem: List of error codes for SQL Toolkit Solution: If you are looking to find a solution to a specific error with SQL Toolkit, please visit our SQL Troubleshooting page. Here's a list of error codes from the Support Reference Library document: The following is a list of errors that are generated by Intersolv's database drivers. The SQL Toolkit does not implement all of the Intersolv functions for various reasons, so many of the errors produced by the drivers are not predictable by the SQL Toolkit. You may encounter some errors in the range of 3800-4100 that are not documented by Intersolv. They have to do with parsing and table or file creation. // These errors will only occur if the installation was not successful -100 toolkit CIN DLL Setup Error. Could not load qelib.dll -101 to -500 toolkit CIN DLL Setup Error. Could not find the functions within the dlls. Could not load the support dll or incorrect version of support dlls. // There are underlying database error codes that database-specific and thus impossible to enumerate Error Number Error Message -7 Returned when a thread of execution attempts to use a Connection Reference that is currently in use by another thread of execution. -6 A lock was attempted, but either no record was selected by the primary key, the record has been deleted by another user, or another user has changed the value of the key field. -5 EOF. Returned by Fetch Next Record, Fetch Previous Record, or Fetch Record N. -4 User canceled out of the login dialog box. -3 Windows is out of memory. 0 Success 1 Success with warning 2 EOF with additional information 1100 to 30190 Intersolv driver errors. 1501 Cannot create file: 'file_name' 1502 Cannot delete file: 'file_name' 1503 Not enough memory for this command. 1504 Cannot set current working directory to 'dir_name' 1506 Insufficient disk space. 1507 Invalid file handle 1508 Access to file denied 'file_name' 1509 File not found 'file_name' 1510 Path not found 'path_name' 1511 You must run SHARE when locking is enabled or you must set Locking=NONE in your ODBC.INI file 1512 Whole or part of the region has already been locked. 1513 Unable to unlock record. 1514 Lock failed! SHARE buffers have been exceeded. 2100 You can only login to this database once. 2105 Unable to load dynamic link library: 'file_name' 2106 Connection string must contain as DSN= 2700 Token too big:'token_name' 2701 Number too large:'number_string' 2702 Number contains an invalid character:'invalid_char' 2703 Unmatched quote character:'character' 2704 Error parsing connect string at offset 'offset' 2705 Error parsing 'string' at offset 'offset' 2706 Attribute 'attribute' specified more than once. 2707 Attribute specified twice using keywords 'keyword1' and 'keyword2' 2708 Invalid hexidecimal character found during conversion 2709 Quicksort stack overflow 2710 Too many sort keys 2711 Invalid license file 'license_file' 2716 Cannot handle string larger than 65500 bytes. 2717 Initialization file is not open. 2719 Could not create trace window. 3800-3999 undocumented parse errors. 4000-4099 undocumented file errors. 4100 You have exceeded the limit on the number of connection and statement handles. 4101 The connection, statement, or query handle you provided is not valid. 4102 LIKE or NOT LIKE requested for a non-character data type. 4103 You provided an invalid column number. Column numbers must be between 1 and the number of columns returned by the SELECT statement. 4104 The information you requested for a column is not relevant given its data type. 4105 You have exceeded the limit on the number of active programs that can use DTK. 4106 You must retrieve the values for columns in increasing column number order, e.g. column 1, then 2, then 3, etc. You cannot retrieve the value for a column more than once. 4114 The database system you are connected to does not support transactions. 4117 You must call qeBeginTran (Start Transaction) to begin a transaction before you can call qeCommit (Commit Transaction) or qeRollback (Rollback Transaction). 4118 You already have an active transaction. Call qeCommit (Commit Transaction) or qeRollback (Rollback Transaction) to end the active transaction. 4119 You have not given a SQL Statement to be executed. 4123 You must call qeFetchSetOptions (Set Fetch Options) before calling a qeBindCol or qeFetch function (Fetch Column Data or Fetch Next Record). 4125 You cannot use qeFetchPrev (Fetch Previous Record), qeFetchRandom (Fetch Record N), or qeFetchNumRecs (Get Number of Records) without first calling qeSetSelectOptions (Set Fetch Options) to enable random fetching. 4127 You can only call this function if the current statement is a Select statement. 4131 You cannot change this columns value. 'reason' 4132 Attempt to get column attribute that does not exist for this table. 4134 Invalid option specified:'invalid_option'. 4139 The specified column is not searchable. 4140 No database source has been specified. 4143 Missing keyword:'keyword' 4149 error_text 4150 warning_text 4151 HSTMT (SQL Reference) was invalidated at end of transaction. 4153 Fetching on this statement cannot occur until the transaction has been committed or rolled back. 4500 Missing keyword:'keyword' 4501 Unexpected text at end of SQL query:'text' 4502 Empty SQL clause found. 4505 You did not give a SQL statement to execute. 4506 Cannot update or delete record, no primary key available. 4507 Operation aborted! 4508 Duplicate table names not allowed in FROM clause:'dup_table_names' 4511 Unable to insert record into database. 4526 A table or table alias name exceeds 'max_chars' characters. 4531 The value of a field is longer than the maximum length that can be stored in the database or generation of a SQL statement has run out of space (>65000 bytes). 10028 Cannot access drive 30040 Cannot open file 'file_name' 30041 Error on input or output to a file. 30042 Cannot rename 'file_name1' to 'file_name2' 30043 Not enough memory for this command. 30045 The maximum number of files are already open. 30047 Reserved file name cannot be opened 'file_name' 30190 Out of memory Related Links: Attachments:
Report Date: 04/07/1998 Last Updated: 12/02/2004 Document ID: 18682FWV |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
