Hi Jeff, 

From error stack trace, looks like Forms fails to get any table through odbc driver. Could you confirm is there any table existing?

If no, please try create a table then add data source again.

Another guess is that escape sequence needs to be set properly, please check https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-us/administration/Default.htm#../Subsystems/Forms/Content/Settings/ODBC-Data-Sources.htm

Hello Ziyan,

Yes there are existing tables.

Also for Escape Sequence, the ODBC Driver the customer is using (U2) is not listed in the Options.

Is the issue, that LF does not support the U2 ODBC Driver.

U2 Driver is for UniData or UniVerse DB

http://www.u2-world.com/article.php?group_id=319&id=20

Appreciate the feedback,

Jeff Curtis

The option is not listed since Forms has not been tested with U2 ODBC driver. I can have team test it when time permits and get back to you later.

To confirm, what is the OS of UniData/UniVerse DB? 

Hello Ziyan,

Should I open a Support Case for this?

Appreciate your feedback,

Jeff Curtis

Yes, please open a support case with more information for the issue. Thanks!

Thanks Ziyan

Will open a case shortly

@████████

We setup an test environment internally as following:

App Version:

• Forms: 10.4.4.444
• Rocket Unidata: 8.2.1.9124（64bit)
• Rocket U2Client: 5.2.0 (64bit)

Actions:

• Install Forms on machine
• Install Unidata on machine, remember the account when installing
• Use U2Client AutoRun.exe to install Rocket U2ODBC and Rocket U2 UCI on machine​
• Use UCIEditor64.exe to create a new UCI datasource (please take action according to material: https://docs.rocketsoftware.com/nxt/gateway.dll/RKBnew20/u2%20clients%20and%20apis/previous%20versions/v5.1.0/u2clients_uciconfigurationeditoruserguide_v510.pdf). All use default settings (please view attached UCIConfig.png)
• Configure U2 ODBC driver (please take action according to material: https://docs.rocketsoftware.com/nxt/gateway.dll/RKBnew20/u2%20clients%20and%20apis/previous%20versions/v5.1.0/u2clients_u2odbcdevguide_v510.pdf). I used the database 'demo' which was already existing after installing unidata with window user configured when installing unidata. (please view attached U2ODBCConfig.png)

We can create a data source using the U2 ODBC with the 'demo' database successfully.  Please check what are the differences between your setup and ours and update the support case if you want further investigation. 

Hello- If this environment is still setup, would it be possible to get a video from you all of the steps you took to get this to work.  Customer is requesting this.

Appreciate your time,

Jeff Curtis

We no longer have the environment setup, I uploaded some screenshots we took when tested the driver.

Thanks Xiuhong

I have passed this along to the customer.

Jeff Curtis

Hello Xiuhong,

Customer is requesting a WebEx to walk through the steps you provided.

Please let me know if this is a possibility or not.

Appreciate your time,

Jeff Curtis

Hi Jeff,

Is there any difference between customer's configuration and our test environment? Is it possible for customer to provide related configuration (like above attached SS) for review first?

Hello Ziyan,

I am checking with the customer to see if they can provide the necessary screenshots.

Thanks,

Jeff Curtis

Hello Ziyan,

Attached is a PDF with the Steps/Error user gets after successfully setting up the Data Connection.

Thanks,

Jeff Curtis

Hi Jeff,

I've reviewed the provided setup and looks like configurations are expected. The difference I noticed is u2 server version, and database being used.

Have you got demo database (used in our test) installed when installing u2 server? If yes, could you try to connect to demo database to see whether still got same error? 

If you can do C# testing, you can try 

var tables = _Connection.GetSchema("Tables");

with odbc connection. Here is example test code https://stackoverflow.com/questions/16695817/how-can-i-get-schema-information-about-a-unidata-universe-database

Forms is looking for data rows with TABLE_SCHEM column is null, or value except INFORMATION_SCHEMA and SYS. I am not sure whether it is applicable to customer's database as I am not familiar with u2.

Regards,

Ziyan