[dba-SQLServer] Can't connect with ADO

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.
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Selina
> Iddon
> Sent: Friday, September 05, 2003 2:13 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Can't connect with ADO
>
>
> Good Afternoon Everyone
>
> After spending HOURS on this, I really need to ask for your help.  I have
an
> Access 2K front end and ODBC connection to my SQL db.  I am happily
> communicating using ODBC and DAO, but ADO just keeps returning me "Data
> source name not found and no default driver specified" every time I try
and
> connect.  I've tried 6 different connection strings and even made a UDL
file
> (which tests successfully) and still no luck.  All I'm really trying to do
> is get back the @@IDENTITY from an Insert string, but I need ADO to use
the
> parameters.
>
> Any suggestions or alternatives would be really greatfully received.
>
> Best Regards
>
> Selina
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
>