What about Sybase iAnywhere's Advantage Database Server ?

TheMSsForum.com: The Microsoft Software Forum

I am trying to attend South West Fox conference in Arizona in October, and
one of the sponsors is Sybase. Does anybody have got an experience with
their Advantage Database Server? Does it replace SQL Server? Pros? Cons?

Walter
Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by Fred

Fred
Sun Jul 06 12:37:48 CDT 2008

Andy Kramek has blogged about it a bit:

http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx

and also he mentioned a screen cast by J. D. Mullin:
http://jdmullin.blogspot.com/2008/02/getting-started-with-visual-foxpro-and.html

--
Fred
Microsoft Visual FoxPro MVP


"WP" <wpaul_nospam@arnet.com.ar> wrote in message
news:eYwz2o43IHA.2064@TK2MSFTNGP02.phx.gbl...
>I am trying to attend South West Fox conference in Arizona in October, and
>one of the sponsors is Sybase. Does anybody have got an experience with
>their Advantage Database Server? Does it replace SQL Server? Pros? Cons?
>
> Walter
>


Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by Dan

Dan
Sun Jul 06 15:39:40 CDT 2008

He's also written about it in FoxRockx (http://www.foxrockx.com).

Dan

Fred Taylor wrote:
> Andy Kramek has blogged about it a bit:
>
> http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx
>
> and also he mentioned a screen cast by J. D. Mullin:
> http://jdmullin.blogspot.com/2008/02/getting-started-with-visual-foxpro-and.html
>
>
> "WP" <wpaul_nospam@arnet.com.ar> wrote in message
> news:eYwz2o43IHA.2064@TK2MSFTNGP02.phx.gbl...
>> I am trying to attend South West Fox conference in Arizona in
>> October, and one of the sponsors is Sybase. Does anybody have got an
>> experience with their Advantage Database Server? Does it replace SQL
>> Server? Pros? Cons? Walter


Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by Lew

Lew
Sun Jul 06 15:49:37 CDT 2008

Is that VFP9 format only? Will it handle 2.6/dos style tables as well?

"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:O$PTh643IHA.2064@TK2MSFTNGP02.phx.gbl...
> Andy Kramek has blogged about it a bit:
>
> http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx
>
> and also he mentioned a screen cast by J. D. Mullin:
> http://jdmullin.blogspot.com/2008/02/getting-started-with-visual-foxpro-and.html
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "WP" <wpaul_nospam@arnet.com.ar> wrote in message
> news:eYwz2o43IHA.2064@TK2MSFTNGP02.phx.gbl...
>>I am trying to attend South West Fox conference in Arizona in October, and
>>one of the sponsors is Sybase. Does anybody have got an experience with
>>their Advantage Database Server? Does it replace SQL Server? Pros? Cons?
>>
>> Walter
>>
>
>


Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by tg

tg
Mon Jul 07 08:25:38 CDT 2008

WP schrieb:
> I am trying to attend South West Fox conference in Arizona in October, and
> one of the sponsors is Sybase. Does anybody have got an experience with
> their Advantage Database Server? Does it replace SQL Server? Pros? Cons?

If you support a table based application whith often changing schema you
still only have the script updating the vfp backend - one area of update
work eliminated. If the reason to move to C/S is more the wish to reduce
network traffic/WAN performance it looks good, but if the aim is higher
security I doubt that it is tested as extensively as SQL server.

Tests planned for such a customer end of year.

regards

thomas
Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by Fred

Fred
Mon Jul 07 11:00:28 CDT 2008

Since it's an ODBC driver, you should be able to communicate just fine via
remote views and SQL Pass Through. So yes, VFP6 should work OK.

--
Fred
Microsoft Visual FoxPro MVP


