Access 97 DSNless connection to SQL server ?

's Computer Specifications

<crossposted to several groups>
Is there any way to create a DSNless connection to SQL server from
access 97 (DAO)
All the samples of connection strings I am finding - all have a
reference to a DSN.

Many thanks
Tony

's Computer Specifications

<ace join_to (E-Mail Removed) (Tony Epton)> wrote in message
news:(E-Mail Removed)
> <crossposted to several groups>
> Is there any way to create a DSNless connection to SQL server from
> access 97 (DAO)
> All the samples of connection strings I am finding - all have a
> reference to a DSN.
>
> Many thanks
> Tony

Doug Steele has an article on this subject:

http://members.rogers.com/douglas.j....LessLinks.html

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ACCESS DSNless connection to SQL	=?Utf-8?B?S2FyZW4gR3J1YmU=?=	Microsoft Access External Data	7	24th Oct 2005 07:04 PM
connection limit from asp pages using dsnless connection string	Jason Gallas	Microsoft Access	0	5th Oct 2004 06:07 PM
Microsoft Access DSNLess connection error, works fine in .ASP page, not in aspx code.	Derrick	Microsoft C# .NET	2	26th Aug 2004 08:12 PM
Microsoft Access DSNLess connection error, works fine in .ASP page, not in aspx code.	Derrick	Microsoft ASP .NET	2	26th Aug 2004 08:12 PM
Creating DSNless connection to MS SQL Server	David J Duryea	Microsoft ADO .NET	0	8th Jan 2004 02:17 AM