sqlite ODBC driver and "attach" statement

userRD06 0
Viewed 22

I want to use the sqlite ODBC driver from http://www.ch-werner.de/sqliteodbc/ and start with an ATTACH statement, as I need joint data from two databases. However the driver returns no dataw when provided the following SQL:

attach 'my.db' as mydb; select 1

It however correctly complains with only one SQL statement allowed when the first statement is indeed a SELECT:

select 2;attach 'my.db' as mydb; select 1

Checking at the source, a checkddl() function analyzes if the provided requests contains DDL (Data Definition Language) statement. Before digging in the complete code, question is:

  • did someone manage to issue a select after an attach with this driver ?
odbc sqlite
0 Answers
Related