Thread

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

   Walt Bigelow <walt@stimpy.com> — 1998-06-01T22:49:13Z

   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
   
   
   
   

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

   jose' soares <sferac@bo.nettuno.it> — 1998-06-02T11:42:43Z

   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'