Menu
▾
▴
firebird-net-provider
|
From: Frode L. <fr...@li...> - 2004-01-17 21:54:00
|
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
|
|
From:
<car...@te...> - 2004-01-17 22:17:24
|
Hello: > For some reason I am not able to use dbcon.CreateDatabase. Because it is static, you need to call it as FbConnection.CreateDatabase The list of valid keys for the hashtable is: Name Description ------------- ------------------------ Database Database path. User User name. Password User Password. Dialect Database dialect. DataSource Server name. Port Port number. Charset Database Character Set. PageSize Database page size. ForcedWrite Create database using forced writes mode. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
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
>
|
|
From: Frode L. <fr...@li...> - 2004-01-19 14:32:34
|
Thanks to both Sander and Carlos, I got it working :) Now I am pondering one thing. Can anyone see a reason why the following query is successful; sql = "CREATE TABLE tokens (f1 varchar(10), token varchar(10));"; while the one below doesn't work - only difference is varchar => int sql = "CREATE TABLE tokens (f1 int(10) NOT NULL, token VARCHAR(50));"; I get a Dynamic SQL Error code = -104 Token unknown ( Anyone? Frode |
|
From: Frode L. <fr...@li...> - 2004-01-19 14:40:57
|
Isn't it typical, as soon as I've sent the mail I see the problem. Just had to remove the (10) behind int to get it working! Sorry! -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of Frode Lillerud Sent: 19. januar 2004 15:38 To: Firebird mailinglist Subject: RE: [Firebird-net-provider] Creating new database with C# Thanks to both Sander and Carlos, I got it working :) Now I am pondering one thing. Can anyone see a reason why the following query is successful; sql = "CREATE TABLE tokens (f1 varchar(10), token varchar(10));"; while the one below doesn't work - only difference is varchar => int sql = "CREATE TABLE tokens (f1 int(10) NOT NULL, token VARCHAR(50));"; I get a Dynamic SQL Error code = -104 Token unknown ( Anyone? Frode ------------------------------------------------------- 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X