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.
Select * from [220.127.116.11].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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.