OT Delphi Prism Nexusdb and Developer Express

1) The NexusDB ADO driver, at least in read mode, works very well with
Delphi Prism.

2) The Developer Express DXExperience components are really quite nice
....but it took me a while to get them to work when deployed. They work
right out of the box in development mode ... but I had to google and
poke around to find out that when you deploy DXexperience ASP
components, you have to locate and deploy their assemblies as well.

If you look at the reference section and see the DXcomponent references,
then if you check their properties, you will see where they exist in
your development environment. Then you can copy the appropriate dlls to
the bin folder of your deployment folder of your AsP.net application.

If when you deploy and run the application, you may get a missing
assembly error. It will mean that you have to copy a particular dll to
your bin folder.

I think Developer Express is a little remiss in not making this clear in
their documentation...

I use the Abyss Web Server ... and it was easy to install the asp.net
application. However, I had been using .net 4.0 ... and I had to
rebuild the application using .net 3.5 because Abyss 2.6 does not
support 4.0 ... the next version will.

The response of the Asp.net application is quite good. Developer
express's components generally only load the visible grid data, so it
was quite fast.

I am testing with a database with 77K records and they load into the
pivot grid in a matter of seconds....

I hope this helps any of you experimenting with ADO and Prism...

This morning I moved my AsP.net Nexusdb ADO provider Developer Express
PivotGrid to my server ....

First of all, I had to install the 3.5 dot net framework.

I had to boot the server after that installation.

then I downloaded and ran the DelphiPrismCommandLineCompiler ... This is
a free download that is necessary in order to install Oxygene in the dot
net environment ...

I ran the NexusDB Runtime installer for the ADO Provider.

Finally I had to copy the V3 provider dll to the Nexusdb bin folder and
then turn on the AdO provider direct connect.

Once this was done all was in place.

I fired up my VPN connection to the server ... typed in the address and
low and behold my application was available and worked perfectly.

I was suprised at how fast everything was over the VPN, which is
normally muc slower than a standard internet connection....

The key is the Developer Express smart loading of the Pivot Grid ... It
seemed almost as fast as a standard windows client server pivot grid
application....

Given the success of this learning experience, I think ADO.Net and
Delphi Prism is probably the best way to go for state of the art web
development....

One of these days, I will look into Silverlight as well ... but next on
my list is learning how to update database tables with the ADO.Net
approach.....

I hope these posts will help any of you starting out in the .NeT world...

have a nice day....

David Guest

David,

This is much appreciated.

Maybe you should write a book?

Web development with new tools and covering all of the "gotchas" to make it all work is sorely needed.
It can take days to fine the "penny that is holding up the dollar".
John
> This morning I moved my AsP.net Nexusdb ADO provider Developer Express
> PivotGrid to my server ....
>
> First of all, I had to install the 3.5 dot net framework.
>
> I had to boot the server after that installation.
>
> then I downloaded and ran the DelphiPrismCommandLineCompiler ... This is
> a free download that is necessary in order to install Oxygene in the dot
> net environment ...
>
> I ran the NexusDB Runtime installer for the ADO Provider.
>
> Finally I had to copy the V3 provider dll to the Nexusdb bin folder and
> then turn on the AdO provider direct connect.
>
> Once this was done all was in place.
>
> I fired up my VPN connection to the server ... typed in the address and
> low and behold my application was available and worked perfectly.
>
> I was suprised at how fast everything was over the VPN, which is
> normally muc slower than a standard internet connection....
>
> The key is the Developer Express smart loading of the Pivot Grid ... It
> seemed almost as fast as a standard windows client server pivot grid
> application....
>
> Given the success of this learning experience, I think ADO.Net and
> Delphi Prism is probably the best way to go for state of the art web
> development....
>
> One of these days, I will look into Silverlight as well ... but next on
> my list is learning how to update database tables with the ADO.Net
> approach.....
>
> I hope these posts will help any of you starting out in the .NeT world...
>
> have a nice day....
>
> David Guest
>

