#12 []s produce Oracle error
Version 3.01. In UT_Class.INC in lines 1010 and 1232
classify the file name. In 1010 brackets are included in
the file name to allow for MS Access table names with
spaces. The brackets through an error if you are
accessing an Oracle table. Removal of the brackets
allows Oracle to work OK. In line 1232 the table name
does not have brackets and will not cause an error
unless an Access table has spaces. One resolution to
the situation would be to add a system varible to hold
the file type and use it to stage an IF-Then to build the
table name. The problem is compounded if you use both
Oracle and Access with UTE. In that case there needs
to be some way to ID what kind of database you are
hitting. In Oracle the logged in user would have to have
sufficient rights to read some kind of ID.
Does anyone know how to find out what kind of
database you are hitting through checking with only ASP
or VBscript or maybe Javascript? If you could ID the
database you could then employ an IF-THEN or a CASE
to configure the table name. Maybe only need to ID if it
is an Access database then do an IF ACCESS THEN
statement.
Ideas?
Logged In: NO
Same problem occurs when trying to access IBM DB2 Tables as
well.
Number: -2147217900 (80040E14)
Category: IBM OLE DB Provider for DB2
File: ute_class.inc
Line: 1010
Description: [DB2] SQL0104N An unexpected token "[" was
found following "". Expected tokens may include: "( TABLE
<IDENTIFIER> ". SQLSTATE=42601
Logged In: NO
Same problem occurs when trying to access IBM DB2 Tables as
well.
Number: -2147217900 (80040E14)
Category: IBM OLE DB Provider for DB2
File: ute_class.inc
Line: 1010
Description: [DB2] SQL0104N An unexpected token "[" was
found following "". Expected tokens may include: "( TABLE
<IDENTIFIER> ". SQLSTATE=42601