Click here to Skip to main content
16,005,141 members
Home / Discussions / C#
   

C#

 
AnswerRe: Can i stop people from deleting a file? Pin
afinnell15-Apr-05 13:55
afinnell15-Apr-05 13:55 
GeneralC# COM Interop Pin
s2111979212-Apr-05 4:30
s2111979212-Apr-05 4:30 
GeneralMake an instance of a child form from a class file. Pin
Mike Jeferson12-Apr-05 4:23
Mike Jeferson12-Apr-05 4:23 
GeneralC# Connection to Northwind via SQL - HELP Pin
Jethro6312-Apr-05 4:08
Jethro6312-Apr-05 4:08 
GeneralRe: C# Connection to Northwind via SQL - HELP Pin
Luis Alonso Ramos12-Apr-05 6:34
Luis Alonso Ramos12-Apr-05 6:34 
GeneralRe: C# Connection to Northwind via SQL - HELP Pin
Jethro6312-Apr-05 15:59
Jethro6312-Apr-05 15:59 
GeneralRe: C# Connection to Northwind via SQL - HELP Pin
Dave Kreskowiak13-Apr-05 4:20
mveDave Kreskowiak13-Apr-05 4:20 
GeneralRe: C# Connection to Northwind via SQL - HELP Pin
Luis Alonso Ramos13-Apr-05 5:29
Luis Alonso Ramos13-Apr-05 5:29 
Jethro63 wrote:
An entire WEB site dedicated to connection strings for databases

Things you can find on the web... Smile | :)

Jethro63 wrote:
Was I mistaken to think that I could connect to a database created with Access using SQL Server?

To add and clarify what Dave replied, a database by itself is only the collection of tables with some data. SQL Server and Access are two database applications, as are many others like mysql, Oracle, and so on. So, you can have your collection of tables (the Northwind database) in an SQL Server database, or an Access database, or an Oracle database, or....

And to connect to each different kind of database application, you need different commands (it's more or less like asking for certain papers in English or in Spanish -- you have to speak the language of that that is giving you the papers, not of the papers themselves.)

OleDb* classes are very general, and you can use those to connect to almost any kind of database, including Access and SQL Server. The only difference is in the provider part of the connection string. So, for simple databases, changing the connection string is enough to change from Access to SQL Server.

But SQL Server is way more powerful than Access. As Dave mentioned, you have stored procedures for example. And the Sql* clasess are specific for SQL Server, giving you better performance and access to SQL Server-specific features, but also restricting you from using other database applications.

By the way, there's a free edition of SQL Server, called Microsoft SQL Server Desktop Engine, which you can download from here[^]. It is SQL Server, with the only limitations of 5 concurrent users and 2 o4 GB per database (enough for most small applications (and for some medium apps too)).

If you have any more questions, feel free to reply to this thread, we'll be glad to answer them.

-- LuisR



Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

GeneralRe: C# Connection to Northwind via SQL - HELP Pin
Jethro6313-Apr-05 15:22
Jethro6313-Apr-05 15:22 
GeneralRe: C# Connection to Northwind via SQL - HELP Pin
Mushtaque Nizamani25-Oct-07 4:41
Mushtaque Nizamani25-Oct-07 4:41 
GeneralPainting Issue Pin
Mark_Harrison12-Apr-05 2:05
Mark_Harrison12-Apr-05 2:05 
GeneralRe: Painting Issue Pin
S. Senthil Kumar12-Apr-05 3:26
S. Senthil Kumar12-Apr-05 3:26 
Generalcreating code demo Pin
rmedo12-Apr-05 1:56
rmedo12-Apr-05 1:56 
GeneralRe: creating code demo Pin
eggie512-Apr-05 13:58
eggie512-Apr-05 13:58 
GeneralRe: creating code demo Pin
rmedo13-Apr-05 4:34
rmedo13-Apr-05 4:34 
GeneralC# & XML & nested loops problem (try 2) Pin
Anonymous12-Apr-05 1:47
Anonymous12-Apr-05 1:47 
GeneralRe: C# & XML & nested loops problem (try 2) Pin
hooray12-Apr-05 2:11
hooray12-Apr-05 2:11 
GeneralRe: C# & XML & nested loops problem (try 2) Pin
Anonymous12-Apr-05 2:38
Anonymous12-Apr-05 2:38 
GeneralC# & XML & nested loops problem Pin
Anonymous12-Apr-05 1:45
Anonymous12-Apr-05 1:45 
GeneralRe: C# & XML & nested loops problem Pin
Ian Bowler12-Apr-05 7:45
Ian Bowler12-Apr-05 7:45 
GeneralRe: C# & XML & nested loops problem Pin
Anonymous12-Apr-05 23:31
Anonymous12-Apr-05 23:31 
GeneralProb with creating user control Pin
Anonymous12-Apr-05 1:03
Anonymous12-Apr-05 1:03 
GeneralRe: Prob with creating user control Pin
Judah Gabriel Himango12-Apr-05 4:38
sponsorJudah Gabriel Himango12-Apr-05 4:38 
Generalon Signed Assemblies in .Net Pin
ppp00112-Apr-05 0:29
ppp00112-Apr-05 0:29 
GeneralThreading.Timer callback called multiple times Pin
sjhart12-Apr-05 0:23
sjhart12-Apr-05 0:23 

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.