Problems connecting to SQLBase using SQLTalk

[paskuda]

Hey there.
We're using at our company SQLBase Server 7.5.1. It has just one, yet huge database, which is designed to work with specialised software we get from public health department.
I've been trying to connect to this database using SQLTalk, because we need some reports on patients that are not included in software.
The configuration in sql.ini is:

[dbnt5sv]
servername=START,sqlapipe,sqlws32
cache=8000
sortcache=4000
readonly=1
oracleouterjoin=0
logfileprealloc=0
partitions=0
optimizerlevel=2
locktimeout=275
centurydefaultmode=0
password=ourpassword
dbdir=C:\CENTURA\DATA
tempdir=C:\CENTURA\TEMP
country=poland
dbname=RUMKAT,sqlapipe,sqlws32

I sniffed login data using the Ethereal, what I got is:
.......RUMKAT/C7340119/LOOGJLDPIHHICILK............
RUMKAT is the name of our DB, C7340119 is user name, so I guess LOOGJ* is the password.

Having all that, I tried to connect to the database:
connect RUMKAT C7340119/LOOGJLDPIHHICILK;
Error: Invalid password

Any ideas on what might be wrong ? Maybe the password in [dbnt5sv] sql.ini's section has something to do with it ?
Hope you think of something

Cheers

 

[GuptaSteve]

Paskuda

Usually you can connect to Sqlbase as SYSADM/SYSADM if all else fails. Try that. Alternatively, you may need to try: 'Set server START' before the connect. Or try commenting out the password entry in sql.ini temorarily (Restart Sqltalk afterwards ). It maybe that LOOGJLDPIHHICILK is the encrypted version.Otherwise find a different user to connect as.

 

[paskuda]

Steve,

Thanks for help. I found a way to bypass this problem by exporting reports generated by our software into xls files and then using small program I've written to insert them in my firebird DB.

And I didn't manage to connect to SQLBase anyway ;-) I'm not the one who installed it, he's not working here anymore, and he didn't leave any passwords/configuration info. Data security at it's best ;-)

Thanks again,
Michael

 

[OliverA]

The setting password= in the sql.ini is not the password for your database user connect. It represents the global password for the server connect. So, if you want to do a 'SET SERVER.... ' you need to do it with this password.
e.g. in your case: SET SERVER START/OURPASSWORD