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

[Firebird-net-provider] 'cast is not valid' error - can't insert rows to my FB :-(

[Umberto <um...@kk...>]

Hello,
I have just started with FB-net-provider and VB.NET Standard and there is
problem from the beginning...
I can not insert rows to my table with numerical values. Char typed fields
works OK, but when I use 'insert... values ('abc', 'defgh', 12) I get an
exeption about that last field: 'cast is not valid'.
I was trying use different methods to put the value into table ('abc',
'defgh', '12'), ('abc', 'defgh', cast(12 as decimal(3)), but the result is
always the same.

Please help me, because I will have to look for another DB (I hope it will
be not nessesery).


Best Greetings,
Robert AbramQ
Poland

Re: [Firebird-net-provider] (no subject)

[<car...@te...>]

Hello:

> The program and database are always on the local computer. So when i say
> i have tried it on the same database but on multiple computers I mean I
> have transported the database to a different computer and run the
> program on it from there. The program does not have the option to backup
> from a computer over the network as it performs the backup from the file
> directly. Hope this makes sense.

And the user you are using for login exists in all computers ??
Can you try using always SYSDBA ( if you are not doing it yet :) ) with 
the correct password in each computer ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] (no subject)

[Phillip C. <phi...@ba...>]

Hi

> The connection is being done always against the same server?? The user

> and password is configured in the target server??

The program and database are=A0always on the local computer. So when i =
say
i have tried it on the same database but on multiple computers I mean I
have transported the database to a different computer and run the
program on it from there. The program does not have the option to backup
from a computer over the network as it performs the backup from the file
directly. Hope this makes sense.
=A0
Cheers
Phil

Re: [Firebird-net-provider] Backup and Restore Problem

[<car...@te...>]

Hello:

> The username and password are configurable. Also I used the same
> database on different computers. On some it works on others it fails.

The connection is being done always against the same server ?? The user 
and password is configured in the target server ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Backup and Restore Problem

[Phillip C. <phi...@ba...>]

The username and password are configurable. Also I used the same
database on different computers. On some it works on others it fails.

Phil

-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: 23 March 2004 14:59
To: Phillip Cannon
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] Backup and Restore Problem

Hello:

> Can anyone think of what could be causing this error and why only a
few=20
> people get this problem?

Seems to be a login problem .. huuummm ... are you using always the same

user/password ??





--
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

Re: [Firebird-net-provider] Backup and Restore Problem

[<car...@te...>]

Hello:

> Can anyone think of what could be causing this error and why only a few 
> people get this problem?

Seems to be a login problem .. huuummm ... are you using always the same 
user/password ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Backup and Restore Problem

[Phillip C. <phi...@ba...>]

Hello,
 
I have just completed a program that performs a Backup and Restore on a
Database using the .NET Data Provider. The program worked fine on my own
computer and a few others that I have tested it on but now I am finding
an increasing number of computers where I get the following error when
the program tries to start the backup:
 
No message for code 152 found.
 
FirebirdSql.Data.Firebird
FirebirdSql.Data.Firebird.FbException: No message for code 152 found.
 ---> FirebirdSql.Data.Firebird.Gds.GdsException: Exception of type
FirebirdSql.Data.Firebird.Gds.GdsException was thrown.
   at FirebirdSql.Data.Firebird.Gds.GdsSvcAttachment.Attach()
   at FirebirdSql.Data.Firebird.Services.FbService.Open()
   --- End of inner exception stack trace ---
   at FirebirdSql.Data.Firebird.Services.FbService.Open()
   at FirebirdSql.Data.Firebird.Services.FbService.startTask()
   at FirebirdSql.Data.Firebird.Services.FbBackup.Start()
   at Database_Cleaner.frmCleaner.Backup()
 
I have tried the program on various version of Firebird and made sure
all people are using the most up to date version of the Firebird .NET
Data Provider by distributing this with the program but to no avail.
Still it is 50\50 whether the program is going to work or not. I also
stop and start the service before the program runs to ensure that the
problem is not related to someone else using the database at the time of
performing the backup.
 
