How can I connect to MS SQL using DAO if it does not have ODBC? I already have finished coding the app using DAO on MS Access tables. But my boss told me to migrate my databases to MS SQL. How can I do that with DAO?
Hi EdenD,
Unfortunately we can not connect to MS-SQL with DAO if wi don't have the ODBC. So, if you want to keep your application with DAO you require ODBC Driver for MS-SQL.(I think that ODBC driver are required for RDO and ADO also.)But still it is not beneficial of using DAO with SQL server.
I recommend that if you are having a medium project(<=50 forms) you should convert it to RDO/ADO.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.