Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ODBC fails connecting to Foxpro DBC file

Posted on 2003-02-26
6
Medium Priority
?
966 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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
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 Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

571 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