Problem with database usage....

  • Thread starter Thread starter Jay King
  • Start date Start date
J

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.
 
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:
Click to expand...
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).
Click to expand...
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.
 
[>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.
 
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 said:
[>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.


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


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.
Click to expand...
Click to expand...
 
http://www.codeguru.com/Cpp/data/mfc_database/adonet/article.php/c4309/

--

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

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

Jay King said:
[>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.


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


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.
Click to expand...
Click to expand...
 
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.
Click to expand...

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.
 
The fact that you mention that this is embedded sends alarm bells ringing
straight away, embedded in what ?
Click to expand...

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.
 
Thank you :-)


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.
Click to expand...
 
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
 
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
 
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
 
Back
Top