firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] Using Firebird embed win32

[Christof <roj...@ya...>]

Hello, I get the same exception when trying to connect to the database. Can
the .Net Data Provider connect to the embedded server?

FirebirdSql.Data.Firebird.FbException: Unable to complete network request to
host "localhost".
 ---> FirebirdSql.Data.INGDS.GDSException: Exception of type
FirebirdSql.Data.INGDS.GDSException was thrown.

I followed the instructions from the readme
  /my_app/app.exe
  /my_app/gds32.dll
  /my_app/firebird.conf
  /my_app/fb/firebird.msg
  /my_app/fb/intl/fbintl.dll
  /my_app/fb/udf/fbudf.dll

  firebird.conf:
  RootDirectory = /my_app/fb

Thanks,
Chris
"Jesus Arevalo" <ja...@er...> wrote in message
news:KME...@er......
> Hi all,
>
> has somebody try to connect to the Firebird embedded version?
>
> I am trying to create a database but what I should use as a dataSource?
> localhost or the name of the dll?
> On the readme file they say that
>
>    "Only true local access is allowed. The embedded server
>     doesn't have any support for remote protocols, so even
>     access via "localhost" won't work."
>
> I was trying something like:
>
> FbConnection.CreateDatabase("gds32.dll", 3050, directory + name, "SYSDBA",
> "masterkey", 3, false, 8192, "NONE");
>
> and I have the dll on the same folder as the application.
>
> But that always generate:
> Exception of type FirebirdSql.Data.INGDS.GDSException was thrown.
>
> Thank you for your help,
>
> jaire
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

[Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[Maarten K. <mk...@xs...>]

Hi,

I have a problem with ExecuteReader. I have the following code:

-------

public override NodeData getNodeData(int id) {
   NodeData data = new NodeData(0);
   FNodeGetNodeDataCommand.Parameters["@ID"].Value = id;
   FNodeGetNodeDataCommand.Transaction = FTransaction;
   try {
    FbDataReader reader =
FNodeGetNodeDataCommand.ExecuteReader(CommandBehavior.SingleRow);
    try {
     if (!reader.Read()) {
      throw new Exception("Node not found (" + id + ")");
     }
     assignNodeData(reader, ref data);
    }
    finally {
     reader.Close();
    }
   } catch {
    // .....
    throw;
   }
   return data;
  }

---------

If I begin a transaction outside this method and then call this method
multiple times without committing the transaction inbetween, the second time
I call this method I get a FbException on the call to ExecuteReader with the
message:

"Dynamic SQL Error SQL Error Code = -502 Attempt to reopen an open cursor".

If I start and commit a transaction for every call I don't get the
exception.

Does anyone see what I am doing wrong here?

Thanks,

Maarten

RE: [Firebird-net-provider] .NET Provider RC2

[Peter W. <Pe...@af...>]

Hi, Carlos -=20

I get the same problem using your code - the call to reader.Read() hangs the
app/never returns in the IDE.  It must be something specific to my computer,
and I will try on another machine.  Thanks for your time spent on this. =20

Regards,
Peter


-----Original Message-----
From: Carlos Guzman Alvarez [mailto:car...@te...]=20
Sent: 30 April 2003 18:41
To: Peter Wood
Cc: 'fir...@li...'
Subject: Re: [Firebird-net-provider] .NET Provider RC2


Hello:

> The users table has data, which is returned running the same query in=20
> isql. The same thing happens if there is no data in the table.  I am=20
> using Firebird 1.5 Beta 4 - is this OK?


I'm testing with this sample, and all goes OK:

FbConnection connection =3D new FbConnection(connectionString);

connection.Open();

FbTransaction transaction =3D connection.BeginTransaction();

string selectText =3D "SELECT * FROM users ";
				=09
FbCommand select =3D new FbCommand(selectText, connection, transaction);
					=09
FbDataReader reader =3D select.ExecuteReader();
								=09
while (reader.Read())
{
	Console.WriteLine("{0} {1} {2}",
	                 reader.GetValue(0),
	                 reader.GetValue(1),
	                 reader.GetValue(2));
}
		=09
reader.Close();
transaction.Commit();
connection.Close();


--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

"No tengo dones especiales.S=F3lo soy apasionadamente curioso" Albert
Einstein, cient=EDfico.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

[Firebird-net-provider] Threading

[Bob l. <bo...@sh...>]

Carlos:

I would like to use your .Net components in threads.  Are there any pitfalls
you are aware of.  I have been using delphi for a long time and have had
troubles with the ibexpress components in threads.  Any suggestions would be
greatly appreciated.

Thanks you've really done a good job.

Bob

[Firebird-net-provider] Using Firebird embed win32

[Jesus A. <ja...@er...>]

Hi all,

has somebody try to connect to the Firebird embedded version?

I am trying to create a database but what I should use as a dataSource?
localhost or the name of the dll?
On the readme file they say that

   "Only true local access is allowed. The embedded server
    doesn't have any support for remote protocols, so even
    access via "localhost" won't work."

I was trying something like:

FbConnection.CreateDatabase("gds32.dll", 3050, directory + name, "SYSDBA",
"masterkey", 3, false, 8192, "NONE");

and I have the dll on the same folder as the application.

But that always generate:
Exception of type FirebirdSql.Data.INGDS.GDSException was thrown.

Thank you for your help,

jaire

Re: AW: [Firebird-net-provider] 'System.TypeLoadException' with RC2

[Carlos G. A. <car...@te...>]

Hello:

> I have to correct me: I have the .Net Framework 1.1 installed, but
> Visual Studio still uses Version 1.0! How can I change this? 
> 
> The TypeLoadException is only thrown by the provider RC2 not by RC1. Do
> I have to use .Net 1.1 for the Provider RC2?

As I know VS 2002 only works with .NET Framework 1.0.

You can build .NET Provider sources using NAnt ( 
http://sourceforge.net/projects/nant ), by default nant uses .NET 
Framework 1.0.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

AW: [Firebird-net-provider] 'System.TypeLoadException' with RC2

[Wotan v. K. <von...@we...>]

Hello,
I have to correct me: I have the .Net Framework 1.1 installed, but
Visual Studio still uses Version 1.0! How can I change this?=20

The TypeLoadException is only thrown by the provider RC2 not by RC1. Do
I have to use .Net 1.1 for the Provider RC2?

Thanks,
Wotan von Klass




-----Urspr=FCngliche Nachricht-----
Von: fir...@li...
[mailto:fir...@li...] Im Auftrag
von Carlos Guzman Alvarez
Gesendet: Mittwoch, 30. April 2003 18:31
An: Wotan von Klass
Cc: 'Firebird-Net-Provider@Lists. Sourceforge. Net'
Betreff: Re: [Firebird-net-provider] 'System.TypeLoadException' with RC2

Hello:

> Since I have installed .Net Framework 1.1 and .net Firebird Provider
RC2=20
> I always get a System.TypeLoadException when I try to open a
connection.

Do yopu have unistalled previous versions of the NET Provider ?? ( if=20
you have them )




--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

"No tengo dones especiales.S=F3lo soy apasionadamente curioso"
Albert Einstein, cient=EDfico.



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] .NET Provider RC2

[Carlos G. A. <car...@te...>]

Hello:

> The users table has data, which is returned running the same query in isql.
> The same thing happens if there is no data in the table.  I am using
> Firebird 1.5 Beta 4 - is this OK?


I'm testing with this sample, and all goes OK:

FbConnection connection = new FbConnection(connectionString);

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

string selectText = "SELECT * FROM users ";
					
FbCommand select = new FbCommand(selectText, connection, transaction);
						
FbDataReader reader = select.ExecuteReader();
									
while (reader.Read())
{
	Console.WriteLine("{0} {1} {2}",
	                 reader.GetValue(0),
	                 reader.GetValue(1),
	                 reader.GetValue(2));
}
			
reader.Close();
transaction.Commit();
connection.Close();


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] 'System.TypeLoadException' with RC2

[Carlos G. A. <car...@te...>]

Hello:

> Since I have installed .Net Framework 1.1 and .net Firebird Provider RC2 
> I always get a System.TypeLoadException when I try to open a connection.

Do yopu have unistalled previous versions of the NET Provider ?? ( if 
you have them )




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] 'System.TypeLoadException' with RC2

[Wotan v. K. <von...@we...>]

