Click here to Skip to main content
15,353,841 members
Home / Discussions / C#
   

C#

 
GeneralRe: Custom Control Pin
Heath Stewart4-Jan-04 18:15
protectorHeath Stewart4-Jan-04 18:15 
GeneralRe: Custom Control Pin
Luther Baker6-Jan-04 18:21
MemberLuther Baker6-Jan-04 18:21 
GeneralRe: Custom Control Pin
Heath Stewart6-Jan-04 18:59
protectorHeath Stewart6-Jan-04 18:59 
GeneralRe: Custom Control Pin
Luther Baker6-Jan-04 19:26
MemberLuther Baker6-Jan-04 19:26 
QuestionI should use what provider? Pin
god4k4-Jan-04 7:23
Membergod4k4-Jan-04 7:23 
AnswerRe: I should use what provider? Pin
Guillermo Rivero4-Jan-04 8:11
MemberGuillermo Rivero4-Jan-04 8:11 
GeneralRe: I should use what provider? Pin
Heath Stewart4-Jan-04 8:37
protectorHeath Stewart4-Jan-04 8:37 
AnswerRe: I should use what provider? Pin
Heath Stewart4-Jan-04 8:45
protectorHeath Stewart4-Jan-04 8:45 
So what's the question? The Microsoft Jet provider for .mdb files doesn't support retrieving parameters from stored procedures, which really are only module functions.

If you need a real RDBMS, look into the Microsoft Data Engine (MSDE) at http://www.microsoft.com/sql/msde/default.asp[^]. This is Microsoft SQL Server with a few limitations, like the number of concurrent connections supported (10). Other than that, it supports true stored procedures, triggers, tables and views (of course), functions, and everything else that SQL Server supports. It is also freely redistributable so long as you have a valid license for a product that includes the MSDE, like Visual Studio .NET, Microsoft Access (I think), an MSDN Subscription, and several others things. It's also a free download.

You can install up to 16 instances of the MSDE and SQL Server (think of them as the same thing). Microsoft Access even supports direct access and designing with the MSDE if you still want to design your databases using MS Access.

Basically, though, you get a real RDBMS that is much faster and supports everything any other RDBMS like Oracle and DB2 does. It also supports output parameters in stored procedures and has better support in .NET using the System.Data.SqlClient namespace, which is written specifically for SQL Server and you don't have to guess at what is supported. System.Data.OleDb is based on OLE DB and uses abstract OLE DB providers that must provide some basic functionality, but don't have to provide any of the optional stuff.

For instance, in an article I wrote I use the Microsoft Indexing Service OLE DB provider. It only supports basic SELECT statements and views using an OleDbCommand. Period. No updates, no insertions, no transactions, no stored procedures. You're left to the will of the OLE DB provider.

 

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
QuestionHow to get list of Tables, Views and Procedure from Oracle database? Pin
god4k4-Jan-04 7:19
Membergod4k4-Jan-04 7:19 
AnswerRe: How to get list of Tables, Views and Procedure from Oracle database? Pin
Nick Parker4-Jan-04 7:52
protectorNick Parker4-Jan-04 7:52 
AnswerRe: How to get list of Tables, Views and Procedure from Oracle database? Pin
Guillermo Rivero4-Jan-04 7:57
MemberGuillermo Rivero4-Jan-04 7:57 
GeneralFeed CheckedListBox with data from XML Pin
dophka4-Jan-04 6:37
Memberdophka4-Jan-04 6:37 
GeneralRe: Feed CheckedListBox with data from XML Pin
Heath Stewart4-Jan-04 8:34
protectorHeath Stewart4-Jan-04 8:34 
GeneralRe: Feed CheckedListBox with data from XML Pin
dophka4-Jan-04 8:46
Memberdophka4-Jan-04 8:46 
GeneralRe: Feed CheckedListBox with data from XML Pin
Heath Stewart4-Jan-04 8:52
protectorHeath Stewart4-Jan-04 8:52 
GeneralRe: Feed CheckedListBox with data from XML Pin
dophka4-Jan-04 9:07
Memberdophka4-Jan-04 9:07 
GeneralRe: Feed CheckedListBox with data from XML Pin
Heath Stewart4-Jan-04 9:11
protectorHeath Stewart4-Jan-04 9:11 
GeneralRe: Feed CheckedListBox with data from XML Pin
dophka4-Jan-04 10:25
Memberdophka4-Jan-04 10:25 
GeneralRe: Feed CheckedListBox with data from XML Pin
Heath Stewart5-Jan-04 6:05
protectorHeath Stewart5-Jan-04 6:05 
Generalhelp me in finding objective and multiple choice questions Pin
imran_rafique4-Jan-04 4:29
Memberimran_rafique4-Jan-04 4:29 
GeneralRe: help me in finding objective and multiple choice questions Pin
Heath Stewart4-Jan-04 8:23
protectorHeath Stewart4-Jan-04 8:23 
GeneralSending mail using SMTP Pin
gr8tushar4-Jan-04 1:47
Membergr8tushar4-Jan-04 1:47 
GeneralRe: Sending mail using SMTP Pin
Mike Ellison4-Jan-04 3:11
MemberMike Ellison4-Jan-04 3:11 
GeneralRe: Sending mail using SMTP Pin
gr8tushar4-Jan-04 3:43
Membergr8tushar4-Jan-04 3:43 
GeneralRe: Sending mail using SMTP Pin
Broken God4-Jan-04 5:59
MemberBroken God4-Jan-04 5:59 

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.