Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

setup ODBC connection from ubuntu machine.

8456fa7b-8e6f-4267-8f7f-99d477b2186fOct 18 2014 — edited Oct 19 2014

Hi,

I am trying to setup ODBC connection from ubuntu machine. I have searched the net, and was able to connect ODBC after setting TWO_TASK env variable. Now the issue is that how can i set the environment to connect databases lying on multiple servers. can i set TWO_TASK variable with multiple SIDs?

I have made all the entries in tns_name.ora and accordingly set the path in the system

i am able to access all the databases through sqlplus .

but i need to connect the databases using ODBC from my application that uses ODBC to connect to the database.

Thanks a ton in advance.

Abhinav

Comments

contemplator

It's funny that the day before, I get stumped by a problem the whole day... then the next day I find the answer to my problem.

The view is actually working. but the last record is not appearing. This is the same for my tables. no last record.

I get 3 rows in the table in the SQL Command Line.

I get 2 rows in the view in the SQL Command Line.

I get 2 rows in the table in the PHP Web page.

I get 1 row in the view in the PHP Web page.

I have only changed the select statement, the rest of the code is the same.

help?

contemplator

OK, I have just figured it out.

Oracle 11g XE allows for one session. Connecting to Oracle through PHP counts as a session.

Disconnecting the console fixed the problem.

Christopher Jones-Oracle

You can have more than one session at a time to XE.  At a guess, you hadn't committed in the first session and disconnecting performed the commit for you.  This let the other session see the data.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 15 2014
Added on Oct 18 2014
#odbc, #windows-and-net
1 comment
1,038 views