Skip site navigation (1) Skip section navigation (2)

Re: Access97/odbcUnicode/pgsql : unable to map text field

From: "Bronto" <brontos(at)hotpop(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field
Date: 2006-06-09 15:44:29
Message-ID: 20060609154433.76F5024FCD12@smtp-3.hotpop.com (view raw or flat)
Thread:
Lists: pgsql-odbc
(Tested)Data type matching:
-----------------------------------------------
|	ACCESS		         |	    POSTGRESQL     |
-----------------------------------------------
|     Text			      |    Varchar(255)	    |
|     Memo			      |    Varchar(65535)   |
| Number: Integer		   |    Int 2		       |
|         Long Integer	|    Int 4		       |
|	    Single		      |    Float 4	       |
|	    Double		      |    Float 8          |
|	   Date/Time	      |    TimeStamp        |
| AutoNumber: Long	   | 	  Serial	          |
|	   Yes/No (Boolean)  |	  Int 2		       |
|	 OLE Object		      |	  ByteA		       |
-----------------------------------------------

ODBC Driver Settings:

--------
|Page 1|
--------

- Check "Disable generic optimizer"
- Check "KSQO..."
- Check "Recognize unique indexes"
- Set "Unknown sizes" to "Maximum"
- Check "Text as LongVarChar"
- Set "Max Varchar" to 255

--------
|Page 2|
--------

- Check "LF <-> CR/LF conversion"
- Check "bytea as LO"
- Check "True is -1"
- Set "Int8 As" to "double"

Make sure you use the ANSI driver

Hope it helps.


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08.06.2006
 

In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-06-09 15:53:07
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field
Previous:From: JGuillaume 'IoGuiX' de RorthaisDate: 2006-06-09 15:37:26
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group