I have a sqlite db on a web server for eg: (www.somehost.com). How do i access that db from local machine. Can i access like Getfolderitem(www.somehost.com/sqlitedb.rsd)
A couple choices spring to mind
- download it so its local
- write some app that runs on the web server that provides an api to use it - but then you don’t open t as a database any more
But no you can’t just open it like you’re example code showed unless you have some way to mount that web site as a volume so it appears like it is local (but I’d suggest not doing that anyways since performance may be poor esp with db locking)
Depends on your server architecture but I would use php on mine to connect, retrieve a record set and then return XML. You would call your php from httpsocket.