I created a system DSN both on the server and the client machine I am using:
https://goo.gl/DkGbFi
The Test Connection works.
The script to create the linked server is as follows:
Code: Select all
EXEC master.dbo.sp_addlinkedserver @server = N'CHAINDRIVE', @srvproduct=N'Chaindrive', @provider=N'MSDASQL', @provstr=N'Dsn=ChainDrive;Driver=Devart ODBC Driver for Firebird;Data Source=192.168.99.47;User ID=sysdba;Password=*********;Client Library=C:\Program Files (x86)\Devart\ODBC\Firebird\fbclient.dll;Database=d:\Multidev\gdb creation\SV1020_012HOIMP BR.GBB'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'CHAINDRIVE',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
https://goo.gl/1PXgKe
Any idea what I am missing?