Support forum
Add Reply
Add Topic2:53 pm
May 28, 2013
Offline
QuoteThe link does not give any information about the reason for the error. It is possible that the error is caused by copying error in the SQL statements or perhaps because of a different ODBC or OLEDB driver that requires a slightly different SQL syntax, but that is hard to tell without a specific error.
You can find an empty 'SMSServer.mdb' Access database file in the 'Examples\SQLConnector' subfolder in the installation folder of Diafaan SMS Server. You can use that database file if you are not able to create a new database file with the SQL statements.
Regards, Henk
12:26 pm
Hi Henk , when I press help from Microsoft it directs me to this
10:27 am
May 28, 2013
Offline
Hello Dimitris,
I have tried the SQL statements for the Access database on the most recent version of Microsoft Access and did not get any syntax errors in the SQL statements.
What is the exact syntax error that you get?
Regards, Henk
10:00 pm
Hi, I downloaded earlier today the app and I began to give it a try but when I follow your instructions to create the database in ACCESS using SQL commands, when I copy and paste the commands in the SQL Query I get the syntax error from ACCESS and it wont create the table.
Can you please help?
Thank you in advance
1 Guest(s)