Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 21st, 2005, 10:31 PM
JB. JB. is offline
Registered User
 
Join Date: Apr 2005
Location: Pennsville, NJ, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access / MSDE / ODBC

I am an Oracle/MySql developer with solid C++/MFC(5.0) experience. I'm building a small-business app in VC++ 6.0, and am using a MySQL db for the backend during development. I am starting to convert the project to Access ('cause I can bundle it for free and keep my costs down). I connect to the mdb over ODBC via DSN, and it is much slower than MySQL using the same approach.
I got three Access books, but they are all beginner-level books on developing Access apps, and not much help. One of them (a 1450 page Gold Edition Bible) gives scant hints about MSDE (a.k.a. SQL Server Desktop?), so I downloaded and installed that, but I don't know how to connect to the .mdb from within VC++. Does anyone on this forum have any experience/advice?

Thank you very much. I would be grateful for any help.
Jim


 
Old April 22nd, 2005, 06:40 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I only use VB.NET, which is very automated when it comes to data connections.

I would suggest posting in the C forums if you don't get your answer here.

Are you using an .mdb back end, and a VC++ front end? If so, why are you using MSDE? I can tell you an .mdb is going to be slower because of the jet database engine. I think this is why MS is going to use MS SQL Express (the new MSDE) as the back end in future Access versions.

mmcdonal
 
Old April 22nd, 2005, 12:09 PM
JB. JB. is offline
Registered User
 
Join Date: Apr 2005
Location: Pennsville, NJ, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for your reply; I appreciate your time and your advice. Yes, I want a .mdb back end, and a VC++ front end. My "Access 2000 Bible" tells me that Access 2000 "now comes with the Microsoft Database Engine, also known as the SQL Server 7.0 desktop edition" - and it does. It goes on to tell me that it also comes with the Jet Database Engine, and that I have a choice of which db engine to use, and that MSDE is more robust, more fully featured, and much faster. That sounds good to me! But there's not much help around on *how* to use it in general, or from VC++ in particular.

I've found that, inside Access 2000, on the Tools menu, you can use the Upsizing Wizard - I think to use MSDE. Here's what it says:
"The Upsizing Wizard allows you to easily upsize your Microsoft Access database to a Microsoft SQL Server database." It then asks "What SQL Server would you like to use for this database?" Buried in the documentation, I found this: "If you are using MSDE on a personal computer, the server name is the name of your computer, and the default logon ID is sa." I tried that, but I get an Overflow error from the Upsizing Wizard. BTW, I do have the SQL Server Service Manager running on my desktop.

I've found articles on the MSDN website related to this topic, and will try to make my way through them. The problem with that is the usual one for that resource - there are tons of documents there, but most of them are out-of-date, they contradict each other, and they make references to tools/technologies/resources that no longer exist or that no longer work with the documentation. Wading through them makes you long for a career as a professional Russian Roulette player…


 
Old April 25th, 2005, 08:40 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I am not sure if you have MSDE actually installed on your computer. You must do this first. It should be on the CD that Access came on.

The SQL Server Service manager is just a short cut to the SQL server service in your Services menu, and doesn't do anything for you. It should actually not be installed since it has limited functions and allows people to easily accidentally turn off SQL server.

But this sounds like you have MSDE installed. When you did the installation, did you set an sa password?

mmcdonal
 
Old November 11th, 2005, 02:28 PM
Authorized User
 
Join Date: Sep 2004
Location: Nanaimo, BC, Canada.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In VC++, you can use DAO Library to access the back-end.

There is info on how to do this in Microsoft Jet Database Engines Guide. Not sure if its been updated for Jet 4.0.

One has to plan ahead as much as possible to go to MSDE, even if its free, what are the tradeoffs.
What limit is there to connections, and how does security behave differently, etc.




Database Agreements




Similar Threads
Thread Thread Starter Forum Replies Last Post
Access or MSDE - Opinions? johnm73 VB Databases Basics 0 July 20th, 2005 03:48 AM
How to switch from ACCESS to MSDE kinnari BOOK: ASP.NET Website Programming Problem-Design-Solution 1 January 18th, 2005 08:22 AM
MSDE and access Conrad SQL Server 2000 1 June 5th, 2003 11:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.