I need for users of my website to be able to work with information that is downloaded into the SQL database from a remote computer. I also need to make it possible for information in my website to be uploaded to the remote computer as well as enable it
to delete information that is no longer needed in my website. Is this possible?
I need for users of my website to be able to work with information that is downloaded into the SQL database from a remote computer. I also need to make it possible for information in my website to be uploaded to the remote computer as well as enable it
to delete information that is no longer needed in my website. Is this possible?
Yes, this is pretty normal stuff and basically how a website works in general. The web application uses a connection string to connect to a database. The web site is also the UI that the user sees to interact with site and database.
Thanks for responding. I have only created websites for human interaction and I didn’t even know that the websites can be interacted by remote computers. Can you refer me to information that will help me to understand how to implement this?
Web sites don't interact with remote computers as such, but they can interact with SQL Server databases located on different (remote) machines. All you need to do is to supply the right connection string to the data access code in the web site. For SQL Server,
this will most likely include the IP address of the remote computer.
This is great news. But, are you saying that a remote computer that accesses the SQL Server with the IP address of the remote computer can read and alter files in the database?
This is great news. But, are you saying that a remote computer that accesses the SQL Server with the IP address of the remote computer can read and alter files in the database?
Yes, if you have a connection string with proper user credentials then the user can connect to the database and execute commands. Usually an application is used to facilitate data entry. This application can be a desktop, web, or service application.
This forum is an example.
Member
218 Points
513 Posts
Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 03:09 PM|Maurice Osborn|LINK
I need for users of my website to be able to work with information that is downloaded into the SQL database from a remote computer. I also need to make it possible for information in my website to be uploaded to the remote computer as well as enable it to delete information that is no longer needed in my website. Is this possible?
All-Star
53051 Points
23634 Posts
Re: Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 03:15 PM|mgebhard|LINK
Yes, this is pretty normal stuff and basically how a website works in general. The web application uses a connection string to connect to a database. The web site is also the UI that the user sees to interact with site and database.
What problem are you having?
Member
218 Points
513 Posts
Re: Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 03:45 PM|Maurice Osborn|LINK
Thanks for responding. I have only created websites for human interaction and I didn’t even know that the websites can be interacted by remote computers. Can you refer me to information that will help me to understand how to implement this?
All-Star
194490 Points
28079 Posts
Moderator
Re: Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 04:01 PM|Mikesdotnetting|LINK
Web sites don't interact with remote computers as such, but they can interact with SQL Server databases located on different (remote) machines. All you need to do is to supply the right connection string to the data access code in the web site. For SQL Server, this will most likely include the IP address of the remote computer.
Member
218 Points
513 Posts
Re: Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 04:24 PM|Maurice Osborn|LINK
This is great news. But, are you saying that a remote computer that accesses the SQL Server with the IP address of the remote computer can read and alter files in the database?
All-Star
53051 Points
23634 Posts
Re: Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 05:02 PM|mgebhard|LINK
Yes, if you have a connection string with proper user credentials then the user can connect to the database and execute commands. Usually an application is used to facilitate data entry. This application can be a desktop, web, or service application. This forum is an example.
Member
218 Points
513 Posts
Re: Is it possible for a remote computer to have access to the SQL database for my website?
Aug 17, 2018 06:18 PM|Maurice Osborn|LINK
Thank you so much for your help with this. This is just what I needed to know.