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 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
"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!
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
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.
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
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
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.
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
.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
by: yezi |
last post by:
How to check out the segment dumped file and debug them in c? Thanks
|
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...
|
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...
|
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'
...
|
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...
|
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...
|
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.
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |