By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

calling my own VB code using ODBC ?

P: n/a
HI all,

is there a way to call my own VB Procedure from a .NET Application
using ODBC ? I tried different ways like:

SELECT myProc() FROM...
SELECT { fn myProc()} FROM...
SELECT { call myProc()} FROM...
SELECT { exec myProc()} FROM...

SELECT { fn now()} FROM.. for instance, works very well.
Is there a trick or any solution to execute my VB code ?
Im using Access 2000/ and,or 2003

thank you
Sven

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think the right (only?) way to do this is to use OLE Automation to
invoke Access to run your VBA code, and not ODBC. You'll have to look
around on MSDN, etc., to get the details for it, but it should be
possible via a COM-.Net bridge.

Jet (the access database query engine) doesn't do this, if I remember
correctly.

Are you having problems running queries in a MDB that use your own VBA
functions not working via ODBC?

Sven wrote:
HI all,

is there a way to call my own VB Procedure from a .NET Application
using ODBC ? I tried different ways like:

SELECT myProc() FROM...
SELECT { fn myProc()} FROM...
SELECT { call myProc()} FROM...
SELECT { exec myProc()} FROM...

SELECT { fn now()} FROM.. for instance, works very well.
Is there a trick or any solution to execute my VB code ?
Im using Access 2000/ and,or 2003

thank you
Sven

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.