[Firebird-net-provider] Ask about stored procedure in ddex

[Tri Mardiono]

Hi,

I use the packageless ddex. I create dataset using designer. And use the 
stored procedure for data retrieval/update. But the parameter name is 
not include "@" prefix, the DbType always "Object" also. Then I should 
change it manually. Will the package ddex solve these manual stuffs? 
Because it must download VS05 SDK, and badly my bandwidth isn't content. 
I need the info before I have a bulk with the VS05 SDK download. Thanks 
for any infos.

Regards,
TriM

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

Got it.

Thanks!

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 10:35 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

> I'm sorry to keep bugging you on this but doesn't super-server lock the
> database file? If so, doesn't it have the same drawbacks as embedded?

But since super server mode is a server - that is, a separate process to IIS
- there's no trouble. There's only ever one super-server mode server
process, no matter how many clients connect to it.

Embedded is like making every client *process* into a super-server. If
there's only one client process, there's no problem. But with web sites,
that can be a tough thing to guarantee.

Dean.



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[AAbend (gmail)]

Server lets any number of users connect to the same database. 

My gds32.dll is not a renamed fbembedded (though I did try to do that
without success). It is a 349k dll from 5/3/2005 and all I can tell you is
that without it, firebird embedded will not work. I installed my app on a
clean machine (a virtual image with nothing on it) and it would not work
until I added that file (by dumb luck). Making a copy of the fbembedded.dll
to fbclient.dll or gds32.dll does not work reliably (I think it worked once
on my PC). 

I am a relative newbie here, so maybe there's something I am doing wrong.
Sorry to take up time on this thread. I'll look for a response but will not
pursue this issue further on this thread. Thanks. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 11:35 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

> I'm sorry to keep bugging you on this but doesn't super-server lock the
> database file? If so, doesn't it have the same drawbacks as embedded?

But since super server mode is a server - that is, a separate process to IIS
- there's no trouble. There's only ever one super-server mode server
process, no matter how many clients connect to it.

Embedded is like making every client *process* into a super-server. If
there's only one client process, there's no problem. But with web sites,
that can be a tough thing to guarantee.

Dean.



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Dean Harding]

> I'm sorry to keep bugging you on this but doesn't super-server lock the
> database file? If so, doesn't it have the same drawbacks as embedded?

But since super server mode is a server - that is, a separate process to IIS
- there's no trouble. There's only ever one super-server mode server
process, no matter how many clients connect to it.

Embedded is like making every client *process* into a super-server. If
there's only one client process, there's no problem. But with web sites,
that can be a tough thing to guarantee.

Dean.



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

I'm sorry to keep bugging you on this but doesn't super-server lock the
database file? If so, doesn't it have the same drawbacks as embedded?

- A

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 10:17 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

> I just re-read the INSTALL notes for FB 2.0 embedded and I may need to
> re-think my plan to use embedded Firebird with my web iste. Would
> classic server have any of the problems you mention?

Nope, either of the server modes (classic or super-server) are
ideally-suited to websites.

Dean.



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Dean Harding]

> I just re-read the INSTALL notes for FB 2.0 embedded and I may need to
> re-think my plan to use embedded Firebird with my web iste. Would
> classic server have any of the problems you mention?

Nope, either of the server modes (classic or super-server) are
ideally-suited to websites.

Dean.



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

I just re-read the INSTALL notes for FB 2.0 embedded and I may need to
re-think my plan to use embedded Firebird with my web iste. Would classic
server have any of the problems you mention?

 

Thanks,

 

Andrew

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 9:37 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

What's the complete exception? My guess is that there is some sort of
permissions problem.

 

Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)?

 

For IIS5 you need to give the ASPNET account read/write permissions to the
database file. For IIS6 you need to give whatever account your Application
Pool is running as read/write permissions to the file.

 

Also, re: your last mail. You can run into problems if you have worker
process recycling turned on in IIS6, but IIS5 should be OK (though if you
ever upgrade to IIS6 in the future...)

 

The problem with worker process recycling is that when IIS6 recycles the
worker process, the old one hangs around while it finishes servicing current
requests. A new worker process is started to service any new requests. So
there is a (admittedly, short) period of time while there will be two
processes running. If the new worker process tries to open the database file
before the old one goes away, you'll get errors.

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 2:30 pm
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Vladislav Panteleev]

