Problem with Blobs on XP Professional

Problem with Blobs on XP Professional

am 24.01.2006 13:32:04 von SSchmidt

This is a multipart message in MIME format.
--=_alternative 0044DB06C1257100_=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

An application, orginally developed in C++ under VS 6.0 which inserts=20
integers,varchar and binary large objects in a database (with=20
SQLPrepare(),=20
SQLBindParameter() and SQLExecute()). Originally the database was an=20
Oracle 8.x and the application runs under Windows 2000 (via ODBC). Then=20
we have tried a Postgres 8.x (on a server) and after changing the syntax=20
of some statements, it worked. Now I have Windows XP Professional V.2002,=20
SP 2 and .NET 1.1 and I get the error message: 'ERROR: type "lo" does not=20
exist'. I=B4ve tried various Versions of the ProsgreSQL OBDC driver. All wi=
th the=20
same result.

Any suggestions?

Regards,

Siegmar=20

--=_alternative 0044DB06C1257100_=
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



An application, orginally developed in C++ under VS =
6.0 which inserts integers,varchar and binary large objects in a database (=
with SQLPrepare(),

SQLBindParameter() and SQLExecute()). Originally the database was an Oracle=
8.x  and the application runs under Windows 2000 (via ODBC). Then

we have tried a Postgres 8.x (on a server) and after changing the syntax of=
some statements, it worked. Now I have Windows XP Professional V.2002, SP =
2 and .NET 1.1 and I get the error message: 'ERROR: type "lo" doe=
s not exist'.
I=B4ve tried v=
arious Versions of the ProsgreSQL OBDC driver. All with the same result. ont>



Any suggestions?



Regards,



Siegmar


--=_alternative 0044DB06C1257100_=--

Re: Problem with Blobs on XP Professional

am 24.01.2006 14:30:02 von Ludek Finstrle

> Oracle 8.x and the application runs under Windows 2000 (via ODBC). The=
n=20
> we have tried a Postgres 8.x (on a server) and after changing the synta=
x=20
> of some statements, it worked. Now I have Windows XP Professional V.200=
2,=20
> SP 2 and .NET 1.1 and I get the error message: 'ERROR: type "lo" does n=
ot=20
> exist'. I=B4ve tried various Versions of the ProsgreSQL OBDC driver. Al=
l
> with the same result.

Is the difference only in OS (could you write version of working OS)?=20

The problem has trivial solution in creating "lo" datatype. You could
find it in pgsql-odbc mailing list (in the end of year 2005) or
in FAQ (from CVS or maybe in official releases).

If you don't use large objects could you send us mylog output?

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match