Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved ADO.net vs ODBC

  1. Issue
0
Votes
Undo
  1. Bjarne Anker
    Bjarne Anker
  2. PowerBuilder
  3. Tuesday, 23 January 2018 22:47 PM UTC

Hi.

 

Right now, our application is set up to connect to the SQL Anywhere 16 database via ODBC (defined in System DSN).

However, I've been thinking about using ADO.net instead.

But is there any better performance in using ADO.net instead ODBC driver?

And if so, does anyone have examples of connectionstrings, both for a running database on another computer (service) and to start and connect to a db-file on a local computer?

 

Regards,

 

Bjarne Anker

Maritech Systems AS

  1. ADO.NET
  2. Build
PB9 - PRINTSEND
Excel file not closing on disconnect
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 7 February 2018 18:51 PM UTC
  2. PowerBuilder
  3. # 1

Chris is right.  And I would add that if you plan on using the new C# features of PB 2018 it might be good idea to standardize on one DB interface (ADO.NET) to simplify coding, testing, debugging, etc.  When I say standardize I mean using ADO.NET on the PowerScript side even though PowerScript is not managed code like C#.

In the case of SQL Anywhere, I don't know what investment has been made by SAP to provide a good ADO.NET data provider.  But for SQL Server and possibly Oracle as well, it seems to me great investments have been made by Microsoft and Oracle to provide a strong ADO.NET driver.  In fact, Microsoft has phased out the SQL Server native client and basically pushing people to use ADO.NET.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 January 2018 14:04 PM UTC
  2. PowerBuilder
  3. # 2

Hi Bjarne;

     AFAIK, there is no better performance on ADO.Net vs ODBC for SA. In fact, I suspect that ADO.NET might even be a little slower on certain aspects vs ODBC. Where ADO.Net does shine is where you have "managed code" - like in pure C# APPs. So for example, in PB 2018's new C# Web API feature - ADO.Net would be running within a managed code execution model. That might certainly be a plus for ADO.Net vs ODBC.

   Note: PowerServer has a native driver for SA.

Just my $0.02.  HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.