Subject Re: c# connection string datasource
Author rkamarowski
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:
> > > >
> > >
> >
>