> I am using the PostgreODBC(Ansi Driver).
> when I describe the source table, varchar(255) datatype is converted into
> Long datatype..
There is Max varchar (implicitly 254) in Datasource configuration.
Let's try increase the value. You don't specify OS, psqlodbc version
so I'm unable to give you better advice.
> In one table I have two fields (say c1 and c2) which are varchar(255) in
> Source Postgre System.they both are converted into Long.Due to which I can
> not query those two fields simultaneously in my select qyery.
> select c1 from table - works fine
> select c2 from table - works fine
> select c1,c2 from table - does not work
What does it mean "does not work"? What error or problem do you get?
In response to
pgsql-odbc by date
|Next:||From: Ludek Finstrle||Date: 2006-04-25 12:57:02|
|Subject: Re: Driver could not be loaded (0) SQLSTATE=IM002|
|Previous:||From: Srimathi Chandrasekaran||Date: 2006-04-25 12:10:47|
|Subject: Driver could not be loaded (0) SQLSTATE=IM002|