Connecting to an Internet database

• April Legate

  Grasshopper

  Points: 17

  More actions

  May 12, 2006 at 10:44 am

  #168291

  I have a website driven by an MS SQL Server 2000 and Coldfusion. I'm an absolute newbie with both. My company had someone put this site together and upload it to the site. I have the ftp information, the name of the database, the password and a backup of the website (from ftp).

  Is there any way I can look in that database on the site using SQL Server on my local machine? (The files are at a hosting service.) If so, how on earth do I do that?

  I appreciate any clues anyone can give me.

  April

• Lowell

  SSC Guru

  Points: 323522

  More actions

  May 12, 2006 at 11:02 am

  #637643

  i doubt it; most db servers are hidden behind the firewall at the hosting company, and only the web server can see the db server.

  but that also means that you can use web pages to access your db server;

  a google of "asp pages to administer sql server" will get you lots of examples of code you could FTP to your site and have an interface to get to your db.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!