How can I get DSN less connections?

[sriky]

I am using ADO's to connect to Access database. I assume in that case, it runs without DSN at the client site.

Thanks

[Lothar Haensler]

to use a dsnless connection to SQLserver use code like this:
conn.Open "Driver={SQL Server};Server=yourservernamegoeshere;UID=...;pwd=...;database=yourdatabase"