O$ - Studio 6.1.2 SQL Browser and ODBC DAM
Denis Woodbury
denis at woodmic.net
Wed Jun 10 10:25:26 EDT 2015
Hi,
Just seen that my message got truncated, so here is the rest of the message
Maybe some of you have had this problem with Studio's SQL Browser Session
Current configuration:
OSX 10.10.3
Studio 6.1.2
Actual Technologies ODBC Driver 3.3.0
MS SQL Server 12.00.2000
>From an SQL session selecting any table and clicking on Show Data I¹m
getting this error at the bottom of the interactive SQL Browser Window
Error. Code # 208 : Actual:SQL Server: Invalid object name 'd'.
The select statement in the interactive SQL Window looks ok, for example:
SELECT * FROM dbo.F01_Groups
If I retype the table name dbo.F01_Groups in the interactive SQL Window the
statement works normally,
I noticed that when deleting the table name I had to backspace twice for
each letters, so I copied and pasted the table name in TextWrangler and it
appears with an upside down question mark between each letter of the table
name (MS Word shows invisible characters), I know it has to do with Unicode,
is there some session property I can set?
--------------
Meanwhile , US Support has replied with the following message
We have raised this as Fault ST/*B/110.
This appears to have been a fault that has been introduced into the o$6.1.2
ODBC DAM, as there are no issues with o$6.1.1.
Please note, we are not recommending that you replace the current DAM with
the one from o$6.1.1.
There are no switches or configurable items that will get you past this
problem.
The only workaround is as you have already found - you have to re-type the
SQL Text in the o$SQL Shell.
Your summation is correct, somehow Unicode data is being passed to/from the
SQL Shell by the DAM.
Plus, the fault is present when using earlier versions of the Actual
Technologies ODBC Driver, the O/S and the SQL Backend.
We replicated this problem using Actual Technologies ODBC Driver 3.2.6, Mac
OS X 10.8.x / 10.9.x and connecting to MS SQL Server 2005.
Denis
More information about the omnisdev-en
mailing list