Shawn, I would like to thank you for your great help, no apologies needed. I have gone through most of the steps describe by you myself in the search for the answers. I am going to take this up with Systat Software people, now. Thank you again, Mikhail Berman
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 3:02 PM 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 > > > > > >