By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,344 Members | 1,114 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,344 IT Pros & Developers. It's quick & easy.

Problem with database usage....

P: n/a
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.
Nov 20 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
> 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.

Nov 20 '05 #2

P: n/a
[>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.


Nov 20 '05 #3

P: n/a
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.

Nov 20 '05 #4

P: n/a
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.

Nov 20 '05 #5

P: n/a
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/
Nov 20 '05 #6

P: n/a
"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/
Nov 20 '05 #7

P: n/a
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.


Nov 20 '05 #8

P: n/a
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/

Nov 20 '05 #9

P: n/a
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/

Nov 20 '05 #10

P: n/a
"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/
Nov 20 '05 #11

P: n/a
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/

Nov 20 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.