Hello Andrew!

This is what you can read in the README_embedded.txt file:


---
Firebird 2.0 Embedded Server notes
---

1. GENERIC INFORMATION

  The embedded server is a fully functional server linked
  as a dynamic library (fbembed.dll). It has exactly the
  same features as the usual server and exports the
  standard Firebird API entrypoints.

2. ISSUES AND LIMITATIONS

  2.1. Registry

The Firebird registry entries are ignored. The root
directory of the embedded server is the directory of
its binary file (library).

  2.2. Database access

Client access can be only via the local protocol, 
i.e. NOT a TCP/IP connection string that includes 
the server name "localhost" or IP address 127.0.0.1. 

The embedded server supports only the local connect
to a database file path without a server name. The
client program gets an exclusive access to the
database file after successful connect.

The embedded server acts as a true local server for a single
client accessing databases on a local machine.  It can also
act as a remote gateway that redirects all network calls to
other hosts, just as the regular client library
does.

  2.3. Authentication and security

The security database (namely security2.fdb) is not used
in the embedded server and hence is not required. Any
user is able to attach to any database. Since both
the server and the client run in the same address space,
the security becomes just an agreement between both
sides which can be easily compromised.

But note that SQL privileges are still checked.

  2.4. Compatibility

You may run any number of applications with the embedded
server without any conflicts. Having IB/FB server running
is not a problem either.

But you should be aware that you cannot access single
database from a number of the embedded servers
simultaneously, because they have SuperServer architecture
and hence exclusively lock attached databases.

3. USAGE

  Just copy fbembed.dll, icudt30.dll, icuin30.dll and
  icuuc30.dll into the directory with your application.
  Then rename fbembed.dll to either fbclient.dll or
  gds32.dll depending on your database connectivity software.
  Then start your application and it will use the embedded
  server as a client library and will be able to access
  local datasases. You should also copy firebird.msg and
  firebird.conf (if necessary) to the same directory.

  If external libraries are required for your application,
  then you should have them separately. Most probably, it
  will be INTL support (fbintl.dll and fbintl.conf) or UDF
  libraries. To be able to use them, you should place them
  into the directory tree which emulates the Firebird server
  one, i.e. has subdirectories like /intl or /udf:

  c:\my_app\app.exe
  c:\my_app\gds32.dll
  c:\my_app\ib_util.dll
  c:\my_app\icudt30.dll
  c:\my_app\icuin30.dll
  c:\my_app\icuuc30.dll
  c:\my_app\firebird.conf
  c:\my_app\firebird.msg
  c:\my_app\intl\fbintl.dll
  c:\my_app\intl\fbintl.conf
  c:\my_app\udf\fbudf.dll

  If you want to place the Firebird files (excluding the
  renamed fbembed.dll) in another directory, you need to
  modify your firebird.conf and set RootDirectory to the
  Firebird directory tree. Example:

  c:\my_app\app.exe
  c:\my_app\gds32.dll
  c:\my_app\ib_util.dll
  c:\my_app\icudt30.dll
  c:\my_app\icuin30.dll
  c:\my_app\icuuc30.dll
  c:\my_app\firebird.conf
  d:\fb\firebird.msg
  d:\fb\intl\fbintl.dll
  c:\fb\intl\fbintl.conf
  d:\fb\udf\fbudf.dll

  firebird.conf:
  RootDirectory = d:\fb



С уважением Владислав Пантелеев,
http://panvladislav.1gb.ru
http://mobile.1gb.ru

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[AAbend (gmail)]

I do not know why gds32.dll is required in fb2 - but if I remove it I get an
error - but not your error (I posted here about 10 days ago)

 

Can you open that file with isql?

 

For convenience, I use the server version when developing - that way you can
log into the database and check things while the app is running. Once I got
it running I renamed the server type from 0 to 1 and deployed embedded
(after testing)

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Monday, January 01, 2007 10:54 PM
To: [EMAIL PROTECTED]; 'For users and developers of the Firebird .NET
providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Firebird embedded v2.0.

 

Why would gds32.dll be needed?

 

Thanks,

 

A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
AAbend (gmail)
Sent: Monday, January 01, 2007 9:45 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Which version of Firebird are you using? I just did this with Firebird 2 and
found a few anomalies. One is that you need to include the gds32.dll file in
the distribution even though there is no mention of  that from the
documentation I read. Also, make sure that all of your dll and exe files are
from the same version and that no odd versions (eg., a renamed fbclient.dll)
are hanging around. I got a similar message when I had some version mixup
going on. 

 

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 10:37 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