=20
Hello,
Since I have installed .Net Framework 1.1 and .net Firebird Provider RC2
I always get a System.TypeLoadException when I try to open a connection.
=20
Code:
=20
FbConnection myConn =3D new
FbConnection("Database=3DC:\\EMPLOYEE.GDB;User=3DSYSDBA;Password=3Dmaster=
key")
;
myConn.Open();
=20
Output in German:
=20
=84Eine nicht behandelte Ausnahme des Typs 'System.TypeLoadException' =
ist
in firebirdsql.data.firebird.dll aufgetreten.
=20
Zus=E4tzliche Informationen: Ung=FCltiges PInvoke-Metadatenformat(=3D =
invalid
PInvoke-Metadata format)
=20
=20
Unbehandelte Ausnahme: System.TypeLoadException: Ung=FCltiges
PInvoke-Metadatenformat.
   at FirebirdSql.Data.Firebird.ConnectionPool.Create(String
connectionString)
   at FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(String
connectionString)
   at FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(String
connectionString)
   at FirebirdSql.Data.Firebird.FbConnection.Open()
. . .
. . .
=20
=93
=20
Thanks,
Wotan von Klass

RE: [Firebird-net-provider] .NET Provider RC2

[Peter W. <Pe...@af...>]

The users table has data, which is returned running the same query in isql.
The same thing happens if there is no data in the table.  I am using
Firebird 1.5 Beta 4 - is this OK?

-----Original Message-----
From: Carlos Guzman Alvarez [mailto:car...@te...]=20
Sent: 30 April 2003 13:31
To: Peter Wood
Cc: 'fir...@li...'
Subject: Re: [Firebird-net-provider] .NET Provider RC2


Hello:


> The problem is clearly so basic that I must be doing something wrong,=20
> but identical code works with other data providers.  I have the same=20
> problem with RC1 and RC2.

I'm making test without problem, are you sure that USERS table have data ??


 >Question - It appears (from error messages if I don't) that a=20
 >transaction must be started and commited even for a simple query like=20
 >this - is this correct?

Yes.





--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

"No tengo dones especiales.S=F3lo soy apasionadamente curioso" Albert
Einstein, cient=EDfico.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Re: [Firebird-net-provider] .NET Provider RC2

[Carlos G. A. <car...@te...>]

Hello:


> The problem is clearly so basic that I must be doing something wrong, but
> identical code works with other data providers.  I have the same problem
> with RC1 and RC2.

I'm making test without problem, are you sure that USERS table have data ??


 >Question - It appears (from error messages if I don't) that a 
 >transaction must be started and commited even for a simple query like 
 >this - is this correct?

Yes.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] .NET Provider RC2

[Peter W. <Pe...@af...>]

Hi, All -

I have a problem and a question I'd appreciate help with...

Problem - I can successfully connect to my database but cannot retrieve
data.  Calls to IDataReader.Read() and DataAdapter.Fill(DataSet) never
return in the IDE/hang a compiled application.  Code snippets follow, so you
can see how the objects are created.  

FbConnection conn = new FbConnection();
conn.ConnectionString = "Database=C:\\PROGRAM
FILES\\FIREBIRD\\PETETEST.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Serve
r=localhost";
conn.Open();	// successful
FbTransaction trans = conn.BeginTransaction();

_selectCommand = "select * from users";

// DataReader
FbCommand comm = new FbCommand(_selectCommand,conn,trans);
IDataReader reader = comm.ExecuteReader();
while(reader.Read()){		// never returns
}

// DataAdapter
FbDataAdapter da = new FbDataAdapter();
DataSet dset = new DataSet("dset");
da.SelectCommand = new FbCommand(_selectCommand,conn,trans);
da.Fill(dset);		// never returns

The problem is clearly so basic that I must be doing something wrong, but
identical code works with other data providers.  I have the same problem
with RC1 and RC2.
	

Question - It appears (from error messages if I don't) that a transaction
must be started and commited even for a simple query like this - is this
correct?  It seems like a huge and unnecessary overhead.


Thanks,
Peter Wood


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

[Firebird-net-provider] Updated Plan for 1.1 release.

[Carlos G. A. <car...@te...>]

Hello:

New in .net framework v1.1:

* FbDataReader class.

     - Add HasRows property.

* FbConnection class.

     - Add EnlistDistributedTransaction. ( I'm not sure about add 
this, i need to see what i need to do )


New features:

* FbCommand class:

     - Add ExecuteScript method. For execution of ISQL scripts.

     - Add CommandPlan property. For return the plan used for the 
Firebird Server.

* Array datatype support.

* FbConnection/FbDatabaseInfo classes.

     - Add DbInfo or DatabaseInfo property to FbConnection class as an 
instance of a reworked implementation of actual FbDatabaseInfo class or 
we can make FbDatabaseInfo to be public class with the need to pass to 
it a FbConnection object instance, any thoughts??.




Suggestions are welcome.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] missing msvcr70.dll

[news.atkin.com <dom...@ho...>]

I realized it is looking for the 1.0 .NET SDK, which contains the
msvcr70.dll.

I may need to build it from source and install it that way instead.

""Dominic Da Silva"" <dom...@si...> wrote in message
news:b7p9cv$35r$1...@ne......
> Well I installed both .NET 1.1 SDK and .NET SDK Redistributable.
> I do not have this problem on my home machine which is running .NET Server
> 2003 RC2.
> The machine I am having problem with is running Win2k SP3.
> Only other .NET software on there is SharpDevelop.
>
> ""Mark E. Scott Jr."" <ms...@sc...> wrote in message
> news:D26...@ro......
> > It sounds as if maybe the provider is looking for the C++ runtime DLL
> > and maybe you only installed C# or something?
> >
> > Mark E. Scott Jr.
> > ms...@sc...
> >
> >
> > -----Original Message-----
> > From: Dominic Da Silva [mailto:dom...@si...]=20
> > Sent: Friday, April 18, 2003 10:46 AM
> > To: fir...@li...
> > Subject: [Firebird-net-provider] missing msvcr70.dll
> >
> > I am trying to install the .NET provider RC2 and it complains I do not
> > have
> > msvcr70.dll installed.
> > I do have .NET SDK 1.1 and .NET Runtime 1.1.
> > Where can I get the DLL?
> >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] disposing the command

[Carlos G.A. <car...@te...>]

HEllo:

> I am using FbNetProvider RC2 in the following piece of code:
> 
> 	private void button2_Click(object sender, System.EventArgs e)
> 	{
> 		this.fbConnection1.Open();
> 		this.fbSelect.Transaction = this.fbConnection1.BeginTransaction();
> 		this.fbDataAdapter1.Fill(this.documentsDataset1, "documents");
> 		this.fbSelect.Transaction.Commit();
> 		this.fbConnection1.Close(); // (x)
> 	}
> 
> After closing the connection at (x), it destroys my fbSelect command (when
> disposing it) and I am not able to use it next time (i.e. it clears the
> CommandText etc.).
> 
> Am I doing something wrong?


No your code is right, the FbConnection.Close method will close always 
all opened commands.





Best regards
Carlos Guzman Alvarez
Vigo-Spain

Re: [Firebird-net-provider] disposing the command

[Carlos G.A. <car...@te...>]

HEllo:

> I am using FbNetProvider RC2 in the following piece of code:
> 
> 	private void button2_Click(object sender, System.EventArgs e)
> 	{
> 		this.fbConnection1.Open();
> 		this.fbSelect.Transaction = this.fbConnection1.BeginTransaction();
> 		this.fbDataAdapter1.Fill(this.documentsDataset1, "documents");
> 		this.fbSelect.Transaction.Commit();
> 		this.fbConnection1.Close(); // (x)
> 	}
> 
> After closing the connection at (x), it destroys my fbSelect command (when
> disposing it) and I am not able to use it next time (i.e. it clears the
> CommandText etc.).
> 
> Am I doing something wrong?


No the FbConnection.Close method will close all opened commands.





Best regards
Carlos Guzman Alvarez
Vigo-Spain

[Firebird-net-provider] disposing the command

[rossi <tes...@at...>]

Hi,

I am using FbNetProvider RC2 in the following piece of code:

	private void button2_Click(object sender, System.EventArgs e)
	{
		this.fbConnection1.Open();
		this.fbSelect.Transaction = this.fbConnection1.BeginTransaction();
		this.fbDataAdapter1.Fill(this.documentsDataset1, "documents");
		this.fbSelect.Transaction.Commit();
		this.fbConnection1.Close(); // (x)
	}

After closing the connection at (x), it destroys my fbSelect command (when
disposing it) and I am not able to use it next time (i.e. it clears the
CommandText etc.).

Am I doing something wrong?

[Firebird-net-provider] rE: missing msvcr70.dll

[Andrew G. <ag...@jc...>]

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

Re: [Firebird-net-provider] missing msvcr70.dll

[Dominic Da S. <dom...@si...>]

Well I installed both .NET 1.1 SDK and .NET SDK Redistributable.
I do not have this problem on my home machine which is running .NET Server
2003 RC2.
The machine I am having problem with is running Win2k SP3.
Only other .NET software on there is SharpDevelop.

""Mark E. Scott Jr."" <ms...@sc...> wrote in message
news:D26...@ro......
> It sounds as if maybe the provider is looking for the C++ runtime DLL
> and maybe you only installed C# or something?
>
> Mark E. Scott Jr.
> ms...@sc...
>
>
> -----Original Message-----
> From: Dominic Da Silva [mailto:dom...@si...]=20
> Sent: Friday, April 18, 2003 10:46 AM
> To: fir...@li...
> Subject: [Firebird-net-provider] missing msvcr70.dll
>
> I am trying to install the .NET provider RC2 and it complains I do not
> have
> msvcr70.dll installed.
> I do have .NET SDK 1.1 and .NET Runtime 1.1.
> Where can I get the DLL?
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] uppercase names for tables?

