Linking Tables to a Web Database

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Thank you for any help you can provide.

I have read a lot of conflicting information on this topic. Here is
what I'm trying to do...I have a database on a web server that needs
to get updated several times a week. What I currently do is download
the database to preserve any new user registrations, make the updates,
and then upload it back.

This is what I would like to be able to do...
I want to set up a local database that links to all of the tables on
the server database. I have been able to connect to the server,via
ftp, and navigate to the file. But, when I click the link button I
get the error "Not a valid file name." I can connect to the server
via HTTP but then I can't see the database directory:

/
- Database - database directory
- www - folder containing aspx files
- bin
- images

I can only see the bin and images folders. I tried putting a copy of
the database is the bin folder and was able to navigate to it, but I
got the same error as when connecting through ftp.

If anyone has any thoughts on this I would really appreciate it.

Michael
 
You cannot link tables via either FTP or HTTP.

As you're already using ASP.NET (.aspx files) your best option is probably
to create ASP.NET pages to perform the updates on the server.
 
Thank you Brendan.

I have considered this but wanted to wait until the site was
completely up and running before taking it on. My host service does
not support SQL Server. If it did I would be able to connect and
update a SQL Server remotely. Is this correct? If it is switching
hosting services may be another option.

Michael
 
I've no personal experience of this, but yes, I have read that SQL Server's
Enterprise Manager tools can be used remotely.
 
Back
Top