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 > >
