Menu
▾
▴
Re: [Firebird-net-provider] Creating new database with C#
|
From: Sander B. <sbo...@es...> - 2004-01-18 03:26:43
|
a good example :-)
System.Collections.Hashtable newDB = new System.Collections.Hashtable();
newDB.Add("User","user");
newDB.Add("Password","password");
newDB.Add("ServerType",1);
newDB.Add("Dialect",3);
newDB.Add("DataSource","localhost");
newDB.Add("Pooling",false);
newDB.Add("Database",Environment.CurrentDirectory + DB + Config.sAFile);
FirebirdSql.Data.Firebird.FbConnection.CreateDatabase(newDB);
newDB.Clear();
""Frode Lillerud"" <fr...@li...> wrote in message
news:000801c3dd45$261702b0$0300000a@scalpel...
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0009_01C3DD4D.87DB6AB0
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hello all, I'm a newcomer to this list.
>
> I'm writing an application in C# (with Visual Studio .NET) which is
> going to use a Firebird database.
> I have successfully been able to connect and query the example
> employee-database, but I'm struggling with creating my own database.
>
> I see in the object browser that there is supposed to be a method called
> CreateDatabase, but I seem unable to use it. Here is the code I use:
>
> string connectionString =
> "Database=C:\\PROGRAM
> FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;" +
> "User=SYSDBA;" +
> "Password=masterkey;" +
> "Dialect=3;" +
> "Server=localhost";
> IDbConnection dbcon = new FbConnection(connectionString);
> dbcon.ConnectionString = connectionString;
> dbcon.Open();
>
> For some reason I am not able to use dbcon.CreateDatabase.
>
> Could anyone explain how to get this working? Or point me in the
> direction of a good C# example? I've already had a look at the
> ibphoenix.com site, to no avail.
> Also I'd like to understand what where to set SYSDBA and masterkey.
>
> Thanks
> Frode
>
> ------=_NextPart_000_0009_01C3DD4D.87DB6AB0
> Content-Type: text/html;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
> xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> <head>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Dus-ascii">
>
>
> <meta name=3DProgId content=3DWord.Document>
> <meta name=3DGenerator content=3D"Microsoft Word 10">
> <meta name=3DOriginator content=3D"Microsoft Word 10">
> <link rel=3DFile-List href=3D"cid:filelist.xml@01C3DD4D.873C92A0">
> <!--[if gte mso 9]><xml>
> <o:OfficeDocumentSettings>
> <o:DoNotRelyOnCSS/>
> </o:OfficeDocumentSettings>
> </xml><![endif]--><!--[if gte mso 9]><xml>
> <w:WordDocument>
> <w:SpellingState>Clean</w:SpellingState>
> <w:GrammarState>Clean</w:GrammarState>
> <w:DocumentKind>DocumentEmail</w:DocumentKind>
> <w:EnvelopeVis/>
> <w:Compatibility>
> <w:BreakWrappedTables/>
> <w:SnapToGridInCell/>
> <w:WrapTextWithPunct/>
> <w:UseAsianBreakRules/>
> </w:Compatibility>
> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
> </w:WordDocument>
> </xml><![endif]-->
> <style>
> <!--
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
> {mso-style-parent:"";
> margin:0cm;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";
> mso-ansi-language:NO-BOK;}
> a:link, span.MsoHyperlink
> {color:blue;
> text-decoration:underline;
> text-underline:single;}
> a:visited, span.MsoHyperlinkFollowed
> {color:purple;
> text-decoration:underline;
> text-underline:single;}
> span.EmailStyle17
> {mso-style-type:personal-compose;
> mso-style-noshow:yes;
> mso-ansi-font-size:10.0pt;
> mso-bidi-font-size:10.0pt;
> font-family:Arial;
> mso-ascii-font-family:Arial;
> mso-hansi-font-family:Arial;
> mso-bidi-font-family:Arial;
> color:windowtext;}
> span.SpellE
> {mso-style-name:"";
> mso-spl-e:yes;}
> span.GramE
> {mso-style-name:"";
> mso-gram-e:yes;}
> @page Section1
> {size:612.0pt 792.0pt;
> margin:72.0pt 90.0pt 72.0pt 90.0pt;
> mso-header-margin:35.4pt;
> mso-footer-margin:35.4pt;
> mso-paper-source:0;}
> div.Section1
> {page:Section1;}
> -->
> </style>
> <!--[if gte mso 10]>
> <style>
> /* Style Definitions */=20
> table.MsoNormalTable
> {mso-style-name:"Table Normal";
> mso-tstyle-rowband-size:0;
> mso-tstyle-colband-size:0;
> mso-style-noshow:yes;
> mso-style-parent:"";
> mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
> mso-para-margin:0cm;
> mso-para-margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:10.0pt;
> font-family:"Times New Roman";}
> </style>
> <![endif]-->
> </head>
>
> <body lang=3DEN-US link=3Dblue vlink=3Dpurple =
> style=3D'tab-interval:36.0pt'>
>
> <div class=3DSection1>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>Hello all, I’m a =
> newcomer to
> this list.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></font=
> ></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>I’m writing an =
> application in
> C# (with Visual Studio .NET) which is going to use a Firebird =
> database.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>I have successfully been able =
> to
> connect and query the example employee-database, but I’m =
> struggling with creating
> my own database.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></font=
> ></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'>I see in the object browser =
> that
> there is supposed to be a method called <span =
> class=3DSpellE>CreateDatabase</span>,
> but I seem unable to use it. Here is the code I =
> use:<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></font=
> ></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DGramE><font size=3D2 color=3Dblue face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial;color:blue;mso-ansi-language:EN-US'>string</span></font=
> ></span><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'> <span class=3DSpellE>connectionString</span> =3D =
> <o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>  =
> ; =
> &=
> nbsp; &n=
> bsp; </span>"Database=3DC<span
> class=3DGramE>:\</span>\PROGRAM =
> FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;" =
> +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>  =
> ; =
> &=
> nbsp; &n=
> bsp; </span>"User=3DSYSDBA;"
> +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>  =
> ; =
> &=
> nbsp; &n=
> bsp; </span>"Password=3D<span
> class=3DSpellE>masterkey</span>;" +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>  =
> ; =
> &=
> nbsp; &n=
> bsp; </span>"Dialect=3D3;"
> +<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><span =
> style=3D'mso-tab-count:4'>  =
> ; =
> &=
> nbsp; &n=
> bsp; </span>"Server=3D<span
> class=3DSpellE>localhost</span>";<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>IDbConnection</span></font></span><font =
> size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'> <span class=3DSpellE>dbcon</span> =3D new <span =
> class=3DSpellE><span
> class=3DGramE>FbConnection</span></span><span =
> class=3DGramE>(</span><span
> class=3DSpellE>connectionString</span>);<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>dbcon.ConnectionString</span></font></span=
> ><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'> =3D <span =
> class=3DSpellE>connectionString</span>;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><span class=3DGramE><font size=3D2 face=3DArial><span =
> style=3D'font-size:
> 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>dbcon.Open</span></font=
> ></span></span><span
> class=3DGramE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>(</span></font></span><font size=3D2 =
> face=3DArial><span
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:EN-US'>);<o=
> :p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>For some reason I am not able to use <span =
> class=3DSpellE>dbcon.CreateDatabase</span>.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>Could anyone explain how to get this working? Or point me in the
> direction of a good C# example? I’ve already had a look at the
> ibphoenix.com site, to no avail.<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>Also I’d like to understand what where to set SYSDBA and =
> <span
> class=3DSpellE>masterkey</span>. <o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><font
> size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:Arial;mso-ansi-language:
> EN-US'>Thanks <o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal =
> style=3D'mso-layout-grid-align:none;text-autospace:none'><span
> class=3DSpellE><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;font-family:
> Arial;mso-ansi-language:EN-US'>Frode</span></font></span><font =
> face=3DArial><span
> style=3D'font-family:Arial;mso-ansi-language:EN-US'><o:p></o:p></span></f=
> ont></p>
>
> </div>
>
> </body>
>
> </html>
>
> ------=_NextPart_000_0009_01C3DD4D.87DB6AB0--
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
