search

martinrybak / SQLClient

Native Microsoft SQL Server client for iOS
http://objcsharp.wordpress.com/2013/10/15/an-open-source-sql-server-library-for-ios/
MIT License
124 stars 51 forks source link

linkedserver support in SQLClient #53

Closed param0091 closed 6 years ago

param0091 commented 6 years ago

Hi Martin,

I am developing a cocoa app that is connecting to SQL Server using SQLClient. I need to compare two databases at different instances (checking for updates purpose). I have found "sp_addlinkedserver" method while one using MSSQL but how we can achieve the same using SQLClient. Please suggest.

Also we are facing some issue regarding pdf and image data insertion, according to you it was fixed under 'types' branch but we are unable to find it.

Thanks

martinrybak commented 6 years ago

You should be able to invoke it normally, provided you have the permissions to do so: EXEC sp_addlinkedserver @server='Servername'

Please see #56 for how you should be able to insert binary data.