[Info-ingres] Visual Studio and Ingres .Net Providers

Programming and Web Development Forums - DATABASE - Issues relating to INGRES products.

Skip to content

[Info-ingres] Visual Studio and Ingres .Net Providers

DATABASE
Post a reply

    Sponsored Links

    Next

  • 1. [Info-Ingres] Ingres 2006 crashed during a CP
    Hi, We upgraded to Ingres 2006 9.1.1 NPTL on Linux Itanium last weekend. All was well for about 3 days then it crashed during a Consistency Point. E_DM9397_CP_INCOMPLETE_ERROR A Buffer Manager protocol error occurred during processing of a Consistency Point. All E_DM9449_DMD_CHECK DMD_CHECK called from file /devsrc/ingres2006r2/b123_2/src/back/dmf/dmp/dm0p.c line 17995. E_DMF024_INCOMPLETE_CP Fatal error: All modified pages could not be flushed out of buffer manager during Consistency Point Does this look familiar to anyone ? Just thought I'd ask here before opening an issue with Ingres support desk. Thanks, Andre
  • 2. Journal size/frequency
    We have a journalled Ingres 2.0 database (we're on extended support) which writes journal files infrequently. Journal block size : 16384 Initial journal size : 4 Target journal size : 32 I've reduced the target journal size to 32 in an attempt to force more frequent writes but nothing is written during the working day. Here's an extract from the end of last week: -rwx------ 1 ingres system 2277888 Sep 25 01:29 j0003260.jnl -rwx------ 1 ingres system 1376768 Sep 25 03:07 j0003261.jnl -rwx------ 1 ingres system 1262080 Sep 25 07:35 j0003262.jnl -rwx------ 1 ingres system 197120 Sep 25 21:43 j0003263.jnl -rwx------ 1 ingres system 2277888 Sep 26 01:26 j0003264.jnl -rwx------ 1 ingres system 1376768 Sep 26 03:06 j0003265.jnl -rwx------ 1 ingres system 4801024 Sep 26 07:35 j0003266.jnl -rwx------ 1 ingres system 1327616 Sep 26 07:35 j0003267.jnl -rwx------ 1 ingres system 410112 Sep 26 21:43 j0003268.jnl The 21:43 relates to the nightly checkpoint, the other night times relate to nightly jobs repopulating tables. The daytime activity appears insufficient to force journal file writes, so I'm worried that a disk crash late in the afternoon would cause us to lose the day's transactions. Can anyone suggest the best course of action? Should I try reducing the journal block size? Alan
  • 3. Community infrastructure planned maintenance
    Hi Everyone, We'll be doing work requiring planned down time on Saturday September 27th. This work will affect the community infrastructure including bugs.ingres.com, code.ingres.com, and inspect.ingres.com. The work is part of efforts to hook the various services to LDAP allowing users to use the same accounts they use for the wiki and forums. The system will be down from 8am Eastern (1pm GMT) until 5pm eastern (10pm GMT). For a real time status, please visit the #ingres IRC channel. We'll reply to this message once the work is complete. Thank you, Andrew
  • 4. verhoeff function for Ingres
    >> What do people think of this?<< Nice work. You can do this in pure SQL via table look-up, but it is awful. I tried it when i wrote THINKING IN SETS. Uggh! >> Do the function names make sense, seem reasonable to use? << Minor nit -- the current convention is "<verb>_<object>" name for code modules, "computer_verhoeff()" or something might be better. >> Also, in passing, I have heard that there is more than one verhoeff 'style' out there, and that they return different numbers. But I can't find a reference to these on wikipedia. Does anyone have any idea about the truth of this multiple style stuff? << I would guess "false" because you would need a group that had <= 10 elements to map to the digits and I think D-5 is the only one in that range with the right properties. However, if the number of elements is increased, I don't know.

[Info-ingres] Visual Studio and Ingres .Net Providers

Postby Nigel Kavanagh » Thu, 01 Dec 2005 19:18:27 GMT

his is a multi-part message in MIME format.


All,



I've added in the Ingres dot net providers as supplied in Ingres R3. We can
write code to connect to an Ingres database fine. But within Visual Studio
you can create data connections via wizards, it has a list of MS and Oracle
databases and others. Selecting others gives me a list of other .net
framework providers but not Ingres, even though all the dll's including VS
designer dll from CA are referenced in the project. What do we need to do to
enable the use of Ingres .Net providers via the toolbox/wizards?.





Regards

Nigel.

-------------------

Nigel J Kavanagh, Corporate Systems, Academic Services, Venn Building,
University of Hull, Cottingham Road, Hull.

HU6 7RX, England

Tel: 01482 466864, Fax: 01482 465930

XXXX@XXXXX.COM

Corporate Systems Support: XXXX@XXXXX.COM




<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>All,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I’ve added in the Ingres dot net providers as supplied in Ingres
R3. We can write code to connect to an Ingres database fine. But within Visual Studio
you can create data connections via wizards, it has a list of MS and Oracle databases
and others. Selecting others gives me a lis
Top

Re: [Info-ingres] Visual Studio and Ingres .Net Providers

Postby thoda04 » Fri, 02 Dec 2005 02:55:01 GMT 

Hi Nigel,

The Ingres r3 .NET Data Provider installation procedure usually installs the 
Ingres connection, data adapter, and command components into the toolbox. 
Dragging and dropping these components onto a design surface like a winform 
launches the Ingres wizards.  If the installation process did not install 
these components into the VS toolbox for some reason, there is a manual 
procedure documented in the Ingres r3 Connectivity Guide, Chapter 12, near 
page 12-45 to include them into the VS toolbox.

The Ingres .NET Data Provider is integrated with the VS toolbox, properties, 
and solution windows, but not yet the Server Explorer.  The Server Explorer 
was a closed interface in VS 2003.  It may be more open in VS 2005.  It's 
something I'm looking at.

Hope this helps,
Dave
Top

Similar Threads:

1..NET provider to MS Visual Studio 2005 

Hi

Has any one got the IBM Informix 2.90 .NET Provider to work with MS Visual
Studio 2005?
Are trying to connect to and IDS 10.00.FC4 and 8.50.FC2/8.51.FC1 thru a
Integration Services Package
but I only get the possibility to make a OLEDB connection, which fails with
an sql error when used.


Regards

Bjarne Wilken Jensen
DatabaseAdm. - IT-produktion.
Alm. Brand Forsikring A/S
Midtermolen 7
DK-2100  Kenhavn ?
Tlf: +45 3547 7771 Mobil. +45 4019 7771
E-Mail:  XXXX@XXXXX.COM

2.SDK 3.00 .net provider and MS visual studio 

Database is Informix Online 9.40 on a Sun Solaris machine, connecting from a 
windows XP client machine with SDK 3.00.TC3 installed (.net provider).

Using visual studio 2008; can successfully connect to the database and 
populate a dataset, but cannot flush changes in the dataset back to the 
base. On the IfxDataAdaptorBankTrans.Update method I am getting the error 
'Unknown SQL Type - 0'. Has anyone seen this before with the Informix .net 
provider? I can update the row fine in dbaccess/winsql.

We are in the process of moving from VB6 to VS2008 so there may well be 
errors in my VB code... I had to adapt it from C# examples found on IBMs 
website.

The .net provider requires a stored procedure to be run on the server before 
the .net provider can be used - this has been done.

Thanks in advance...



Table Schema:



DBSCHEMA Schema Utility       INFORMIX-SQL Version 9.40.UC3
Copyright (C) Informix Software, Inc., 1984-1997
{ TABLE bank_trans_net row size = 83 number of columns = 9 index size
              = 50 }
create table bank_trans_net
  (
    ser serial not null ,
    source char(20) not null ,
    client_no integer not null ,
    trans_code char(2) not null ,
    trans_date date not null ,
    descr char(30),
    trans_val money(12,2) not null ,
    uname char(8) not null ,
    updated date not null ,

    check (ser > 0 ),

    check (client_no > 0 )
  );

create index ix_bt1n on bank_trans_net (client_no)
    using btree ;
create unique index ix_bt5n on bank_trans_net
    (ser) using btree ;
create index ix_bt6n on bank_trans_net (source)
    using btree ;
create index ix_bt7n on bank_trans_net (trans_code)
    using btree ;
alter table bank_trans_net add constraint primary
    key (ser)  ;


VB code follows:


Option Strict On
Imports System.Data
Imports IBM.Data.Informix

Public Class MainForm

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As 
System.EventArgs) Handles Button1.Click
        Dim ifxConn As New IBM.Data.Informix.IfxConnection


        Try
            ifxConn.ConnectionString="database=xxxxxx;server=xxxxxxx;host=10.10.10.10;uid=userid;pwd=password;protocol=onsoctcp;service=2769;"

            ifxConn.Open()

            Dim IfxDataAdaptorBankTrans As New 
