MySQL Forums
Forum List  »  Delphi

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

Options: ReplyQuote


Subject
Written By
Posted
odbc not returning column names
January 04, 2011 02:20PM


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.