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

Database woes, never a real answere...

P: n/a
Well so far I've been directed to Access (when I asked for a free
solution), I'be also been directed to firebird. I then asked how with
firebird do I create the initial database, and setup the table. So
that I can go back to writting my program and having it handle the
add/edit/delete/search functions. No one seems to be able to tell me,
or to point me to some kind of walk through, I'm not stupid, but I
also don't want to have to read some 150 plus page book to do
something that shoudl be so much simpler. This database will not be
used over a betwork or the internet. Only the client using the
software will be using it and only one connection will have to be
made.

What I really need is the ability to store some data like

index time/date server user
message bayesianvalue
1 10:34:35 irc.winbeta.org bob
blahblahblah .072344
Now I COULD just write this data in a text file, but searching through
it and querying for data would become unessecaraly difficult and take
to much time. I thought a database would be a simply solution. That
way I could simply request record 1, or the user name and get all the
data I needed. Seraching would also be faster, and also the entering
and deletion of data.
Unfortunatly after three days of trying to use MyCC, firebird I cannot
figure out how to cnnect properly with a password and IP address (why
I dont want to use this over a 'connection'), nor do I particularaly
care if its protected with a password or user name, and further more,
neither of these programs listed have any instructions that tell you
how to set up anything as default so you can connecto to the dame
thing (sorry for the language).

I'm finding this extremely aggrivating, why isn't there a simple
solution for me? I know of XML, unfortunaly theres not much out there
telling anyone how to use XML if your not interested in using it over
the net with ASP. Also xml takes up alot of space (its bloated comeon
admit it).
Ok I'm done my beg for help/rant. I have Sams tech yourself Begining
databasses unfortunatly it usses access which I don't have and will
not buy.
Nov 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
With Access, you will need to create your database with Access itself. It
is possible to do this programatically, but I dont want to go into too much
depth.

Read this.

http://msdn.microsoft.com/SQL/sqlrel...onetprimer.asp

--

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:i8********************************@4ax.com...
Well so far I've been directed to Access (when I asked for a free
solution), I'be also been directed to firebird. I then asked how with
firebird do I create the initial database, and setup the table. So
that I can go back to writting my program and having it handle the
add/edit/delete/search functions. No one seems to be able to tell me,
or to point me to some kind of walk through, I'm not stupid, but I
also don't want to have to read some 150 plus page book to do
something that shoudl be so much simpler. This database will not be
used over a betwork or the internet. Only the client using the
software will be using it and only one connection will have to be
made.

What I really need is the ability to store some data like

index time/date server user
message bayesianvalue
1 10:34:35 irc.winbeta.org bob
blahblahblah .072344
Now I COULD just write this data in a text file, but searching through
it and querying for data would become unessecaraly difficult and take
to much time. I thought a database would be a simply solution. That
way I could simply request record 1, or the user name and get all the
data I needed. Seraching would also be faster, and also the entering
and deletion of data.
Unfortunatly after three days of trying to use MyCC, firebird I cannot
figure out how to cnnect properly with a password and IP address (why
I dont want to use this over a 'connection'), nor do I particularaly
care if its protected with a password or user name, and further more,
neither of these programs listed have any instructions that tell you
how to set up anything as default so you can connecto to the dame
thing (sorry for the language).

I'm finding this extremely aggrivating, why isn't there a simple
solution for me? I know of XML, unfortunaly theres not much out there
telling anyone how to use XML if your not interested in using it over
the net with ASP. Also xml takes up alot of space (its bloated comeon
admit it).
Ok I'm done my beg for help/rant. I have Sams tech yourself Begining
databasses unfortunatly it usses access which I don't have and will
not buy.

Nov 20 '05 #2

P: n/a
Unfortunatly I will be working with litteraly thousands of records,
MSDE seems to be what I'm looking for then, I guess I'll have to
return the book I got and get one for MSDE. Is it possible to create
the database through code with MSDE, or do I need access, I dont have
access and dont want to buy it. So if I can avoid it that be great.

On Fri, 16 Jul 2004 13:06:03 -0700, "David Williams"
<Da***********@discussions.microsoft.com> wrote:
How much data are you talking about? XML is not really to "bloated" until you are talking about 100s or 1000s of records.

Using XML in .NET, in any environment (well, I can not talk about the Compact Framework as I have not done anything with it) is very simple. Add an

Imports System.XML

To load the file from disk:

Dim dom As New XMLDocument
dom.load FileName

To transverse the file read up a little on XPath:

http://msdn.microsoft.com/library/de...pathsyntax.asp

I use XML all the time for smaller requirements. It has a number of advantages:

Human readable (This is what causes it to be "bloated".)
Portable to any platform.
Easy to work with.
Relitively quick in use (if not too large. If lots of data, use a database. MSDE is free if you have VS.NET and comes with sample databases.)
Requires not "external" objects (I.E. MDAC) to access and modify.
Is quickly become a "standard" for lite data storage.

HTH


Nov 20 '05 #3

P: n/a
So if I were to use MSDE were do I get the tools? Not MSDE
apparently I have it already installed, or so says the install
program for it).

On Fri, 16 Jul 2004 13:06:03 -0700, "David Williams"
<Da***********@discussions.microsoft.com> wrote:
How much data are you talking about? XML is not really to "bloated" until you are talking about 100s or 1000s of records.