Can anyone think of what could be causing this error and why only a few
people get this problem?
 
Thanks in Advance
Phill
 

Re: [Firebird-net-provider] Typed Dataset

[Oleg U. <ol...@ya...>]

Thanks to all! :)

Re: [Firebird-net-provider] insert many rows

[<car...@te...>]

Hello:

> This is part of a routine to store any dataset into the database, so I
> create the SQL for the table as well (although the code is not yet
> complete).
> OK, here it is:

I think it will be working correctly now in 1.6 sources in CVS, it needs 
more testing, but seems to be working for me now.

The changes will be only in 1.6 for now.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Typed Dataset

[mirek <mi...@si...>]

Użytkownik Oleg Ufaev napisał:

>Hi!
>
>Somebody! Please tell me, can i generate typed dataset with firebird .net
>provider or other tool? If yes, where i can find this thing?
>  
>
You can try the following methode:
Create another project.
Create new database connection in server explorer window using ODBC 
Interbase/Firebird driver.
drag&drop connection from server explorer window to your form to create 
connection, mark all tables in server explorer window and drag all to 
form. Use data menu to generate DataSet.
Now you can back to your main project and you can add generated 
Dataset1.xsd to your project, then you can add DataSet from toolbox and 
use Dataset1.Now you will get typed Dateset in your Firebird.Net project.

Mirek

Re: [Firebird-net-provider] Typed Dataset

[<car...@te...>]

Hello:

> Somebody! Please tell me, can i generate typed dataset with firebird .net
> provider or other tool? If yes, where i can find this thing?

Visually no ;) Try using the TypedDataSetGenerator class, review the 
list tere a message arround this issue ( one or two months old, let me 
know if you can't find it )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] insert many rows

[<car...@te...>]

Hello:

Sorry for the delay.

> This results in:
> 
> An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
> occurred in system.data.dll

I got the exception when using the Command Builder with the Data 
Adapter, i have done some little changes in your sample code and now 
runs fine, i have done the test with 1.6 CVS sources and i have done 
changes in the FbCommand.Clone method for a correct implementation.

I will try to review why this fails when using the FbCommandBuilder, 
thanks for the sample code,
very useful :)



The new code:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

string		tableName	= "TEST1";
string		message		= String.Empty;
DataSet		ds			= new DataSet("ds" + tableName);
DataTable	dt			= new DataTable(tableName);
string		sql			= String.Empty;

dt.Columns.Add("TSTAMP"	, typeof(String));
dt.Columns.Add("ID"		, typeof(Int32));
dt.Columns.Add("MSG"	, typeof(String));
ds.Tables.Add(dt);

try
{
	sql = String.Format("drop table {0}", tableName);
	FbCommand dropTable = new FbCommand(sql, connection);
	dropTable.ExecuteNonQuery();
}
catch
{
}

bool	first1	= true;
bool	hasID	= false;
string	cmd		= String.Format("create table {0} (", tableName);

for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
	DataColumn dc = ds.Tables[0].Columns[i];

	if (first1)
	{
		first1 = false;
	}
	else
	{
		cmd += ",";
	}

	StringBuilder fc = new StringBuilder(dc.ColumnName.ToUpper());

	if (fc.Length < 1)
	{
		message = "Kolom zonder naam gevonden";
		return;
	}

	if (!System.Char.IsLetter(fc[0]))
	{
		fc = new StringBuilder("N" + fc) ;
	}

	for (int k = 0; k < fc.Length; k++)
	{
		if (System.Char.IsLetterOrDigit(fc[k]) )
		{
			continue;
		}

		fc[k] = '_';   // maak van de rest een underscore
	}

	if (fc.ToString() == "ID")
	{
		hasID			= true;
		dc.AllowDBNull	= false;
	}

	fc.Append(" ");
	if( dc.DataType == typeof(System.DateTime))
		fc.Append("TIMESTAMP");
	else if( dc.DataType == typeof(System.Int16))
		fc.Append("INTEGER");
	else if( dc.DataType == typeof(System.Int32))
		fc.Append("INTEGER");
	else if( dc.DataType == typeof(System.Double))
		fc.Append("DOUBLE PRECISION");
	else if( dc.DataType == typeof(System.Object))
		fc.Append("BLOB");
	else
	{
		fc.Append("VARCHAR(30)");
	}

	if (!dc.AllowDBNull)
	{
		fc.Append( " not null");
	}
	cmd += fc;
}
if (!hasID)
{
	cmd += ",ID INTEGER NOT NULL";
}
cmd += ");";

