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 derfloh 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
Joined
Jun 1, 2001
Messages
13
Location
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

Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
895
Chris Miller
Chris Miller
MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
907
Chriss Miller
C
V
  • Locked
  • Question Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
1K
Volvere
V
elly00
  • Locked
  • Question Question
create sql view using batch file
Replies
5
Views
985
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001

Part and Inventory Search

Sponsor

Back
Top