[dba-SQLServer] Can't connect with ADO

Mike and Doris Manning mikedorism at ntelos.net
Fri Sep 5 06:51:14 CDT 2003


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



More information about the dba-SQLServer mailing list