1. ODBC
- Posted by RogerL Jan 15, 2010
- 1145 views
Trying to set up an odbc connection to an sqlite database. Have no problem doing so with a dsn and openConnectionODBC, but would like to use openDriverConnectionODBC with a connection string to simplify distribution and installation of software. Can get openDriverConnectionODBC with no connection string and prompting for the DSN - but don't seem to be able to get the connection string right - currently using :-
k = openDriverConnectionODBC("Driver=SQLite3 ODBC Driver;Database=c:/users/roger/euphoriaodbc/ClubBooks.db3;", get_handle(mainPanel), SQL_DRIVER_NOPROMPT)
Have tried all sorts of variations (such as putting in empty username and password fields in the connection string - I don't have a username or password).
Could someone please give me an example or otherwise show me where I am going wrong.
Thanks
RogerL
2. Re: ODBC
- Posted by m_sabal Jan 18, 2010
- 1080 views
Just to make sure the file path isn't a problem, try doing a standard Euphoria open on the file, using the exact same path as you have listed, and make sure you don't get an error. Also, I noticed you have Database=.... For SQLLite, it should be Data Source=... Connection String examples
