Error messages while using ACCESS
I am getting this error when connecting to the
database:
[Microsoft][ODBC Microsoft Access Driver] Data type
mismatch in criteria expression.
New versions of OZEKI SMS allow you to control the SQL queries used to access the data in your Access database. In these versions, you must modify these queries to make things work. Here is what you should do:
Remove the apostrophe around the word $id. ('$id' should be changed to $id)
Here is what you'll get after modifying the SQL statements:
This form can be accessed from Ozeki SMS after installing the Database Plugin and clicking on the Plugins / Database Configuration menu item)
Before running the SMS Server you need to delete all the unprocessed queries (see the image below) These unprocessed queries are not stored in order to avoid data loss - in case the queries are not getting processed. After deleting the Uprocessed SQL Queries window section will remain blank.
I am getting this error when connecting to the database:
[Microsoft][ODBC Microsoft Access driver] The table ('ozekismsout')
has ben opened by another user and cannot be accessed
Log out of the Access or close the design view.
I am getting this error when connecting to the database:
[Microsoft][ODBC Microsoft Access driver] Too few paramters. Expected: 1.
Most probably the ozekismsout table doesn't contain all the necessary coloumns. Check the name and number of the coloumns.
More information
- Binary messages
- ACCESS error messages
- Database table update
- Database memory leak
- VCard
- How to send a Flash SMS
- Plugin installation
- Database connection in Service Mode
- Special charaters
- New Line Character
- Database field size 160 charaters
- Automatic Startup
- Dummy phone for developers
- SMS_SEND_FAILED
- Date formats
- Changing Sender Number
- TC35 Connection
- Nokia Connection
- Service Startup Failed