Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Gupta SQLBase dababase problem.

Posted on 2001-06-26
17
Medium Priority
?
4,144 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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 1200 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
 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

972 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