[Carlos G. A. <car...@te...>]

Hello:


> custDA.SelectCommand = new FbCommand("SELECT * FROM Persons", conn, txn);
> The Name of the Table is “Persons”.

How you have created the table??, If you have created the table using

CREATE TABLE "Persons" (
	....
);

Yo need to use:

custDA.SelectCommand = new FbCommand("SELECT * FROM \"Persons\"", conn, 
txn);



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Only the first record filled in a dataset.

[Carlos G. A. <car...@te...>]

Hello:

>                    custDA.SelectCommand = new FbCommand("EXECUTE 
> PROCEDURE PERSONS_S", conn, txn);

Try using :

	custDA.SelectCommand = new FbCommand("SELECT * FROM PERSONS_S", conn, txn);




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] missing msvcr70.dll

[Mark E. S. Jr. <ms...@sc...>]

It sounds as if maybe the provider is looking for the C++ runtime DLL
and maybe you only installed C# or something?

Mark E. Scott Jr.
ms...@sc...


-----Original Message-----
From: Dominic Da Silva [mailto:dom...@si...]=20
Sent: Friday, April 18, 2003 10:46 AM
To: fir...@li...
Subject: [Firebird-net-provider] missing msvcr70.dll

I am trying to install the .NET provider RC2 and it complains I do not
have
msvcr70.dll installed.
I do have .NET SDK 1.1 and .NET Runtime 1.1.
Where can I get the DLL?




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] missing msvcr70.dll

