Prev Previous Post   Next Post Next
Old 9th May 2016, 23:51   #1
pkonduru
Member
 
Join Date: Jul 2015
Posts: 62
Oracle connection test

Hi all,

I tried searching around but could not find a solution to test an oracle connection in the forums. This is what I tried doing so far:
--On the command line this works:
"sqlplus user\pwd@SID"

I am trying to run this using nsExec(all the three parameters are variables)
nsExec::Exec "sqlplus $user/$pwd@$SID"
Pop $0
Pop $1
$0 has "1"
$1 has some random number like "13390"

Is there anyway from the output I can tell connection has been successful ? I tried writing to a log file and that works

nsExec::Exec "cmd /C sqlplus $user/$pwd@$SID > C:\sqltest.log"

Any other way to test this without having to write to a log file?

--Pavan
pkonduru is offline   Reply With Quote
 
Go Back   Winamp & Shoutcast Forums > Developer Center > NSIS Discussion

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump