Oracle Database Using Query Database Module

[renil]

I am running Win2K, Processional SP3.

 

On this machine I have an oracle instance running with sid "imsid". Using the Oracle ODBC 32 bit test which comes with the Oracle 8i installation for windows, I am able to connect and execute queries on this database. Using the ODBC Data Source Administrator a System DSN named "test" with the Driver "Oracle ODBC Driver" is added.

 

Now when I run the script, which is attached, I get a pop up

.........................................................................

Oracle8 ODBC Driver Connect |

........................................................................|

Service Name:im.slb |

User Name:IM |

Password:** |

........................................................................|

 

Although I am typing the correct password, here is a part of the trace where it begins to fail:

143958.42 8 PlaySoundStop ok

143958.43 8 [save Data to File] Run Program

143958.43 8 RVreplace start: [C:\WINNT\system32\command.com /c echo $RV[NIR] > C:\output.txt]

143958.43 8 RVreplace end: [C:\WINNT\system32\command.com /c echo 41030815143924 > C:\output.txt]

143958.44 8 running:[C:\WINNT\system32\command.com /c echo 41030815143924 > C:\output.txt] WindowMode:[Hide]

143958.47 8 Run Program continuing...

143958.47 8 Going down On Success path.

143958.48 8 [iMQUERY] DB Query

143958.49 8 ODBC mode used

144001.59 8 monitortone 1

144002.54 8 ERROR 5.0.2000 OpenDatabase [3146:ODBC--call failed.]

144002.55 8 Hanging up call... [srlib 282]

144002.56 8 RecSoundStop ok

144002.56 8 PlaySoundStop ok

144002.57 8 fnHangupCall end

144002.61 8 linedevstate 2048 0 0

144002.61 8 callstate IDLE 65741 0 0

144002.62 8 WorkingMode@Idle=

144002.62 8 tapi Reply 65622 0

144003.52 8 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

144003.52 8 ReinitTelephony due to IDLE start

144003.52 8 tapic lineDeallocateCall(MainCall:65741) 0

144003.82 8 lineOpen(8) => 0

144003.82 8 Waiting for a call...

144003.82 8 lineOpen(8)LineHandle=65605

 

The connect String used here is :

Database :test

Connect String

ODBC;DSN=test;UID=im;PWD=im;SRVR=t:DWANG9A-APC:imsid;

Query

select SID from engineers where id=02

 

(By the way, I did verify the query works and the instance is up and running)

 

So, here are the questions to which I would appreciate any help:

 

1. why is there a pop up, can it just straight away connect to the database with the UID/PWD provided?

2. what am I doing wrong here that is causing the script to fail? (script attached)

3. Should I be using a System DSN with a "Microsoft ODBC for Oracle" driver? If that is the case how would the connect string look?

 

Please guide and advice!!

 

renil

Helpdesk.vgs

[SupportTeam]

Not too sure why the ODBC driver is popping up the login box - usually these things happen if the ODBC driver was not supplied enough data in the connect string... and I'm not an expert on Oracle connect strings, so I cannot comment on what could be amiss here...

 

If the OpenDatabase call returns the error this means that the ODBC driver used did not allow the connection...

Are you using the latest Oracle driver?

 

If you're stuck I'd recommend looking at what other approaches could be used here - and trying the "Microsoft ODBC for Oracle" driver would be a good next step - I don't know what the connect string should be for this driver so you may want to do a search for "Microsoft ODBC for Oracle" on :

 

http://www.google.com/groups

 

(a search on "Oracle ODBC Driver" there might bring up some usefull info as well...)

 

 

Another approach would be to use the "Oracle OLE objects" to access the database directly - you can use them from within the "Run VB Script" module.