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

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

Skip to content

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

DATABASE
Post a reply

    Sponsored Links

    Next

  • 1. DBP - Why does this not work ?
    Hi Guys I am trying to set a local varaible within a DBP then use that variable as a tablename which I then select from. Below is a simplified version of what I am trying to ..... create proc dbp ( in_param char(4) ) as declare yr char(2); tab char(4); param1 char(5); BEGIN tab = 'table_name' ; SELECT stuff INTO :param1 FROM :tab WHERE col = 'something' ; END ; \p\g It doesnt work. I am missing something? All help appreciated Jeff
  • 2. [Info-ingres] How much memory can a server use?
    Hi Everyone, The other day a user ran an unloaddb on a database as part of a normal scripted maintenance task. Sadly the job blew up 3 or so hours later - still trying to complete the unloaddb itself - not the actual data unload. At the start of the process my server was about 160M. The server is a non-shared cache sole server. By the time it blew up, the server had expanded to 908M! The total memory on this host is 1G. The ingres user is unlimited in data size on this host. I also measured the swap area slowly filling up. We have 1G of swap configured - 500M in a swap device and another 500M in a swap file. The swap device went 100% filled and we started using the swapfile at the time the error was generated. The errlog shows an E_SC0107 error expanding virtual size of server and it highlights the (UNIX) data area of the process. Since that event the database has been unloaded successfully several times. Has anyone got any ideas? My understanding is that only the dynamic memory pools may expand - upto a maximum set in the config.dat. But, not surprisingly, none of my dynamic pools have a max of a couple of 100M let alone a Gig. My suspicion lies in the optimizer as this host has been doing some weird things with SIGSEGVs in that area. Martin Bowes

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

Postby Nigel J Kavanagh » Wed, 11 Jul 2007 06:34:32 GMT 

This is a multi-part message in MIME format.



Hello All,

 

I have installed ingres2006-9.1.0-123-com-win-x86-DotNet, with VS 2005.

I can select Ingres in the server explorer, see tables etc, but  I'm unable to see the Ingres .Net data provider as an option when I try to define a shared data source.

 

Is this version of the Ingres .Net data provider capable of this, or is it a configuration option. 

 

Thanks.

 


<HTML dir=ltr><HEAD><TITLE>Re: [Info-Ingres] Use of TZ env variable in presentation of datevalues</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText75998 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Times New Roman" size=3>Hello All,</FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman" size=3>I have installed ingres2006-9.1.0-123-com-win-x86-DotNet, with VS 2005.</FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman" size=3>I can select Ingres in the server explorer, see tables etc, but <SPAN style="mso-spacerun: yes"> </SPAN>I’m unable to see the Ingres .Net data provider as an option when I try to define a shared data source.</FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face="Times New Roman" size=3>Is this version of the Ingres .Net data provider capable of this, or is it a configuration option. </FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt">Thanks.</P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"></FONT><FONT size=2></FONT> </P></DIV></DIV></BODY></HTML>
*****************************************************************************************
To view the terms under which this email is distributed, please go to  http://www.**--****.com/ 
*****************************************************************************************
Top

Similar Threads:

1.[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>

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

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

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

5.Ingres.Net Data Provider, anyone using it? 

Hi,
   Is any one using the Ingres .NET Data Provider in a production 
environment?  I've been doing some testing with it and so far it looks 
great.  I wonder if anyone else has any good or bad experiences?  Is there 
anything I should be wary of?

Thanks,

Steve

6. Calling Ingres Database Procedures through .Net Data Provider

7. Loading a blank Ingres date through .Net Data Provider

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

Post a reply

Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 1 guest

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