DSXchange

I attempting to do a dns-less connection to an excel obdc

has any one done this using a connection string like
Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\directory;

Can you provide a simple example of how you used it because I am at a lost how to use it

Thanking you all in advance

You'll always need a DNS (or some other way of resolving host names to IP addresses).

Whether or not you need a DSN (data source name) is a different question.