| Topic: Kid Lightning! |
| ||
|
We are having issues entering doubles matches. The matches enter but the points don't calculate. Here's a message from Skye. I seldom look at this site so I apologize for the delay.. Regarding the error. I believe that this has something to do with the database location link.. Kid lightening should look at line 48 on both pages mentioned in the error. This is the part that needs to be adjusted: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= d:\webspace\ADMIN\vancouverfoosball.com\db\foos.mdb" *the above is from an old page I have on my computer... The strange thing is... I don't understand why that would make a difference. My first thought without reading the error was that it had something to do with the date... Also, if anyone has time they should change the database to MySQL. I didn't think the site would get that much use so I originally just used an Access database. I think the problem with the memory is because Access really isn't designed for this type of use... and I made the SQL queries too long. I'm not referring to the control panel for the site but instead just the pages that display the results. Going back to the current problem. If changing the line I mentioned doesn't work please email me the ftp info and I'll correct the problem. Can you do anything for this Shingo? |
Posted: Jan 21 2009 3:27PM
| ||
|
And Shing'o WAS his name'o  . |
| ||
|
The line: "Provider=Microsoft.Jet.OLEDB.4.0;" is referring to the database program. Jet is how you refer to MS Access. For mySQL see below: OLE DB Provider for mySQL oConn.Open "Provider=MySQLProv;" & _ "Data Source=mySQLDB;" & _ "User Id=myUsername;" & _ "Password=myPassword" Of course, you will need to change the part after the equal signs to what it is for your particular database. If you don't have a password you can leave out that parameter. And no, I don't really want to be the admin for your code. It should be someone who is physically there to test and debug stuff properly. I hope this helps. Fred |
| ||
|
I've never been in the admin side so I don't know what to expect. I've made the changes for CalcSingles.asp and CalcDoubles.asp. Try it again and let me know if it fixed the problem. |
| ||
|
Ok here we go, im going to enter the dec 28th tournament now and see. |
| ||
|
Well whatdoya know it's Fixed!! Thanks so much Shane!! Ok guys last 3 doubles tournaments Dec 28 Jan 11 and Jan 18th are up and fresh!! |
| ||
|
and Skye, and Fred, and Jeff Tung. Paul congrats, you returned to Expert last tournament!! |
| ||
|
Good to hear it's working but it kind of doesn't make sense why it worked for the longest time on your server without changing the two lines. I thought this was changed when you put it on your server. For that reason I thought it was a date error, but only because it seemed to happen just after the new year. (09=00 etc..) Whatever the case it's great to hear it's now working. If you do decide to migrate the data over to MySQL.. note that you will need to adjust a few of the pages. For example, the page in the connection folder etc.. One great advantage if you migrate the data to MySQL then you can run it either on windows or linux (with chili soft)... if you put it on linux - you will get some minor errors on some of the web pages but they should be very minor. Also, you don't need to migrate it manually - there's free database MySQL software that you can download and just by clicking one button it will do it automatically. I'm sorry I forget the name of it - it's been about 8-9 years since I've done something like that... Again, it's good to hear it's working.. :o) |
| ||
|
Good to hear it's working but it kind of doesn't make sense why it worked for the longest time on your server without changing the two lines. I thought this was changed when you put it on your server. For that reason I thought it was a date error, but only because it seemed to happen just after the new year. (09=00 etc..) Whatever the case it's great to hear it's now working. If you do decide to migrate the data over to MySQL.. note that you will need to adjust a few of the pages. For example, the page in the connection folder etc.. One great advantage if you migrate the data to MySQL then you can run it either on windows or linux (with chili soft)... if you put it on linux - you will get some minor errors on some of the web pages but they should be very minor. Also, you don't need to migrate it manually - there's free database MySQL software that you can download and just by clicking one button it will do it automatically. I'm sorry I forget the name of it - it's been about 8-9 years since I've done something like that... Again, it's good to hear it's working.. :o) |
The last post to this thread is more than 30 days old.