Problem with database usage....

[Jay King]

Ok I'm very new to the whole database thing, my problem is I'd like to
use firebirds embeded database engine so I can just send it as some
stand alone dlls to my user with my main program. I have two
problems:

1. I have no idea how to create database tables for the initial
database nor how to make the initial database (does this make sence).
2. What tools do I need to have to achieve the above, and where can I
get them.
If you think im missing something I probably am, this database is only
being used for simple storage and retrieval of data, albiet lots of
data, it will not need to be access by outside machines, just the
program on the clients computer.

[One Handed Man \( OHM - Terry Burns \)]

> Ok I'm very new to the whole database thing, my problem is I'd like to

use firebirds embeded database engine so I can just send it as some
stand alone dlls to my user with my main program. I have two
problems: Is Firebirds what used to be Borlands Database Engine ?, If so
Im not sure if there is a provider for this, I assume there is one
from the publishers. If there is . . .


1. I have no idea how to create database tables for the initial
database nor how to make the initial database (does this make sence). You need to add the provider for your database type and add the database to
the list of databases on the server explorer. This way you can drag the
tables to
the form.

2. What tools do I need to have to achieve the above, and where can I
get them.
If you think im missing something I probably am, this database is only
being used for simple storage and retrieval of data, albiet lots of
data, it will not need to be access by outside machines, just the
program on the clients computer.

[Jay King]

[>You need to add the provider for your database type and add the
database to the list of databases on the server explorer.]

Hmm let's think about this here, how in the world am I suppose to ADD
A DATABASE to a list, if I havnt made one yet? What am I missing
here. Remember I don't know what am doing. So How do i make the
initial database (pretent I'm mind numblingly dumb), and databse type,
oh god more confusion.

Is there a databasses for dumbies somewhere, I think I need it. Iv'e
been programming since I was 12, I'm 21 now, so I'll catch on quick,
but I think I'm missing the keystone to understanding the terminology
here.
On Wed, 14 Jul 2004 16:13:53 +0100, "One Handed Man \( OHM - Terry
Burns \)" <news.microsoft.com> wrote:

Ok I'm very new to the whole database thing, my problem is I'd like to
use firebirds embeded database engine so I can just send it as some
stand alone dlls to my user with my main program. I have two
problems:

Is Firebirds what used to be Borlands Database Engine ?, If so
Im not sure if there is a provider for this, I assume there is one
from the publishers. If there is . . .

1. I have no idea how to create database tables for the initial
database nor how to make the initial database (does this make sence).

You need to add the provider for your database type and add the database to
the list of databases on the server explorer. This way you can drag the
tables to
the form.

2. What tools do I need to have to achieve the above, and where can I
get them.
If you think im missing something I probably am, this database is only
being used for simple storage and retrieval of data, albiet lots of
data, it will not need to be access by outside machines, just the
program on the clients computer.

[One Handed Man \( OHM - Terry Burns \)]

OK, with .NET, you use something called ADO.NET ( part of the .NET
framework ) to connect to and access databases. You are referring to a third
party DataBase called FireBird embedded database engine right ?

Firstly, I think this is a derivitive of something formerly made by Borland,
but im not sure. Anyway, in other to connect to this database, you need
three things essentially.

Connection object / DataAdapter and a Dataset to store the retreived data.
There are three types of Database connections you can make.

SQL Connection
OLEDB Connection
ODBC Connection

You need first to find out from your embedded database publisher what
support they have for .NET
The fact that you mention that this is embedded sends alarm bells ringing
straight away, embedded in what ?

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Jay King" <mr********@cinci.rr.com> wrote in message
news:0e********************************@4ax.com...

[>You need to add the provider for your database type and add the
database to the list of databases on the server explorer.]

Hmm let's think about this here, how in the world am I suppose to ADD
A DATABASE to a list, if I havnt made one yet? What am I missing
here. Remember I don't know what am doing. So How do i make the
initial database (pretent I'm mind numblingly dumb), and databse type,
oh god more confusion.

Is there a databasses for dumbies somewhere, I think I need it. Iv'e
been programming since I was 12, I'm 21 now, so I'll catch on quick,
but I think I'm missing the keystone to understanding the terminology
here.
On Wed, 14 Jul 2004 16:13:53 +0100, "One Handed Man \( OHM - Terry
Burns \)" <news.microsoft.com> wrote:

Ok I'm very new to the whole database thing, my problem is I'd like to
use firebirds embeded database engine so I can just send it as some
stand alone dlls to my user with my main program. I have two
problems:

Is Firebirds what used to be Borlands Database Engine ?, If so
Im not sure if there is a provider for this, I assume there is one
from the publishers. If there is . . .

1. I have no idea how to create database tables for the initial
database nor how to make the initial database (does this make sence).

You need to add the provider for your database type and add the database tothe list of databases on the server explorer. This way you can drag the
tables to
the form.

2. What tools do I need to have to achieve the above, and where can I
get them.
If you think im missing something I probably am, this database is only
being used for simple storage and retrieval of data, albiet lots of
data, it will not need to be access by outside machines, just the
program on the clients computer.

[One Handed Man \( OHM - Terry Burns \)]

http://www.codeguru.com/Cpp/data/mfc...cle.php/c4309/

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Jay King" <mr********@cinci.rr.com> wrote in message
news:0e********************************@4ax.com...

[>You need to add the provider for your database type and add the
database to the list of databases on the server explorer.]

