Search results for query: *

@Craig Didnt try that but will give it a try. @Olaf ahh didnt think of that but that could be even better (staging area to sql server and do rest transforms by server). Yea will be lot work but for long run think is best solution. Think will start working on that. Thanks again all.

Maybe Craig but since other DB will mainly be storage for bulk inserts and primary selects from it and nothing more, so far i didnt found exact or similar results. For example bulk inserts in one table 500000 rows of 5 colums in fox is ~0.5 sec, via ODBC in some other DB best i got is ~8sec...

Thanks all for answers, will try some of appointed ways and see what will suit most.

Thanks for answer. Its not problem install but more like visit over 2000 clients who use software for intalls additional software(odbc/oledb driver). At least what you think i should choose for database from view of speed of drivers and large tables ? Thanks in advance.

Hi all, I would like to know is it possibile to connect from vfp to some other database but without odbc or oledb drivers. Basicly to be portable, without additional installs of some drivers except vfp runtime. I have complete DataWarehous solution but after some time my app bumped in wall...