can anyone help throw some light on this one, I can get an ODBC to work perfectly to get information into a spreadsheet from the view of a database table on the remote server. I use the same username and password. There is no VPN in place.
I want to insert the results into a local table but cannot get the simple query below to work.
The query results in the above error
EXEC sp_addlinkedserver '220.127.116.11', N'SQL Server'
EXEC sp_addlinkedsrvlogin '18.104.22.168', 'false', NULL, 'username', 'password'
Select * from [22.214.171.124].remotedb.dbview
I am not any sort of SQL Expert but am reasonably confident with queries to select, update or create tables etc.
Thanks in anticipation
Thank you for your reply
Select * from [126.96.36.199].remotedb.dbview is the line thatgives the error, I can run all other lines of the code without issue.
I have just put an entry in the host file so that the name could be resolved as the machine is not otherwise identified on the internet. But the error remain the same other than the ipaddress shown in the error message is now the machine name.
Also just tested a new ODBC Data Source, using the machine name, and that works great.