pchaloux
asked on
SQL WorkSheet
Hi,
I used to have SQL Worksheet with Oracle 7.3.
When i wanted to start it, all I had to do is to click on a shortcut. I didn't have to enter the username and password. In the shortcut, the command was :
C:\orant\BIN\VAW.EXE username=myUserName password=myCurrentPwd service=MyDOMAINE
Now, i'm using SQL PLUS WorkSheet with Oracle 8.1.
The command that starts SqlPlus is :
D:\Ora81NT\bin\oemapp.bat WORKSHEET
I tried to add parameters (after 'WORKSHEET'), but it didn't work
How should i proceed to have the same result as I use to have ?
Thanks in advance
I used to have SQL Worksheet with Oracle 7.3.
When i wanted to start it, all I had to do is to click on a shortcut. I didn't have to enter the username and password. In the shortcut, the command was :
C:\orant\BIN\VAW.EXE username=myUserName password=myCurrentPwd service=MyDOMAINE
Now, i'm using SQL PLUS WorkSheet with Oracle 8.1.
The command that starts SqlPlus is :
D:\Ora81NT\bin\oemapp.bat WORKSHEET
I tried to add parameters (after 'WORKSHEET'), but it didn't work
How should i proceed to have the same result as I use to have ?
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It worked, thanks
If you mean , you want to use sql worksheet with Oracle 8.1
server , you still be able to use your old SQL worksheet program.Just change your service to poin to tns of 8.1
C:\orant\BIN\VAW.EXE username=myUserName password=myCurrentPwd service=setvicefor8
I understand that in 8.1 client , they come with sqlPlus not Sql Worksheet.
HTH