Connecting to a Local Database

March 15, 2007 at 7:24 pm 2 comments

SQL is my kind of fast, powerful, geekiness. I’m forever forgetting the ins-and-outs of connecting to a local database with SQL Anywhere though, so it needs noting.

There’s a pretty comprehensive SupportWeb article that covers everything you need to know. In summary:

  • for Siebel 6 use isql55.exe from the \bin directory, then username DBA and password SQL.
  • for 7.0 and 7.5 use dbisqlc.exe and the same DBA/SQL.
  • for 7.7 and 7.8 it’s still dbisqlc.exe but the login changes to DBA/<Enterprise Name> (in upper case).
  • not sure about 8 yet…

Update: those executables are all in the client\bin directory, regardless of version.

Another login option in all versions is the username SIEBEL with the local password for the database you’re connecting to (in upper case). This can be handy if somebody’s changed the database admin password, for instance…

The Watcom-SQL variant is somewhat different from Oracle or SQL Server SQL, so it’s worth keeping the SQL Anywhere User’s Guide to hand while hacking around.

Advertisements

Entry filed under: Siebel, SQL.

Siebel DBA Resource Tools Object Explorer options

2 Comments


Feeds


%d bloggers like this: