[dba-SQLServer] Can't connect with ADO

Here are some url's for verifying type of SQL authentication installed

By default, for Windows NT and later, MSDE installs by using Windows 
Authentication. On computers running Windows 98, MSDE uses SQL 
authentication.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;322336#4
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B325022#9
Using Microsoft Access 2002 with MSDE 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp

MartyConnelly wrote:

> 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 :)
>>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>