We have a rather complex C++ app that uses MySQL, as well as MSSQL7 and
Oracle in conjunction with Microsoft's Transaction Server.
After considerable trial and error, we have foudn we need to use four of the
options which effect the behaviour of MyODBC ...
- Don't optimize column width
- Return matching rows
- Use manager cursors (exp)
- Return table names in SQLDescribeCol
G. Jensen
----- Original Message -----
From: "Øystein Selbekk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 1:55 AM
Subject: MyODBC - Long varchar
>
> Hi, we are testing out MySQL, too se if it might meet our needs.
> We are currently having problems returning Text fields from the database
through ODBC.
> System:
> Win NT 4.0
> Visual Basic 6.0 Ent.
> RDO (Remote data objekts, must use!)
> MySQL servers both on W32 and Linux
>
> The first record in the result contains the correct content of the Text
field, but the rest returns NULL. Is there any setting that might fix this
problem?
>
> Another thing: show fields from #tablename# returns 1 record more in a
Linux MySQL server than in the W32. Is there a way to control how much info
that is returned?
>
> Regards Øystein Selbekk, Visbook AS
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
