?
Solved

Write to Paradox files

Posted on 2009-03-31
4
Medium Priority
?
381 Views
Last Modified: 2012-05-06
I desperately need to write new records and updates to a number of Paradox *.db files.  

I have tried several connection strings, all of which give an error: "ServerVersion = 'cn.ServerVersion' threw an exception of type 'System.InvalidOperationException'"

What is the best approach to access Paradox files?  Please advise how to make a connection or find a VS tool to accomplish this.

Capt  
0
Comment
Question by:Glen Gibb
  • 3
4 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 2000 total points
ID: 24029593
have u seen this? http://www.progware.org/Blog/post/Connecting-to-a-PARADOX-DB-with-C-(Vista-XP).aspx
Only thing is BDEInfo which Im not sure whether u need to do or not

and this is a useful website to look at various connection strings http://www.connectionstrings.com
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24029610
if u use something like ODBC, have you ensured you have the right driver?
0
 

Author Closing Comment

by:Glen Gibb
ID: 31564851
Terrific!  It had all the steps I needed.  Apparently the connection strings were working.  All I needed to do was to open the conn and fill up a datatable.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24032635
Cool :)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying 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

Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

757 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