473,322 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Database woes, never a real answere...

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
6 1110
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alex | last post by:
Hi all, I'm looking for some advice on how best to implement storage of access logs into a db/2 8.1.4 database running on a RH 7.2 system. I have 5 (squid) web caches running here that...
6
by: GGerard | last post by:
Hello Does anyone know if there's a way to mirror data from a backend database to a second database? Example: When writing data to one database it would mirror the data in a second database...
2
by: Carl | last post by:
Hi, I am currently developing an access database for books which contains ISBN,author,title info etc... I am trying to find an online book library or database that would allow me to search for...
4
by: Lars Netzel | last post by:
Hello! Is there anyway in VB.NET (windows forms) to work in realtime on the database? I mean entering stuff in a textbox directly, updates the database... Best Regards /Lars
0
by: RD | last post by:
Having a vb.net application that must be able to read and write data to certain tables in an AS400 database, in real time as the program is running. I suspect use of and OLE DB driver is necessary....
1
by: fong.yang | last post by:
I have a database that is split into front end and back end. The back end is on shared folder on the server. I have just the front end running locally on two pc's that are connected to the...
0
by: Xarious | last post by:
Greetings and salutations. The project I am currently working on is nothing more than a dummied down Access replica. My problem is that I cannot figure out a way to stream changes made to...
2
by: webcm123 | last post by:
People say that structural programming isn't good for database connection. I code fast-running structural oriented CMS and I don't know what I should do. I use mysql connection using mysql_*. I...
1
by: Mike Howarth | last post by:
I've been having a few problems with connecting to SQL Server, initially I was using dblib however found some problems with returning text fields whereby all text fields were ignored and it bawked...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.