Database woes, never a real answere...

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

Jay King

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.
 
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.
 
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).
 
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
 
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/default.asp?url=/library/en-us/dnsse/html/sseoverview.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
 
¤ 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top