What's the complete exception? My guess is that there is some sort of
permissions problem.

 

Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)?

 

For IIS5 you need to give the ASPNET account read/write permissions to the
database file. For IIS6 you need to give whatever account your Application
Pool is running as read/write permissions to the file.

 

Also, re: your last mail. You can run into problems if you have worker
process recycling turned on in IIS6, but IIS5 should be OK (though if you
ever upgrade to IIS6 in the future...)

 

The problem with worker process recycling is that when IIS6 recycles the
worker process, the old one hangs around while it finishes servicing current
requests. A new worker process is started to service any new requests. So
there is a (admittedly, short) period of time while there will be two
processes running. If the new worker process tries to open the database file
before the old one goes away, you'll get errors.

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 2:30 pm
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

Re: [Firebird-net-provider] Connection string for embedded firebird

[Dean Harding]

> Below is the full text of the exception.

Well, I guess it doesn't give us the actual error code :)

> I am using Windows XP Pro.

My guess is still a file permission problem. Under XP Pro, ASP.NET runs as
the ASPNET user. So make sure that account has read/write access to the
file.

Dean.



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

Firebird embedded v2.0.

 

Why would gds32.dll be needed?

 

Thanks,

 

A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
AAbend (gmail)
Sent: Monday, January 01, 2007 9:45 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Which version of Firebird are you using? I just did this with Firebird 2 and
found a few anomalies. One is that you need to include the gds32.dll file in
the distribution even though there is no mention of  that from the
documentation I read. Also, make sure that all of your dll and exe files are
from the same version and that no odd versions (eg., a renamed fbclient.dll)
are hanging around. I got a similar message when I had some version mixup
going on. 

 

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 10:37 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

What's the complete exception? My guess is that there is some sort of
permissions problem.

 

Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)?

 

For IIS5 you need to give the ASPNET account read/write permissions to the
database file. For IIS6 you need to give whatever account your Application
Pool is running as read/write permissions to the file.

 

Also, re: your last mail. You can run into problems if you have worker
process recycling turned on in IIS6, but IIS5 should be OK (though if you
ever upgrade to IIS6 in the future...)

 

The problem with worker process recycling is that when IIS6 recycles the
worker process, the old one hangs around while it finishes servicing current
requests. A new worker process is started to service any new requests. So
there is a (admittedly, short) period of time while there will be two
processes running. If the new worker process tries to open the database file
before the old one goes away, you'll get errors.

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 2:30 pm
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV__

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

Below is the full text of the exception.

 

I am using Windows XP Pro.

 


I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file 


Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code. 

Exception Details: FirebirdSql.Data.Firebird.FbException: I/O error for file
CreateFile (open) "D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while
trying to open file

Source Error: 


 
Line 86: //MCSConnection myConnection = new
MCSConnection(System.Configuration.ConfigurationSettings.AppSettings["DBConn
ectionString"]);
Line 87: #endif
Line 88:   myConnection.Open();
Line 89: #if MSSQL
Line 90:   SqlCommand UsersSelectCommand = new
SqlCommand(sSQLSelectUsers, myConnection);  


Source File: d:\web sites\callrecording\20060426\login.aspx.csLine: 88 

Stack Trace: 


 
[FbException: I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB"
Error while trying to open file]
   FirebirdSql.Data.Firebird.FbConnectionInternal.Connect()
   FirebirdSql.Data.Firebird.FbConnectionPool.Create()
   FirebirdSql.Data.Firebird.FbConnectionPool.CheckOut()
   FirebirdSql.Data.Firebird.FbConnection.Open()
   CallRecording.login.bLogin_Click(Object sender, ImageClickEventArgs e) in
d:\web sites\callrecording\20060426\login.aspx.cs:88
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e)
 
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.Ra
isePostBackEvent(String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   System.Web.UI.Page.ProcessRequestMain()

 

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 9:37 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

What's the complete exception? My guess is that there is some sort of
permissions problem.

 

Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)?

 

For IIS5 you need to give the ASPNET account read/write permissions to the
database file. For IIS6 you need to give whatever account your Application
Pool is running as read/write permissions to the file.

 

Also, re: your last mail. You can run into problems if you have worker
process recycling turned on in IIS6, but IIS5 should be OK (though if you
ever upgrade to IIS6 in the future...)

 

The problem with worker process recycling is that when IIS6 recycles the
worker process, the old one hangs around while it finishes servicing current
requests. A new worker process is started to service any new requests. So
there is a (admittedly, short) period of time while there will be two
processes running. If the new worker process tries to open the database file
before the old one goes away, you'll get errors.

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 2:30 pm
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

De

Re: [Firebird-net-provider] Connection string for embedded firebird

[AAbend (gmail)]

Which version of Firebird are you using? I just did this with Firebird 2 and
found a few anomalies. One is that you need to include the gds32.dll file in
the distribution even though there is no mention of  that from the
documentation I read. Also, make sure that all of your dll and exe files are
from the same version and that no odd versions (eg., a renamed fbclient.dll)
are hanging around. I got a similar message when I had some version mixup
going on. 

 

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 10:37 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

What's the complete exception? My guess is that there is some sort of
permissions problem.

 

Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)?

 