"Lew" <lew@fastmail.fm> wrote in message
news:%237YFRn63IHA.2336@TK2MSFTNGP03.phx.gbl...
> Is that VFP9 format only? Will it handle 2.6/dos style tables as well?
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:O$PTh643IHA.2064@TK2MSFTNGP02.phx.gbl...
>> Andy Kramek has blogged about it a bit:
>>
>> http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx
>>
>> and also he mentioned a screen cast by J. D. Mullin:
>> http://jdmullin.blogspot.com/2008/02/getting-started-with-visual-foxpro-and.html
>>
>> --
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "WP" <wpaul_nospam@arnet.com.ar> wrote in message
>> news:eYwz2o43IHA.2064@TK2MSFTNGP02.phx.gbl...
>>>I am trying to attend South West Fox conference in Arizona in October,
>>>and one of the sponsors is Sybase. Does anybody have got an experience
>>>with their Advantage Database Server? Does it replace SQL Server? Pros?
>>>Cons?
>>>
>>> Walter
>>>
>>
>>
>
>


Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by Lew

Lew
Mon Jul 07 19:42:32 CDT 2008

I was asking about foxbase 2.6 ...
"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:%23mDvyoE4IHA.3396@TK2MSFTNGP02.phx.gbl...
> Since it's an ODBC driver, you should be able to communicate just fine via
> remote views and SQL Pass Through. So yes, VFP6 should work OK.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Lew" <lew@fastmail.fm> wrote in message
> news:%237YFRn63IHA.2336@TK2MSFTNGP03.phx.gbl...
>> Is that VFP9 format only? Will it handle 2.6/dos style tables as well?
>>
>> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
>> news:O$PTh643IHA.2064@TK2MSFTNGP02.phx.gbl...
>>> Andy Kramek has blogged about it a bit:
>>>
>>> http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx
>>>
>>> and also he mentioned a screen cast by J. D. Mullin:
>>> http://jdmullin.blogspot.com/2008/02/getting-started-with-visual-foxpro-and.html
>>>
>>> --
>>> Fred
>>> Microsoft Visual FoxPro MVP
>>>
>>>
>>> "WP" <wpaul_nospam@arnet.com.ar> wrote in message
>>> news:eYwz2o43IHA.2064@TK2MSFTNGP02.phx.gbl...
>>>>I am trying to attend South West Fox conference in Arizona in October,
>>>>and one of the sponsors is Sybase. Does anybody have got an experience
>>>>with their Advantage Database Server? Does it replace SQL Server? Pros?
>>>>Cons?
>>>>
>>>> Walter
>>>>
>>>
>>>
>>
>>
>
>


Top

Re: What about Sybase iAnywhere's Advantage Database Server ? by Fred

Fred
Mon Jul 07 20:00:05 CDT 2008

If you are able to to talk to ODBC with the connectivity kit that was
available for 2.6, then yes. You still won't be able to reference field
types that are not availablel in FPDos.

--
Fred
Microsoft Visual FoxPro MVP


"Lew" <lew@fastmail.fm> wrote in message
news:eZdZFOJ4IHA.4776@TK2MSFTNGP05.phx.gbl...
>I was asking about foxbase 2.6 ...
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:%23mDvyoE4IHA.3396@TK2MSFTNGP02.phx.gbl...
>> Since it's an ODBC driver, you should be able to communicate just fine
>> via remote views and SQL Pass Through. So yes, VFP6 should work OK.
>>
>> --
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "Lew" <lew@fastmail.fm> wrote in message
>> news:%237YFRn63IHA.2336@TK2MSFTNGP03.phx.gbl...
>>> Is that VFP9 format only? Will it handle 2.6/dos style tables as well?
>>>
>>> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
>>> news:O$PTh643IHA.2064@TK2MSFTNGP02.phx.gbl...
>>>> Andy Kramek has blogged about it a bit:
>>>>
>>>> http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx
>>>>
>>>> and also he mentioned a screen cast by J. D. Mullin:
>>>> http://jdmullin.blogspot.com/2008/02/getting-started-with-visual-foxpro-and.html
>>>>
>>>> --
>>>> Fred
>>>> Microsoft Visual FoxPro MVP
>>>>
>>>>
>>>> "WP" <wpaul_nospam@arnet.com.ar> wrote in message
>>>> news:eYwz2o43IHA.2064@TK2MSFTNGP02.phx.gbl...
>>>>>I am trying to attend South West Fox conference in Arizona in October,
>>>>>and one of the sponsors is Sybase. Does anybody have got an experience
>>>>>with their Advantage Database Server? Does it replace SQL Server? Pros?
>>>>>Cons?
>>>>>
>>>>> Walter
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Top