Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


235 posts

Master Geek


Topic # 13676 23-May-2007 10:14
Send private message

For a start, does anyone remember this or use it???

I used this back in the late 90's and it was my first database experience. I haven't touched it yet alone seen it in almost a decade now so I was mildly bemused when I was asked if I wanted to port a Foxpro database to SQL on the side.

So i'm thinking I will do this, however, does anyone know how to port the data or got any ideas on how to because from memory it's not SQL-92 compliant but then I can't remember as it's so long ago now...could I import data into excel through ODBC?

Thoughts?

Create new topic
BDFL - Memuneh
61516 posts

Uber Geek
+1 received by user: 12237

Administrator
Trusted
Geekzone
Lifetime subscriber

Reply # 71837 23-May-2007 10:23
Send private message

Are you porting to Microsoft SQL? If so I think you can import directly, there are drivers (Data Transformation Services) that are automatically installed for you in the Enterprise Manager (SQL Server 2000) although I can't see one in the Import Wizard (Microsoft SQL Server Management Studio 2005).












235 posts

Master Geek


  Reply # 71840 23-May-2007 10:27
Send private message

I don't have that information yet as I was in a pub half cut and promising the world haha

Guessing I just need assurance that FoxPro isn't so obsolete that there are tools for exporting the data out in a usable fashion and if so what they are.

122 posts

Master Geek


  Reply # 72155 25-May-2007 07:03
Send private message

Guessing I just need assurance that FoxPro isn't so obsolete


Nooo...FoxPro isn't obsolete! Apparently, you can still get Visual FoxPro 9 to 'create and manage high-performance, 32-bit database applications and components' (!) - see http://msdn2.microsoft.com/en-us/vfoxpro/default.aspx. Amazingly, there's even a Visual FoxPro toolkit for .NET.

I have vague (and painful) memories of FoxPro. However, there's a 'Visual FoxPro' ODBC driver on XP (MDAC 2.81.1117.0) which I assume could be used to export the data to a modern DBMS. Of course, if your data is pre-Visual FoxPro i.e. FoxPro 2 or something, you could have problems.

3 posts

Wannabe Geek


Reply # 72817 30-May-2007 12:22
Send private message

My boss uses foxpro and I recently had to write a dll so that he could easily access a .NET web service, I found that Rick Strahl of www.west-wind.com is the guru of foxpro. This article on integrating .NET with foxpro was really useful.

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.