Re: interface between Visual Basic and Oracle

mrichter_at_oracle.uucp (Mark Richter) writes:

>In article <27130_at_rnd.GBA.NYU.EDU> atuzhili_at_rnd.GBA.NYU.EDU (Alexander Tuzhilin) writes:
>>I'm trying to develop an application using a full-fledged relational
>>database on a PC under MS-Windows. The application must therefore have
>>a nice Graphical User Interface (GUI). I was thinking of using Oracle
>>as the database and Visual Basic as the programming language since it
>>has a nice GUI. Does anyone have any experience using the two
>>together?
>>
 

>Yes. You can write in Visual Basic and use Oracle for Windows. OFW has
>a DDE Manager component. The DDE Manager is a DDE server that runs in
>its own window. It allows you to send SQL to Oracle using the DDE
>protocol and receive data back into the program. Works very well for
>small amounts of data. I haven't got any experience trying it on large
>amounts of data, however.
 

>I've placed a sample application and a technical paper on the Oracle
>Forum (GO ORACLE) on Compuserve. Look in section #1 for VBDDEM.EXE.
 

>I have a library of VB calls in there
>that isolates all of the DDE nastyness from your code. If you like I
>can email you the source (it's not long) to these calls. If there
>is sufficient interest I can post it here, as well.

From my experience a better product is Q+E Database Library from Pioneer Software. It is a library of .DLL files that allow the sending of SQL statements to the database product, even if it doesn't support SQL. Supported databases that I know of are:

	IBM DB2
	dBase
	Excel worksheet files
	Novell's NetWare SQL
	Oracle
	IBM OS/2 Extended Edition Database Manager
	Paradox
	Sybase
	Microsoft SQL Server products
	ASCII text files.

John

-- 
John Trappett                           ....     o       
Telecom Australia                      ....   _/\_>      
trappetj_at_cheops.qld.tne.oz.au           .....O,> / O...