Link to home
Start Free TrialLog in
Avatar of DrLechter
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?  
ASKER CERTIFIED SOLUTION
Avatar of tonydemarco
tonydemarco
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
cheers!