Gupta SQLBase dababase problem.

I have a problem with a SQLBase 5.x database.

I had a problem with my computer and it restarted automatically when a i was working with my SQLBase database (local database).

Now i can't connect to it.

The message is:

"Cannot open log file

Error: 4005
      Reason: Attempting to open an existing file and a failure has occurred.

      Remedy: Determine and correct the cause of the open file failure. Verify that the specified file exists.  Verify the number of files allowed open for the operating system permits the additional file, that is, check the FILES= configuration parameter setting. "

I don't have a Backup... (very bad, i know).

I need some help.

ineilaAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
and again

--- paste begin

Try running the following:

rollforward (database name) to end;

until you get a restore log file message(usually twice), and then run:

rollforward (database name) end;

Hope it works

----

Thank you Bill and Mike !
Its working very well.
Seems all data still exists.

--- paste end

hope it will work for you to

meikl ;-)

0
 
ThierryBertinCommented:
hi,

i suggest you to find the location and the name of the log file.

So, you delete this file and recreate a file with the same name and extention in the same location.

regards.
0
 
kretzschmarCommented:
this would not work, because in the log-file are the open transactions stored, such a manipulation could leave the database in a inconsistent state, even if it may work to open the database.

without an backup, i guess, you've lost

meikl ;-)
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ineilaAuthor Commented:
That's right. kretzschmar,
the same name of logfile doesn't works.

I know it's 621.log.

I know there are tools for SQLBase 7.x (32bits) to this problem (http://www.downa.demon.co.uk) but i haven't found any tool to SQLBase 5.x ...

I think it's gonna be a imposible mission...

ineila
0
 
kretzschmarCommented:
hi,

found this in a newsgroup

paste begin ---

You do *not* have to connect to the database to do a rollforward.  That is a
function of the server logon.  Do a 'SET SERVER servername/password' and
then you can do a rollforward.  Consider that the database is named MIKE.
Make sure there are no log files in the logdir= directory of the database
(or dbdir= directory if no logdir= statement is used - move them someplace
else and copy the .dbs file someplace else just in case).  Go into SQLTalk,
do a set server command as above and then do this:

A.  ROLLFORWARD MIKE TO BACKUP;
        <<error message returned.  Disregard. >>

B.  ROLLFORWARD MIKE TO BACKUP;  <<Yes, do it again!>>
        <<Log file x.LOG not found>> message returned.

C.  ROLLFORWARD MIKE END;
        <<Rollforward completed>> message returned.

D.  CONNECT MIKE 1 username/password;
        <<Connected to MIKE>> message returned.

E.  Do a check database, etc. to find out the status of your database.

Good luck!

--- paste end

also delete the corrupted logfile,
and do some rollforwards,

maybe it does the trick

meikl ;-)
0
 
kretzschmarCommented:
any results? did you tried my last comments?
0
 
kretzschmarCommented:
keep in mins, i'm NOT the current answerer :-)
0
 
kretzschmarCommented:
mins->mind
0
 
ineilaAuthor Commented:
Ok, this is great!

but before trying it.. i have a problem.

I have installed SQLTalk (i only had installed Wintalk); but i don't know what's wrong with it... because it doesn't works...

I run TLKNRTR.EXE from the DOS prompt.
But it crash with the message:

C:\GUPTA>tlknrtr

SQLTALK Interactive Data Manager (Version 5.2.1-PTF7)
Copyright (c) Gupta Corporation 1985-01. All Rights Reserved.

Database[DEMO    ]:
Username[SYSADM  ]:
Password[?!?!?!?!?!?!?!?!]:
Connecting to DEMO in Interactive Line Mode

Error: Network not functioning

What's wrong???

I don't know if i need some special configuration to run SQLTalk.

ineila
0
 
kretzschmarCommented:
hi ineila,

do you have experience with gupta?

there is a sql.ini file, and a configurationtool, with which the entries can be edited,
but experienced users can do this also by hand.

for me its now a long time ago, where i used gupta-databases,
and i may have not all in mind.

try to configure the sql.ini file, which should reside with your client software.

there is to define the databasename and the protocol, usual in the winclient-section
of the sql.ini file.

maybe it helps to post the content of the ini-file here

meikl ;-)
0
 
ineilaAuthor Commented:
Yes, i have some experience, but i see not enough :)

I have my sql.ini configured to works properly with Wintalk; but i don't know what it needs to configure to SQLTalk...  and my server is dbwservr.exe not a DOS server.

Here is my sql.ini

[dbwindow]
cache=1000
directio=0
;dbdir=C:\SQLBASE
dbdir=C:\SQLBASE

[dbwservr]
servername=server1
locktimeout=2
directio=0
dbdir=C:\SQLBASE

cache=200
[winclient]
clientname=server1

[winclient.dll]
comdll=sqlwsv

[winclient.nbiow]
;
; This section is used to specify parameters that a Windows client workstation
; using NetBios would use. Uncomment ibmnetbios=1 if using Windows or WIN-OS/2
; with IBM NetBios.
RetryTimeout=10
;ibmnetbios=1

[dbdfault]
errorfile=DB2ERROR
defaultdatabase=PRENSA
defaultuser=SYSADM
defaultpassword=SYSADM


[dblocal]
;dbdir=C:\SQLBASE
dbdir=C:\SQLBASE

[dbxcombo]
;dbdir=C:\SQLBASE
dbdir=C:\SQLBASE

[dbxlocal]
;dbdir=C:\SQLBASE
dbdir=C:\SQLBASE

[sqlxdemo]
;dbdir=C:\SQLBASE
dbdir=C:\SQLBASE

Thanx, Ivan
0
 
ineilaAuthor Commented:
Sorry, but i have discovered that TLKNRTR.EXE is a spx router.

I have tried sqlxdemo.exe but it doesn't works.. it crashes... I don't know what i need to run SQLTalk...


Ivan
0
 
kretzschmarCommented:
sorry,
i must pass, didn't have the correct entries in mind

do you tried to use the configurations tool to configure?

0
 
ineilaAuthor Commented:
sorry, I don't have the configuration tools..
Does SQLTalk needs another special file configuration?

Does SQLTalk executes under ms-dos prompt in Win95??

0
 
kretzschmarCommented:
no, but the enviroment-variable must be set,
as i remember correct, then there is an enviroment var like

set sqlbase=ADirectoy

whereas ADirectoy is the directory where the sql.ini resides

but i'm unsure bout this

do you have no manual?
0
 
ineilaAuthor Commented:
I get IT!!!

I needed DOS 6.22 and enough conventional memory free! ... Not Win95 to RUN sqlxdemo.exe.

I ran sqlxdemo noconnect
then i executed:

rollforward (database name) to end;
rollforward (database name) to end;
rollforward (database name) end;

Thanks Kretzschmar!!
0
 
kretzschmarCommented:
puh,

glad that you got it work :-)
its a long time ago i used the gupta database,
therefore, sorry that couldn't help more specific.

thanks for the points :-)

good luck again

meikl ;-)
0
All Courses

From novice to tech pro — start learning today.