Data source name not found and no default driver [message #74340] |
Thu, 18 November 2004 06:24 |
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 |
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
|
|
|