IBM.Data.Informix.IfxDataAdapter
            Dim CmdUpdateBankTrans As New IBM.Data.Informix.IfxCommand
            Dim CmdSelectBankTrans As New IBM.Data.Informix.IfxCommand


            CmdSelectBankTrans.CommandText = "select ser, source, client_no, 
trans_code, trans_date, " & _
                            " descr, trans_val, uname, updated from 
bank_trans_net where client_no = 1755"
            IfxDataAdaptorBankTrans.SelectCommand = CmdSelectBankTrans
            IfxDataAdaptorBankTrans.SelectCommand.Connection = ifxConn

            Dim ifxCBuild As New IfxCommandBuilder(IfxDataAdaptorBankTrans)
            IfxDataAdaptorBankTrans.UpdateCommand = 
ifxCBuild.GetUpdateCommand
            IfxDataAdaptorBankTrans.UpdateCommand.Connection = ifxConn

            Dim BankdataSet As New DataSet
            IfxDataAdaptorBankTrans.Fill(BankdataSet, "bank_trans_net")
            BankdataSet.Tables.Item(0).TableName = "bank_trans_net"

            Dim _Row As DataRow

            For Each _Row In BankdataSet.Tables.Item("bank_trans_net").Rows
                If CType(_Row("ser"), Integer) = 2443150 Then
                    ClientNumber.Text = _Row("descr").ToString
                    _Row("descr") = "Changed"

                    ClientNumber.Text = _Row("descr").ToString
                End If
            Next


            For Each _Row In BankdataSet.Tables.Item("bank_trans_net").Rows
                ListBox1.Items.Add(_Row("descr"))
            Next

            Dim newDataSet As DataSet
            newDataSet = BankdataSet.GetChanges()

            IfxDataAdaptorBankTrans.Update(newDataSet, "bank_trans_net")
            BankdataSet.Tables("bank_trans_net").AcceptChanges()


        Catch ex As Exception
            MsgBox("Error " & ex.Message)

        End Try
    End Sub