[Dominic Da S. <dom...@si...>]

I am trying to install the .NET provider RC2 and it complains I do not have
msvcr70.dll installed.
I do have .NET SDK 1.1 and .NET Runtime 1.1.
Where can I get the DLL?

[Firebird-net-provider] Only the first record filled in a dataset.

[Wotan v. K. <von...@we...>]

Hallo,
 
I tried to fill a dataset with a dataadapter. The selectCommand of the
dataadapter calls a stored procedure that returns many records. But only
the first record is filled in the dataset.
 
..
 
                   FbConnection     conn  = new
FbConnection(Common.Configuration.ConnectionString);
                   conn.Open();
                   FbDataAdapter    custDA      = new FbDataAdapter();
 
custDA.TableMappings.Add("Table",PersonData.PERSONEN_TABLE);
                   FbTransaction    txn         =
conn.BeginTransaction();
                   custDA.MissingSchemaAction =
MissingSchemaAction.AddWithKey;
                   custDA.SelectCommand = new FbCommand("EXECUTE
PROCEDURE PERSONS_S", conn, txn);
                   custDA.SelectCommand.CommandType =
CommandType.StoredProcedure;
                   PersonData personDS = new PersonData();
                   custDA.Fill(personDS);
                   txn.Commit();
                   personDS.AcceptChanges();
...
 
 
 
Wotan von Klass
Germany