Visual Basic, ODBC, and Case sensitivity

Thread View: comp.lang.basic.visual

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by anturner@sc1500. Mon, 10 Jan 1994 20:54

#23

Author: anturner@sc1500.
Date: Mon, 10 Jan 1994 20:54

33 lines
1347 bytes

We have a project using VB accessing Oracle data via ODBC.

Does anyone know if a VB-Oracle API exists that will allow
direct calls from Visual Basic to Oracle?  We would like to
do some benchmarking comparing a VB-Oracle API with VB-ODBC.

Has anyone encountered a situation using Visual Basic's
data control to access Oracle where the SQL commands sent are
converted to all upper-case?  This occurs when we use the data
control's DB_SQLPassthrough option of VB to send a SQL command
to Oracle via ODBC.  Our Oracle table name and column names
were all lower-case as was our SQL statement.  We received an
error from Oracle indicating the requested table could not be
found.  When we changed our table and column names within the
VB code to all upper-case, the table was found and data was
returned.

We have also found that when we do not use the DB_SQLPassthrough
option and allow ODBC to format the SQL statement, it is successful
regardless of the case of the table name or column names.  However,
this method of access is approximately 4x slower on the initial
connect and read and 10x slower on subsequent reads when compared
to the use of DB_SQLPassthrough.

I will consolidate any responses I receive and post a summary.

Thanks,

Alan N. Turner
Systems and Equipment Sector
Texas Instruments, Inc.
anturner@sc1500.dseg.ti.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads