From: | Walt Bigelow <walt(at)stimpy(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | problem with the 'date' data type and msaccess95 :( |
Date: | 1998-06-01 22:49:13 |
Message-ID: | Pine.LNX.3.96.980601153854.1206A-100000@alice.stimpy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I've looked around a bit and I'm not sure if it has been asked before, but
I am using posgreSQL 6.3.2 and the ODBC driver postODBC 2.10.0004 and
microsoft access 95.
I transferred all my tables into the Sql server, and all is okay except
that access does not handel the date type for some reason. I create a
table like follows:
CREATE TABLE tbldate (date date);
Then insert a record:
INSERT INTO tbldate (date) VALUES ('11/10/1998');
then a select returns:
SELECT * from tbldate;
11-10-1998
For some reason, when I import that table "link" into Msaccess, it sees it
as a date but will display "#Name?" in the table, and create an error
message "ODBC--call failed" Is this a know incompatibility between access
and postgreSql? I would really rather user another front end system than
access, but I'm stuck with it :(
Thanks in advance!
Walt Bigelow
(ODBC trace follows)
walt(at)stimpy(dot)com
ODBC trace:
MSACCESS fff9c479:fff9d089 EXIT SQLBindParameter with
return code 0 (SQL_SUCCESS)
HSTMT 0x02db0078
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 9 <SQL_DATE>
UDWORD 10
SWORD 0
PTR 0x09571356
SDWORD 0
SDWORD * 0x09571352 (16)
MSACCESS fff9c479:fff9d089 ENTER SQLExecDirect
HSTMT 0x02db0078
UCHAR * 0x09572354 [ -3] "INSERT INTO
tbldate (date) VALUES (?)"
SDWORD -3
MSACCESS fff9c479:fff9d089 EXIT SQLExecDirect with return
code -1 (SQL_ERROR)
HSTMT 0x02db0078
UCHAR * 0x09572354 [ -3] "INSERT INTO
tbldate (date) VALUES (?)"
SDWORD -3
MSACCESS fff9c479:fff9d089 ENTER SQLError
HENV 0x031b05e0
HDBC 0x031b09d0
HSTMT 0x02db0078
UCHAR * 0x0062f160 (NYI)
SDWORD * 0x0062f188
UCHAR * 0x00691fb0
SWORD 8192
SWORD * 0x0062f192
MSACCESS fff9c479:fff9d089 ENTER SQLErrorW
HENV 0x031b05e0
HDBC 0x031b09d0
HSTMT 0x02db0078
WCHAR * 0x0062f104 (NYI)
SDWORD * 0x0062f188
WCHAR * 0x0062ed04
SWORD 1024
SWORD * 0x0062f192
MSACCESS fff9c479:fff9d089 EXIT SQLErrorW with return code
100 (SQL_NO_DATA_FOUND)
HENV 0x031b05e0
HDBC 0x031b09d0
HSTMT 0x02db0078
WCHAR * 0x0062f104 (NYI)
SDWORD * 0x0062f188
WCHAR * 0x0062ed04
SWORD 1024
SWORD * 0x0062f192
MSACCESS fff9c479:fff9d089 EXIT SQLError with return code
100 (SQL_NO_DATA_FOUND)
HENV 0x031b05e0
HDBC 0x031b09d0
HSTMT 0x02db0078
UCHAR * 0x0062f160 (NYI)
SDWORD * 0x0062f188
UCHAR * 0x00691fb0
SWORD 8192
SWORD * 0x0062f192
From | Date | Subject | |
---|---|---|---|
Next Message | Marin D | 1998-06-02 07:36:58 | timespan weirdness (fwd) |
Previous Message | Bruce Momjian | 1998-06-01 21:37:31 | Re: [SQL] SELECT Command? Messed again? |