FbCommand createTable = new FbCommand(cmd, connection);
createTable.ExecuteNonQuery();

cmd = @"alter table " + tableName + " add constraint PK1 primary key (ID);";

FbCommand alterTable = new FbCommand(cmd, connection);
alterTable.ExecuteNonQuery();

FbTransaction transaction = connection.BeginTransaction();

sql = "SELECT * FROM " + tableName + ";";

FbDataAdapter		mDataAdapter	= new FbDataAdapter(new FbCommand(sql, 
connection, transaction));
FbCommandBuilder	cb				= new FbCommandBuilder(mDataAdapter);  // 
genereer de insert, etc

mDataAdapter.InsertCommand = 
(FbCommand)((ICloneable)cb.GetInsertCommand()).Clone();
mDataAdapter.UpdateCommand = 
(FbCommand)((ICloneable)cb.GetUpdateCommand()).Clone();
mDataAdapter.DeleteCommand = 
(FbCommand)((ICloneable)cb.GetDeleteCommand()).Clone();

cb.Dispose();

DataSet nds = new DataSet("ds" + tableName);
mDataAdapter.Fill(nds, tableName);
nds.Tables[0].TableName = tableName;

int id	= 1;

ds.Tables[0].BeginLoadData();

for (int j=0; j < 50000; j++)
{
	DataRow dr = ds.Tables[0].NewRow();

	dr["ID"]		= id++;
	dr["TSTAMP"]	= System.DateTime.Now.ToShortTimeString();
	dr["MSG"]		= System.DateTime.Now.ToShortDateString();

	ds.Tables[0].Rows.Add(dr);
}

ds.Tables[0].EndLoadData();

mDataAdapter.Update(ds, tableName);  // do it

transaction.Commit();

connection.Close();




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Typed Dataset

[Oleg U. <ol...@ya...>]

Hi!

Somebody! Please tell me, can i generate typed dataset with firebird .net
provider or other tool? If yes, where i can find this thing?

[Firebird-net-provider] [ANN] Firebird ADO.NET Data Provider 1.5.2 released

[<car...@te...>]

Hello:

Firebird ADO.NET Data Provider 1.5.2 available for download.


Changes in this release:

1.5.2 ( 2004-03-21 )
----- - ---- -- -- -

- Bug fixes (Please review the changelog for details) :

	- Fix for the GetBytes and GetChars methods of the FbDataReader class.

	- Commit implicit transactions of active commands when
	closing the connection.

	- Fix for delete stored proc execution using the DataAdapter.

- Varchars are now sent trimmed over the wire.

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


You can read the Changelog at:

https://sourceforge.net/project/shownotes.php?release_id=225295


You can download binarys for .NET 1.0 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.2-NET1.0.exe?download


You can download binarys for .NET 1.1 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.2-NET1.1.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.2-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.2-Doc.zip?download




CVS Tag: NP_1_5_2



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbBatchExecution doesn't assign sqlTransaction to atomicCommand

[Abel E. P. <sa...@sa...>]

Greetings Mike,

Carlos has gently forwarded this message to me.
FbBatchExecution is not complete. I was expecting to have it finished last
week, but the time available made it impossible.
The problem you've experimented exists because the
FbBatchExecution.Execute() is not complete (I think it's the only method
remaining)...
I'll keep yor email and notify you soon as I finnish it. Anyway, I hope to
complete the Isql namespace by next friday to be ready for 1.6 Beta 1
release.

Best regards,

