Connection string to Oracle Database

I am looking to set up a connection from my CRM to an Oracle database.
I have installed the Oracle Client on the CRM Server but an struggling with the connection string. Can anybody advise me on the syntax please?

This is what I am trying:

Server=10.99.9.999;database=dbname;uid=dbowner;pwd=password;driver=Microsoft ODBC for Oracle

Getting this error:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Open in new window

The ODBC driver is installed on the CRM server and I am using the database name defined in thr tnsnames.ora.

Thank you.

Databases* ODBCOracle Database* Oracle connection

Last Comment

Rita Byrne

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

7/15/2021

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Rita Byrne

7/15/2021

ASKER

Thanks very much for the response and info. It sounds exactly like the solution I need.
I've downloaded the basic version with the odbc add-ons.Sophos is preventing me from installing right now but I will get this sorted and I'm confident that your recommendations will resolve my issue.

Many thanks.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Certified Expert Program

Credly Partnership

Udemy Partnership