Hello:
Some questions :)
In the directory X:\Program Files\fyracle-0.8.9\bin\assembly i have:
FirebirdSql.Data.FirebirdClient.dll ( .pdb )
FirebirdSql.ExternalEngine.Samples.dll (.pdb ) <- This is the assembly
with the stored procedure implementations
In the directory X:\Program Files\fyracle-0.8.9\plugins i have:
CLRExternalEngine.dll (.pdb )
Did you have this in the same way ??
Ok, and now the database table contents, how do you have them ??:
INSERT INTO RDB$EXTERNAL_ENGINE (RDB$LANGUAGE, RDB$MODULE_NAME) VALUES
('DOTNET', 'clrexternalengine');
COMMIT WORK;
INSERT INTO RDB$EXTERNAL_FUNCTIONS (RDB$FUNCTION_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('CURRENTDATE
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::CurrentDate',
'DOTNET');
COMMIT WORK;
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('GET_EMP_PROJ
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::GetEmployeeProject',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('ADD_EMP_PROJ
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::AddEmployeeProject',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('SUB_TOT_BUDGET
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::SubTotalBudget',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('TESTDATE
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::TestDate',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('SHIP_ORDER
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::ShipOrder',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('TESTTIME
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::TestTime',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('GET_JOB_REQUIREMENTS
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::GetJobRequirements',
'DOTNET');
INSERT INTO RDB$EXTERNAL_PROCEDURES (RDB$PROCEDURE_NAME,
RDB$EXTERNAL_NAME, RDB$LANGUAGE) VALUES ('TESTTIMESTAMP
',
'FirebirdSql.ExternalEngine.Samples.Employee,FirebirdSql.ExternalEngine.Samples::TestTimestamp',
'DOTNET');
COMMIT WORK;
--
Carlos Guzmán Álvarez
Vigo-Spain
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
