Home » RDBMS Server » Server Utilities » Data source name not found and no default driver
Data source name not found and no default driver [message #74340] Thu, 18 November 2004 06:24 Go to next message
Chandra Vedantham
Messages: 14
Registered: November 2004
Junior Member
Hi,

I am having problems connecting to Oracle database without using DSN froma VC++ application.

The connection string which I am using to connect is

"ODBC;Driver=Oracle73 Ver 2.5;SERVER=PUBIS.WORLD;Uid=CHANDU;Pwd=Singer12;"

I am not very sure where I am going wrong.

Can anyone find out where I am wrong?

Also can anyone suggest me how to prepare a Connection String

for an Oracle database.I donot want to use DSN.

-Chandu
Re: Data source name not found and no default driver [message #74341 is a reply to message #74340] Thu, 18 November 2004 06:37 Go to previous message
Chandra Vedantham
Messages: 14
Registered: November 2004
Junior Member
Hi
I was able to connect if I changed my connection string to

"ODBC;Driver={Oracle73 Ver 2.5};DBQ=PUBIS;Uid=CHANDU;Pwd=Singer12;"

I could understand the Driver was creating trouble due to spaces in between.
But why was the Server creating a problem?

can we use dbq to connect to any database?

Regards,
Chandra V
Previous Topic: Urgent.
Next Topic: SQL*Loader/Cron
Goto Forum:
  


Current Time: Wed Dec 25 18:48:49 CST 2024