update link table connection

[pl456]

Is there a way of changing the link connection string when you have linked tables from an sql server so that they don't use a DSN?

The problem I have is when you allow access to upsize the db to sql it creates the connection as
DRIVER=SQL Server;SERVER=......... and so on...
all I can do them is create DSN connections, which I don't want as the previous connection meant iot could be run without creating a DSN.

 

[namliam]

Yes you can create "DNS LESS" connections, using the server name and so on... There are some issues with it though... And I dont exactly know how to get them working properly, so I am just going to say " yes you can " and hope someone else will show us both exactly how..