Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection to MS SQL using DAO

Status
Not open for further replies.
EdenD

EdenD

Programmer
Jun 1, 2001
13
0
0
PH
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?
 
Sort by date Sort by votes
ADO tends to be the one most people use to connect to SQL Server.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
DAO has been DOA (dead on arrival) for sql server for about 5 years now.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
202
Volvere
V
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
119
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
166
pjw001
pjw001
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
274
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
102
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top