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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODBC driver doesn't appear in ODBC data source

237415Aug 30 2010 — edited Sep 26 2011
Hello,

Before I posted this information request, I check in the forum if I could find information regarding my ODBC Driver installation problem bout I didn't find anything.

I am looking to connect to an application created with Visual Basic. The application must to connect to the Oracle database via ODBC

I installed the ODBC client which come with a package ODAC101040 the installation went smoothly and I did configure the database as well.

I tried to create a data source, I couldn't find the Oracle Driver. I opened the registry and there is not Oracle ODBC Driver under the ODBC

if I have to create the oracle registry link how do I do this?

I need your help and I have a reward for this help

Comments

Pedro F
Answer

If you're looking to get the last underscore of a specific string than you can use the Locate function like this:

LOCATE('_','This_is_a_test_for_OTN' ,-1)

This will return you the numeric position of the last underscore in your string.

Marked as Answer by Subhadeep Guha · Sep 27 2020
Thomas Dodds

"What I need is the position of the Nth occurrence of that underscore(which basically INSTR() function in SQL does). Is there any alternate way of deriving it?" -- use the INSTR() in the PHYSICAL mapping on the logical column in the RPD... this way the function is shipped back to the database which can handle it better than OBIS/OBIPS.

Subhadeep Guha

Thanks Pedro! It worked. Appreciate your help!

Subhadeep Guha

Thanks Thomas for the response! It looks like a more performance friendly solution. I will definitely try it next time I make changes in the RPD. For this time, I needed a quick solution and I used LOCATE('','', -1) in the report.

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

Post Details

Locked on Oct 24 2011
Added on Aug 30 2010
#11g, #odbc, #oracle, #windows-and-net
19 comments
191,549 views