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