Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Firebird SQL Development
Reload this Page

Using FB Embedded in ASP.NET Web Application?

Discuss Using FB Embedded in ASP.NET Web Application? in the Firebird SQL Development forum on Dev Shed.
Using FB Embedded in ASP.NET Web Application? Firebird SQL Development forum discussing administration, Firebird SQL syntax, or other Firebird SQL-related topics. Firebird is the evolution of Borland's Interbase product.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 13th, 2005, 09:33 AM
BaBaBooey BaBaBooey is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 1 BaBaBooey User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 32 sec
Reputation Power: 0
Using FB Embedded in ASP.NET Web Application?
Hi,

Would it be possible/wise to use Firebird's embedded DLL engine in a ASP.NET web application? I know the embedded engine is for single user desktop applications but I still have to ask about this situation. Has anyone used Firebird's embedded DLL engine in a ASP/ASP.NET web application before?

Thanks in advance!
Reply With Quote
  #2  
Old February 13th, 2005, 03:12 PM
ademirtug ademirtug is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 9 ademirtug User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 45 m 34 sec
Reputation Power: 0
download the embedded server at http://prdownloads.sourceforge.net/firebird/Firebird-1.5.2.4731_embed_win32.zip and copy fbembed.dll into the "bin" directory, in order to connect to the server you can use Firebird .net driver.
Reply With Quote
  #3  
Old February 21st, 2005, 11:10 AM
bLiTzJoN bLiTzJoN is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 3 bLiTzJoN User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 46 sec
Reputation Power: 0
Send a message via ICQ to bLiTzJoN Send a message via AIM to bLiTzJoN Send a message via MSN to bLiTzJoN Send a message via Yahoo to bLiTzJoN
I can find that information anywhere, but I have yet to actually hear anyone try it with success. I keep getting "Exception Details: System.DllNotFoundException: Unable to load DLL (fbembed)." no matter where I put the dll. I even put it in the /bin & / directory adding full aspnet priviledges.

This would be VERY cool to get working and use. I have many applications where embedding a database would be ideal to work around host limitations and have enterprise level db capabilities.
Reply With Quote
  #4  
Old February 21st, 2005, 03:08 PM
ademirtug ademirtug is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 9 ademirtug User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 45 m 34 sec
Reputation Power: 0
Quote:
Originally Posted by bLiTzJoN
no matter where I put the dll. I even put it in the /bin & / directory


Set the directory as an "IIS Application"
Reply With Quote
  #5  
Old February 22nd, 2005, 01:04 PM
bLiTzJoN bLiTzJoN is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 3 bLiTzJoN User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 46 sec
Reputation Power: 0
Send a message via ICQ to bLiTzJoN Send a message via AIM to bLiTzJoN Send a message via MSN to bLiTzJoN Send a message via Yahoo to bLiTzJoN
Thumbs down Didn't work
Do you happen to have an example solution? I set up the directory to grant full control to the ASPNET & the IIS Guest account, allow Scripts & Execute with Write access & even set the Application protection to Low (I would never find someone to host this app if this was all necessary). I copied all the files in the application root & bin directory. Still not working.

I know it's either not possible or something very very simple. I have zipped up my sample solution for anyone to play with. I would love to hear how someone got theirs to work.

I'm using 1.7 RC1 connector along with embeded 1.5.2.4731 server. I used 1.6.3 connector (required hashtable connection string instead of using the FbConnectionStringBuilder) with same results.
Reply With Quote
  #6  
Old February 23rd, 2005, 09:23 AM
fetcher fetcher is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Portugal
Posts: 106 fetcher User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 11 m 33 sec
Reputation Power: 6
I opened your zip file and I just changed the database string to this
Code:
fbConn.Database = "c:\\inetpub\\wwwroot\\samplefirebird\\sample.fbd"


and it worked.... I think. At least it didn't give any errors, so I suppose it created the database .. and I didn't have to change any permissions in any directory
Reply With Quote
  #7  
Old February 23rd, 2005, 11:37 AM
fetcher fetcher is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Portugal
Posts: 106 fetcher User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 11 m 33 sec
Reputation Power: 6
First I add to create a database(I used IBExpert). Then I gave the necessary write permissions and I used this code

Code:
        Dim fb As New FirebirdSql.Data.Firebird.FbConnection
        Dim fbConn As New FirebirdSql.Data.Firebird.FbConnectionStringBuilder
        fbConn.ServerType = 1
        fbConn.Database = "c:\\inetpub\\wwwroot\\samplefirebird\\DATA.FDB"
        fbConn.DataSource = "localhost"
        fbConn.UserID = "SYSDBA"
        fbConn.Password = "masterkey"
        fbConn.Dialect = 3
        Dim fbcon As New FirebirdSql.Data.Firebird.FbConnection(fbConn.ToString())

        fbcon.Open()
        Dim fbc As New FirebirdSql.Data.Firebird.FbDataAdapter("select * from teste", fbcon)
        Dim ds As New DataSet
        fbc.Fill(ds)
        DataGrid1.DataSource = ds
        DataGrid1.DataBind()


and it worked
Reply With Quote
  #8  
Old February 23rd, 2005, 09:45 PM
bLiTzJoN bLiTzJoN is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 3 bLiTzJoN User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 46 sec
Reputation Power: 0
Send a message via ICQ to bLiTzJoN Send a message via AIM to bLiTzJoN Send a message via MSN to bLiTzJoN Send a message via Yahoo to bLiTzJoN
Thumbs up We are getting somewhere now!
Finally, some answers! I appreciate your contribution. You say you have set permissions to "write". Was that the directory /data? I added "write" to the directory through IS Manager and I am still receiving: "I/O error for file CreateFile (create) "C:\INETPUB\WWWROOT\SAMPLEFIREBIRD\DATA\SAMPLE.FBD" Error while trying to create file" The directory path is correct, just need to figure out the correct permissions.

At least I know it is trying to do something now!
Reply With Quote
  #9  
Old February 24th, 2005, 04:25 AM
fetcher fetcher is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Portugal
Posts: 106 fetcher User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 11 m 33 sec
Reputation Power: 6
I gave permissions to the directory. Write permissions to the ASP.NET user. If it still doesnt work try giving write permssions to NETWORK SERVICE and IWAN_{...}.... and if still doesn't work, lol give full control to everyone, for testing purposes only
Reply With Quote
  #10  
Old March 1st, 2005, 03:35 AM
mariuz's Avatar
mariuz mariuz is offline
Bug Hunter
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 274 mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9
Quote:
Originally Posted by fetcher
I gave permissions to the directory. Write permissions to the ASP.NET user. If it still doesnt work try giving write permssions to NETWORK SERVICE and IWAN_{...}.... and if still doesn't work, lol give full control to everyone, for testing purposes only


On server is better to use superserver or classic (on machines with many real processors)
__________________
My home page: http://www.firebirdsql.org and work place :http://www.reea.net
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Using FB Embedded in ASP.NET Web Application?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway. 
Stay green...Green IT