create database programmatically

[Wolfie7873]

Trying to find a simple snippet to create a database from within a program.

I'm relatively new to databases, but i'm picking up fast. I know all of the basic SQL commands and how to implement them once I have an open connection to an existing database, but what I would like is something like this:

CREATE_DBV4=<user defined path>;
OleDbConnection * cnDirector = new OleDbConnection;
cnDirector->ConnectionString =
S" Provider=Microsoft.Jet.OLEDB.4.0;"
S"Data Source=<path>";
cnDirector->Open();
OleDbCommand * cmDirector = new OleDbCommand(S"CREATE TABLE <etc>",cnDirector);

and continue from there. I don't quite get how/where the first CREATE command works. Where exactly does it go in relation to the connection directive?

Thanks in advance...

 

[esdee]

you connect to the server first, then issue commands, your script seems to be correct.

------------------------

http://esdeeblog.blogspot.com/

 

[Wolfie7873]

I'm not sure I understand what you mean. This is not a network application. The program and the created database will live on the user's machine. What do you mean by connect to the server first?

 

[esdee]

i mean you call Connect method and then call Execute on corresponding classes...whether the database server is local or on a network doesnt matter

------------------------

http://esdeeblog.blogspot.com/

 

[Wolfie7873]

I'm afraid I still need a little more help. Do I need any additional namespaces besides System, System:ata, and System:ata:OleDb ?

What's the syntax for connecting to the server in this case?

 

[esdee]

i am using odbc so here ms.data.odbc is used,
basically you will use syntax much like this

using System;
using System.IO;
using System.Collections;
using System.Data;
using Microsoft.Data.Odbc;
using System.Windows.Forms;
using System.Reflection;

(...)
MyConString = String.Format("DRIVER={{MySQL ODBC 3.51 Driver}};" + 
"SERVER={0};" +
"DATABASE={1};" +
"UID={2};" +
"PASSWORD={3};" +
"OPTION=3", srvName, dbName, user, password);
sr.Close()

------------------------

http://esdeeblog.blogspot.com/

 

[esdee]

here're some example connection strings you may use, depending on your backend:

http://www.sqlkingdom.com/connectionstring/forget.shtm

read through msdn topics on OdbcConnection (OleDBConnection) etc - lots of example code there

------------------------

http://esdeeblog.blogspot.com/