Executing procedures in access db?

  • Thread starter Thread starter Edwin Knoppert
  • Start date Start date
E

Edwin Knoppert

I have a query using a module and function and executes fine in access.
When this query is executed from ASP.NET 2 it results in an error that the
function is not found.

Is there a way to let the jet engine call this function anyway?

I'm not looking for alternative VBA loading and executing technique.
 
The short answer is NO!.

You have to remember that the module and function you refer to are specific
to Microsoft Access which just happens to use a Jet database as it's data
repository.

From .NET, you are only connecting to the Jet database, not the Microsoft
Access application.

You will need to pull the raw data into your program and process it further
there.
 
I thought so.
to bad..

The instintric functions like IIF() and VAL() do work luckily.
 
Yes, because the Jet engine implements those and some other 'functions' as
part of the Jet dialect of SQL.

If however you 'set' the setting that tells Jet to use SQL-92 syntax then
some of those functions will not be available.
 
I also had this so far unanswered topic below: OnEvent OleDB?

Maybe ASP.NET 2 can proceduce an event per record to modify field RESULT
data?
I'm not interested in writting the fielddata, the resultset should show the
desired data based on a boolean field.
 
¤ I have a query using a module and function and executes fine in access.
¤ When this query is executed from ASP.NET 2 it results in an error that the
¤ function is not found.
¤
¤ Is there a way to let the jet engine call this function anyway?
¤
¤ I'm not looking for alternative VBA loading and executing technique.
¤

What is supported via Jet (and sandbox mode) is listed below:

How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003
http://support.microsoft.com/kb/294698/en-us


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top