But where is the database?
I've been mucking about with some relatively simple ASP scripts which led me out of curiousity to have a look at files associated with a members-only searchable database which exists on our site - I believe it's an SQL database (still working out terminology here, so bear with me) and runs on an NT server.
There are loads of files associated with it, but they are mostly .asp with a few .inc files. My question is ... where is the database containing all of the records? I have hunted all over the site and simply can find no trace of it! I have been able to find the other databases (Access files) relating to other areas of the site involving ASP, but nothing for this particular one.
So I'm puzzled. Is this something to do with SQL? Or could our ex-web developers have placed it somewhere external to our site (and should we therefore be stressed about this)? And where do I look for the code which will tell me where the files point?
Hope this makes a teensy bit of sense!
Thanks
Bug
Peter J. Boettcher posted this at 14:21 — 27th December 2001.
They have: 812 posts
Joined: Feb 2000
If its a SQL Server database its probably sitting on another server on your network. Take a look at the global.asa file, the connection strings for the database should be in there (might help in locating the SQL server).
Be careful about using .inc files, you should rename them to .asp and change the links. If you have any server-side code in the .inc file it can be exposed.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.