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? b) In SigmaPlot, tell the software to use the connection you just created and tested. What happens? 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. ) 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 > > > >
