>From your options is this what you have turned on?? 131072 Safe 512 Pad Char To Full Length 16 Don't Prompt Upon Connect 8 Allow Big Results 1 Don't Optimized Column Width
I am not sure what the first option is doing but the second one is the one that I am trying to not have happen. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: Friday, June 01, 2007 8:25 AM To: [EMAIL PROTECTED] Subject: Re: MySQL ODBC Brian Erickson wrote: > I am having a very big problem with the way Fox is interacting with the > MySQL odbc driver. Below is the connection string that I am using to > connect to my db server. There are a couple of problems that I am running > into. > 1. In a sql pass through any of the varchars on the server are coming > through as a char. That is not a problem the problem comes when I connect > the cursor to the backend server make a couple of changes and push updates. > All of the character fields get padded out with spaces. That is inflating > the db and causing problems with indexes and locate statements. > 2. If I open up an actual remote view and not use sqlexec() and not do > anything with the view for an amount of time then try to close the view I > get a fatal odbc error. SQL Server has gone away error number 2006. > > I have looked on line for some resolution but have not found any. > Server version: 5.0.32 > Driver version: 3.51.15.00 and 3.51.12.00 I have the same problems with > both versions. > > Is there any way to get the padding to sop and the disconnect to stop as > well????? > > DATABASE=atto;DRIVER={MySQL ODBC 3.51 > > I noticed right away that your OPTION value is different than mine: DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;UID=root;PWD=foxpro;DATABASE=mydb;option=131609 Try that one! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
