all fields are now defined, and still the same error???

bob k.



--- In firebird-support@yahoogroups.com, "Jeffrey Bradley"
<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?
>
> --- 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:
> > > > > >
> > > > >
> > > >
> > >
> >
>