Acess throughing ODBC Errors

This is a multipart message in MIME format.

------=_NextPart_000_0031_01C85C24.0CC90DA0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I have a table (Types) that I should be able to add data too.



I can on the INT fields but when it comes to attempting to add it to VARCHAR
it throughs ODBC errors.



This is strange as it works on one machine but not another, and on other
tables with VARCHAR datatypes it works ok but not on this one. Does anyone
know why this happens and if so, a way around it??


------=_NextPart_000_0031_01C85C24.0CC90DA0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: Acess throughing ODBC Errors

Hello,

Steve Coleman-Williams wrote:
>
> I have a table (Types) that I should be able to add data too.
>
>
>
> I can on the INT fields but when it comes to attempting to add it to
> VARCHAR it throughs ODBC errors.
>
>
>

Please show us this error message DSN settings (or connection string)
and ODBC driver version.

> This is strange as it works on one machine but not another, and on
> other tables with VARCHAR datatypes it works ok but not on this one.
> Does anyone know why this happens and if so, a way around it??
>

Do you use the same ODBC driver on both machines? Are you trying ot
access the same remote Database?

--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate