Re: Visual Basic & Dlls With Oracle
Date: 28 Sep 1994 16:07:36 GMT
Message-ID: <36c4c8$qrd_at_news.nd.edu>
In article <779930998snz_at_vitesse.demon.co.uk> rich_at_vitesse.demon.co.uk writes:
>Thanks for reading this (anyone). If I've made any Internet blunders I
>appologise in advance. I'm new.
>
>I wanted to know how to find the call parameters of the Oracle SQL*NET Dll's
>in Visual Basic. I know Visual Basic can call Dlls, but you need to know the
>type and number of all the parameters passed and returned (right?).
>
>Oracle won't give me them. They've not said it can't be done, but want me
>not by a grand or two of software to do it. I'm sure it can be done.
They may be telling the truth somewhat. Their DLL's may require you to pass and recieve special structures/strings that VB cannot generate. You can get around this though. You'd have to write some wrapper functions in your own DLL which would act as a gateway between VB and the Oracle DLL's. Pretty much what Oracle*Glue would do for you.
>
>I get the feeling that ODBC grabs all the tables that you have access to at
>login, slowing logins down, which is no use, 'cos all I want to do is run a
>standard query on tables that won't change, so basically I want quick access
>via Windows with a pre-written query.
I don't know what ODBC does, but all I hear is that it slows things down. This is why I wrote the previous article entitled 'ODBC performance Vs. Oracle*Glue' I still haven't received any specs from anyone as of yet.
>
>Hope someone can help!
>
>P.S. Would it be easier writing it in some other language?
IMHO, VB provides the most flexibility.
>
>Rich.
>--
>Rich Shepard
Received on Wed Sep 28 1994 - 17:07:36 CET