Visual Basic with Oracle V6

Hello Oracle-Freeks,

I've very small experience to oracle, but problems with it.

We want to use Oracle Database running on a Novell-Server, in connection with Visual Basic 3.0. (Since 2 Weeks)

I think, that I have followed the advices in Oracle.txt

	Oracle Installer 	3.0.8.3.6
	Support Files    	7.0.10.5.0
	SQL*Net SPX for Windows 1.1.1.3

I succeeded in running SQL-Plus for Windows without any Problems, and without any DOS SQLPME or SQLSPX Drivers.

SQLPLUSW (and also old versions of SQLPME and SQLSPX) are installed in C:\ORACLE6\BIN (Rests of a DOS-installation).

The above Installation is in c:\orawin.

I succeed in connecting to the Database with Christal-Reports.

The Installation of VB-ODBC ends with a warning, that the "config" is not set (as adviced in oracle.txt).

Sample VISDATA ends with a memory-error in VBDB300.DLL alt 000A:1B0F.

Self made programms succeed in Opening the Database and in Creating a Dynaset (which takes lots of time, 15-20 seconds for a very short Table) and filling a list box with the Contents of the Table. But it is not possible to write anything into the Database like Creating a Table  (exactly the same Error of VISDATA occurs).

Also VB3.0 does not accept all SQL-Strings, that are accepted by Oracle. This SQL-Strings should not be computed by VB, but passed to Oracle.

Now I have the following questions:

• Did anybody succeed in using Visual Basic 3.0 as front End of Oracle (Novell)?
• Did you have the same Problems with performance?
• Can anybody help us?

I would be lucky, if you forget my terrible english, and i would get any help.

So long

Schmitz_at_alf1.ngate.uni-regensburg.de Received on Wed Sep 22 1993 - 09:03:48 CEST