DrLechter
asked on
Problems connecting to DB after switching to SQL Native Client
I have an MS Access 2003 DB with a SQL Backend. Everything has been working great until recently when I migrated the back-end data from SQL 2000 to SQL 2005 and changed the ODBC data source from SQL Server to SQL Native Client. Now, I receive spurious failures when trying to open forms and reports. The error I receive is error 3151, ODBC--connection to <odbc name> failed.
Is there some sort of compatibility issue with MS Access 2003 and the SQL Native Client driver?
Is there some sort of compatibility issue with MS Access 2003 and the SQL Native Client driver?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
cheers!