|
|
Sponsor |
Empty text field returning x: msg#00002db.mysql.odbc
I am using the MySQL ODBC driver version 3.51 to export data from MySQL version 3.23 to SQL Server 2005 and am having problems with text fields with an empty string being returned with an 'x'. I have done a lot of searching and have not found anyone else that seems to have this problem, so I'm assuming I must have a setting wrong in my driver. I've gone in to the driver settings and checked/unchecked any settings that I thought could be related, but each time the same results were returned. I would appreciate any help you could provide. I'm using the Openquery function in SQL Server to execute the query. Below is my very simple select query which when Field2 and Field3 actually contain an empty space, but is being returned as an x: SELECT * FROM OPENQUERY(LinkedServer, 'SELECT Field2, Field3 FROM MySQLTable WHERE Field1 = 49') Thanks, Wendy Schuman
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: Connector/ODBC installation problem, Jess Balint |
|---|---|
| Next by Date: | Connector/ODBC installation problem, Alexander Andriyanov |
| Previous by Thread: | Connector/ODBC installation problem, Alexander Andriyanov |
| Next by Thread: | Temporary tables, Jean-Claude DAVID |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home | sitemap
| advertise | OSDir is
an inevitable website.
|