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

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old May 25th, 2005, 02:38 AM
el soledad el soledad is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2005
Location: Malaysia
Posts: 6 el soledad User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 35 m 11 sec
Reputation Power: 0
MS ASP.NET Web Matrix with FirebirdSql

does anyone know wat's the problem with this code? it works fine if i connect to Sql Server and fill a dataset. the code is as follows:

.
.
.
using FirebirdSql.Data.Firebird;
.
.
.
[WebMethod]
public DataSet newDS {
string strcon = "...";

string strcom = "...";

FbConnection fbcon = new FbConnection(strcon);
FbDataAdapter da = new FbDataAdapter(strcom, strcon);
DataSet ds = new DataSet();

da.Fill(ds, "tableName");

return ds;
}

the error message is as follows:

Compiler Error Message: CS0246: The type or namespace name 'FirebirdSql' could not be found (are you missing a using directive or an assembly reference?)

Source Error:


Line 4: using System.Web.Services;
Line 5: using System.Xml.Serialization;
Line 6: using FirebirdSql.Data.Firebird;

Reply With Quote
  #2  
Old May 25th, 2005, 08:26 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
Talking

you need to add the dll (.net provider) to the reference folder in vs.net

ps: i found the answer on google , don't know too much about vs
__________________
My home page: http://www.firebirdsql.org and work place :http://www.reea.net

Reply With Quote
  #3  
Old May 25th, 2005, 08:57 PM
el soledad el soledad is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2005
Location: Malaysia
Posts: 6 el soledad User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 35 m 11 sec
Reputation Power: 0
thanks for the idea. i have added the .net provider to my class reference in Web Matrix and VS.Net. the problem is more like this. i run the app in Web Matrix, it will say "namespace name 'FirebirdSql' could not be found" but when i run it in VS.Net, the Web Service's method will show but will not work once i click on the "Invoke" button. the supposed xml generated thereafter appears to be empty.

Reply With Quote
  #4  
Old May 29th, 2005, 09:06 PM
el soledad el soledad is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2005
Location: Malaysia
Posts: 6 el soledad User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 35 m 11 sec
Reputation Power: 0
The problem has been solved. The Web Service actually works fine in my own PC. I tested it by writing an app to call that WS. It works fine. Thanks.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > MS ASP.NET Web Matrix with FirebirdSql


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
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