473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Dumped in my lap

Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks
Jul 19 '05 #1
9 1434
The pages would have no way of knowning anything about the database. You'll
have to go through to the code in the pages and see what comments are in
there and if the creator used dynamic SQL that will let you get the names
and relationships of DB objects and try to piece it together manually.

Ray at work

"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks

Jul 19 '05 #2
"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?


You'll probably have to infer the database from the code. Look in code for
any object that is either assigned by .Execute([sql statement]) or by
Server.CreateObject("ADODB.Recordset"). In either the SQL statement that
creates the object, or the ("ColumnName") properties of the object, you
should see the column names that have to exist, and may get a sense even of
the datatype of the column from how it is used, or what it is named.

Good luck!
Jul 19 '05 #3
On Wed, 10 Dec 2003 06:16:52 -0800, "Paul Clemmons"
<pc*******@pcnetworkswa.com> wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?


Without documentation on the database structure, the best you can do
is start working through the coe, noting database, table and field
references. Hopefully the other company used field names like
FirstName or FName and not Field1. You may have to do a lot of work
with relationships, depending on how sophisticated the original
database was.

Jeff
Jul 19 '05 #4
Paul Clemmons wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a
fairly complicated interactive website in ASP, provided it to a
customer and didn't give them the database to make it all work. The
company went out of business and I have a customer with everything to
do the site but the database. Is there any way to rebuild the
database using the existing pages? I am fairly proficient at
databasing SQL and Access and good at HTML, but can someone give me a
good place to start in building up the tables for this thing?

Paul Clemmons
PC Networks


Did the customer provide specs for the application?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #5
Wow, thanks guys. I have been posting to groups here for years and this has
to be the fastest I have seen responses. I will let you know how it goes.
Paul
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:3f*************@msnews.microsoft.com...
On Wed, 10 Dec 2003 06:16:52 -0800, "Paul Clemmons"
<pc*******@pcnetworkswa.com> wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn'tgive them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?


Without documentation on the database structure, the best you can do
is start working through the coe, noting database, table and field
references. Hopefully the other company used field names like
FirstName or FName and not Field1. You may have to do a lot of work
with relationships, depending on how sophisticated the original
database was.

Jeff

Jul 19 '05 #6
If at all possible get hold of someone (anyone at all) from the other
'Company' and try to get hold of a sample / production database. Investigate
where the website was hosted and see if the host has the database. See if
the customer has any mobile numbers for contacts with the company - perhaps
they used contract developers?
If all this fails (and I'm pretty sure you will have tried all that) then
it's going to be a long, horrible, painful job to recreate the DB.
My suggestion is to get the customer spec on the site and create a new DB
(your own design), write and implement a DB access layer in your preferred
language of choice (script, VB, etc.) and then go through and re-connect the
pages to the new DB access layer.
Trying to re-create the original will be nigh on impossible unless its a
simple one or two table database.

Chris.

"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks

Jul 19 '05 #7
He provided me all the asp pages and images. It is like both ends of a
puzzle, with the middle ripped out. The company that created it for my
customer went out of business last year and the database went with it. My
customer has been trying to contact the owner, but 1) he is up in Canada and
sort of gone dark and 2) when he did contact him about two months ago, he
said that he could do it for another $5k (customer already paid $4600 for
what he has now) and it will be another month or so to do it. I am figuring
it will take me about two weeks to get the db back in place and put it on my
development server locally to test and find all the bugs in it.
Fortunately, the main thing the customer needs up is a news database and a
membership database up and running in short order, the rest is a bit later.
Phases.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Paul Clemmons wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a
fairly complicated interactive website in ASP, provided it to a
customer and didn't give them the database to make it all work. The
company went out of business and I have a customer with everything to
do the site but the database. Is there any way to rebuild the
database using the existing pages? I am fairly proficient at
databasing SQL and Access and good at HTML, but can someone give me a
good place to start in building up the tables for this thing?

Paul Clemmons
PC Networks


Did the customer provide specs for the application?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 19 '05 #8
Did the design firm also host the site. If not, the DB
may be available from their webhost or possibly on a
backup tape somewhere at the webhost.

Worth a try.

-----Original Message-----
Hopefully someone can help me, or at least direct me to the correctnewsgroup. I just inherited a project where a company created a fairlycomplicated interactive website in ASP, provided it to a customer and didn'tgive them the database to make it all work. The company went out ofbusiness and I have a customer with everything to do the site but thedatabase. Is there any way to rebuild the database using the existingpages? I am fairly proficient at databasing SQL and Access and good atHTML, but can someone give me a good place to start in building up thetables for this thing?

Paul Clemmons
PC Networks
.

Jul 19 '05 #9
Jon
In the ASP pages look for the part where it connects to the database (eg
strMDBpath = "e:\.........") this will tell you it's name and expected
location.

Next the fields and table name (strsql = "SELECT COLUMN_NAMES FROM tblNAME
WHERE .......)

The "COLUMN_NAMES" will be the fields, separated by commas.
The "tblNAME" will be the table name.

Look at the ASP page in Dreamweaver or whatever and see what sort of data
will go in the boxes etc, so if it expecting a data, set the field type to
date/time

And so on....

Certainly not worth $5k

Good luck

Jon

"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks

Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Nish | last post by:
I have the coredump of my process that crashed. Is there any unix utility/program or option in gdb that can be used just to find out as to the process core-dumped because of which signal? I do...
1
by: Paul Mc Gee | last post by:
hi everybody i have postgresql installed on my red hat linux machine and i want to load up a dumped postgresql database which i have on cdrom. does anyone know how i could do this? thanks paul...
13
by: N.S. du Toit | last post by:
Just having a bit of trouble programming with C under FreeBSD 5.1 using the gcc compiler. I'm a bit new to C so my apologies if the answer to my question appear obvious :) Basically I've...
2
by: yezi | last post by:
How to check out the segment dumped file and debug them in c? Thanks
6
by: Rajesh Kumar Mallah | last post by:
Greetings! It is found that pg_dump does not dump function referred in CHECK constraint definations before dumping the table defination . As a result the tables do not get restored due to lack...
0
by: dboileau | last post by:
Can anyone help me out with this error, I am trying to compile mysql with gcc 3.4.6 (Compiled from source) using CC=gcc CFLAGS="-O3 -mcpu=v8 -Wa,-xarch=v8plusa" \ CXX=gcc CXXFLAGS="-O3...
5
by: su | last post by:
to find which process dumped core at the promt we give $ file core.28424 core.28424: ELF 32-bit LSB core file of 'soffice.bin' (signal 11), Intel 80386, version 1 (SYSV), from 'soffice.bin' ...
29
by: DanielJohnson | last post by:
I wrote this small program to reverse each word in the string. For example: "I love You" should print as "I evoL uoY". I get Segmentation Fault (core dumped) error upon running the program. It...
2
by: Verdana | last post by:
We're using Python 2.5 on our production and testing servers, which both run SunOS 5.8 and Oracle 10g. The script we're working on is supposed to process wddx packets, enter some info in the database...
1
by: madhuskk | last post by:
Hi, When I am trying to run Cognos setup in IBM AIX 5.3, the following error is displaying: IOT - Abort trap (Core Dumped) Please inform me the reason for this error.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.