Then I tried installong the 32 bit version. After that couldn't I see the odbc driver for Oracle in 64 bit odbc. At that time could I however fix my odbc source by running the 32 version av odbc! C: Windows SysWOW64 odbcad32.exe. But installing the 32 version av Orcale didn't help my fixing linked servers.
Active3 years, 4 months ago
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?
user73322user73322
2 Answers
ODBC as just an interface between applications and drivers.
It is impossible to create an ODBC connection without using some installed driver.
CL.CL.It is impossible to create an ODBC connection without using some installed driver.
3,11311 gold badge1212 silver badges1616 bronze badges
![Install odbc driver without admin rights windows 7 Install odbc driver without admin rights windows 7](https://www.stata.com/support/faqs/data-management/configuring-odbc-win/8.1user.png)
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.
Sir Swears-a-lotSir Swears-a-lot2,34422 gold badges1616 silver badges3535 bronze badges