[Noob] SQLBase won't start

[ychaouche]

Start > Program Files > Unify > SQLBase Engine

No splash screen, no GUI is launched, no error message, nothing. In windows process monitor, I only see dbntsrv for a couple of seconds before it disappears.

[ychaouche]

SQLTalk told me that the sql.ini file was missing a serverpath instruction, which I added.

Code: Select all

[dbntsrv]
dbname=ISLAND
servername=server1
cache=2000
sortcache=2000
readonly=0
oracleouterjoin=0
logfileprealloc=0
partitions=0
optimizerlevel=2
ansijoinsyntax=0
dbdir=C:\Program Files\Unify\Team Developer 6.0
tempdir=C:\Program Files\Unify\Team Developer 6.0

[win32client]
clientname=ychaouche
clientruntimedir="C:\Program Files\Unify\Team Developer 6.0" 
secureapi=0
negotiateapi=0

[win32client.dll]
; order of win32client dll's is important when connecting to multiple databases. 
; sqlws32 should always be the last and sqlodb32 be 2nd last. 

comdll=sqlodb32 
comdll=sqlws32 

[win32client.ws32]
;  Resource Manager (sqlmpipe uses port 2156 explicitly declared instead of
;  default port 2155
autostartserverpath="C:\Program Files\Unify\Team Developer 6.0\sqlbase\dbntsrv.exe" 
serverpath=server1,localhost,2156/*

Now I have this error : Error: 00401 DBA COD Cannot open database

[FRBhote]

If it's not ISLAND you're trying to connect to then:

SET SERVER SERVER1;
INSTALL DATABASE database;

Also try:

SHOW DATABASES ON SERVER SERVER1;

[ychaouche]

Thanks FRBhote. It *is* ISLAND I want to connect to, just to test that the SQLBase engine starts correctly.

What I wanted to do in the first place is to use Team Developer's Object Manager, its code versionning system. Object Manager needs a SQLBase database to connect to. So I wanted to create one via the SQLBase control center but apparently the server itself did not start (SQLBase Engine). I tried and failed to start it so I reported the errors above. I wanted to test the connection to the database by connection to the ISLAND database but it still doesn't work.

But since you said "If it's not ISLAND you're trying to connect to", I don't know if I should try your solution or not ? what do you think ?

[Igor Ivanovic]

Is this the whole sql.ini, or just a part of it?
Cause I don't see some entries You need to successfully start a server:

Code: Select all

[dbntsrv]
servername=server1, sqlws32

[dbntsrv.dll]
comdll=sqlws32

[dbntsrv.ws32]
ListenPort=2156

1) No sqlws32 in servername - I don't remember what is the default if You ommit it, but just to make sure, use it
2) You are trying to connect with a non default port 2156 (the default is 2155), so You must define it

Also, use the SQLBase Management Console (SQLBmmc_XP), and try to start Your server as a program, not as a service.
That way You'll be able to see the actual error, instead of just disappearing.

HTH,
Igor