Chris Keen Posted February 6, 2011 Share Posted February 6, 2011 Hey everyone. I'm trying to get the Self Squadding started for the Ohio State Championship, but when I tried to upgrade my EzWinScore from 4.05 to 4.06 I now receive a Box that says "CONNECT TO ADAPTIVE SERVER ANYWHERE" and asks me for a User ID and password. When I try to enter any password I get a respnse that says "Cannot Connect to Infofile Database. EzWinScore cannot run unless it can access the infofile database. Report the following error to USPSA. SQLSTATE = 08001 [sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database server Also see the attached pic. Link to comment Share on other sites More sharing options...
Mark R Posted February 7, 2011 Share Posted February 7, 2011 (edited) Chris...I got that error when I accidentally removed the ODBC drivers on my system. After I re-installed them, I had to use the username and password for the EXWin software. Make sure you have all the ODBC connections...sounds like the infofile one maybe corrupt or missing. Will send you a PM. Edited February 7, 2011 by Mark R Link to comment Share on other sites More sharing options...
Jim Norman Posted February 7, 2011 Share Posted February 7, 2011 Anyone else having trouble? I have to upgrade and I don't want to get caught out not being able to score a match due to a funky problem with the software. Maybe I'll leave one system alone and see what happens first? Link to comment Share on other sites More sharing options...
Mark R Posted February 7, 2011 Share Posted February 7, 2011 (edited) I just upgraded from 4.05 to 4.06 and didn't appear to have any issues. Opened Ezwinscore and recalculated last match OK. I have a special classifier match this weekend...will update if I find any hiccups. Edited February 7, 2011 by Mark R Link to comment Share on other sites More sharing options...
Flexmoney Posted February 7, 2011 Share Posted February 7, 2011 Jim, I scored a match (this weekend) with 4.05, then upgraded to 4.06, and loaded the scores (plus a later correction) to the USPSA site with 4.06. Link to comment Share on other sites More sharing options...
Jim Norman Posted February 7, 2011 Share Posted February 7, 2011 Appreciated. I will upload this week. That gives me a few days to debug if I screw it up. Link to comment Share on other sites More sharing options...
High Lord Gomer Posted February 7, 2011 Share Posted February 7, 2011 I went from 4.03 to 4.06 with no problems. Link to comment Share on other sites More sharing options...
wgnoyes Posted February 8, 2011 Share Posted February 8, 2011 I scored a 50 competitor, 6 stage match with it yesterday. Link to comment Share on other sites More sharing options...
Skydiver Posted February 8, 2011 Share Posted February 8, 2011 4.06 worked well for me this weekend when I played guest stats person. My guess is that the failure the OP is seeing is forgetting to run EzWinScore as Administrator on a Vista or Win7 machine. Link to comment Share on other sites More sharing options...
Chris Keen Posted February 8, 2011 Author Share Posted February 8, 2011 4.06 worked well for me this weekend when I played guest stats person. My guess is that the failure the OP is seeing is forgetting to run EzWinScore as Administrator on a Vista or Win7 machine. Nope. I can't stand Vista, and have never even given Win7 a try so alas, I am stuck using Win XP. Link to comment Share on other sites More sharing options...
Chris Keen Posted February 8, 2011 Author Share Posted February 8, 2011 This is so freaking annoying ........... I can't even get EzWinScore to start, so I couldn't use a built-in help file if I wanted to. Also since changing over to the new USPSA website, it is allot less user-friendly. The old website had a little more information about EzWinScore support and such. I got an email from Roger Maier telling me to "check my ODBC database settings" ............. Yeah right. If I knew what an ODBC setting was we probably wouldn't be having this discussion! LOL I'm so frustrated I'm about to delete everything and start from scratch, but the only thing keeping me from doing that is I'm afraid I'll just end up back at square 1, with NO NAMES in my shooters database. Then I'd really be pissed. Can anybody help me in regard to checking my ODBC database settings? I've never had to enter a "user id" and "password" to get into EzWinScore before, why now? And when I try to change the supplied user id and PW, it gives me an error, then on the next try it defaults the "user id" back to USPSA and the PW to a string of 12 stars (*) and nothing more. I'm completely lost. HELP! PLEASE! Link to comment Share on other sites More sharing options...
Chris Keen Posted February 8, 2011 Author Share Posted February 8, 2011 (edited) I did figure out how to access a help file by browsing the USPSA folder, and clicking on the file named Ezwinscore.hlp. I then did a search for ODBC and that lead me to a section that says: .....updated the file locations in the system DSN definitions (located under ODBC in the control panel) But I'm more confused now than before. This is certainly uncharted territory for me, so I'm afraid I might just make things worse by playing with these settings. Edited February 8, 2011 by Chris Keen Link to comment Share on other sites More sharing options...
Chris Keen Posted February 8, 2011 Author Share Posted February 8, 2011 OK as of right now, I have tried copying all the files to a different hard drive. That didn't work Then I tried "downgrading" from 4.06 to 4.05 when I had no troubles ....... That didn't work What else? Link to comment Share on other sites More sharing options...
Mark R Posted February 8, 2011 Share Posted February 8, 2011 Chris, ODBC means "Object Data Base Connectivity". When accessing various databases, a programmer or user (in your case) needs to access the applicable database files (EZwinScore DB files). An ODBC connector is sort of a driver to open the DB files. Usually the DB software manufacturer will create an ODBC for access to their particular DB files. In this case you need Adaptive Server Anywhere ODBC to access the EZWINScore DB files. When installing EZWinScore, they install by default...however, if they have been corrupted for some reason or deleted by accident, you need to re-create them. First thing to do is see if they still exist... To check your ODBC connector, open your control panel (start, control panel) and select Administrative Tools. You should see a line something to the nature of "Data Sources (ODBC)"...click that. When the ODBC Data Sources Administrator dialog box opens, select the SYSTEM DSN tab on top. Now you should see a list of ODBC connectors. If you have run EZWinScore for a while you should see a bunch of ODBC connections. From your earlier post you indicated that the error message showed the INFOFILE odbc as in error. Look in the Name column for INFOFILE. If it's there, you might "Configure" it with userid and password I PM'ed you, or if it's missing, then add a new odbc called INFOFILE. The Driver must be Adaptive Server Anywhere 9.0. At a minimum you should have these odbc connectors... emptymatch infofile masternames newmasternames match (<--not sure about this one) uspsaclasses And a bunch for each match you set up in the past. (not needed anymore) hope it helps. Mark Link to comment Share on other sites More sharing options...
wgnoyes Posted February 9, 2011 Share Posted February 9, 2011 OK as of right now, I have tried copying all the files to a different hard drive. That didn't work Then I tried "downgrading" from 4.06 to 4.05 when I had no troubles ....... That didn't work What else? Here's what to do. Copy off your masternames.db file to a safe location. Then completely uninstall ezwinscore. (You may have to do it 2 or 3 times; I'm not sure.) Then install the base version 4.0. Then install 4.06 over the top of that. What this is going to do is reload and recreate all the database connections for you so you don't have to try to manipulate them manually. Then copy back in your saved masternames.db, overlaying the empty one that's there from the reinstall, and you should be set. Link to comment Share on other sites More sharing options...
Mark R Posted February 9, 2011 Share Posted February 9, 2011 Hey Bill...is the masternames.db the file that holds all the shooters you have registered in the past? i.e Master database? Mark Link to comment Share on other sites More sharing options...
DKSComp Posted February 9, 2011 Share Posted February 9, 2011 Chris; When I had troubles with the scoring program I called Roger at USPSA, he coached me through it on the phone. Really a stand up guy. Dave Schattel Link to comment Share on other sites More sharing options...
wgnoyes Posted February 14, 2011 Share Posted February 14, 2011 Hey Bill...is the masternames.db the file that holds all the shooters you have registered in the past? i.e Master database? Mark Yes. Link to comment Share on other sites More sharing options...
Dan Burwell Posted March 4, 2011 Share Posted March 4, 2011 OK just fired up ezwin to do my classifier match tomorrow and same thing happened to me. Is the only fix to uninstall and reinstall ezwin? If so my wife is going to be pissed she has to help me try and find the disc again. Link to comment Share on other sites More sharing options...
Skydiver Posted March 4, 2011 Share Posted March 4, 2011 (edited) Strange that this is happening to you guys... Are you folks doing a System Restore or something that is undoing the registered data sources? Are you logging in a different users on the same machine? Anyway a small trick once you find your CD. Copy everything off the CD into another directory ("C:\USPSA_CD_BACKUP" perhaps?) on your hard drive. There is no copy protection on the CD itself. Also keep the downloaded updates in that same directory. So if ever you need to reinstall, just reinstall from that backup directory. After installation, run the updates as well to get you up to the latest version. [Of course USPSA is probably going to be unhappy to hear that you can easily pirate and distribute EzWinScore this way, so use this knowledge for good. :-) ] Edited March 4, 2011 by Skydiver Link to comment Share on other sites More sharing options...
Dan Burwell Posted March 4, 2011 Share Posted March 4, 2011 Strange that this is happening to you guys... Are you folks doing a System Restore or something that is undoing the registered data sources? Are you logging in a different users on the same machine? I did do a system restore not long ago when I was having issues with another program. If that is all it takes to screw it up, that sux, I am certain I will screw it up again! I'll have to back up the disc to my NAS so I don't lose it again(if I can find it). Link to comment Share on other sites More sharing options...
Skydiver Posted March 4, 2011 Share Posted March 4, 2011 Once you get EzWinScore installed and updated, create a new restore point. That way a System Restore will at least not undo the EzWinScore installation settings. Link to comment Share on other sites More sharing options...
Dan Burwell Posted March 4, 2011 Share Posted March 4, 2011 In case this happens to anyone else what I did was: make a backup of the masternames.db file, uninstall everything, delete the USPSA folder, empty the recycle bin, then restart the computer before reinstalling EzWin. Link to comment Share on other sites More sharing options...
Nik Habicht Posted March 7, 2011 Share Posted March 7, 2011 If you're doing scores for a local cub, Thank you! Now do yourselves a favor: After you score each month's match, e-mail the match database for that month and the masternames database to the match director, or another person involved in running the match. This way, if your computer ever totally dies/gets stolen/burns up, you'll be able to install EZW on a new machine, arrange for your contact to e-mail you the files, and be back in business..... Not to mention -- should you die, they can easily find someone else to score the match..... Data integrity and continuity is a good thing.... Link to comment Share on other sites More sharing options...
Poppa Bear Posted March 8, 2011 Share Posted March 8, 2011 I had the same problem and honestly cannot remember what program was conflicting with it. The problem for me was related to a dll file with an identical name used by another program. I did not need the program, one of those installed by the factory on a new computer, so I restored to an a point before the 4.06 update. I then deleted the program and installed the 4.06 update. Been working fine ever since then. To be clear, my error message specifically mentioned a dll error and not a db error. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now