Subject Re: c# connection string datasource
Author corygm
> "Database=c:/photography/databaase/csharp/rak-photography.fdb;" +

Did you intend to spell database with two As?

"Database=c:/photography/database/csharp/rak-photography.fdb;" +

--- In firebird-support@yahoogroups.com, "rkamarowski"
<rkamarowski@...> wrote:
>
> Jeff,
>
> i've tried 'localhost', 'local' and null (dataresource=;), and i'm
> still getting the error. this is a local database, and the 'test
> connection' always come back as successful.
>
> here's the code that's making the call:
>
>
> string connStr;
> connStr = "User=SYSDBA;" +
> "Password=masterkey;" +
> "Database=c:/photography/databaase/csharp/rak-photography.fdb;" +
> "DataSource=localhost";
>
> FbConnection conn = new FbConnection(connStr);
> conn.Open();
>
>
> bob k.
>
> --- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
> <jeff_bradley@> wrote:
> >
> > The Datasource refers to the server name not the System DSN - I would
> > imagine you would set it to "localhost" (unless you are accessing it
> > across the LAN/WAN).
> >
> > Jeff
> >
> > --- In firebird-support@yahoogroups.com, "rkamarowski"
> > <rkamarowski@> wrote:
> > >
> > > Jeff,
> > >
> > > the folder is now 'csharp', and i updated the System DSN, but i'm
> > > still getting the same error.
> > >
> > > bob k.
> > >
> > > --- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
> > > <jeff_bradley@> wrote:
> > > >
> > > > According to the error message, it looks like it is getting hung
> up on
> > > > the "pound/sharp" sign. Could you change the name of the
> directory to
> > > > somethen like c-sharpe instead of using a special character?
> > > >
> > > > Jeff
> > > >
> > > > --- In firebird-support@yahoogroups.com, "rkamarowski"
> > > > <rkamarowski@> wrote:
> > > > >
> > > > > the following connection string is returning an error:
> > > > >
> > > > > connStr = "User=SYSDBA;
> > > > > Password=masterkey;
> > > > > Database=c:/photography/databaase/c#/rak-photography;
> > > > > DataSource=rak;
> > > > > SystemType=1;";
> > > > >
> > > > > i have a System DSN defined as 'rak' with the
> Firebird/InterBase(r)
> > > > Driver
> > > > >
> > > > > below is the error. what am i doing wrong???
> > > > > thanks,
> > > > > bob k.
> > > > > -----------
> > > > > FirebirdSql.Data.FirebirdClient.FbException was unhandled
> > > > > Message="Unable to complete network request to host \"rak\"."
> > > > > Source="FirebirdSql.Data.FirebirdClient"
> > > > > ErrorCode=-2147467259
> > > > > StackTrace:
> > > > > at
> > > FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
> > > > > at
> FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()
> > > > > at
> > FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()
> > > > > at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
> > > > > at rak_photography.FormMain..ctor() in
> > > > >
> > > >
> > >
> >
>
C:\Photography\Software\rak-photography\rak-photography\rak-photography\FormMain.cs:line
> > > > > 40
> > > > > at rak_photography.Program.Main() in
> > > > >
> > > >
> > >
> >
>
C:\Photography\Software\rak-photography\rak-photography\rak-photography\Program.cs:line
> > > > > 17
> > > > > at System.AppDomain._nExecuteAssembly(Assembly assembly,
> > > > > String[] args)
> > > > > at System.AppDomain.ExecuteAssembly(String assemblyFile,
> > > > > Evidence assemblySecurity, String[] args)
> > > > > at
> > > > >
Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
> > > > > at
System.Threading.ThreadHelper.ThreadStart_Context(Object
> > > > state)
> > > > > at System.Threading.ExecutionContext.Run(ExecutionContext
> > > > > executionContext, ContextCallback callback, Object state)
> > > > > at System.Threading.ThreadHelper.ThreadStart()
> > > > > InnerException: FirebirdSql.Data.Common.IscException
> > > > > Message="Exception of type
> > > > > 'FirebirdSql.Data.Common.IscException' was thrown."
> > > > > Source="FirebirdSql.Data.FirebirdClient"
> > > > > ErrorCode=335544721
> > > > > IsWarning=false
> > > > > StackTrace:
> > > > > at
> > > > > FirebirdSql.Data.Client.Gds.GdsConnection.Connect(String
> dataSource,
> > > > > Int32 port, Int32 packetSize, Charset charset)
> > > > > at
> > > > >
> > FirebirdSql.Data.Client.Gds.GdsDatabase.Attach(DatabaseParameterBuffer
> > > > > dpb, String dataSource, Int32 port, String database)
> > > > > at
> > > > > FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
> > > > > InnerException:
> > > > >
> > > >
> > >
> >
>