ASNA Datagate vs Client Access

[pgollnic]

Hello ... I am looking at developing a VS 200x .net application and want to use DB2 as my datasource. I have been using ASNA's datagate for years (writting classes to retrieve my data). Is it possible to do the same thing using Client Access??

thanks

gollnick

[littlepd]

Re: ASNA Datagate vs Client Access

From what I can remember of Datagate (and it has been several years), there is nothing within Client Access that is comparable. However, Client Access does provide a .NET data provider that you can use to connect to DB2. You use it like any other ActiveX Data Object control. The classes can then be written in .NET.

[pgollnic]

Re: ASNA Datagate vs Client Access

Thank you... Are there any examples you could point me towards?
Also ... I assume this would extend to both web and windows .net applications.. After all.. a class is a class...
Would this be similiar to the sql data provider??

Thanks

gollnick

[jamief]

Re: ASNA Datagate vs Client Access

i use this with ASP its OLD Schoold but can get you going.
Please post updates as they happen...

<%
'=======================================================================
  'Create DB objects

  Set cmd = Server.CreateObject("ADODB.Command")
  Set rs = Server.CreateObject("ADODB.Recordset")
  Set Connection = Server.CreateObject("ADODB.Connection")


  Connection.Open "Provider=IBMDA400;User ID=&USERID;Password=&Password;Data Source=10.0.1.1;"

 '=======================================================================
%> 

to query data ...
use <!--#include virtual="/includes/header2.asp" --> to include above code

                <!-- loop starts here !-->
                <%
            
        


  SQLSTMT =  "select cname, sname, city , state , monweight, ytdweight  "  & _
             "from CUSTOMERS  order by ytdweight desc"

save1 = 0
save2 = 0

 Set RS = Connection.Execute(SQLStmt)
 Do While Not RS.EOF

  count = count +1





  if background = ""  or Background = "#FFFFFF" then
     background = "#CCFFCC"
  else
     background = "#FFFFFF"
  end if


  Response.Write("<tr  bgcolor= " & background & ">")

  Response.Write("<td>")
  Response.Write(count)
  Response.Write("</td>")
  Response.Write("<td>")
  Response.Write(RS.Fields("CNAME"))
  Response.Write("</td>")
  Response.Write("<td>")
  Response.Write(RS.Fields("SNAME"))
  Response.Write("</td>")
  Response.Write("<td>")
  Response.Write(RS.Fields("CITY"))
  Response.Write("</td>")
  Response.Write("<td>")
  Response.Write(RS.Fields("STATE"))
  Response.Write("</td>")
  Response.Write("<td>")

  nosalesthismonth = FormatNumber(RS.Fields("MONWEIGHT"),0)
  if nosalesthismonth = 0 then
   Response.Write("<font color=RED>No Sales</font>")
  else
   Response.Write(FormatNumber(RS.Fields("MONWEIGHT"),0))
  end if

  Response.Write("</td>")
  Response.Write("<td>")
  Response.Write(FormatNumber(RS.Fields("YTDWEIGHT"),0))
  Response.Write("</td>")

  Response.Write("</tr>")


save1 = save1 + Round(RS.Fields("MONWEIGHT"))
save2 = save2 + Round(RS.Fields("YTDWEIGHT"))



rs.MoveNext
Loop
rs.Close 

[jamief]

Re: ASNA Datagate vs Client Access

and I just got this.....

[jtemple]

Re: ASNA Datagate vs Client Access

and I just got this.....

Interesting paper. I would, however, like to point out one incorrect point. The paper states that .Net applications only run on Windows making one think that .Net is a Microsoft proprietary product. In actuality .Net and more specifically, CLI (Common Language Infrastructure) was developed jointly by Microsoft, HP and Intel. Microsoft .Net is without a doubt the most common implementation of the CLI standard but not the only one. The article incorrectly states that .Net can only run on Windows. .Net applications can also run on Linux. For example, FROG's replacement (named Tadpole) runs identically between Windows and Linux using MONO. I loaded the solution file created by VS2008 into MONO without modification, pressed F5 and the program ran.

One other point to consider when using IBM's .Net driver for the i is that as of V6R1 the driver is compatible with the database provider factory of .net. This means you write one program to access your database via a generic set of classes within .Net and set the drive to use outside of the application. That way you could very easily port your application to another database if desired.

[pgollnic]

Re: ASNA Datagate vs Client Access

Thanks.. I guess what it comes down to is getting
ISeries ADO .NET provider......

Anyone with knowledge on this would be very helpful...

Thanks

gollnick

[jtemple]

Re: ASNA Datagate vs Client Access

If you have an iSeries then you should have an iSeries Access CD that came with the system. You should have gotten this CD whether you ordered Access licenses or not. That CD will have the driver you need.

Also, if you check my web site (link in signature) there are a few examples of how to use the driver as well as links to other sites that have the same.

[littlepd]

Re: ASNA Datagate vs Client Access

If you have an iSeries then you should have an iSeries Access CD that came with the system. You should have gotten this CD whether you ordered Access licenses or not. That CD will have the driver you need.

Also, if you check my web site (link in signature) there are a few examples of how to use the driver as well as links to other sites that have the same.

Jonas,

Is my memory correct here? Even though parts of iSeries Access are chargeable licensed features, I don't think the data providers are. They are free to install and use. Correct?

[jtemple]

Re: ASNA Datagate vs Client Access

Jonas,

Is my memory correct here? Even though parts of iSeries Access are chargeable licensed features, I don't think the data providers are. They are free to install and use. Correct?

You are correct, sir! The only portions of iSeries Access that require a license is terminal/printer emulation.

[littlepd]

Re: ASNA Datagate vs Client Access

That's what I thought.

[pgollnic]

Re: ASNA Datagate vs Client Access

Thanks for all the input guys. I'll tell ya ... DATAGATE fromASNA really is a dream for data access compared to the ado providers. A read is a read and a setll is a setll and everything a coder loves. And no additional work... It's just that there is a per seat concurrancy and this new project would entail many hundreds of ci=oncurrent seats that the cost is prohibitive. Need to look at alternatives to get my data. Research goes on.. Any and all examples are welcome (and needed)

Thanks again

gollnick