3

I am currently trying to access a SQLite database via an ODBC connection but the system that I am working on is extremely locked down and it is therefore not possible to install the drivers. Is there any way to bypass this?

2
  • What are you trying to do? Are trying to access the data from a frontend application or just trying to query for data?
    – Nelson
    Aug 21, 2015 at 22:18
  • 1
    Use the client from a memory stick?
    – Vérace
    Aug 22, 2015 at 2:12

2 Answers 2

1

ODBC as just an interface between applications and drivers.
It is impossible to create an ODBC connection without using some installed driver.

0

The answer will depend upon what tools you have available. What database system are you trying to get the data into? Oracle? Sql server? Windows machine or unix box?

One alternative could be install software on a 3rd machine. (your PC?) Extract the data and convert it into a suitable format to import.

Another option could be to export the data to a .csv file and then import that.

You could use Excel, MS Access or even sql express.

However, this is going to become part of a regular process. I suggest you try again to have the required drivers installed. That would be the cleanest and most straight forward option. Everything extra step you have to take costs time and introduces risk.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.