Hi!

I have this file called:
CVendu_db_200405251319.BAK

According to: file CVendu_db_200405251319.BAK it is "data".

the first couple bytes as seen from VI are
TAPE^@^@^C^@~L^@^N^A^@^@^@^@^@^@^@^@^@^@^@^@^@

I have a second file, that was probably created using the same method as the first.

According to file:
Forum_db_200405291319.BAK: data

The first file is 100mb the second is 2 mb.

According to vi the second file starts with:
^@^@^B^A^A^@^@^@^@^@^@^@Z^@^

I am so totally stumped. I need these files opened. I am pretty sure that they are backups of databases. Because the CD the guy gave me has a website coded in ASP and these two files. (Also they say db in the name).

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=CVendu"
That is how it is referenced.

The data, however it is stored, was originally a SQL database.

I found many SQL statements in the ASP code such as objRS.Open "SELECT @@IDENTITY AS Test",
objConn, 1, 3, 1

So how is it saved? Unfortunatly I do not know which SQL server was used. Wether it was mySQL or Micro$oft SQL Server. I would appreciate any thoughts on the situation.

(It is neither a Gzip, Tar, Bz2 or ZIP file. I tried these. Windows XP does not recognize it as a backed up file).


Thanks,

David

Been a while since I've mucked about with winDOHs
programming, but I think ADO is an abstraction layer
that will pretty much allow you to treat near everything
as if it were an SQL database ... for all I know the file
you're accessing may be Access, Excel or any other
product. From the interpretation of vi one can't tell too
much, either, maybe if you use a binary editor and
copy and paste?

I'd suggest you just ask "the guy who gave you the
CD" what the stuff was made with, though ;)


Cheers,
Tink

SELECT @@IDENTITY

is microsoft sql server for returning the last autoinc key used from the last INSERT statement. if that's code that uses the database, its sqlserver alright.

And you'll have to figure out sql server administrator to restore the backup... and its not easy. the menu option to restore a file is burried like 18 levels deep. (*I found it once, and it wasnt obvious*)

-Andy