RE: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'

Hi Hiroshi,

Firstly;

The changes you made meant that the ‘Create Tables’ is now working. Previously, it wouldn’t create ‘Float Table’ and ‘String Table’ – presumably because they were the two tables that had a TIMESTAMP column. I previously had to create them manually.

[cid:image005(dot)jpg(at)01D5412E(dot)54014C90]

Secondly;

Now when I click 'OK', I get the following error instead. So it appears the TIMESTAMP issue is fixed (what was the problem!?), but now a new problem;

[cid:image006(dot)jpg(at)01D5412E(dot)54014C90]

I have attached the mylog log.

Thanks for your time!

Regards,

Michael Riksman

Instrument and Control Specialist

Khalda Petroleum Co.

A KPC/Apache Corp. Joint Venture

Salam Base, Egypt

Mob: +20 122 0530603

Email: michael(dot)riksman(at)khalda-eg(dot)com

-----Original Message-----
From: Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
Sent: Tuesday, 23 July 2019 7:07 AM
To: Michael Riksman (Salam - Gas)
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'

Hi Michael,

Could you please try the test drivers 11.00.0100 on Windows at https://winpg.jp/~inoue/psqlodbc/index.html

?

regards,

Hiroshi Inoue

On 2019/07/23 13:24, michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com> wrote:

> Hi Hiroshi,

>

> I’ll try anything! Would be great to use PostgreSQL with an industrial software like Rockwell.

>

> Thanks :)

>

> Regards,

>

> Michael Riksman

>

> Sent from iPhone

>

> On 23 Jul 2019, at 1:14 am, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp<mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp>> wrote:

>

>  Hi Michael,

>

> Could you try the test driver if I provide a Windows test driver?

>

> regards,

> Hiroshi Inoue

>

> On 2019/07/18 18:18, michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com%3cmailto:michael(dot)riksman(at)khalda-eg(dot)com>> wrote:

> Hi,

>

>

> · your ODBC driver version

>

> psqlODBC is v11.01.000.

>

>

>

> SQL_DRIVER_ODBC_VER reports “3.51”

>

> [6608-0.002] info.c[PGAPI_GetInfo]71: entering...fInfoType=77

>

> [6608-0.002] info.c[PGAPI_GetInfo]1032: p='03.51', len=0, value=0, cbMax=12

>

>

>

> · your PostgreSQL database version

>

> v10.9 x86

>

> Running on Windows 10 32-bit

>

>

>

> · any error messages you saw on the screen

>

> The client application (Rockwell FactoryTalk), has a button which can automatically create the tables in an existing database.

> It created a table successfully that DID NOT have a TIMESTAMP column. But I had to manually create two tables that had a TIMESTAMP column.

> When I clicked ‘OK’ to accept the changes, I get this error;

>

> <image001.png>

>

> FactoryTalk works fine with Microsoft SQL ODBC.

>

>

> · the debug log (mylog_????.log) file (you will have to enable the mylog driver option)

>

> Attached.

>

>

>

>

>

>

> I ran the ODBC Test tool, and connected via ODBC version 2 (as this is

> what FactoryTalk appears to be using)

> [2892-0.001]odbcapi30.[SQLSetEnvAttr]477: Entering att=200,2

>

> I then ran a GetTypeInfo on SQL_TIMESTAMP(11), and it returns

> SQL_SUCCESS <image002.png>

>

> But in the logs, it shows this;

> [6608-1677.216]odbcapiw.c[SQLGetTypeInfoW]1015: Entering

> [6608-1677.216] info.c[PGAPI_GetTypeInfo]1115: entering...fSqlType=93

> [6608-1677.216]statement.[SC_recycle_statement]812: entering

> self=0052D2E0 [6608-1677.216] qresult.c[QR_Constructor]173: entering

> [6608-1677.216] qresult.c[QR_Constructor]242: leaving

> [6608-1677.216]statement.[SC_set_Result]531: (0052D2E0, 00539F48)

> [6608-1677.216] qresult.c[QR_Destructor]344: entering

> [6608-1677.216] bind.c[extend_column_bindings]718: entering ... self=0052D370, bindings_allocated=0, num_columns=19

> [6608-1677.216] bind.c[extend_column_bindings]762: leaving 004F8C30

> [6608-1677.216] qresult.c[QR_set_num_fields]40: entering

> [6608-1677.216] qresult.c[QR_set_num_fields]44: leaving

>

> It appears the fSQLType changed from SQL_TIMESTAMP(11) to SQL_TYPE_TIMESTAMP(93)…? Could this be what is causing the issue?

>

>

>

> Regards,

>

> Michael Riksman

> Instrument and Control Specialist

> Khalda Petroleum Co.

> A KPC/Apache Corp. Joint Venture

> Salam Base, Egypt

> Mob: +20 122 0530603

> Email:

> michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com%3cmailto:michael(dot)riksman(at)khalda-eg(dot)com>>