RE: Does anyone have experience?
I do believe that a problem is with SigmaPlot itself, because of all research we have done. And, an additional fact that SigmaPlot ODBC connection works properly with DSN created for MS-Access, but not with DSN to MySQL. Best Mikhail Berman From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 3:27 PM To: mathias fatene Cc: Berman, Mikhail; mysql@lists.mysql.com Subject: RE: Does anyone have experience? MySQL is not listed in the screenshot because that is a sample screenshot provided by the **manufacturer**, not a screen shot from his installation. I was trying to use it to get a sense of how many connection-specific options he may have had control over from within SigmaPlot. Basically, it appears that if he has already created (and tested) a MySQL DSN in the ODBC manager, it should show up in the list. If picking it from the list didn't work then I think the program is probably broken. I think he shares that opinion as his last post said he was taking the issue up with the manufacturer. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "mathias fatene" <[EMAIL PROTECTED]> wrote on 04/28/2005 03:22:55 PM: > Hi, > Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html > > One can't see the mysql ODBC driver in your snapshot. > > Best Regards > > Mathias FATENE > > Hope that helps > *This not an official mysql support answer > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: jeudi 28 avril 2005 21:02 > To: Berman, Mikhail > Cc: mysql@lists.mysql.com > Subject: RE: Does anyone have experience? > > > Thank you for being so patient with me. What options does SigmaPlot give > > you when selecting an ODBC data source? Have you verified that you are > either using the default settings (as you defined when you set up the > connection) or that you are using the same credentials you used to test > your ODBC connection? > > Looking at this screen shot > (http://www.systat.com/products/SigmaPlot/productinfo/pop_nf_odimp.html) > I > think the ODBC datasource interface gives you the choices to use a DSN > you > already created or to make another one from scratch. If selecting an > already-tested and working DSN from this list continues to fail, then I > think this is an issue you need to take up with the manufacturer of > SigmaPlot. After further research I found out the using ODBC is *new* to > > v9.0. Some new features still have some bugs to work out and your > problems > may be caused by one of those. > > As a workaround, you may be able to use Access or Excel as crutches to > get > at your MySQL data then get the data from one of them into SigmaPlot. > However, if you can use your MySQL server and you can use an ODBC > connection with another program to get at your MySQL data then it seems > very likely to me that the problem is going to be in SigmaPlot. Have you > > tried their online forums or their "contact a technician" links? > (http://www.systat.com/products/SigmaPlot/resources/?sec=1019) > > Again, thank you for your patience and I am very sorry I couldn't be > more > helpful, > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 02:13:29 PM: > > > See inserts below > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 28, 2005 12:36 PM > > To: Berman, Mikhail > > Cc: mysql@lists.mysql.com > > 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
RE: Does anyone have experience?
MySQL is not listed in the screenshot because that is a sample screenshot provided by the **manufacturer**, not a screen shot from his installation. I was trying to use it to get a sense of how many connection-specific options he may have had control over from within SigmaPlot. Basically, it appears that if he has already created (and tested) a MySQL DSN in the ODBC manager, it should show up in the list. If picking it from the list didn't work then I think the program is probably broken. I think he shares that opinion as his last post said he was taking the issue up with the manufacturer. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "mathias fatene" <[EMAIL PROTECTED]> wrote on 04/28/2005 03:22:55 PM: > Hi, > Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html > > One can't see the mysql ODBC driver in your snapshot. > > Best Regards > > Mathias FATENE > > Hope that helps > *This not an official mysql support answer > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: jeudi 28 avril 2005 21:02 > To: Berman, Mikhail > Cc: mysql@lists.mysql.com > Subject: RE: Does anyone have experience? > > > Thank you for being so patient with me. What options does SigmaPlot give > > you when selecting an ODBC data source? Have you verified that you are > either using the default settings (as you defined when you set up the > connection) or that you are using the same credentials you used to test > your ODBC connection? > > Looking at this screen shot > (http://www.systat.com/products/SigmaPlot/productinfo/pop_nf_odimp.html) > I > think the ODBC datasource interface gives you the choices to use a DSN > you > already created or to make another one from scratch. If selecting an > already-tested and working DSN from this list continues to fail, then I > think this is an issue you need to take up with the manufacturer of > SigmaPlot. After further research I found out the using ODBC is *new* to > > v9.0. Some new features still have some bugs to work out and your > problems > may be caused by one of those. > > As a workaround, you may be able to use Access or Excel as crutches to > get > at your MySQL data then get the data from one of them into SigmaPlot. > However, if you can use your MySQL server and you can use an ODBC > connection with another program to get at your MySQL data then it seems > very likely to me that the problem is going to be in SigmaPlot. Have you > > tried their online forums or their "contact a technician" links? > (http://www.systat.com/products/SigmaPlot/resources/?sec=1019) > > Again, thank you for your patience and I am very sorry I couldn't be > more > helpful, > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 02:13:29 PM: > > > See inserts below > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 28, 2005 12:36 PM > > To: Berman, Mikhail > > Cc: mysql@lists.mysql.com > > 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. Howev
RE: Does anyone have experience?
Hi, Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html One can't see the mysql ODBC driver in your snapshot. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: jeudi 28 avril 2005 21:02 To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: RE: Does anyone have experience? Thank you for being so patient with me. What options does SigmaPlot give you when selecting an ODBC data source? Have you verified that you are either using the default settings (as you defined when you set up the connection) or that you are using the same credentials you used to test your ODBC connection? Looking at this screen shot (http://www.systat.com/products/SigmaPlot/productinfo/pop_nf_odimp.html) I think the ODBC datasource interface gives you the choices to use a DSN you already created or to make another one from scratch. If selecting an already-tested and working DSN from this list continues to fail, then I think this is an issue you need to take up with the manufacturer of SigmaPlot. After further research I found out the using ODBC is *new* to v9.0. Some new features still have some bugs to work out and your problems may be caused by one of those. As a workaround, you may be able to use Access or Excel as crutches to get at your MySQL data then get the data from one of them into SigmaPlot. However, if you can use your MySQL server and you can use an ODBC connection with another program to get at your MySQL data then it seems very likely to me that the problem is going to be in SigmaPlot. Have you tried their online forums or their "contact a technician" links? (http://www.systat.com/products/SigmaPlot/resources/?sec=1019) Again, thank you for your patience and I am very sorry I couldn't be more helpful, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 02:13:29 PM: > See inserts below > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 28, 2005 12:36 PM > To: Berman, Mikhail > Cc: mysql@lists.mysql.com > 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" <[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 th
RE: Does anyone have experience?
Shawn, I would like to thank you for your great help, no apologies needed. I have gone through most of the steps describe by you myself in the search for the answers. I am going to take this up with Systat Software people, now. Thank you again, Mikhail Berman From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 3:02 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: RE: Does anyone have experience? Thank you for being so patient with me. What options does SigmaPlot give you when selecting an ODBC data source? Have you verified that you are either using the default settings (as you defined when you set up the connection) or that you are using the same credentials you used to test your ODBC connection? Looking at this screen shot (http://www.systat.com/products/SigmaPlot/productinfo/pop_nf_odimp.html) I think the ODBC datasource interface gives you the choices to use a DSN you already created or to make another one from scratch. If selecting an already-tested and working DSN from this list continues to fail, then I think this is an issue you need to take up with the manufacturer of SigmaPlot. After further research I found out the using ODBC is *new* to v9.0. Some new features still have some bugs to work out and your problems may be caused by one of those. As a workaround, you may be able to use Access or Excel as crutches to get at your MySQL data then get the data from one of them into SigmaPlot. However, if you can use your MySQL server and you can use an ODBC connection with another program to get at your MySQL data then it seems very likely to me that the problem is going to be in SigmaPlot. Have you tried their online forums or their "contact a technician" links? (http://www.systat.com/products/SigmaPlot/resources/?sec=1019) Again, thank you for your patience and I am very sorry I couldn't be more helpful, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 02:13:29 PM: > See inserts below > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 28, 2005 12:36 PM > To: Berman, Mikhail > Cc: mysql@lists.mysql.com > 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" <[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 a
RE: Does anyone have experience?
Thank you for being so patient with me. What options does SigmaPlot give you when selecting an ODBC data source? Have you verified that you are either using the default settings (as you defined when you set up the connection) or that you are using the same credentials you used to test your ODBC connection? Looking at this screen shot (http://www.systat.com/products/SigmaPlot/productinfo/pop_nf_odimp.html) I think the ODBC datasource interface gives you the choices to use a DSN you already created or to make another one from scratch. If selecting an already-tested and working DSN from this list continues to fail, then I think this is an issue you need to take up with the manufacturer of SigmaPlot. After further research I found out the using ODBC is *new* to v9.0. Some new features still have some bugs to work out and your problems may be caused by one of those. As a workaround, you may be able to use Access or Excel as crutches to get at your MySQL data then get the data from one of them into SigmaPlot. However, if you can use your MySQL server and you can use an ODBC connection with another program to get at your MySQL data then it seems very likely to me that the problem is going to be in SigmaPlot. Have you tried their online forums or their "contact a technician" links? (http://www.systat.com/products/SigmaPlot/resources/?sec=1019) Again, thank you for your patience and I am very sorry I couldn't be more helpful, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 02:13:29 PM: > See inserts below > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 28, 2005 12:36 PM > To: Berman, Mikhail > Cc: mysql@lists.mysql.com > 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" <[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:
RE: Does anyone have experience?
See inserts below From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 12:36 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com 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" <[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] > > >
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? 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
RE: Does anyone have experience?
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 > >
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 > >
RE: Does anyone have experience?
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
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
