hola a todos. tengo un problema al conectarme con una base de datos en firebird, tengo una aplicación de consola en c# que trabaja perfectamente, pero al ejecutarla desde un web service no hace nada. acaso me faltará algún componente? alguien podría darme alguna pista? esta es la aplicacion de consola que funciona:
string connectionString;
connectionString = "DRIVER=Firebird/InterBase® driver;UID=SYSDBA;PWD=masterkey;DBNAME=C:/Inetpub/wwwroot/database.FDB";
OdbcConnection connection = new OdbcConnection(connectionString);
connection.Open();
string sSQL ="";
sSQL = ("select JV.TO_STOPAREA_ID, JV.VEHICLE_ID, V.VEHICLE_ID, V.VEHICLE_TYPE_ID, VC.UNIT_XCAP, VC.UNIT_YCAP, VC.VEHICLE_TYPE_ID "
+"from JVEHICLE JV, VEHICLE V, vehiclecap VC "
+"where JV.TO_STOPAREA_ID = 14418223 "
+ "AND V.VEHICLE_ID = 11 "
+ "AND VC.vehicle_type_id = 10 ");
OdbcDataAdapter daReservationInfo = new OdbcDataAdapter(sSQL,connection);
DataSet dsPubs = new DataSet("Pubs");
daReservationInfo.FillSchema(dsPubs,SchemaType.Source, "ReservationInfo");
daReservationInfo.Fill(dsPubs,"ReservationInfo");
DataTable tblReservationInfo;
tblReservationInfo = dsPubs.Tables["ReservationInfo"];
foreach (DataRow drCurrent in tblReservationInfo.Rows)
{
Console.WriteLine("TO_STOPAREA_ID:{0}, VEHICLE_ID:{1}, VEHICLE_ID:{2}, VEHICLE_TYPE_ID:{3}, UNIT_XCAP:{4} UNIT_XCAP:{5} VEHICLE_TYPE_ID:{6}",
drCurrent["TO_STOPAREA_ID"].ToString(),
drCurrent["VEHICLE_ID"].ToString(),
drCurrent["VEHICLE_ID"].ToString(),
drCurrent["VEHICLE_TYPE_ID"].ToString(),
drCurrent["UNIT_XCAP"].ToString(),
drCurrent["UNIT_YCAP"].ToString(),
drCurrent["VEHICLE_TYPE_ID"].ToString());
}
y en mi web service (que no funciona) la escribo así:
string connectionString;
connectionString = "DRIVER=Firebird/InterBase® driver;UID=SYSDBA;PWD=masterkey;DBNAME=C:/Inetpub/wwwroot/MTBS1704.02.FDB";
OdbcConnection connection = new OdbcConnection(connectionString);
connection.Open();
string sSQL ="";
sSQL = ("select JV.TO_STOPAREA_ID, JV.VEHICLE_ID, V.VEHICLE_ID, V.VEHICLE_TYPE_ID, VC.UNIT_XCAP, VC.UNIT_YCAP, VC.VEHICLE_TYPE_ID "
+"from JVEHICLE JV, VEHICLE V, vehiclecap VC "
+"where JV.TO_STOPAREA_ID = 14418223 "
+ "AND V.VEHICLE_ID = 11 "
+ "AND VC.vehicle_type_id = 10 ");
OdbcDataAdapter daReservationInfo = new OdbcDataAdapter(sSQL,connection);
DataSet dsPubs = new DataSet("Pubs");
daReservationInfo.FillSchema(dsPubs,SchemaType.Source, "ReservationInfo");
daReservationInfo.Fill(dsPubs,"ReservationInfo");
DataTable tblReservationInfo;
tblReservationInfo = dsPubs.Tables["ReservationInfo"];
por favor, si alguien sabe por que pasa esto, explíqueme