That would be "finD the penny...not fine"
> David,
>
> This is much appreciated.
>
> Maybe you should write a book?
>
> Web development with new tools and covering all of the "gotchas" to make
> it all work is sorely needed.
> It can take days to fine the "penny that is holding up the dollar".
> John
>> This morning I moved my AsP.net Nexusdb ADO provider Developer Express
>> PivotGrid to my server ....
>>
>> First of all, I had to install the 3.5 dot net framework.
>>
>> I had to boot the server after that installation.
>>
>> then I downloaded and ran the DelphiPrismCommandLineCompiler ... This
>> is a free download that is necessary in order to install Oxygene in
>> the dot net environment ...
>>
>> I ran the NexusDB Runtime installer for the ADO Provider.
>>
>> Finally I had to copy the V3 provider dll to the Nexusdb bin folder
>> and then turn on the AdO provider direct connect.
>>
>> Once this was done all was in place.
>>
>> I fired up my VPN connection to the server ... typed in the address
>> and low and behold my application was available and worked perfectly.
>>
>> I was suprised at how fast everything was over the VPN, which is
>> normally muc slower than a standard internet connection....
>>
>> The key is the Developer Express smart loading of the Pivot Grid ...
>> It seemed almost as fast as a standard windows client server pivot
>> grid application....
>>
>> Given the success of this learning experience, I think ADO.Net and
>> Delphi Prism is probably the best way to go for state of the art web
>> development....
>>
>> One of these days, I will look into Silverlight as well ... but next
>> on my list is learning how to update database tables with the ADO.Net
>> approach.....
>>
>> I hope these posts will help any of you starting out in the .NeT world...
>>
>> have a nice day....
>>
>> David Guest
>>

David,

I agree fully.

These guys bail me out regularly!

John
> On 10/19/2010 10:34 AM, John Turner wrote:
>> David,
>>
>> This is much appreciated.
>>
>> Maybe you should write a book?
>>
>
>
> Fiction is all I can write...two novels, two full plays and 5 one act
> plays....I wish I had more time to write ... would like to do another
> big novel....
>
> I love Nexusdb ... the newsgroups are the best support in the industry
> ... not matter what your problem is, somebody out here gives you the
> answer or the direction to go in.... So, I am just trying to do my
> little bit ...

On 10/19/2010 10:34 AM, John Turner wrote:
> David,
>
> This is much appreciated.
>
> Maybe you should write a book?
>


Fiction is all I can write...two novels, two full plays and 5 one act
plays....I wish I had more time to write ... would like to do another
big novel....

I love Nexusdb ... the newsgroups are the best support in the industry
.... not matter what your problem is, somebody out here gives you the
answer or the direction to go in.... So, I am just trying to do my
little bit ...

David,

I honestly envy you and another NexusDB friend, Scott Martin, who are
able to "dab" into several technologies.

I am still stuck in C Builder 2007 and IW 10.x because our business is
actually growing by large % (300% this year) and I am stuck implementing
new features in C Builder 2007 for the see-able future just to keep our
existing + new clients happy!

Best Regards,

Shane

On 10/19/2010 4:56 PM, Shane Stump wrote:
> David,
>
> I honestly envy you and another NexusDB friend, Scott Martin, who are
> able to "dab" into several technologies.
>
> I am still stuck in C Builder 2007 and IW 10.x because our business is
> actually growing by large % (300% this year) and I am stuck implementing
> new features in C Builder 2007 for the see-able future just to keep our
> existing + new clients happy!
>
> Best Regards,
>
> Shane

Shane, I get paid for working for the non profit hospital for 25 hours a
week ... but I work about 60 hours... some of that, when I get tired of
solving idiot problems, I invest in learning ... Thorsten sets a good
example. He once said that he takes two hours a day to research and
learn ...

Another problem I have, is that the hospital keeps putting blocks in
front of my creating and installing c/s applications on the desktop ...
They are moving to citrix and thin clients ... so learning enough about
web based applications is a must ... even if it is on my own time. I
started this morning at 4 am ... It was the only time I could install
3.5 dot net on my server at the hospital.

.. and as I approach my 79th birthday in December, I'd like to be able to
keep up with the industry.

Make some time, take some time... and do keep up ...this morning, I got
an application working that will be useful to the executives at the
hospital and which took me over the hump in the .Net learning curve....

I truly understand where you are coming from, Shane ... but do invest in
the future... it is your future...

have a nice day...

David Guest

> ... but do invest in the future... it is your future...

AMEN!

--

Hannes Danzl / NexusDB

Manuals - http://www.nexusdb.com/support/index..._manual_v3.htm
Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
Newsgroup Web Gateway - http://www.nexusdb.com/forums/
Newsgroup Search - http://www.nexusdb.com/forums/search.php

> I truly understand where you are coming from, Shane ... but do invest in
> the future... it is your future...
>
I own 50% of the business so whatever customers want, they get (that is
my future)!

If I give any more time to the business, I won't have a life <BG>!

Oh well, I am hoping to hire two programmers for the team next year and
hopefully I will get to dab into other things!

> have a nice day...

LIKEWISE!

Shane