OraFAQ Forum: Networking and Gateways » SQLConfigDataSource giving problems with Oracle ODBC

Home » RDBMS Server » Networking and Gateways » SQLConfigDataSource giving problems with Oracle ODBC

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLConfigDataSource giving problems with Oracle ODBC [message #66441]

Wed, 12 June 2002 15:25

Anil
Messages: 80
Registered: September 2001

Member

Hello, I am trying to configure DSN through my application, and nothing I tried seems to work. Here's what I am doing:
CString odbcDriverName = ""Oracle in OraHome90"
CString attributes = "DSN=OracleDRDB;HOST=localhost;PORT=1521;UID=system;PWD=Anil;SERVER=DRight;"
(SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, odbcDriverName, attributes)),
datails:
1.Database process is running on localmachine.
2.I have a TNS Listener running, and was able to create a SystemDSN usinf ODBC DataSourceAdministrator dialog, but doesn't work when I try thro' my application. I am particularly NOT clear with key words in 'attributes' field
I get the error code as ODBC_ERROR_REQUEST_FAILED, when I tried SQLInstallerError(...) function.

Any help would be greatly appreciated.
thanks/Anil.

Report message to a moderator

Re: SQLConfigDataSource giving problems with Oracle ODBC [message #66442 is a reply to message #66441]

Wed, 12 June 2002 17:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleive SQLConfigDataSource is part of the installer API provided by Microsoft. does it use the Oracle ODBC driver??.
anyhow
HOWTO: Create ODBC Data Sources Using SqlConfigDataSource may be helpful to u.

Report message to a moderator

Re: SQLConfigDataSource giving problems with Oracle ODBC [message #66446 is a reply to message #66441]

Fri, 14 June 2002 14:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

actually my knowledge with anything that is not oracle is very very limited.
anyhow as per your posting
CString odbcDriverName = ""Oracle in OraHome90"
is this the driver Name?
i beleive you need to give a valid driver name.
example
CString odbcDriverName = "{Oracle ODBC Driver}"
and also do check your syntax for using curley brackets etc
( you have used double quotes twice )

Report message to a moderator

Previous Topic:	TNS:could not resolve service name
Next Topic:	Re: ÈçºÎ½¨Á¢Ò»¸öÊý¾Ý¿âÁ´£¿

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 04:50:39 CDT 2025