Advertisement

08.16.2007 at 08:12PM PDT, ID: 22768870
[x]
Attachment Details

Connecting to Oracle through TNS DSN, SqlSetConnectAttr failed

Asked by dolphin_g in MS SQL DTS, Oracle 10.x, ActiveX

Tags: oracle, sqlsetconnectattr, failed

Im trying to Connect to Oracle Instance from my ActiveX Script Task using ADODB Connection. Created a System DSN with the Oracle Client Driver installed on my server (Windows 2000 & SQL Server 2000).

The system DSN is fine, tested it several times and by creating other Connections. But when i try to run the activeX script It throws an

 Error: {Microsoft ODBC Driver for Oracle} SqlSetConnectAttr failed.

The snapshot of the code is :

myConn.open "Driver = {Oracle in OraClient10g_home1};DSN:ods;user=userid;pwd=pwd"

i get an error when i try to execute a sql statement

ASAP please.

Thank you.Start Free Trial
[+][-]08.17.2007 at 12:05AM PDT, ID: 19715024

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.17.2007 at 11:49AM PDT, ID: 19719340

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.18.2007 at 03:05AM PDT, ID: 19722149

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.18.2007 at 06:14PM PDT, ID: 19724305

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.20.2007 at 11:39AM PDT, ID: 19732597

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, Oracle 10.x, ActiveX
Tags: oracle, sqlsetconnectattr, failed
Sign Up Now!
Solution Provided By: dolphin_g
Participating Experts: 1
Solution Grade: B
 
 
[+][-]09.07.2007 at 03:10AM PDT, ID: 19846457

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]09.11.2007 at 03:42AM PDT, ID: 19867341

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]09.11.2007 at 03:42AM PDT, ID: 19867342

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628