List:General Discussion« Previous MessageNext Message »
From:Mikhail Berman Date:April 28 2005 6:13pm
Subject:RE: Does anyone have experience?
View as plain text  
See inserts below 

________________________________

From: SGreen@stripped [mailto:SGreen@stripped] 
Sent: Thursday, April 28, 2005 12:36 PM
To: Berman, Mikhail
Cc: mysql@stripped
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" <mberman@stripped> 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: SGreen@stripped [mailto:SGreen@stripped] 
> Sent: Thursday, April 28, 2005 11:41 AM
> To: Berman, Mikhail
> Cc: mysql@stripped
> Subject: RE: Does anyone have experience?

> 
> 
> "Berman, Mikhail" <mberman@stripped> 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: SGreen@stripped [mailto:SGreen@stripped] 
> > Sent: Thursday, April 28, 2005 10:39 AM
> > To: Berman, Mikhail
> > Cc: mysql@stripped
> > Subject: Re: Does anyone have experience?
> > 
> > 
> > 
> > 
> > "Berman, Mikhail" <mberman@stripped> 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:mberman@stripped] 
> > > Sent: Wednesday, April 27, 2005 9:57 AM
> > > To: myodbc@stripped
> > > 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 
> > 
> > 

Thread
Does anyone have experience?Mikhail Berman28 Apr
  • Re: Does anyone have experience?SGreen28 Apr
RE: Does anyone have experience?Mikhail Berman28 Apr
  • RE: Does anyone have experience?SGreen28 Apr
RE: Does anyone have experience?Mikhail Berman28 Apr
  • RE: Does anyone have experience?SGreen28 Apr
RE: Does anyone have experience?Mikhail Berman28 Apr
  • RE: Does anyone have experience?SGreen28 Apr
    • RE: Does anyone have experience?mathias fatene28 Apr
      • RE: Does anyone have experience?SGreen28 Apr
RE: Does anyone have experience?Mikhail Berman28 Apr
RE: Does anyone have experience?Mikhail Berman28 Apr