ODBC

new topic     » topic index » view thread      » older message » newer message
  • Posted by RogerL Jan 15, 2010
  • 1144 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

new topic     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu