dBASE and me

i agree with you anything you have not had for a w...

2010-02-10T10:16:20.507-08:00

i agree with you anything you have not had for a while and you continually think about it then its an addiction. I for one am addicted to facebook, whenever i don't go on facebook in a day it feels like am not complete. Yeah its not until you take alcohol that means you are an addict, people also get addicted to social networks. I really am addicted to the internet because whenever my

Any idea how to access a dBase file using openrows...

2009-12-11T09:01:03.756-08:00

Any idea how to access a dBase file using openrowset in SS2K8 64-bit? Apparently the 64-bit version of the MSDASQL provider cannot access 32-bit drivers. There currently is no 64-bit Microsoft dBase Driver.

Thanks for your quick response.
Well, Before ...

2009-12-07T08:40:14.636-08:00

Thanks for your quick response.

Well, Before I worked the way you display in your site (it works any time), I worked as follows:
openrowset('MSDASQL',
'DSN=Visual FoxPro Tables;
SourceDB=d:\bases\iclientes;
SourceType=DBF',
'select * from maescaj')...
for select, update querys but the problem is that sometimes works and

I can tell you why it happen, but as of yet, I Hav...

2009-12-07T07:02:08.335-08:00

I can tell you why it happen, but as of yet, I Haven't found a solution.

The problem is cause because of the BDE, or Borland Database engine. This has not been update in a while. SO older ODBC dirvers written to interact with it do not understand the newer (well not so new) dBASE file and index structure. The Driver that we are using are actually meant for dbase 5.0. Even then they

2009-12-07T06:58:59.810-08:00

This comment has been removed by a blog administrator.

Hi, good article, it was helpful for my select que...

2009-12-07T06:29:00.704-08:00

Hi, good article, it was helpful for my select query...
I have one question, I hope you can help me, when I use a select query for example:

select * from openrowset('MSDASQL',
'Driver={Microsoft dBase Driver (*.dbf)};
DBQ=d:\bases\iclientes;
SourceType=DBF',
'select * from maesbag') , it works perfectly, but when i tried to execute

excellent!! This is just what i needed!!! congratu...

2009-09-02T11:51:02.906-07:00

excellent!! This is just what i needed!!! congratulations, really!!

I don't really think you have to tell them tha...

2009-08-12T08:53:02.964-07:00

I don't really think you have to tell them that they are bad. I guess people actually do check out work that a company's done before actually purchasing a website.

As a journalism student with visual communication as a subject, I also seem to notice the bad stuff.

As for the fact that I work for a web designer/internet marketing company, I always seem to notice as

Many thanks for your "How to ..." I had ...

2009-08-10T12:18:02.858-07:00

Many thanks for your "How to ..." I had trouble with .dbf files having names longer than 8 characters. Used David K's hint about Visual FoxPro; downloaded and installed in C:\Program Files\Common Files\System\Ole DB. Used Provider choice Microsoft OLE DB Provider for Visual FoxPro. Long table names now work!

I have seen this coming. I didn't have been d...

2009-07-29T02:31:15.130-07:00

I have seen this coming. I didn't have been dragging my feet to really dig in to c#. I have never said anything to others like yourself for moving on. Actually I admired it then and still do today.
I will be making the move little by little. Knowing you are here and always offering to help is a blessing for guys like me :-)
You have some tutorials that are great and I am sure I

thank you. very good article. search it for two da...

2009-04-08T04:54:00.000-07:00

thank you. very good article. search it for two days and was very satisfied.

Are you a dbase developer? Do you do freelance wor...

2009-03-27T08:58:00.000-07:00

Are you a dbase developer? Do you do freelance work? I'm interested in a business model enabling modified google maps or perhaps hosting map services for a social group of hikers, bikers, off road drivers and other outdoor enthusiasts.

If interested, email me at kellerchch@gmail.com

Excellent, but for the Tables and Views nodes. The...

2009-02-12T13:55:00.000-08:00

Excellent, but for the Tables and Views nodes. They don't appear... I did however run a select query and it worked!!

Sucks that I can't see tables though. Anyone have any insight on the issue? Please drop me a line at info@rad3tech.com

Thanks!

Robert;
I have found that v.7 dbf tables with l...

