I am helping another witango user(Mark Weiss), with a setup of OS X
10.3.9 server with 5.5.009, Openlink iODBC 3.52.1 connecting to
Primebase 4.2.49 also running on OS X.
The issue has to do with errors inserting timestamps. I made a test
with my setup, which is identical, 5.5.009, and Primebase 4.2.49, but
I am using Windows, not OS X.
I have checked the setup of his database server, and the witango
server, and they are setup the same as mine, but look at debug when
he inserts a timestamp:
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Normally, I would see the timestamp escaped, like this below, a test
from my system:
I VERIFIED that both test were inserted with action like so:
So, why is witango escaping on mine, and not his system? Does witango
escape when certain conditions apply with ODBC? What are those
conditions, so I can check with Primebase? When I use other tools, I
do not see issues with ts inserts, and I have verified that both ODBC/
DB systems on both machines are expecting date in YYYY-MM-DD
HH:MM:SS, standard SQLTimeStamp format.
I have verified that on the OS X system, mark did not alter the DB so
that it looks for a different format.
Hoping Support, or someone on the list may have some insight.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
