locked
Sqldatasource from db in onedrive..how? RRS feed

  • Question

  • User-775831949 posted
    My sqldatasource in web.config is pointing to local Ms Access or Excel filee in App_data folder


    I wish it point to such file saved in my Onedrive for business or stored in Sharepoint server instead.

    Is this possible and if so how?

    Thanks
    Saturday, May 25, 2019 8:27 PM

Answers

  • User-821857111 posted

    No. File based databases all require a file path as part of their connection string. Therefore the file must at least be accessible within the same network. All the ones that I have ever worked with must actually be located on the same machine as the application that uses them.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 27, 2019 7:29 PM

All replies

  • User-821857111 posted

    Is this possible
    No. The Access or Excel connection strings require a file path. You can't place them on remote machines.

    Saturday, May 25, 2019 8:53 PM
  • User-775831949 posted

    Thanks. So I am giving up using Access.

    Is there any alternative file based database which I can easily design using graphic UI, while allow me to store the file on Onedrive business and link to my sqldatasource in asp.net.

    Many thanks

    Sunday, May 26, 2019 4:09 AM
  • User-821857111 posted

    No. File based databases all require a file path as part of their connection string. Therefore the file must at least be accessible within the same network. All the ones that I have ever worked with must actually be located on the same machine as the application that uses them.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 27, 2019 7:29 PM