odbc not returning column names
Posted by:
Steve Harp
Date: January 04, 2011 02:20PM
Hi All,
I'm using Delphi 2007 and MySql ODBC v 5.01.08 from 10/28/2010. Using a TQuery object, I can do inserts and updates without problems. However, when I do a select, I don't get any columns returned. I can take my select statement and copy it into MySql Query Browser and it executes just fine returning the expected result set. I've also tried my queries with another tool that uses ODBC and the queries work fine. It must be an issue in the configuration of my TDatabase, TSession, or TQuery.
Here's my DataModules' DFM:
object dbVsFTP: TDatabase
AliasName = 'VsFTP-Steve-Dev'
DatabaseName = 'VsFTP-MySql'
LoginPrompt = False
Params.Strings = (
'USER NAME=root'
'PASSWORD=mucoolpassword')
SessionName = 'sesVsFtp'
BeforeConnect = dbVsFTPBeforeConnect
OnLogin = dbVsFTPLogin
Left = 32
Top = 24
end
object sesVsFtp: TSession
Active = True
SessionName = 'sesVsFtp'
Left = 32
Top = 72
end
object qryUser: TQuery
DatabaseName = 'VsFTP-MySql'
SessionName = 'sesVsFtp'
Left = 88
Top = 24
end
What am I missing?
TIA
Subject
Written By
Posted
odbc not returning column names
January 04, 2011 02:20PM
February 01, 2011 04:47PM
February 02, 2011 07:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.