#1  
Old 10th October 2012, 05:58 AM
David Guest
 
Posts: n/a
Default How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

Stuck and I cannot move forward until I can see the ADO.Net Provider in
VS 2010...

I have it running on the Server....
  #2  
Old 11th October 2012, 02:20 AM
David Guest
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

On 10/9/2012 1:58 PM, David Guest wrote:
> Stuck and I cannot move forward until I can see the ADO.Net Provider in
> VS 2010...
>
> I have it running on the Server....



i finally figured it out ....
  #3  
Old 12th October 2012, 11:33 PM
tempit tempit is offline
Junior Member
 
Join Date: Oct 2011
Posts: 21
Default

Quote:
Originally Posted by David Guest View Post
On 10/9/2012 1:58 PM, David Guest wrote:

i finally figured it out ....
Hello David,

are you willing to share your wisdom?

TIA
Markus
  #4  
Old 13th October 2012, 02:52 AM
David Guest
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

Not much wisdom here ... and I am not sure what really did it, but I
made sure the v3connector dll was in the directory where my nxserver is.
I then ran the runtime installer. It completed, but I am not sure
what it did. I also copied the two dlls in the bin directory to windows
system 32.

then when I went to add a new DNS I saw the nexus provider driver and
was able to get it to work, that is create a new connection, point it to
a known data base and create the retrieval sql.

However, I am having problems getting the ADO provider to automatically
create update, delete and insert sQLs. I make sure I have a primary
key, verified by doing a generated SQL creation script ... but the
provider still doesn't seem to recognize it.

In my opinion, not spending lots of effort on the ADO provider is a HUGE
mistake on the part of Nexusdb. Microsoft's vision of the future is all
based on the .NET framework. And if the nexusdb stuff does not work
easily and effectively in that world, then it will be all over for
nexusdb. The Delphi world (embarcadero) has shot itself in the foot.
Moving to Unicode might be good for many developers in the world, but in
the US, it is a pain to say the least, and uses twice as much bandwith
storage, etc.

Visual Studio 2012 has done it right. Everything is Ansi, unless you
want UNICODE.

My hospital will never need Unicode... so it doesn't make sense to move
in that direction. But it does make sense to move to the Web with
ASP.Net ... It is like old fashioned drag and drop and set a few
properties... and C# looks like a nifty little language....

If I were Nexusdb, I would create a nice little package for VB, C# and
F# users, the nxserver, the enterprise manager, and the ADO provider
with a license for unlimited deployment with no royalities... go head to
head with Microsoft and the MSSQL product for the web world...

But it would have to work, be documented have working examples and be
easy to use and be flawless in its performance....

I will say more, if and when I get a handle on these things.
  #5  
Old 13th October 2012, 08:59 AM
David Guest
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

I just followed my own steps on another computer and it did not work...

Lost again ....

What I do not know is how to make Windows see the Nexus ADO.Net
provider.....
  #6  
Old 13th October 2012, 11:12 PM
Ramzi H.
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

On 13/10/2012 1:52 AM, David Guest wrote:
> However, I am having problems getting the ADO provider to automatically
> create update, delete and insert sQLs. I make sure I have a primary
> key, verified by doing a generated SQL creation script ... but the
> provider still doesn't seem to recognize it.
>


David, are you referring to the .NET v4 Entity Framework, and the
automatic update, delete and insert SQL generation (using Linq)? If
that is the case, then I can tell that it does not work at all, at least
not with the fair amount of testing I did on the trial version of the
NexusDB ADO.NET driver in VS2010.

In the end I gave up and just decided to do it all manually, until
NexusDB comes out with full support for the Entity Framework.

If you want working code examples, let me know and I'll create a C#
Update/Delete/Insert based on the code I'm using at the moment. The
code is also as generic as possible with regards to the database
connection, so you can swap it for another database easily (like MySQL etc).

>
> If I were Nexusdb, I would create a nice little package for VB, C# and
> F# users, the nxserver, the enterprise manager, and the ADO provider
> with a license for unlimited deployment with no royalities... go head to
> head with Microsoft and the MSSQL product for the web world...
>
> But it would have to work, be documented have working examples and be
> easy to use and be flawless in its performance....
>


