AnsweredAssumed Answered

Cannot retrieve text value from FM data source via ODBC (with 11.3.76 driver)

Question asked by IwaoAVE! on Jan 13, 2011
Latest reply on Jul 7, 2011 by IwaoAVE!

Summary

Cannot retrieve text value from FM data source via ODBC (with 11.3.76 driver)

Product

FileMaker Pro

Version

11v2

Operating system version

Windows XP SP3

Description of the issue

I am still unable to get text values from FM data source via ODBC if the 'maximum number of characters' validation option is not specified for the field.
I have installed the new FileMaker ODBC client driver (11.03.76.00).

Steps to reproduce the problem

1. Create new database (test.fp7).
2. Create a text field 'f1' in the table 'test'.
3. Input 'abc' in the field 'f1' in browse mode.
4. Publish the file using ODBC/JDBC protocol.
5. Create a VBScript 'fm11_ado.vbs' (see below).
6. Execute the script (double click .vbs in explorer).

[fm11_ado.vbs]
Set Cn = CreateObject("ADODB.Connection")
Set Rs = CreateObject("ADODB.RecordSet")

Query = "select f1 from test"
ConnectionString = "Provider=MSDASQL;" & _
"Persist Security Info=False;" & _
"AutoDetectEncoding=No;" & _
"MultiByteEncoding=UTF-8;" & _
"UseLongVarchar=Yes;" & _
"User Id=admin;" & _
"Password=;" & _
"DRIVER={FileMaker ODBC};" & _
"SERVER=127.0.0.1;" & _
"DATABASE=test;"

Cn.Open ConnectionString
Rs.Open Query, Cn

Do While not Rs.EOF
  Wscript.Echo "Result is " & Rs.Fields(0).Value
  Rs.MoveNext
Loop

Rs.Close
Cn.Close

Expected result

A dialog box with a string "Result is abc" is displayed.

Actual result

A dialog box with a string "Result is " is displayed (retrieved data is an empty string).

Exact text of any error message(s) that appear

No error occurs.

Configuration information

I have tried several different combination of connection string parameters, but none of them worked.

Workaround

Set 'maximum number of characters' validation option to field 'f1'.
There is no workaround for a calculation field because the option is not available.

Outcomes