End Class

3.[Info-ingres] Ingres Datasources in Visual Studio

4.[Info-ingres] Calling Ingres Database Procedures through .Net Data Provider 

This is a multi-part message in MIME format.

Ingres r3 supports row-producing procedures.  The Ingres .NET Data
Provider reads the result set produced by that procedure just as any
result set produced by a query.

 

If the procedure is something like this:

 

drop procedure rowproc \p\g

 

create procedure rowproc

   result row(char(32)) as

declare tabname char(32);

begin

   for select table_name into :tabname from iitables

   do

      return row(:tabname);

   endfor;

end;

\p\g

 

The .NET application would execute the procedure and read the result set
like this:

 

            IDataReader reader = null;

      cmd = new IngresCommand(

            "rowproc", conn, txn); //"{ call rowproc}", conn, txn);

      cmd.CommandType = CommandType.StoredProcedure;

      reader = cmd.ExecuteReader();

 

      Console.Write("ColumnName='" + reader.GetName(0) + "'");

      Console.WriteLine();

 

      while (reader.Read())

      {

            Console.Write(reader.GetString(0) + "\t");

      }

      Console.WriteLine();

      reader.Close();

 

Hope this helps,

Dave


<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:#606420;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink="#606420">

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Ingres r3 supports row-producing procedures.  The
Ingres .NET Data Provider reads the result set produced by that procedure just
as any result set produced by a query.</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>If the procedure is something like this:</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>drop procedure rowproc \p\g</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>create procedure rowproc</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   result row(char(32)) as</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>declare tabname char(32);</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>begin</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   for select table_name
into :tabname from iitables</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   do</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>     
return row(:tabname);</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   endfor;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>end;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>\p\g</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The .NET application would execute the procedure and read the
result set like this:</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>           
</span></font><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>IDataReader reader = null;</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      cmd
= <font color=blue><span style='color:blue'>new</span></font> IngresCommand(</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>            "rowproc",
conn, txn); <font color=green><span style='color:green'>//"{ call
rowproc}", conn, txn);</span></font></span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      cmd.CommandType
= CommandType.StoredProcedure;</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      reader
= cmd.ExecuteReader();</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      Console.Write("ColumnName='"
+ reader.GetName(0) + "'");</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      Console.WriteLine();</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      <font
color=blue><span style='color:blue'>while</span></font> (reader.Read())</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      {</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>            Console.Write(reader.GetString(0)
+ "\t");</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      }</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      Console.WriteLine();</span></font></p>

<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>      reader.Close();</span></font></p>

<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hope this helps,</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Dave</span></font></p>

</div>

</body>

</html>

5.[Info-Ingres] Ingres .Net data provider and VS 2005 Data Sources

6. [Info-Ingres] Ingres .NET data provider

7. [Info-ingres] Ingres Stored Procedure Visual Basic .net

8. [Info-Ingres] .NET Data Provider with Ingres 2.6

Post a reply

Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 52 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group