Abel Eduardo Pereira

"Mike Scott" <mik...@ex...> wrote in message
news:405...@ex......
> Hi Carlos
>
> Long time no speak! I've been working on a different project which
> didn't require Firebird, but now we're back looking at Firebird again so
> you'll probably see more messages from me in the future :-)
>
> I don't know if you remember, but I was interested in getting a better
> ISQL script parser. I now see that you've implemented a parser class and
> I've been playing with FbBatchExecution. However, I get exceptions which
> complain that the command has no transaction set. Having looked at the
> code, I can see that you don't assign the sqlTransaction to the
> atomicCommand in the loop in Execute(). So the commands don't have the
> transaction assigned.
>
> Cheers,
>
> Mike Scott.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Firebird BDP driver for C#Builder and

[Abel E. P. <sa...@sa...>]

Greetings Johannes,

Like Carlos has wrote, there are plans for making Firebird available through
BDP; I estimate that there will be something working by the end of this
summer :-|

Regards,

Abel Eduardo Pereira

"Johannes" <n@n.com> wrote in message news:c36ipv$80k$1...@ne......
>
>
> Carlos Guzmán Álvarez wrote:
> > Hello:
> >
> >> I wonder if there exists an Borland BDP driver for Firebird?
> >
> >
> > No yet.
> >
> >> If it doesn't exist then are there any plans for creating one?
> >
> >
> > Yes, there are plans for it.
> >
> >
> Great, thanks.
> Is there also any raw timeframe one could expect a BDP-driver? a half
> year, a year ....
>
> Regards
>
> Johannes
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[<car...@te...>]

Hello:

>    I might found the clue... I think at least I have to do the tablemappings
> between the source table (fbcommand)  and dataset table(dataset) is it?
> But unfortunely I got error :- Object reference not set to an instance of an
> object ... why ?

Do you mean at design time ?? If yes, maybe i'm wrong but seems that 
borland and ms wizards doesn't support "custom" data providers. You can 
do it manually.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[benny <be...@ch...>]

> Don't see why, as i tell in my latest email it's a specific feature of
> the Borland Data Provider, maybe i'm wrong but if you try with SqlClient
> you will be not able to see the data at desing time either.

> How are you assigning the DataSet to the DataGrid ?? and how are you
> doing the Fill of the DataSet ??

> You can review one of the ASP.NET samples (the VB.NET one) in the 1.5
> packages that uses a datagrid for show data.

Hi,

   I might found the clue... I think at least I have to do the tablemappings
between the source table (fbcommand)  and dataset table(dataset) is it?
But unfortunely I got error :- Object reference not set to an instance of an
object ... why ?
As if I cant set references on the Dataset, I would get empty dataset that I
can't use datagrid's datasource to reference on it. By doing so, I can't
even fill the
column in Datagrids according to the Data Fields [that exist after assigning
the non-empty dataset].

TIA

regards,

benny ;)