2009-01-28T11:42:00.000-08:00

Robert;
I have found that v.7 dbf tables with long column names can be copied to MS Access (via ODBC and updateset) without the column names being modified. Similarly, Access tables with long column names (<32 chars) can be copied to dBase without the column names being changed. So Access seems like a useable intermediary. Access can link to v.7 dbfs, but unfortunately long column names

You will find anomolies with MDAC and version 7 ta...

2009-01-28T11:03:00.000-08:00

You will find anomolies with MDAC and version 7 tables. Truth be told, MDAC only supports level 5 tables. So such things as Long field names, ie greater than 10, will be a problem.

Interesting. Thanks.
Regarding MDAC: It will o...

2009-01-28T09:40:00.000-08:00

Interesting. Thanks.
Regarding MDAC: It will open v.7 dBase tables, as you say. But my experience (linking to dBase 7 tables in Access) is that long fields names get messed up. After the tenth character, the table name is inserted.

Thank you so much for this article. Keep up the go...

2009-01-27T16:05:00.000-08:00

Thank you so much for this article. Keep up the good work.

Excellent article, I followed your instructions an...

2008-11-22T17:12:00.000-08:00

Excellent article, I followed your instructions and it worked perfectly.

I found another option for linking dbf files - instead of using the Jet database engine, you can use the OLE DB Provider for Visual FoxPro 9.0 which seems to work slightly faster (although I didn't properly test this).

You can download the OLE DB Provider for Visual FoxPro 9.0 from Microsoft at http://

Hi Robert,

Thankfully, you and several othe...

2008-11-17T09:17:00.000-08:00

Hi Robert,

Thankfully, you and several other dBASE supporters have brought this to our attention and we are doing everything we can to resolve it and minimize any negative impact.

I spoke with our customer service manager about this.

There was a misunderstanding that occurred which is now being addressed through a direct email to the customer, to the Microsoft newsgroup

Robert ... your key phrase here is "Wow! Can you b...

2008-11-17T00:24:00.000-08:00

Robert ... your key phrase here is "Wow! Can you believe that?"

There is a risk in accepting information from an unknown poster as fact.

One must also question what motivation led to that post.

Unless verification is possible, to re-post, or expand on the subject might be viewed as risky.

Well I just commented on one of your more recent p...

2008-09-27T05:14:00.000-07:00

Well I just commented on one of your more recent postings, but having now read most of your posts on this blog, I'd like to add a few things:

1) In this day and age of FOSS, if you had to commit your future or your company's future to a particular software you would choose either:

a) Open Source - Where you have the benefit of having source and not relying on a company to

I did start programming in dbase IV in, i think 19...

2008-09-27T04:50:00.000-07:00

I did start programming in dbase IV in, i think 1992. it was great at the time and dbase 7 GUI was real nice and productive; i went on a bit to db2k, but since 2002 haven't really touched dbase. i check dbase.com every now and again to see if anything is new, but, man it sure seems to be the same old dusty stuff over there.

The same names from 10 years ago still posting. The same

Is there a problem with dbase? is it becoming o...

2008-09-01T08:00:00.000-07:00
Is there a problem with dbase? is it becoming obsolete?

I've been working with dBase since the first dBase for Windows, in early 1996. The development team of my company has written in dBase, and marketed, more than one hundred programs of the most varied characteristics:

- Commercial Management, billing and warehouse.
- Control patients in hospital services as

Hi,
I am an old dBase fan. But with advent of W...

2008-08-30T21:50:00.000-07:00
Hi,
I am an old dBase fan. But with advent of Windows I had noi option but to shift to other xBase platforms. I still feel some one somewhere will pickup dBase and whip it in shape to get it competition ready. In the meantime I have started using Harbour xBase compiler which is an open source project.

Excerpts from a couple of my posts on the dBase ne...

2008-08-24T11:26:00.000-07:00
Excerpts from a couple of my posts on the dBase newgroup.

Geoff, Bruce and Roland,

Just wanted to say thanks a couple million for all your help.
Did a lot of studying and testing based on all of your replies and came up
with a solution that works perfectly.
Can't say enough about how much your contributions further the knowledge of all of us trying to learn the ins