From: Geoff Schaller on
But all DBMS support this!

Why shackle yourself to a second rate product?

"diskbit" <diskbit(a)inwest.pl> wrote in message
news:da6e9874-9662-4370-87c0-1a3f8c721137(a)z11g2000yqz.googlegroups.com:

> give names of tables large and with lower-case letters
> install http:\\www.inwest.pl\MySQLDrvSetup.exe

From: Geoff Schaller on
Hello Tyrone.

Ok, then that is a shame. MySQL has always had difficulty on the OLEDB
front but there are drivers. You must buy them (although I do not think
they are expensive) but without them you cannot use ADO.

I say 'unfortunate' because ODBC is an older technology (which ADO
supports) and so VO2Ado is of limited value. VO2Ado is recommended
because you can basically use your DBF code - all the methods and
properties you know and love are still supported.

It is a pity your web guys have limited you to MySQL. Most ISPs now
offer MS SQL by default and MySQL if requested. It is an indication of
the maturity of MS SQL for web based activity.

Geoff



"TW" <TYRONEWU(a)LIVE.COM> wrote in message
news:daa1c313-928b-448d-b269-59219dd3919a(a)w20g2000prm.googlegroups.com:

> Hi all,
>
> My Name is Tyrone.
>
> In our software teams, we have VO and web. I responsible for the VO
> part. We need to connect VO with the web development database and they
> use MySQL. The reason is that simply.
>
> I do understand that upgrading the tool is important, but sometimes
> upgrading may cause some unexpected issues which may cause some time
> to resolve.
>
>
> >>how is TW going to use MySql with (VO2)Ado?
> >>AFAIK there is no Ado/Oledb provider available for MySql...
>
>
> I'm just a learner of using SQL. I'm not quite understand Erik's
> comment.
> Does he mean that it needs a driver for MySQL to work with VO2ADO but
> the driver is not available now ?
>
> Since MySQL cannot be changed, can I still use VO2ADO ?
> Base on Erik's comment I have a little bit confuse.
>
> Anyway thanks for all your valuable opinions.
>
> Regards,
>
> Tyrone

From: Jorge on
On 22 abr, 18:42, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au>
wrote:
> Hello Tyrone.
>
> Ok, then that is a shame. MySQL has always had difficulty on the OLEDB
> front but there are drivers. You must buy them (although I do not think
> they are expensive) but without them you cannot use ADO.
>
> I say 'unfortunate' because ODBC is an older technology (which ADO
> supports) and so VO2Ado is of limited value. VO2Ado is recommended
> because you can basically use your DBF code - all the methods and
> properties you know and love are still supported.
>
> It is a pity your web guys have limited you to MySQL. Most ISPs now
> offer MS SQL by default and MySQL if requested. It is an indication of
> the maturity of MS SQL for web based activity.
>
> Geoff
>
> "TW" <TYRON...(a)LIVE.COM> wrote in message
>
> news:daa1c313-928b-448d-b269-59219dd3919a(a)w20g2000prm.googlegroups.com:
>
>
>
> > Hi all,
>
> > My Name is Tyrone.
>
> > In our software teams, we have VO and web. I responsible for the VO
> > part. We need to connect VO with the web development database and they
> > use MySQL. The reason is that simply.
>
> > I do understand that upgrading the tool is important, but sometimes
> > upgrading may cause some unexpected issues which may cause some time
> > to resolve.
>
> > >>how is TW going to use MySql with (VO2)Ado?
> > >>AFAIK there is no Ado/Oledb provider available for MySql...
>
> > I'm just a learner of using SQL. I'm not quite understand Erik's
> > comment.
> > Does he mean that it needs a driver for MySQL to work with VO2ADO but
> > the driver is not available now ?
>
> > Since MySQL cannot be changed, can I still use VO2ADO ?
> > Base on Erik's comment I have a little bit confuse.
>
> > Anyway thanks for all your valuable opinions.
>
> > Regards,
>
> > Tyrone- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -



Hello Tyrone


I've been using mysql without problems and with good
perfomance (select takes no more than 2 / 3
Second, take the idea of a comment by Geoff)

But you must upgrade VO and bBrowser.
Some bugs were corrected in these last
versions

If you could choose I also recommend
sql server. (The future of mysql is not clear)

But if you have no chance it's not so pitiful

Best regards
Jorge Accinelli
From: E®!k /!$$E® on
Willie, Geoff,
I agree with you both that Vo2Ado is the way to go in a Win32 app
development, but....

how is TW going to use MySql with (VO2)Ado?
AFAIK there is no Ado/Oledb provider available for MySql...

regards,

Erik




