[dba-SQLServer] Can't connect with ADO

Can you show us your connection string code  should look like one of the 
following

For Standard Security

oConn.Open "Provider=sqloledb;" & _
           "Data Source=myServerName;" & _
           "Initial Catalog=myDatabaseName;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"
 
For a Trusted Connection Windows Authentication

oConn.Open "Provider=sqloledb;" & _
           "Data Source=myServerName;" & _
           "Initial Catalog=myDatabaseName;" & _
           "Integrated Security=SSPI"



Francisco H Tapia wrote:

> Selina Iddon wrote:
>
>> Thank you, I'm running MDAC 2.7.
>> Cheers
>> Selina
>>
>>
>> ---------------------------------------------------------------------------- 
>>
>> ---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy 
>> Access
>> Databases
>> ----- Original Message ----- From: "Mike and Doris Manning" 
>> <mikedorism at ntelos.net>
>> To: <dba-sqlserver at databaseadvisors.com>
>> Sent: Friday, September 05, 2003 9:50 PM
>> Subject: RE: [dba-SQLServer] Can't connect with ADO
>>
>>
>>
>>> Have you checked your MDAC version.  You need to have at least MDAC 2.6
>>> installed to work with SQL Server.
>>>
>
> Thank you? the problem is solved? or thank you but you are using 2.7 
> and the problem persists :)
>