Re: [Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[<car...@te...>]

Hello:

> but I do be able to load the data during design time using Borland Data
> Provider on datagrid until what I have try so far ...

Don't see why, as i tell in my latest email it's a specific feature of 
the Borland Data Provider, maybe i'm wrong but if you try with SqlClient 
you will be not able to see the data at desing time either.


How are you assigning the DataSet to the DataGrid ?? and how are you 
doing the Fill of the DataSet ??

You can review one of the ASP.NET samples (the VB.NET one) in the 1.5 
packages that uses a datagrid for show data.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Wanted: Firebird-Programmer for Open Source project (app. 6 hours work)

[Philipp S. <no...@12...>]

Hello

I'm developing the .NET Data Access Object, an persistence framework 
that consists of

- a vendor-independent relational data access layer (comparable to JDBC)
- an object-relational mapping unit (container managed persistence)
- a Visual Studio .NET Add-in to map relational data to objects (mapping 
data is stored in XML files, no code generation needed)


To access specific databases, so called Data Access Objects are being 
used which implement a set of template methods of a common abstract base 
class, e.g.


//MySql Data Access Object
public override IDbConnection GetConnection()
{
   return new MySqlConnection();
}



Using the framwork is pretty easy. A container is used through it's 
interface while the container uses a Data Access Object through the 
abstract base class. The container does not now the currently used DBMS 
and your application does not know the container:

//store current instance
IPersistableObjectHandler container = GlobalConfig.Container;
container.CreatePersistable(this);




The process of creating a new DAO is pretty easy, but there are a few 
things to test as the framework supports transactions, output 
parameters, sequences etc.

The whole solution comes along with a very simple sample application 
(PigFarm) that accesses 3 tables on a database (Farm, Pig, Fruit). 
Depending on the used container (there are currently 2 container 
implementations), the database is being accessed via Stored Procedures 
or SQL (stored externally in XML files).

I'm looking for a Firebird programmer who will create and test a new DAO 
for the current Firebird release. Furthermore, the PigFarm database 
should be ported to Firebird including sequences and Stored Procedures. 
To make this a painless job, I can provide you with DDL and the current 
DAO-implementation for Oracle. I guess the whole thing will not take 
more than 6 hours - the DAO itself will be implemented in a few minutes.


You may want to have a look at the project site that also contains the 
contact address:
http://dao.sourceforge.net


The currently available release on SourceForge is 1.3.1 but I will 
provide you with the RC for 1.4 which contains many enhancements 
regarding database compatibility (sequence support, improved mapping 
abilities and ID handling). If you're interested in implementing the 
DAO, please contact me.

Thanks for your support

Philipp

[Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[benny <be...@ch...>]

> But you can't load the data at design time or at runtime ??

 Hi,

    Design time or run time also can't on using
FirebirdNETProvider1.5.1-NET1.1 on Delphi8 .net..
Anyway I could set reference on DataSet to FbDataAdapter? as In Borland Data
Provider I could see the tables and the related columns for that table after
doing so...  Or is FirebirdNetProvider do it on other way ? I seem cant
simply load the data on datagrid ..

but I do be able to load the data during design time using Borland Data
Provider on datagrid until what I have try so far ...

TIA

regards,

benny ;)

Re: [Firebird-net-provider] cant load the data on Delphi8 using FbDataAdapter...

[<car...@te...>]

Hello:

>      Anyone who installed the FirebirdNETProvider1.5.1-NET1.1, tried on 
> Delphi8 ASP.Net Web Application? As I used the FbConnection,
> FbCommand, FbDataAdapter and Dataset but I cant load the data on the 
> Datagrid. 

But you can't load the data at design time or at runtime ??

> On the other hand, I can try successful on using the Borland Data 
> Provider: BdpConnection,   BdpDataAdapter, BdpCommand and DataSet.
> Here I discovered the differences FbDataAdapter and 
> BdpDataAdapter properties, where I found BdpDataAdapter have property:- 
> Live Data that consist of Dataset
> that I assigned the DataSet there ... When I use the Datagrid I am able 
> to set DataSet to Datagrid's datasource.

That property is specific of the Borland Data Provider.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Error installing Version 1.6 Alpha 1

[<car...@te...>]

Hello:

> There is an error in the installation of DataProvider  1.6 for .NET 1.1.
> FirebirdSql.Data.Firebird.dll is copied into temp folder and not 
> in program folder.

I know it will be fixed in next alpha, the assembly is installed in the 
GAC in any case if i am not wrong.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] cant load the data on Delphi8 using FbDataAdapter...

[benny <be...@ch...>]

Hi,
 =20
     Anyone who installed the FirebirdNETProvider1.5.1-NET1.1, tried on =
Delphi8 ASP.Net Web Application? As I used the FbConnection,=20
FbCommand, FbDataAdapter and Dataset but I cant load the data on the =
Datagrid.=20
On the other hand, I can try successful on using the Borland Data =
Provider: BdpConnection,   BdpDataAdapter, BdpCommand and DataSet.
Here I discovered the differences FbDataAdapter and BdpDataAdapter =
properties, where I found BdpDataAdapter have property:- Live Data that =
consist of Dataset=20
that I assigned the DataSet there ... When I use the Datagrid I am able =
to set DataSet to Datagrid's datasource.