Using XML in .NET, in any environment (well, I can not talk about the Compact Framework as I have not done anything with it) is very simple. Add an

Imports System.XML

To load the file from disk:

Dim dom As New XMLDocument
dom.load FileName

To transverse the file read up a little on XPath:

http://msdn.microsoft.com/library/de...pathsyntax.asp

I use XML all the time for smaller requirements. It has a number of advantages:

Human readable (This is what causes it to be "bloated".)
Portable to any platform.
Easy to work with.
Relitively quick in use (if not too large. If lots of data, use a database. MSDE is free if you have VS.NET and comes with sample databases.)
Requires not "external" objects (I.E. MDAC) to access and modify.
Is quickly become a "standard" for lite data storage.

HTH


Nov 20 '05 #4

P: n/a
VS.NET comes with "Server Explorer" (Ctrl-Alt-S from within the IDE). It
should let your create a database from scratch for MSDE. I've never tried
it though. I always use Enterpise Manager that comes with SQL Server (but
not with MSDE).

If you right-click on the Data Connections node (in Server Explorer) you
should see "Create new SQL Server database...". For some reason this isn't
working on my machine. Maybe you'll have more luck. :^)

BTW: If you really have MSDE installed, you would normally see the Service
Manager icon in your tray. (looks like a server with a green arrow). Also,
if you installed MSDE during your VS.NET setup it may have installed an
instance named VSdotNET. (as opposed to a default instance) This means your
server name will be YOURCOMPUTERNAME\VSdotNET, not simply YOURCOMPUTERNAME.

HTH,
Greg
"Jay King" <mr********@cinci.rr.com> wrote in message
news:o6********************************@4ax.com...
So if I were to use MSDE were do I get the tools? Not MSDE
apparently I have it already installed, or so says the install
program for it).

On Fri, 16 Jul 2004 13:06:03 -0700, "David Williams"
<Da***********@discussions.microsoft.com> wrote:
How much data are you talking about? XML is not really to "bloated" until
you are talking about 100s or 1000s of records.

Using XML in .NET, in any environment (well, I can not talk about the
Compact Framework as I have not done anything with it) is very simple.
Add an

Imports System.XML

To load the file from disk:

Dim dom As New XMLDocument
dom.load FileName

To transverse the file read up a little on XPath:

http://msdn.microsoft.com/library/de...pathsyntax.asp

I use XML all the time for smaller requirements. It has a number of
advantages:

Human readable (This is what causes it to be "bloated".)
Portable to any platform.
Easy to work with.
Relitively quick in use (if not too large. If lots of data, use a
database. MSDE is free if you have VS.NET and comes with sample
databases.)
Requires not "external" objects (I.E. MDAC) to access and modify.
Is quickly become a "standard" for lite data storage.

HTH

Nov 20 '05 #5

P: n/a
Hi Jay,

Thousand of records is not that much when it are records of 1byte however
keep in mind that MSDE as well as successor SQL express have a 4Gb limit.

http://msdn.microsoft.com/library/de...seoverview.asp

For this type of databases Access or XML are not the way to go. Some easy
decission pointers I have for choising.

- Access for smaller mostly standalone applications where you do not do
the deployment yourself
- MSDE for smaller multiuser applications where you do (or a company
which you can tell how) do the deployment of the MSDE.
- XML for pda where you replicate XML time by time with a larger database
- SQL server for company databases with more than 3 users.

I hope this helps?

Cor
Nov 20 '05 #6

P: n/a
On Fri, 16 Jul 2004 19:05:46 GMT, Jay King <mr********@cinci.rr.com> wrote:

Well so far I've been directed to Access (when I asked for a free
solution), I'be also been directed to firebird. I then asked how with
firebird do I create the initial database, and setup the table. So
that I can go back to writting my program and having it handle the
add/edit/delete/search functions. No one seems to be able to tell me,
or to point me to some kind of walk through, I'm not stupid, but I
also don't want to have to read some 150 plus page book to do
something that shoudl be so much simpler. This database will not be
used over a betwork or the internet. Only the client using the
software will be using it and only one connection will have to be
made.

What I really need is the ability to store some data like

index time/date server user
message bayesianvalue
1 10:34:35 irc.winbeta.org bob
blahblahblah .072344


Now I COULD just write this data in a text file, but searching through
it and querying for data would become unessecaraly difficult and take
to much time. I thought a database would be a simply solution. That
way I could simply request record 1, or the user name and get all the
data I needed. Seraching would also be faster, and also the entering
and deletion of data.


Unfortunatly after three days of trying to use MyCC, firebird I cannot
figure out how to cnnect properly with a password and IP address (why
I dont want to use this over a 'connection'), nor do I particularaly
care if its protected with a password or user name, and further more,
neither of these programs listed have any instructions that tell you
how to set up anything as default so you can connecto to the dame
thing (sorry for the language).

I'm finding this extremely aggrivating, why isn't there a simple
solution for me? I know of XML, unfortunaly theres not much out there
telling anyone how to use XML if your not interested in using it over
the net with ASP. Also xml takes up alot of space (its bloated comeon
admit it).


Ok I'm done my beg for help/rant. I have Sams tech yourself Begining
databasses unfortunatly it usses access which I don't have and will
not buy.

Have you looked at MySQL?

http://www.mysql.com
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.