I do believe that a problem is with SigmaPlot itself, because of all research we have done. And, an additional fact that SigmaPlot ODBC connection works properly with DSN created for MS-Access, but not with DSN to MySQL. Best Mikhail Berman
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 3:27 PM To: mathias fatene Cc: Berman, Mikhail; mysql@lists.mysql.com Subject: RE: Does anyone have experience? MySQL is not listed in the screenshot because that is a sample screenshot provided by the **manufacturer**, not a screen shot from his installation. I was trying to use it to get a sense of how many connection-specific options he may have had control over from within SigmaPlot. Basically, it appears that if he has already created (and tested) a MySQL DSN in the ODBC manager, it should show up in the list. If picking it from the list didn't work then I think the program is probably broken. I think he shares that opinion as his last post said he was taking the issue up with the manufacturer. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "mathias fatene" <[EMAIL PROTECTED]> wrote on 04/28/2005 03:22:55 PM: > Hi, > Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html > > One can't see the mysql ODBC driver in your snapshot. > > Best Regards > -------------------- > Mathias FATENE > > Hope that helps > *This not an official mysql support answer > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: jeudi 28 avril 2005 21:02 > To: Berman, Mikhail > Cc: mysql@lists.mysql.com > Subject: RE: Does anyone have experience? > > > Thank you for being so patient with me. What options does SigmaPlot give > > you when selecting an ODBC data source? Have you verified that you are > either using the default settings (as you defined when you set up the > connection) or that you are using the same credentials you used to test > your ODBC connection? > > Looking at this screen shot > (http://www.systat.com/products/SigmaPlot/productinfo/pop_nf_odimp.html) > I > think the ODBC datasource interface gives you the choices to use a DSN > you > already created or to make another one from scratch. If selecting an > already-tested and working DSN from this list continues to fail, then I > think this is an issue you need to take up with the manufacturer of > SigmaPlot. After further research I found out the using ODBC is *new* to > > v9.0. Some new features still have some bugs to work out and your > problems > may be caused by one of those. > > As a workaround, you may be able to use Access or Excel as crutches to > get > at your MySQL data then get the data from one of them into SigmaPlot. > However, if you can use your MySQL server and you can use an ODBC > connection with another program to get at your MySQL data then it seems > very likely to me that the problem is going to be in SigmaPlot. Have you > > tried their online forums or their "contact a technician" links? > (http://www.systat.com/products/SigmaPlot/resources/?sec=1019) > > Again, thank you for your patience and I am very sorry I couldn't be > more > helpful, > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 02:13:29 PM: > > > See inserts below > > > > ________________________________ > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 28, 2005 12:36 PM > > To: Berman, Mikhail > > Cc: mysql@lists.mysql.com > > Subject: RE: Does anyone have experience? > > > > > > > > OK, I am still confused. Let's run down the list of what's working and > > > what isn't: > > > > a) In the ODBC manager, create a System DSN and click on the TEST > > CONNECTION button. What happens? > > > > ODBC manager returns - "Success. Connection was made" > > > > b) In SigmaPlot, tell the software to use the connection you just > > created and tested. What happens? > > > > SigmaPlot returns - "Cannot connect to data source" > > > > If we can't get the ODBC manager to connect, nothing else using that > > DSN can possibly connect. The fact that your MySQL database is in a > > different machine running a different OS is not important. What is > > important is that you are using a user account to make your connection > > > (a MySQL user account, NOT an OS user account) that has privileges and > > > that you can connect to the server and authenticate with that > > account's credentials. > > > > If for some reason there is a firewall between your XP machine and > > your MySQL server, that can also cause a failure to connect. Can you > > ping the server from your XP machine? Can you telnet from your XP > > machine to your MySQL server on port 3660? (You cannot create a > > normal telnet session with a MySQL server. However, if you can see the > > > version of the server surrounded by several lines of gibberish, this > > telnet test was successful. ) > > > > I work freely with MySQL servers from XP machine as a part of my daily > > > routine. > > > > The reason I keep going back to ODBC is that I want to make absolutely > > > certain that this is not the weak link. If all ODBC tests are good > > then we need to look at the connection between SigmaPlot and ODBC as > > the problem. > > > > > > Shawn Green > > Database Administrator > > Unimin Corporation - Spruce Pine > > > > > > > > "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 11:59:27 > > AM: > > > > > Hi, > > > > > > I do use Data Sources(ODBC) manager to create DSNs. > > > > > > Either User or System DSN failed to connect from SysPlot to UNIX > > > databases, with the same error message "Cannot connect to data > source" > > > > > > > > > > > Sorry I was not precise in description, I have mentioned MS-Access > > > vs. Excel only to raised a point that ODBC should work similarly > > > with both tools, but it does not. > > > I am aware of row limitation for Excel so my test are ran against > > > the tables that are under Excel limitations > > > > > > Regards, > > > > > > Mikhail Berman > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, April 28, 2005 11:41 AM > > > To: Berman, Mikhail > > > Cc: mysql@lists.mysql.com > > > Subject: RE: Does anyone have experience? > > > > > > > > > > > "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 10:50:17 > > AM: > > > > > > > Yes, > > > > > > > > I do test DSN connection itself. It returns "Success. Connection > > > > was made". I am creating User DSN. > > > > > > > > > > That's a good sign. > > > > > > > The only tool able to connect to my UNIX databases via ODBC driver > > is > > > > MS-Access, not Excel. > > > > > > If you are on XP (as you say) there is an ODBC Manager separate from > > > > all other programs. Look under Start -> Control Panel -> > > > Administrative Tools -> (this is where I get lost. I don't use XP at > > > work.) -> Data Sources (ODBC). That's the tool I wanted you to use, > > > not Access. You don't need to use MS Access in order to work with > > > ODBC DSNs ( unless you really want to.) > > > > > > If you can create a sucessful "system" DSN connection (I don't > > > create "user" DSNs for applications, I always make them "system" > > > DSNs) then what problem are you having telling SigmaPlot to use the > > > DSN you created? > > > > > > Shawn Green > > > Database Administrator > > > Unimin Corporation - Spruce Pine > > > > > > > > > > > Regards, > > > > > > > > Mikhail Berman > > > > > > > > ________________________________ > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, April 28, 2005 10:39 AM > > > > To: Berman, Mikhail > > > > Cc: mysql@lists.mysql.com > > > > Subject: Re: Does anyone have experience? > > > > > > > > > > > > > > > > > > > > "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 > > > > 10:32:53 > > AM: > > > > > > > > > Hi, > > > > > > > > > > I am promoting this E-mail to larger list in hope to find people > > who > > > > can > > > > > help me. > > > > > > > > > > Regards, > > > > > > > > > > Mikhail Berman > > > > > > > > > > -----Original Message----- > > > > > From: Berman, Mikhail [mailto:[EMAIL PROTECTED] > > > > > Sent: Wednesday, April 27, 2005 9:57 AM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: Does anyone have experience? > > > > > > > > > > Hi everyone, > > > > > > > > > > Does anyone have experience connecting statistical tool > > > > > SigmaPlot > > 9.01 > > > > > from Systat Software (http://www.systat.com/products/sigmaplot/) > > to > > > > > MySQL databases running on: > > > > > > > > > > > > > > > 1. mysql> status > > > > > -------------- > > > > > mysql Ver 14.7 Distrib 4.1.9, for sun-solaris2.8 (sparc) > > > > > > > > > > And > > > > > > > > > > 1. mysql> status > > > > > -------------- > > > > > mysql Ver 11.13 Distrib 3.23.36, for sun-solaris2.7 (sparc) > > > > > > > > > > > > > > > Through MySQL ODBC driver v.3.51.10.00 installed on Windows XP > > Home > > > > > Edition machine. > > > > > > > > > > All my attempts to connect have failed. SigmaPlot returns " > > > > > Cannot connect to data source." > > > > > > > > > > Best, > > > > > > > > > > Mikhail Berman > > > > > > > > > > > > > Can you get a good "connection test" if you just use the ODBC > > manager? > > > > While you attempt to create a DSN, there is a button on the > > interface to > > > > "test" the connection parameters you just entered. Please tell us > > the > > > > result of that test. > > > > > > > > Shawn Green > > > > Database Administrator > > > > Unimin Corporation - Spruce Pine > > > > > > > > >