But for FbDataAdapter I din see the property of Dataset. I failed to =
load the table on the dataset....=20
Anyone try successfully could tell me any mistake I made??


I am currently using Delphi8 professional, Firebird1.5 and =
FirebirdNETProvider1.5.1-NET1.1 [where I only add the =
FirebirdSql.Data.Firebird assembly on Delphi]

TIA=20

regards,

benny ;)

RE: [Firebird-net-provider] Visual Studio.NET and C#.[Scanned]

[Peter M. <P.m...@de...>]

I have been taking the long road to make typed datasets: Create the =
table
within MS SQL (now for free for personal use), drag it into my project =
,
creating the xsd and typed dataset, extract the SQL statements to =
create the
table and feed it into Firebird.
If you have anything working in that area, I'd be interested. I have =
been
writing some code to create SQL from a dataset (which is not a feature =
in
.net to my knowledge), see previous posting.

Peter

-----Oorspronkelijk bericht-----
Van: fir...@li...
[mailto:fir...@li...] Namens =
JS.staff
Verzonden: vrijdag 19 maart 2004 0:38
Aan: fir...@li...
Onderwerp: RE: [Firebird-net-provider] Visual Studio.NET and =
C#.[Scanned]

Hia Austin,
=20
I'm using the provider with VS 2003. You need to install the components =
on
the toolbar, ('Tools' menu, then 'add remove toolbox items', then find =
the
assembly for the .net provider, usually in C:\Program
Files\FirebirdNETProvider1.5
=20
Then select the 'FirebirdSql.Data.Firebird.dll' file. This should make =
the
FbConnection, FbCommand etc components appear in the toolbox.
=20
It works independently of the OLE DB components - nothing to do with =
them.
=20
Oh, another 'gotcha' - you'll need to add the assembly to the =
'References'
section of each project that uses it. Otherwise you get an error when =
you
drop the components onto the form.
=20
If you need help making typed datasets, ive got some code to make it a
little easier - not as slick as the SQL Server tools though.
=20
John

	-----Original Message-----=20
	From: Austin Sauls [mailto:aus...@sp...]=20
	Sent: Thu 18/03/2004 22:29=20
	To: fir...@li...=20
	Cc:=20
	Subject: [Firebird-net-provider] Visual Studio.NET and C#.[Scanned]
=09
=09

	I have created a Firebird database (C:\CMDRPT.FDB).

	When I am in Visual Studio.NET and using C#, I am trying to add a
data form.

	The data form wizard asks me some questions.

	It has a Data Link Properties page.

	The first tab is for Provider and there are only OLE DB providers in
the list.

	Do I have to place the firebird .net data provider into a special
folder, etc.

	Also the second tab on the Data Link Properties page is a connection
test.

	I am using server name of local host and using =
=E2=80=9CC:\CMDRPT.FDB=E2=80=9D as
the database on the server.

	I can not connect to the Firebird DataBase.

	Thanks,

	Austin Sauls

N=18HS^=E9=9A=8AX'u=E0=BE=BC=04=02S=E9=87=BA+l=16.)
=DB=AD=DE=B1	y=16
zThm=E0=B8=A7=02'^=D6=A7t!
:(=E0=A0=B5!=DE=89h'-=E6=AB=9D
+axwZ	=
j[-=CC=ACvh=E1=AE=A7kj=E4=BD=92=1Bmv,vw(=E9=8F=9B=E6=9D=89=E3=BD=96ZrAb=E0=
=A0=AD=06=19'^=E0=A0=AEf)+-=16*=E5=99=89n*=DD=9Di=ED=AE=8Bu=E6=BD=A3=C5=8A=
lq

zm=E0=BE=B6?X=EE=AC=B6(=1E~zw=ED=A9=ADX=0Fb=CA=9D?~*=E2=80=A0n*=DD=9Di=E0=
=AE=8B