|
|
|
Junior Member
 
Group: Campus Recreation
Last Login: 2/18/2008 12:35:05 PM
Posts: 21,
Visits: 88
|
|
| HI, I was trying to add a new service into the Scheduler in the Spectrum Management Software but it said that there was a message saying "The Following occurred: ODBC--Call failed" Then on pressing ok It says "Error in saving record due to : ODBC --call failed" What can be the error about? Why am I not able to create new Services in the scheduler? Regards, Ranjeesh Yelamanchili
|
|
|
|
|
Forum Administrator
Group: Administrators
Last Login: Today @ 2:47:42 PM
Posts: 99,
Visits: 1,062
|
|
The error 'ODBC -- Call Failed' means that for some reason, the system cannot read from or write to the database. This is caused typically by a one or a combination of four things: 1) The data is too long for the field you are trying to save it in, 2) there is a character in the data string, such as a single or double quote, that SQL cannot accept, 3) You are trying to save a null value into a field that cannot accept nulls, or 4) The database is missing a field that the program is trying to save. The most common reason that this happens at Scheduler is #4, and to fix it, you will need to contact our Tech Support department to connect to your server and run the appropriate database scripts. First, you should have them look at the data you are trying to post, to verify that it isn't one of the other three reasons.
PJ Gustafson Director of Educational Services CSI Software (800) 247-3431 x250 (713) 942-7779 x250 pgustafson@csisoftwareusa.com www.csisoftwareusa.com 
|
|
|
|
|
Junior Member
Group: Campus Recreation
Last Login: 2/18/2008 12:35:05 PM
Posts: 21,
Visits: 88
|
|
| Hi PJ, I called CSI today and tried to get the problem solved. They didn't check for any of the reasons u mentioned but tried to reconnect all the tables and retry. That still didn't work. They needed the administrator password and username for the Database Server here but as I am new I couldn't provide the uid and password. Even Darleen doesn't know the uid/password. But I think maybe the NULL Value thing u mentioned is right coz the FEES button at the bottom is disables and am not able to set any value for it so maybe it is taking it as a NULL value. The only thing is I dont know if the FEES field in the database table accepts NULL value or not? I will call CSI Tech Support again when I get the username and password to the Server. In the meantime I am hoping for a solution from you if possible. Regards, Ranjeesh Yelamanchili
|
|
|
|
|
Forum Administrator
Group: Administrators
Last Login: Today @ 2:47:42 PM
Posts: 99,
Visits: 1,062
|
|
Well, the fees button is disabled until after you initially save the service and pull it back up. The reason for this is because in the database the fees are in a different table than the rest of the service information, and it needs a unique service id to link it to, which isn't created until after the initial information for the service is saved. I will look up which tech you spoke with and discuss the matter with them to help resolve this quickly.
PJ Gustafson Director of Educational Services CSI Software (800) 247-3431 x250 (713) 942-7779 x250 pgustafson@csisoftwareusa.com www.csisoftwareusa.com
|
|
|
|
|
Junior Member
Group: Campus Recreation
Last Login: 2/18/2008 12:35:05 PM
Posts: 21,
Visits: 88
|
|
| In case u need any reference to my call the other day...the tech team gave me a TICKET number for resuming the problem solving procedure. The Ticket number was 47234 and the Username and Password which they were asking for solving the problem cannot be revealed for "security reasons". Regards, Ranjeesh
|
|
|
|
|
New to Forum
Group: Forum Members
Last Login: 7/17/2007 10:57:43 AM
Posts: 3,
Visits: 5
|
|
| It doesn't sound like it's due to the same cause but we receive the "ODBC call failed" errors as well. Usually it's just our front desk PC's but occassionally others get it. It happens almost every day and sometimes more than once a day. The PC isn't always even being used at the time. Oddly, other PC's that are logged in at the same time do not get the error. If anyone has any other ideas on why this is happening, I'd love to hear them!!! Thanks! Susan Luethke
IT Business Analyst
Madonna Proactive
|
|
|
|
|
Forum Administrator
Group: Administrators
Last Login: Today @ 2:47:42 PM
Posts: 99,
Visits: 1,062
|
|
| Susan, Have you noticed it occurring on a particular screen or during a particular operation? If there's a pattern as to when it happens, that may help narrow down the cause.
PJ Gustafson Director of Educational Services CSI Software (800) 247-3431 x250 (713) 942-7779 x250 pgustafson@csisoftwareusa.com www.csisoftwareusa.com
|
|
|
| | |