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

Hey,

I’m not sure what happened, but after restarting the PC, it started working. I am sure I restarted after installing the driver, but perhaps I didn’t…?

But we have data!
[cid:image001(dot)png(at)01D54529(dot)2509C2B0]

THANK YOU SO MUCH!

I am curious – what was the original error with TIMESTAMP? What lines of code did you change?

Thanks.

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

From: Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
Sent: Friday, 26 July 2019 2:29 PM
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,
On 2019/07/25 15:27, michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com> wrote:
Hey,

I turned it on;
[cid:image002(dot)jpg(at)01D54529(dot)2509C2B0]

But the only time something is written to the trace is when I open up the configuration window, and click OK;

[cid:image003(dot)jpg(at)01D54529(dot)2509C2B0]

[cid:image004(dot)jpg(at)01D54529(dot)2509C2B0]

postgreSQL
51 ‘Tags in Model’
SQLpostgres.LOG

Microsoft SQL
17 ‘Tags in Model’
SQLmsql.LOG

But when I right-click and start the DataLog;

[cid:image005(dot)jpg(at)01D54529(dot)2509C2B0]

Nothing is added to the SQL.LOG file/ODBC Tracing.

Data is successfully being logged to Microsoft SQL at this point – but still no additional data in the ODBC Tracing.

So there seems no ODBC API call.
Would you like to see the page www.plctalk.net/qanda/archive/index.php/t-109368.html<http://www.plctalk.net/qanda/archive/index.php/t-109368.html> ?

regards,
Hiroshi Inoue

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>

[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png]<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>

ウイルス フリー｡ www.avg.com<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>