Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

odbc driver sqlite

87f73e4e-c9cb-4825-a60a-b67640417afbJun 15 2015 — edited Jun 16 2015

I create an ODBC connection to SQLite  as in thread Creation db link to Sqlite?

file initdg4odbc.ora

#

# HS init parameters # HS_FDS_CONNECT_INFO = SQLITE2ORACLE

HS_FDS_TRACE_LEVEL = 4

#

# Environment variables required for the non-Oracle system # #set <envvar>=<value>

tnsnames.ora in network\admin:

dg4odbc  =   (DESCRIPTION=     (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1524))     (CONNECT_DATA=(SID=dg4odbc))     (HS=OK)   ) 

listener.ora in the same folder:

SID_LIST_LISTENER=   (SID_LIST=       (SID_DESC=          (SID_NAME=dg4odbc)          (ORACLE_HOME=D:\ora11\product\11.1.0\db_1)          (PROGRAM=dg4odbc)       )   )

I created an table in Sqlite:

create table table1(col integer)
insert into table1 values (1)

Using this the above configuration I successfully create a working database link:

create database link test using 'dg4odbc';

This SQL runs correctly:

Select * FROM table1@test;

the above select returns the correct values.

However I can't run the following SQL :

select col from table1@test;

00904. 00000 -  "%s: invalid identifier"

Does anybody knows why can't I have named columns in the sql statement?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2015
Added on Jun 15 2015
4 comments
1,448 views