using a file dsn in sql.request to connect to sql server

Tricia

Posts: n/a

using a file dsn in sql.request to connect to sql server

What is the syntax to use a file dsn that connects to sql server in the
sql.request excel function? It is working fine for me using a local or
system dsn, but not a file dsn stored on my network.

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening a file with code without a set file name	jenkinspat	Excel Discussion (Misc queries)	1	March 4th 05 10:50 AM
Locating a file in excel with a partial file name.	Audra	Excel Discussion (Misc queries)	1	February 19th 05 08:51 PM
Locating a file in excel with a partial file name.	Audra	Excel Discussion (Misc queries)	0	February 19th 05 02:03 PM
Locating a file in excel with a partial file name.	Audra	Excel Discussion (Misc queries)	0	February 19th 05 02:03 PM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM

All times are GMT +1. The time now is 02:59 PM.

Menu

About Us