Walt Cygan wrote an article on how to access data from SQL Server..:
http://www.mp2kmag.com/articles.asp?...erver.dns-less

The other way to do it is through a Microsoft Data Link or UDL file.. start in the Help File and search for Microsoft Data Link, you can find some more references here: http://www.google.com/search?q=site%...p2kmag.com+udl

__________________