02
Apr
07

Toad using instant client

I’ve seen plenty of search concerning Toad and instant client.

Instant client requires a bit of work to get it work. But if it works and toad doesn’t then look somewhere else 😉

Working with toad is not much a problem with instant client it concerns the CONNECT_DATA parameter in the tnsnames.ora file.

MYDB.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYDB.WORLD)
)
)

Try to add the parameter SID = MYDB instead.

Toad should work better like this. That’s a solution based on experience. If it’s not or if you have another solution, feel free to add your comment to this post. It will help others.

Advertisements

2 Responses to “Toad using instant client”


  1. September 20, 2014 at 4:39 pm

    I’ve been browsing online greater than 3 hours as of late, yet I by no means discovered any fascinating
    article like yours. It’s pretty worth enough for me. Personally, if
    all web owners and bloggers made excellent content
    material as you did, the web will probably be a lot more
    useful than ever before.

  2. November 13, 2014 at 6:37 am

    Casinos Australasia – Gamble online at a licensed and secure Web casino.
    Paris Casino & Sportsbook – Exciting On line casino motion & Sports activities betting awaits you!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: