pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem with the 'date' data type and msaccess95 :(
2+ messages / 2 participants
[nested] [flat]
* problem with the 'date' data type and msaccess95 :(
@ 1998-06-01 22:49 Walt Bigelow <walt@stimpy.com>
0 siblings, 1 reply; 2+ messages in thread
From: Walt Bigelow @ 1998-06-01 22:49 UTC (permalink / raw)
To: 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@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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] problem with the 'date' data type and msaccess95 :(
@ 1998-06-02 11:42 Jose' Soares Da Silva <sferac@bo.nettuno.it>
parent: Walt Bigelow <walt@stimpy.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jose' Soares Da Silva @ 1998-06-02 11:42 UTC (permalink / raw)
To: Walt Bigelow <walt@stimpy.com>; +Cc: pgsql-sql
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'
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-06-02 11:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-01 22:49 problem with the 'date' data type and msaccess95 :( Walt Bigelow <walt@stimpy.com>
1998-06-02 11:42 ` Jose' Soares Da Silva <sferac@bo.nettuno.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox