?
Solved

ODBC fails connecting to Foxpro DBC file

Posted on 2003-02-26
6
Medium Priority
?
943 Views
Last Modified: 2012-05-04
Hi All,

Not sure if I got right board but here goes. Anytime we use a new PC to make a new connection to a Foxpro DBC file via ODBC we get an error message.

Exisitng links on old PC's to the file are perfectly fine!

The ODBC link is used by us in several in-house designed applications which are written in Access/Visual basic.

The file we are trying to connect to is called "Comp_A.dbc". We are getting an error message saying "Invalid Database Specification" when trying to create the user or system DSN

We believe that the Comp_A.dbc has been corrupted somehow.

I have tried using the "Free table connection" but then only some of the foxpro DBF files are

available to me when i try to set up a linked table within Access!!

Any ideas?
0
Comment
Question by:ciarank
[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
  • 4
  • 2
6 Comments
 

Expert Comment

by:JDPEPPER
ID: 8027887
What you need to do is go into the registry of the existing old pc and do an EXPORT of the odbc registry.  Save it to a floppy or to your network drive and then import it into the new machine.

We have had this happen several times when installing new machines.  Microsoft had no explination for us.

Try this and see if it doesn't solve your problem like it has done for us.
0
 

Expert Comment

by:JDPEPPER
ID: 8027942
What you need to do is go into the registry of the existing old pc and do an EXPORT of the odbc registry.  Save it to a floppy or to your network drive and then import it into the new machine.

We have had this happen several times when installing new machines.  Microsoft had no explination for us.

Try this and see if it doesn't solve your problem like it has done for us.
0
 

Expert Comment

by:JDPEPPER
ID: 8038132
Did you try what I suggested?  Did you find another way to get those to work?  I would appreciate a follow up...Thanks
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:ciarank
ID: 8042800
thx for quick response JDPEpper. The only problem I have is that i don't now how to export an ODBC Registry.

Could you please give me some pointers?

thx once again
0
 

Accepted Solution

by:
JDPEPPER earned 400 total points
ID: 8043693
What version of Windows is the old machine running and what version of Windows is the new machine running?

Click on the START Button in Left Hand Corner and you should be given the option of RUN.  Click on the RUN.  In the Dialog Box tpye in REGEDIT and click enter.

ON YOUR OLD MACHINE

You will have the Registry Editor Box Open with a tree view of your registry.

Click on the "+" by the HKEY_LOCAL_MACHINE

Click on the "+" by the SOFTWARE

Right click on the ODBC Folder

One of the options is to Export the Registry

Choose the Selected Branch and Save it to a floppy disk called a:\ODBC.reg

ON THE NEW MACHINE

Open the A Drive and double click on the file odbc.reg ....You will be prompted whether you want to update the registry and select OK

That is how you transfer the ODBC registry from one machine to another, therefore all your machines have the same ODBC registry settings and it should solve your problem.



0
 

Author Comment

by:ciarank
ID: 8070946
JDPepper - you are the man!! ( or woman i dunno ! :)

you have really got me out of a tricky situation - THX !!!!!
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

777 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