Its not a matter of technology. Its the target audience. I'm old enough to remember the "software backlog". All the Basic language flavors were targeted toward biz analysts who are...

very concise. Very helpful. tks much.

Foxpro error msgs are pretty "obtuse". Its probably trying to complain about the "fred...drugnote" part. I use openquery() through the linked server for all CRUD statements successfully. For non-select statements,...

IMHO, in your mixed language environment, I'd do sprocs when you have control flow to further cook you data. If the cooking is done in VB, you're bringing lots of...

your cisco guy is concerned about security like he should be. 1433 is a well known port and not secured. Have him setup a VPN tunnel between the firewalls and...

I do this on steroids. I have a "traditional" table with ProductID, sku, and other cols that are common to ALL products like weight and dims.

I have a second tbl...

cool. I assume that's in sql 2000 also. I'll hunt around for it. It didnt jump out at me.

tks for the pointer.