pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problem 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>
  1998-06-02 11:42 ` Re: [SQL] problem with the 'date' data type and msaccess95 :( Jose' Soares Da Silva <sferac@bo.nettuno.it>
  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-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>
  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