ODBC Driver for SQLite: attach database

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
bairog
Posts: 120
Joined: Mon 29 Apr 2013 09:05

ODBC Driver for SQLite: attach database

Post by bairog » Mon 16 Jul 2018 12:53

Hello.
Does ODBC Driver for SQLite support attach database in connection string?
Thank you in advance.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: ODBC Driver for SQLite: attach database

Post by MaximG » Tue 17 Jul 2018 12:03

Our driver doesn't support attach database in connection string. However, you can attach the database you are interested in (for example, C:\contract.db3 file), execute the following query:

Code: Select all

     ATTACH DATABASE 'C:\contract.db3' AS CONTRACTS
Detailed information about the command can be found at: https://www.sqlite.org/lang_attach.html

Post Reply