The database is of file type .db if thats helps. Im starting to assume that its impossible and can only be done via ole db.
data source name = Hhome1
host name: home1
I have even tried this but dont seem to get far, when i enter this query it runs succesfully but i see no change
USE master GO EXEC sp_addlinkedserver @server='home1', @srvproduct='', @provider='', @datasrc='homs'