Solved

Gupta SQLBase dababase problem.

Posted on 2001-06-26
17
3,737 Views
Last Modified: 2012-06-21
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.

0
Comment
Question by:ineila
  • 10
  • 6
17 Comments
 

Expert Comment

by:ThierryBertin
ID: 6238900
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6251551
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
 

Author Comment

by:ineila
ID: 6253366
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6254464
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
 
LVL 27

Accepted Solution

by:
kretzschmar earned 300 total points
ID: 6254479
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6258446
any results? did you tried my last comments?
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6258454
keep in mins, i'm NOT the current answerer :-)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6258514
mins->mind
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:ineila
ID: 6265458
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6266167
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
 

Author Comment

by:ineila
ID: 6268056
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
 

Author Comment

by:ineila
ID: 6274533
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6275888
sorry,
i must pass, didn't have the correct entries in mind

do you tried to use the configurations tool to configure?

0
 

Author Comment

by:ineila
ID: 6277492
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6280069
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
 

Author Comment

by:ineila
ID: 6286628
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6286865
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now