For IIS5 you need to give the ASPNET account read/write permissions to the
database file. For IIS6 you need to give whatever account your Application
Pool is running as read/write permissions to the file.

 

Also, re: your last mail. You can run into problems if you have worker
process recycling turned on in IIS6, but IIS5 should be OK (though if you
ever upgrade to IIS6 in the future...)

 

The problem with worker process recycling is that when IIS6 recycles the
worker process, the old one hangs around while it finishes servicing current
requests. A new worker process is started to service any new requests. So
there is a (admittedly, short) period of time while there will be two
processes running. If the new worker process tries to open the database file
before the old one goes away, you'll get errors.

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 2:30 pm
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Dean Harding]

What's the complete exception? My guess is that there is some sort of
permissions problem.

 

Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)?

 

For IIS5 you need to give the ASPNET account read/write permissions to the
database file. For IIS6 you need to give whatever account your Application
Pool is running as read/write permissions to the file.

 

Also, re: your last mail. You can run into problems if you have worker
process recycling turned on in IIS6, but IIS5 should be OK (though if you
ever upgrade to IIS6 in the future...)

 

The problem with worker process recycling is that when IIS6 recycles the
worker process, the old one hangs around while it finishes servicing current
requests. A new worker process is started to service any new requests. So
there is a (admittedly, short) period of time while there will be two
processes running. If the new worker process tries to open the database file
before the old one goes away, you'll get errors.

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 2:30 pm
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

Here is the error reported by .Net:

 

I/O error for file CreateFile (open)
"D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open
file

 

However, no other process has the file open.

- A

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

Thanks for the detailed reply. 

 

You raise an important point I am not trying to use Firebird embedded with a
web farm, but I am trying to use it with a web site. Will this fail for the
same reasons?

 

Thanks,

 

Andrew

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird

 

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection string for embedded firebird

[Dean Harding]

Personally, I prefer the use of the FbConnectionStringBuilder class, the
following works:

 

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

cs.ServerType = FbServerType.Embedded;

cs.Database = fileName;

 

Calling ToString() on this returns:

 

"Initial Catalog={fileName}; Server Type=Embedded"

 

Notice that you don't need to specify a user name/password - there is not
security in embedded mode. Also, you can use the text of the enumeration for
Server Type ("Embedded" is more readable than "1")

 

What is the error that you get? It could be a file system permissions thing.
Also remember that embedded mode acts like super server - meaing you cannot
open the same database file from different processes. This is important if
you're trying to run in embedded on a web farm or something (you basically
can't do it); it also proves problematic in the event of worker process
recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a
website).

 

Dean.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Chalk
Sent: Tuesday, 2 January 2007 12:56 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Connection string for embedded firebird

 

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Connection string for embedded firebird

[Andrew Chalk]

Could someone give me or refer me to some example connection strings for the
embedded version of Firebird? My string below gets an error opening the
file.

 



 

 

Many thanks.

 

__

 Communications Solutions



7000 Independence Pkwy., Ste. 160-227

Plano, TX 75025 USA

(972) 377-9074

www.magnacartasoftware.com

  [EMAIL PROTECTED]

  [EMAIL PROTECTED]

 
[EMAIL PROTECTED]

 

 



image001.gif
Description: GIF image
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider