Subject | Re: c# connection string datasource |
---|---|
Author | Jeffrey Bradley |
Post date | 2007-07-18T19:39:33Z |
in that case, your connection string should look similar to the one I
sent earlier. You need to make sure that the "Server Type" is set to
0. You were trying to connect to a Super Server using the embedded
methods.
--- In firebird-support@yahoogroups.com, "rkamarowski"
<rkamarowski@...> wrote:
sent earlier. You need to make sure that the "Server Type" is set to
0. You were trying to connect to a Super Server using the embedded
methods.
--- In firebird-support@yahoogroups.com, "rkamarowski"
<rkamarowski@...> wrote:
>like
> i'm running superserver
>
> --- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
> <jeff_bradley@> wrote:
> >
> > if you downloaded a file named something similar to
> > "Firebird-1.5.x.xxxx-x-Win32.exe", then you are running either the
> > Super Server or Classic Server depending on what you selected during
> > your setup.
> >
> > If you downloaded a file named something similar to
> > "Firebird-1.5.x.xxxx-x_embed_win32.zip", then you are running the
> > embedded Firebird.
> >
> > If you are running the embedded Firebird, you should not include a
> > "Data Source" parameter. Your connect string should probably look
> >printout?
> > connStr = "User=SYSDBA;
> > Password=masterkey;
> > Database=c:/photography/databaase/csharp/rak-photography;
> > SystemType=1;";
> >
> >
> > --- In firebird-support@yahoogroups.com, "rkamarowski"
> > <rkamarowski@> wrote:
> > >
> > > hmmmm... i'm new to this. i have Firebird 1.5 installed. what i
> > > wanted was the embedded Firebird. is that a different install???
> > >
> > >
> > >
> > > --- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
> > > <jeff_bradley@> wrote:
> > > >
> > > > Are you using Embedded Firebird or one of the flavors of Firebird
> > > Server?
> > > >
> > > > --- In firebird-support@yahoogroups.com, "rkamarowski"
> > > > <rkamarowski@> wrote:
> > > > >
> > > > >
> > > > > it has changed to 'localhost' do you want another error
> > > > >or ...?
> > > > > i'm using:
> > > > > Microsoft Visual Studio Codename Orcas
> > > > > Version 9.0.20404.0 Beta1
> > > > > Microsoft .NET Framework
> > > > > Version 2.0.50727
> > > > > Installed Edition: C# Express
> > > > > Microsoft Visual C# Codename "Orcas" 76544-000-0000011-00126
> > > > > Microsoft Visual C# Codename "Orcas"
> > > > >
> > > > > --- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
> > > > > <jeff_bradley@> wrote:
> > > > > >
> > > > > > I am still using .NET 2.x.
> > > > > >
> > > > > > Does the error message still indicate that it is having a
> > > problem with
> > > > > > "rac", or does it change it to "localhost", etc?
> > > > > >
> > > > > >
> > > > > > --- In firebird-support@yahoogroups.com, "rkamarowski"
> > > > > > <rkamarowski@> wrote:
> > > > > > >
> > > > > > >
> > > > > > > .NET Framework 3.5
> > > > > > >
> > > > > > > --- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
> > > > > > > <jeff_bradley@> wrote:
> > > > > > > >
> > > > > > > > Are you using the Firebird .NET data provider or ADO
> > > > > > > >Bradley"
> > > > > > > > --- In firebird-support@yahoogroups.com, "rkamarowski"
> > > > > > > > <rkamarowski@> wrote:
> > > > > > > > >
> > > > > > > > > all fields are now defined, and still the same error???
> > > > > > > > >
> > > > > > > > > bob k.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --- In firebird-support@yahoogroups.com, "Jeffrey
> > > > > > > > > <jeff_bradley@> wrote:
> > > > > > > > > >
> > > > > > > > > > Here is an example of one of my connection strings
> > (note: I
> > > > > > changed
> > > > > > > > > > User and Password to protect the guilty)
> > > > > > > > > >
> > > > > > > > > > strConn = "User=XXXXXX;" +
> > > > > > > > > > "Password=xxxxxx;" +
> > > > > > > > > >
> "Database=d:\\data\\test_datawarehouse.fdb;" +
> > > > > > > > > > "DataSource=localhost;" +
> > > > > > > > > > "Port=3050;" +
> > > > > > > > > > "Dialect=3;" +
> > > > > > > > > > "Charset=NONE;" +
> > > > > > > > > > "Role=;" +
> > > > > > > > > > "Connection lifetime=0;" +
> > > > > > > > > > "Connection timeout=15;" +
> > > > > > > > > > "Pooling=True;" +
> > > > > > > > > > "Packet Size=8192;" +
> > > > > > > > > > "Server Type=0";
> > > > > > > > > >
> > > > > > > > > > I don't know if you need to specify every parameter
> like I
> > > > > > did, but
> > > > > > > > > > you may need to specify the Port and Packet Size.
> > Also, are
> > > > > > you by
> > > > > > > > > > any chance running a local firewall?
> > > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>