MSACCESS Conection Problems

I've searched the MSACCESS Install disk and can find no trace of the dll at all. I am running OFFICE 2000 though...do you think that this may be the problem? Possibly the dll has changed and delphi is still searching for the 95 or 97 dll?


Thanks in Advance.
mcdonluAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kretzschmarCommented:
hi mcdonlu,

i guess its a configuration problem of your odbc driver or your native-driver, therefore i ask you, can you provide a bit more information, how you has configured your driver?

also the error message might point, to a duplicate(or more) choice by the given dns-name.

meikl
0
jswebyCommented:
Why not use the BDE to connect to Access?
0
mcdonluAuthor Commented:
Edited text of question.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

jswebyCommented:
In the BDE Admin program, select File|New.

Select MSACCESS as the driver name, not "Microsoft Access Driver (*.mdb)".
Press OK.

Change the DATABASE NAME to your MDB file, LANGDRIVER to "Access General". SYSTEM DATABASE should be the location of system.mdw on your PC. If it's not anywhere to be found, re-install Access as this could be your problem. USER NAME can either be blank or "ADMIN". Try either.

Hope this helps. Go to Help|About in the Admin program to check you're on at least BDE 5.0 to get the most from Access & the BDE.
0
mcdonluAuthor Commented:
Edited text of question.
0
jswebyCommented:
As for the freezing up, that's a little odd - it is sometimes VERY slow to drop the list down - have you given it a good couple of minutes to allow the list to drop? If you have and still no joy then don't worry about this particularly.

The real problem is not being able to find the IDAPI Service Library (C:\winnt\msapps\DAO\DAO3032.DLL in your case). This file (and others that go with it) are the link between Access and everything else and should have been installed when MS Access was installed on your PC. It is installed, isn't it? If not, then you'll need to find the download for Microsoft DAO drivers, try microsoft.com first.

If Access is installed then these files are missing and you should reinstall Access with all options turned on to do with exporting, etc.
0
mcdonluAuthor Commented:
Edited text of question.
0
jswebyCommented:
Ah, yes, Office 2000, therefore Access 2000, uses ADO now instead of DAO so any attempt to use drivers for anything less that Access 2000 won't work.

Bit of a pain that!

You either need to:

(1) Go back to using Access 97/98
(2) Use a third-party BDE replacement that deals with ADO (can't think of one though)
(3) Check Borland's website to see if they're planning to support ADO using the BDE.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mcdonluAuthor Commented:
Thank you for your time and your quick replies. I belive I have enough understanding now to figure out what needs to be done. Thank you agian!
0
kretzschmarCommented:
no no no,

http://www.cybermagic.co.nz/winsoft/dao.htm

get this commercial replacement, trial also available, easy to connect to access 2000 and fast

meikl
0
jswebyCommented:
Yeah, looks like I jumped the gun there; as long as you're using DAO 3.6 which should have been installed with Access 2000 you should be fine.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.