Click here to Skip to main content
15,879,490 members
Home / Discussions / Database
   

Database

 
GeneralPutting fixed array into DB field Pin
EddieSD647-Nov-03 11:31
sussEddieSD647-Nov-03 11:31 
GeneralStored Procs, parameters and IN Clause Pin
stephen woolhead7-Nov-03 5:00
stephen woolhead7-Nov-03 5:00 
GeneralRe: Stored Procs, parameters and IN Clause Pin
jeff_martin11-Nov-03 12:04
jeff_martin11-Nov-03 12:04 
GeneralSQL Server does not exist or access denied Pin
yyf7-Nov-03 2:50
yyf7-Nov-03 2:50 
GeneralProblem with _Connection::Open ! Pin
nigs_krec7-Nov-03 1:53
nigs_krec7-Nov-03 1:53 
GeneralManaged .NET Embedded Database Pin
Andrew Shapira6-Nov-03 10:11
Andrew Shapira6-Nov-03 10:11 
GeneralRe: Managed .NET Embedded Database Pin
Mike Dimmick7-Nov-03 2:54
Mike Dimmick7-Nov-03 2:54 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira7-Nov-03 10:17
Andrew Shapira7-Nov-03 10:17 
Hi Mike.

I am an experienced programmer and am new to databases. Please be nice.

Maybe a bit more background about the application will help. I am writing a server application that runs on a dedicated host. I don't need to do complicated SQL queries and I'd be perfectly happy to use a custom API instead of SQL queries. Doing SQL queries may be fine too. The main reasons I have been looking at databases is to get atomic transactions so that the database is always in a consistent state. In my situation recovery is also nice although it's less important than atomic transactions. The ability to access the database from multiple threads would be extremely helpful.

Benefits of staying in managed code for this application are type safety, debuggability, and security.

Benefits of embedding the database over using a database server are relative ease of deployment and system management. If performance is better using embedding than a database server, that would be another benefit. As you say though, maybe performance will be about the same either way.

You mentioned Jet.. Is Jet something that can be used directly from my C# application, or does it have to be used with a higher level package like Access? If it can be used directly, is there somewhere I can read about Jet from a non-propaganda standpoint? I looked around some in Google and found mostly Jet error messages and security bulletins. I have been avoiding Access because my understanding is that Access does not perform well with large databases.

GeneralRe: Managed .NET Embedded Database Pin
Arjan Einbu10-Nov-03 11:01
Arjan Einbu10-Nov-03 11:01 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira10-Nov-03 13:57
Andrew Shapira10-Nov-03 13:57 
GeneralMax Pool Size's Limitation Pin
yyf6-Nov-03 8:43
yyf6-Nov-03 8:43 
GeneralCreating a DBASE file Pin
DonBush6-Nov-03 4:04
DonBush6-Nov-03 4:04 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson6-Nov-03 14:00
Jörgen Sigvardsson6-Nov-03 14:00 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 2:33
DonBush7-Nov-03 2:33 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson7-Nov-03 3:14
Jörgen Sigvardsson7-Nov-03 3:14 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 4:10
DonBush7-Nov-03 4:10 
GeneralRe: Creating a DBASE file Pin
Arjan Einbu10-Nov-03 11:07
Arjan Einbu10-Nov-03 11:07 
GeneralRe: Creating a DBASE file Pin
DonBush11-Nov-03 2:47
DonBush11-Nov-03 2:47 
QuestionMust be a permissions thing, but what? Pin
Colin Angus Mackay6-Nov-03 4:04
Colin Angus Mackay6-Nov-03 4:04 
Answer(Actually it wasn't) Pin
Colin Angus Mackay6-Nov-03 5:33
Colin Angus Mackay6-Nov-03 5:33 
GeneralRe: (Actually it wasn't) Pin
Michael Dunn6-Nov-03 13:01
sitebuilderMichael Dunn6-Nov-03 13:01 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson6-Nov-03 13:58
Jörgen Sigvardsson6-Nov-03 13:58 
GeneralRe: (Actually it wasn't) Pin
Colin Angus Mackay7-Nov-03 1:37
Colin Angus Mackay7-Nov-03 1:37 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson7-Nov-03 3:11
Jörgen Sigvardsson7-Nov-03 3:11 
AnswerRe: Must be a permissions thing, but what? Pin
Giles7-Nov-03 3:49
Giles7-Nov-03 3:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.