>Hi, Ethan,
  I tried your dsn-less connection below and received this error message. 
I am trying to connect from an Windows NT4 IIS server to a sql 7 server. 
and I get this

Microsoft OLE DB Provider for SQL Server error '80004005' 

[DBMSSOCN]General network error. Check your network documentation. 

/Sharp/globalconnect.asp, line 9 

I also tried to use  "Network Library=DBMSSOCN" at the end of the string 
but it still errors out.

Any suggetions?
Thanks in advance for a speedy reply.
Charlie

Your original code is below

 
OLEDB
> 
> SQL Server:
> "Provider=SQLOLEDB;Data Source=yourServerName;Initial
> Catalog=yourDatabaseName;User ID=yourUserID;Password=yourPassword;"
> 
> Access 2000:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= D:\yourPath.mdb"
> 
> Ethan
> 
> 
> 
> -----Original Message-----
> From: cck79@y... [mailto:cck79@y...]
> Sent: Tuesday, January 29, 2002 7:20 AM
> To: ASP_ADO_RDS
> Subject: [asp_ado_rds] ADO and database connection
> 
> Hi,
>       Can someone tell me what is the most efficient and fastest way to
> connect to the database using ADO? Thank you in advance.
> 
> cck
> 
>