Personally I would prefer an option to purchase the ADO.NET drive with
the source code, so at least we can add the missing parts to the ADO.NET
driver, and fix any issues ourselves, assuming the NexusDB team doesn't
have the time/resources available to do so themselves.

With the current state of the ADO.NET driver, I honestly think it is not
worth the cost, but in saying that, I would gladly pay that same price
if the source code was available, and more than willing to submit any
and all modifications & updates I make to the driver.

RH

  #7  
Old 13th October 2012, 11:17 PM
Ramzi H.
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

On 13/10/2012 7:59 AM, David Guest wrote:
> I just followed my own steps on another computer and it did not work...
>
> Lost again ....
>
> What I do not know is how to make Windows see the Nexus ADO.Net
> provider.....


I had that exact issue, and resolved it by creating a directory
(C:\NexusDBDrivers), and putting the ADO.NET (and PHP) DLLs in that
directory, then adding that to the Windows PATH variable.

I hope that helps.

RH


  #8  
Old 14th October 2012, 03:30 AM
David Guest
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

"David, are you referring to the .NET v4 Entity Framework, and the
automatic update, delete and insert SQL generation (using Linq)? If
that is the case, then I can tell that it does not work at all, at least
not with the fair amount of testing I did on the trial version of the
NexusDB ADO.NET driver in VS2010."

I got it to work on an earlier version of Prism... I was not using LINK,
just the SQL interface ... I actually was able to edit and create new
entries using the grid component...

However, with Visual Studio 2012, I cannot even see the ADO.Net provider.

The fact that you have tested it extensively and cannot get it to work
is disturbing...

I agree with you that Nexusdb should for the delphi developer world,
offer the source and a standard package with no deployment costs...

For the C# and VB world they should provide a package including the
nexusdb server and EM at an attractive price and go after the huge VB
market..

It would be nice if the damn thing would work and that it was documented
well enough so that a neophyte like me could follow some instructions
and get it to work....

  #9  
Old 14th October 2012, 03:31 AM
David Guest
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?


> If you want working code examples, let me know and I'll create a C#
> Update/Delete/Insert based on the code I'm using at the moment. The
> code is also as generic as possible with regards to the database
> connection, so you can swap it for another database easily (like MySQL
> etc).
>


I would love working code examples ...With those I could at least make
some progress in learning to deal with C# and my many databases in a web
world....

thank you ramzi...

have a nice weekend...

David Guest
dpguest@aol.com

  #10  
Old 14th October 2012, 11:24 AM
Ramzi H.
 
Posts: n/a
Default Re: How do I add the Nexusdb ADO.NET Provider to Visual Studio 2010?

On 14/10/2012 2:31 AM, David Guest wrote:

> I would love working code examples ...With those I could at least make
> some progress in learning to deal with C# and my many databases in a web
> world....
>
> thank you ramzi...
>
> have a nice weekend...
>
> David Guest
> dpguest@aol.com
>


David,

I've upload a small WinForms VS2010 application to the binaries
newsgroup, titled "VS2010 ADO.NET WinForms example app". It uses code
directly from the ASP.NET application I am developing.

An ASP.NET app will also be uploaded when I have a bit more time (within
a few days).

In the WinForms application, the only WinForms specific bit of code is
the actual form itself. The rest of the C# code is used as is in a
ASP.NET application, with the user interface code calling the required
functions in the 'Business Logic' layer of the code to retrieve & save
the data.


RH




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Studio Tabs Studio Hannes Danzl[NDD] nexusdb.public.discussions 0 3rd June 2010 10:09 AM
Visual Studio 2010 Franz-Leo Chomse [NDX] nexusdb.public.discussions 0 13th April 2010 05:37 AM
Visual Studio Arne De Herdt nexusdb.public.support 1 23rd March 2010 11:31 PM
NexusDb with Visual Studio 2005 Mark Clark nexusdb.public.support.adoprovider 1 17th January 2008 01:09 PM
dotNet Provider for Visual Studio 2005 and NexusDB Version 2.04 Beta Bernhard Roos nexusdb.public.support.adoprovider 0 13th January 2006 12:44 AM


All times are GMT +11. The time now is 06:26 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.