"Geoff Schaller" <geoffx(a)softxwareobjectives.com.au> schreef in bericht
news:TSKzn.20597$pv.14261(a)news-server.bigpond.net.au...
> TW,
>
> (What is your name please). In summary, a SQL version can always be made
> to run as quickly as DBF, with some caveats, but there are many things
> that can be 1000 times faster than for DBF. Computation and reporting
> among them. There are some things that a just too difficult to do in DBF
> that is a snap in SQL. And remember that filters are fast and exciting in
> SQL. Let's look at how you can make your app work faster:
>
> 1. Use ADO instead of ODBC. This is just simply vital.
> 2. Use MS SQL Express instead of MySQL. It is an order of magnitude
> faster.
> 3. Do not use the VO SQL classes. Use VO2Ado. There is a small cost here.
> 4. Make sure you have appropriate indexes, a primary key, etc in your
> table.
> 5. Pull only the columns and rows you need.
>
> Having said that, I would expect 4000 rows to load virtually instantly and
> in my applications they do. And this is on bBrowser.
>
> Why should you upgrade to bBrowser 3.0? Well for exactly the same reason
> you should be using VO 2.8 - major, major class and functionality upgrades
> and bug fixes. Please tell me the argument for NOT upgrading? The cost is
> small. Read their update and What's New docs for precise details.
>
> Your DLL error is simple DLL hell. You have one with the wrong version in
> the execution file path.
>
> Cheers,
>
> Geoff
>
>
>
> "TW" <TYRONEWU(a)LIVE.COM> wrote in message
> news:c8e7093a-b4bc-48d6-ba80-7999bbd19cc2(a)x18g2000prk.googlegroups.com:
>
>> Hi,
>>
>> I would like to thanks for Geoff. I can make it work now but the speed
>> of loading is so much slower than DBF. DBF can show it almost right
>> away. Anyway I can set the Query statement to include less columns and
>> rows. For this table I have 68 fields and 3785 records. It does not
>> seem to be a problem in DBF.
>>
>>
>> Also thanks for Jorge. I will consider of upgrading to version 3, but
>> can you tell me what features to make it worth upgrading.
>>
>>
>> Does anyone know the following problem ?
>> Recently, I move my VO from the old machine with Windows 2000 to a
>> new
>> machine with Windows XP Pro. When I run an application with bBrowser
>> under VO in the new machine with Windows XP Pro, I get an error
>> message "The ordinal 125 could not be located in the dynamic link
>> library VO27OLE.DLL". In the old machine with Windows 2000, I do not
>> have such problem.
>>
>>
>> Thanks.
>>
>> TW
>
From: Geoff Schaller on
I agree - I am waiting also to hear why he is using MySQL.


"ER!k \/!$$ER" <nospam(a)nospam.com> wrote in message
news:83a7ebFfjeU1(a)mid.individual.net:

> Willie, Geoff,
> I agree with you both that Vo2Ado is the way to go in a Win32 app
> development, but....
>
> how is TW going to use MySql with (VO2)Ado?
> AFAIK there is no Ado/Oledb provider available for MySql...
>
> regards,
>
> Erik
>
>
>
>
> "Geoff Schaller" <geoffx(a)softxwareobjectives.com.au> schreef in bericht
> news:TSKzn.20597$pv.14261(a)news-server.bigpond.net.au...
>
> > TW,
> >
> > (What is your name please). In summary, a SQL version can always be made
> > to run as quickly as DBF, with some caveats, but there are many things
> > that can be 1000 times faster than for DBF. Computation and reporting
> > among them. There are some things that a just too difficult to do in DBF
> > that is a snap in SQL. And remember that filters are fast and exciting in
> > SQL. Let's look at how you can make your app work faster:
> >
> > 1. Use ADO instead of ODBC. This is just simply vital.
> > 2. Use MS SQL Express instead of MySQL. It is an order of magnitude
> > faster.
> > 3. Do not use the VO SQL classes. Use VO2Ado. There is a small cost here.
> > 4. Make sure you have appropriate indexes, a primary key, etc in your
> > table.
> > 5. Pull only the columns and rows you need.
> >
> > Having said that, I would expect 4000 rows to load virtually instantly and
> > in my applications they do. And this is on bBrowser.
> >
> > Why should you upgrade to bBrowser 3.0? Well for exactly the same reason
> > you should be using VO 2.8 - major, major class and functionality upgrades
> > and bug fixes. Please tell me the argument for NOT upgrading? The cost is
> > small. Read their update and What's New docs for precise details.
> >
> > Your DLL error is simple DLL hell. You have one with the wrong version in
> > the execution file path.
> >
> > Cheers,
> >
> > Geoff
> >
> >
> >
> > "TW" <TYRONEWU(a)LIVE.COM> wrote in message
> > news:c8e7093a-b4bc-48d6-ba80-7999bbd19cc2(a)x18g2000prk.googlegroups.com:
> >
>
> >> Hi,
> >>
> >> I would like to thanks for Geoff. I can make it work now but the speed
> >> of loading is so much slower than DBF. DBF can show it almost right
> >> away. Anyway I can set the Query statement to include less columns and
> >> rows. For this table I have 68 fields and 3785 records. It does not
> >> seem to be a problem in DBF.
> >>
> >>
> >> Also thanks for Jorge. I will consider of upgrading to version 3, but
> >> can you tell me what features to make it worth upgrading.
> >>
> >>
> >> Does anyone know the following problem ?
> >> Recently, I move my VO from the old machine with Windows 2000 to a
> >> new
> >> machine with Windows XP Pro. When I run an application with bBrowser
> >> under VO in the new machine with Windows XP Pro, I get an error
> >> message "The ordinal 125 could not be located in the dynamic link
> >> library VO27OLE.DLL". In the old machine with Windows 2000, I do not
> >> have such problem.
> >>
> >>
> >> Thanks.
> >>
> >> TW
>
> >