Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

E_FAIL when connecting to Access

Posted on 2002-04-29
10
Medium Priority
?
195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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
 
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:Greg Rowland
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

650 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