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?

asked Aug 21, 2015 at 17:24
2
  • What are you trying to do? Are trying to access the data from a frontend application or just trying to query for data? Commented Aug 21, 2015 at 22:18
  • 1
    Use the client from a memory stick? Commented 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.

answered Aug 22, 2015 at 16:47
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.

answered Aug 26, 2015 at 5:02

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.