Yes, I do test DSN connection itself. It returns "Success. Connection was made". I am creating User DSN. The only tool able to connect to my UNIX databases via ODBC driver is MS-Access, not Excel. 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