Hmm let's think about this here, how in the world am I suppose to ADD
A DATABASE to a list, if I havnt made one yet? What am I missing
here. Remember I don't know what am doing. So How do i make the
initial database (pretent I'm mind numblingly dumb), and databse type,
oh god more confusion.

Is there a databasses for dumbies somewhere, I think I need it. Iv'e
been programming since I was 12, I'm 21 now, so I'll catch on quick,
but I think I'm missing the keystone to understanding the terminology
here.
On Wed, 14 Jul 2004 16:13:53 +0100, "One Handed Man \( OHM - Terry
Burns \)" <news.microsoft.com> wrote:

Ok I'm very new to the whole database thing, my problem is I'd like to
use firebirds embeded database engine so I can just send it as some
stand alone dlls to my user with my main program. I have two
problems:

Is Firebirds what used to be Borlands Database Engine ?, If so
Im not sure if there is a provider for this, I assume there is one
from the publishers. If there is . . .

1. I have no idea how to create database tables for the initial
database nor how to make the initial database (does this make sence).

You need to add the provider for your database type and add the database tothe list of databases on the server explorer. This way you can drag the
tables to
the form.

2. What tools do I need to have to achieve the above, and where can I
get them.
If you think im missing something I probably am, this database is only
being used for simple storage and retrieval of data, albiet lots of
data, it will not need to be access by outside machines, just the
program on the clients computer.

[Lucas Tam]

Jay King <mr********@cinci.rr.com> wrote in
news:0e********************************@4ax.com:

Hmm let's think about this here, how in the world am I suppose to ADD
A DATABASE to a list, if I havnt made one yet? What am I missing
here. Remember I don't know what am doing. So How do i make the
initial database (pretent I'm mind numblingly dumb), and databse type,
oh god more confusion.

Because you're using the embedded version, there is no GUI to add/remove.

You need to load the full version of Firebird, create the tables using one
of the many free administrator tools, then copy the tables (could of data
files) into your project directory.

BTW, you should read a database modeling book before continuing... because
if you don't design the data model correctly, it can be very hard to fix
later on.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"One Handed Man \( OHM - Terry Burns \)" <news.microsoft.com> wrote in
news:#o**************@TK2MSFTNGP09.phx.gbl:

The fact that you mention that this is embedded sends alarm bells ringing
straight away, embedded in what ?

Firebird has the ability to be embedded into a .NET project - you'll get a
fully functioning SQL database embedded into a project. So you get more
power than Microsoft Access without all the bloat of loading MSDE/MS SQL or
MySQL.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Jay King]

Thank you :-)
On Wed, 14 Jul 2004 17:24:59 GMT, Lucas Tam <RE********@rogers.com>
wrote:

Jay King <mr********@cinci.rr.com> wrote in
news:0e********************************@4ax.com :

Hmm let's think about this here, how in the world am I suppose to ADD
A DATABASE to a list, if I havnt made one yet? What am I missing
here. Remember I don't know what am doing. So How do i make the
initial database (pretent I'm mind numblingly dumb), and databse type,
oh god more confusion.

Because you're using the embedded version, there is no GUI to add/remove.

You need to load the full version of Firebird, create the tables using one
of the many free administrator tools, then copy the tables (could of data
files) into your project directory.

BTW, you should read a database modeling book before continuing... because
if you don't design the data model correctly, it can be very hard to fix
later on.

[One Handed Man \( OHM - Terry Burns \)]

I see, sounds interesting, I'd never heardof Firebird before today.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .

"One Handed Man \( OHM - Terry Burns \)" <news.microsoft.com> wrote in
news:#o**************@TK2MSFTNGP09.phx.gbl:

The fact that you mention that this is embedded sends alarm bells ringing straight away, embedded in what ?
Firebird has the ability to be embedded into a .NET project - you'll get a
fully functioning SQL database embedded into a project. So you get more
power than Microsoft Access without all the bloat of loading MSDE/MS SQL

or MySQL.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[One Handed Man \( OHM - Terry Burns \)]

How does this fit in with ADO.NET ?

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .

"One Handed Man \( OHM - Terry Burns \)" <news.microsoft.com> wrote in
news:#o**************@TK2MSFTNGP09.phx.gbl:

The fact that you mention that this is embedded sends alarm bells ringing straight away, embedded in what ?
Firebird has the ability to be embedded into a .NET project - you'll get a
fully functioning SQL database embedded into a project. So you get more
power than Microsoft Access without all the bloat of loading MSDE/MS SQL

or MySQL.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Lucas Tam]

"One Handed Man \( OHM - Terry Burns \)" <news.microsoft.com> wrote in
news:Oi**************@TK2MSFTNGP09.phx.gbl:

How does this fit in with ADO.NET ?

The Firebird project has an offical ADO.NET driver. The latest beta version
supports the embedded version of Firebird.

http://firebird.sourceforge.net/inde...id=netprovider

It would be interesting to see the database performance between Firebird
and Access.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[One Handed Man \( OHM - Terry Burns \)]

Thanks, I might try this out when I get a minute.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .

"One Handed Man \( OHM - Terry Burns \)" <news.microsoft.com> wrote in
news:Oi**************@TK2MSFTNGP09.phx.gbl:

How does this fit in with ADO.NET ?
The Firebird project has an offical ADO.NET driver. The latest beta

version supports the embedded version of Firebird.

http://firebird.sourceforge.net/inde...id=netprovider

It would be interesting to see the database performance between Firebird
and Access.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/