Monday, June 29, 2009

Getting hard time opening DBISQLC ?

Whenever you need to run a query in your Siebel Local database, sometimes it feels bad as we need to follow the below steps everytime :

1. Navigate to SiebSrvr/Bin folder.
2. Open DBISQLC
3. Need to fill in the followig fields in Connection window :
a) Under Login Tab: fill in User Id and Password (in CAPS)
b) Under Database Tab : Click on Browse and locate the SSE_DATA.dbf file.
4. Click on "Ok".

hhmmmm, following the above steps everytime is not a good choice, isn't it?

okayyy.. lets automate this and try to open dbisqlc in just a button click, sounds good !! I know :)

Here are the steps : (taking the assumption Siebel is installed in "E:\Siebel\8.1\Client", "E:\Siebel\8.1\Tools")

1. Create a new batch file (for eg: "mydbisqlc.bat") on the desktop.
2. Copy paste the below lines of text in it.
cd E:\Siebel\8.1\Client_1\BIN
e:
dbisqlc -c
userid=SIEBELMANTRA;password=MYPASSWORD;databasefile=E:\Siebel\8.1\Tools_1\LOCAL\sse_data.dbf

.........................Note : Please change your user name and password in the above command.

3. Save the file on Desktop for keep it handy.
4. Double click on it and enjoy.

I know you must be smiling now after getting this cool tip !!!!
Check it out !!!!!!
.

4 comments:

  1. Thank you. Definitely helpful.

    ReplyDelete
  2. Though dbiSQL is a nice tool, its user interface is far from userfriendly. There are several options available to eliviate this inconvinience. Here I give you two:

    The local tools/web client database is in fact a Sybase Anywhere database. This means that you can use the free developer edition of Sybase Anywhere from http://www.sybase.com/products/databasemanagement/sqlanywhere to do your regular queries, but also to manage users on the database and other priviledges you may want to change. For example when you want to locally test something that involves checking responsibilities/position then visually creating a new user on the local DB for will be extremely helpful.

    If you want a regular SQL client that can work accross several database systems at once then I can recommend the open source SQL Explorer: http://www.sqlexplorer.org/. Doesn´t break the bank and with its functions to remember queries, tables tree listing and tabbed sql result windows its far better then dbisql.

    In the end it is often upon personal preference, but that can be accomodated by the many open source sql tools available.

    ReplyDelete
  3. Cool tip indeed :) thanks

    ReplyDelete