TESTING QUERY: SELECT PhoneNumber FROM TableName WHERE PhoneNumber = '1119' ĮRROR Data type mismatch in criteria expression. If you run a query on a column containing numbers (or other kinds of data) you will get the following error when testing the query in the 6160: Entering a number in Excel will automatically default it to a number value, while the 6160 ODBC connection only supports alphanumerical values. Expected 1.įor example, the column names in the above region would be named Name and PhoneNumber.Īnother important restriction is that the value has to be a text value. TESTING QUERY: SELECT Extension FROM TableName WHERE Extension = '1142' ĮRROR Too few parameters. If you attempt to test the ODBC Connection on inexistent rows, the following error will be returned: By default, it will use the first rows in the region, and use their values as column names. The Excel spreadsheet searchable region needs to have column names. Note that any data outside of the region will not be searchable. This window will appear, and the ODBC Table Name, as entered in the 6160, will be the same as the one defined in this window. Select the searchable area, and select Insert > Name > Define.
#ERROR 42000 MICROSOFT ODBC EXCEL DRIVER DRIVER#
The ODBC driver needs to know what area it needs to search. Make sure the object exists and that you spell its name and the path name correctly. TESTING QUERY: SELECT Extension FROM Directory WHERE Extension = '1142' ĮRROR The Microsoft Jet database engine could not find the object ''. If you try to test the query in the 6160, on a table with no table definition, you will get the following error message: However, by doing only that, you haven’t defined where the ODBC query will search in your excel document. To set up your Excel Spreadsheet, enter your data in rows and columns. It’s important to state that the actual verified collected digits (in the Messaging Service), will fail as well if the Excel document is being used by another program. It is already opened exclusively by another user, or you need permission to view its data.ĮRROR Driver's SQLSetConnectAttr failed For example, if you are currently editing the spreadsheet, and testing it in the UI, it will fail, and give the following error message:ĮRROR The Microsoft Jet database engine cannot open the file '(unknown)'. The first restriction is that not more than one program must be using the Excel spreadsheet. They are listed here, with the associated error that is printed out in the 6160 UI when testing the ODBC connection. We have found issues and restrictions when using ODBC connections to an Excel Spreadsheet. IQ Excel ODBC Connection (Verified Collected Digits)