Solved

E_FAIL when connecting to Access

Posted on 2002-04-29
10
187 Views
Last Modified: 2010-04-04
Hi guys,
I am getting an E_FAIL error and I have no idea what it means.  I am connecting to an Access database which has queries which query a Foxpro Database.  Any ideas?

Cheers
0
Comment
Question by:gtbikeuk
10 Comments
 

Author Comment

by:gtbikeuk
ID: 6978374
I've just increased the points as I am desperate to solve this quickly
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6978559
how do you connect?
a bit more info, please
0
 

Author Comment

by:gtbikeuk
ID: 6978744
I'm connecting via ADO
0
 

Author Comment

by:gtbikeuk
ID: 6978782
I'm connecting via ADO
0
 
LVL 14

Expert Comment

by:DragonSlayer
ID: 6979243
more information please, e.g. what's your connection string like?

also, how do you query the Foxpro DB from Access? Can access find the Foxpro DB in the first place?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 17

Expert Comment

by:inthe
ID: 6979627
Put something like this in your connection (use try except block) and hopefully it will tell you more about why its failing.

ShowMessage(SysErrorMessage(GetLastError));
0
 
LVL 4

Expert Comment

by:SurferJoe
ID: 6981108
Record a macro in Excel or Word,
Connect to the database using the built in dialogs,
Save the macro.
In Excel use Tools, Macros, Visual Basic Editor to examine the connection string it generates.

HTH,

Greg
0
 

Accepted Solution

by:
gtbikeuk earned 0 total points
ID: 6981179
Thanks guys, solved the problem...using ADOQuerys instead of doing it via access...works fine.  Who do you think I should award the points to?
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6981392
no one, or all in splitted parts,
but, i vote for no one

ask at community support,
for taking this q into paq
and refunding your points

meikl ;-)
0
 
LVL 1

Expert Comment

by:pnh73
ID: 9004363
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/ Refund

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now