Mike and Doris Manning
mikedorism at ntelos.net
Fri Sep 5 06:50:57 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