Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem with the 'date' data type and msaccess95 :(

problem with the 'date' data type and msaccess95 :(

From
Walt Bigelow
Date:
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@stimpy.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

Re: [SQL] problem with the 'date' data type and msaccess95 :(

From
"Jose' Soares Da Silva"
Date:
On Mon, 1 Jun 1998, Walt Bigelow wrote:

> 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
Try psqlodbc v06.30.0243 at:
(http://www.insightdist.com/psqlodbc).
                                              Jose'