How to have a connection String? - Not A Valid File Name

[Paraman]

My company have static IP- configured via router and can be accessed from internet like File Explorer - Network - Then the address bar I use to give like the below

ftp://100.99.101.102/volume(sda3)/Data/

For the above address, how to give a connection string, any kind help will be very much useful !

My Tries -Connection String

String MyDBConString = "Provider=Microsoft.ace.Oledb.12.0; Data Source='ftp://100.99.101.102/volume(sda1)/Data/MyDB1.accdb'; Persist Security Info=False; ";

Thanks

 

[jmcilhinney]

You can't connect to a data file on an FTP site. FTP is for transferring files and that's it. You need to download the file and then connect locally.

 

[Skydiver]

Just like in your other thread, in general and Access database cannot be accessed using a website or FTP site. Also other "cloud" solutions will not work for Access database files if you need multi-user access due to the way file locking works for Access.

I suggest using a real SQL database backend, and then have Access as your UI front end. But again be aware of the danger of exposing a database raw to the Internet, just like warned in the other thread.

 

[jmcilhinney]

This may be repeating something that was mentioned in a previous thread but, usually, when you want to expose a database to the world, you do so via a web service/API. The web service acts much like a web site with no UI, so any authorised application can retrieve and send data from and to it and then it interacts with the database. This enables you to control what interactions are allowed and how the data is exposed. In theory, you could have an Access database behind that web service, but the Access database engine is explicitly not supported on servers. If you really want to use a file-based database then you should use SQLite, but a proper database like SQL Server or MySQL should generally be preferred. These are generally offered by the same host you would use for the web service.