ODBC SQL Server Driver errors "Invalid date format", "Invalid time format", "String data, right ....
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
ODBC SQL Server Driver errors "Invalid date format... - 18.May2007 9:24:47 AM
|
|
|
bradxray
Posts: 14
Score: 0
Status: offline
|
Everyday, I get error messages when reading the W3C files on our web servers. The error message is very vage:
5/9/2007 10:57:35 AM database N/A [Microsoft][ODBC SQL Server Driver]Invalid time format - 22007
5/9/2007 10:57:48 AM database N/A [Microsoft][ODBC SQL Server Driver]String data, right truncation - 22001
5/9/2007 10:57:57 AM database N/A [Microsoft][ODBC SQL Server Driver]Invalid date format - 22007
When I look in the W3C file, I don't see anything wrong. The timestamp is when GFI read the file, not the timestamp of the line causing the problem. I turned on debug in GFI and can't find enough information to point to a particular line that is causing the problem. Wouldn't that be a nice feature for GFI (hint hint).
Does anyone know how to turn on debugging in SQL 2005 so I can see what was going on in the SQL server when this error message happens? Or maybe a way to get GFI to show me the data it is trying to insert into the database when it is having this problem?
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 23.May2007 8:18:08 AM
|
|
|
Mark Busuttil
Posts: 4836
Score: 0
Joined: 16.Oct.2005
Status: offline
|
This issue is currently being handled by e-mail support. The reference number(s) used are:
CAS-18119-6X9M - bradxray
NOTE: We have sent you an email on the address that you have registered over the forums with.
Should you require any updates or further information, kindly contact us using the support form at the following link:
http://support.gfi.com/supportrequestform.asp
_____________________________
Regards,
Mark Busuttil
GFI Software Ltd - www.gfi.com
Messaging, Content Security & Network Security Software
GFI: MailEssentials - MailSecurity - MailArchiver - FAXmaker - LANguard – WebMonitor
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 23.May2007 1:41:27 PM
|
|
|
bradxray
Posts: 14
Score: 0
Status: offline
|
Hi Mark,
I did get an email that said they are still working on the "Invalid time format" problem, but they also said "there is no further information available at this time". So that leads me to believe the "http://support.gfi.com/supportrequestform.asp " link won't do me much good.
I am trying to figure out a way to troubleshoot any error message that is coming from the "ODBC SQL Server Driver". Not just the "Invalid time format" error.
I think I asked Carlton if he knows a way to figure out what line the process is working with, but he did not know. Do you know how?
Case CAS-18119-6X9M was opened a month ago. I thought maybe someone in the forum might be able to give me some troubleshooting tips to help identify the problem a little quicker.
Thanks
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 31.May2007 5:26:45 AM
|
|
|
Tony.A
Posts: 18
Score: 0
Joined: 7.May2007
Status: offline
|
I opened CAS-17838-4ZKJ in April. The end result was I was told this was a known issue that would be fixed in a future build. I just bought the software, and installed and I see the issue is still there.
Is there resolution to this problem yet?
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 31.May2007 9:20:19 AM
|
|
|
bradxray
Posts: 14
Score: 0
Status: offline
|
Hi Tony,
Do you get all three error messages? The last 20 or so that I received were "Invalid time format", but I sometimes get the other two errors also.
Thanks,
Bradxray
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 31.May2007 3:03:50 PM
|
|
|
Tony.A
Posts: 18
Score: 0
Joined: 7.May2007
Status: offline
|
A quick glance at my email says I seem to only be getting:
/31/2007 5:06:12 AM database N/A [Microsoft][ODBC SQL Server Driver]Invalid time format - 22007
multiple times. This was not a thorough check, but I'll go through some logs and let you know.
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 25.Jul.2007 10:21:48 AM
|
|
|
Tony.A
Posts: 18
Score: 0
Joined: 7.May2007
Status: offline
|
Just bumping this, still having this problem with the very latest build. My anti virus is not scanning any GFI directories.
I am wondering if this is happening because the back end DB is SQLK 2005 X64?
Any resolution to this anyone?
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 25.Jul.2007 12:24:30 PM
|
|
|
bradxray
Posts: 14
Score: 0
Status: offline
|
Hey Tony,
I have not bothered loading the latest version. I don't think we will be using this product much longer.
A few people contacted me wanting to troubleshoot this using my servers instead of just copying the W3C logs to theirs. But, I told them I could not do that due to security reasons. I offered to send them my log files, but they never asked for them.
6/21/07 CWhitehead@gfi.com said they could not reproduce the "exact same" problem.
6/25/07 DRubright@gfi.com asked for the info I had on the case. That is the last interaction I have had with them. It has been over 3 months now, I give up.
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 25.Jul.2007 12:27:53 PM
|
|
|
Tony.A
Posts: 18
Score: 0
Joined: 7.May2007
Status: offline
|
Hopefully someone will see this and work on the issue. I am in a bit of a tight spot and have no choice but to continue to use this product until the licese runs out, but I amlready testing alternatives.
I have also started to see new errors as of the time I loaded the latest version (earlier today)
the errors are:
7/25/2007 12:39:04 PM database N/A [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). - 01000
7/25/2007 12:39:05 PM database N/A [Microsoft][ODBC SQL Server Driver]Communication link failure - 08S01
7/25/2007 12:39:05 PM database N/A [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). - 01000
7/25/2007 12:39:05 PM database N/A [Microsoft][ODBC Driver Manager] Invalid string or buffer length - HY090
7/25/2007 12:39:09 PM database N/A [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). - 01000
7/25/2007 12:39:12 PM database N/A [Microsoft][ODBC SQL Server Driver]Invalid time format - 22007
7/25/2007 12:39:25 PM database N/A [Microsoft][ODBC SQL Server Driver]Invalid time format - 22007
< Message edited by Tony.A -- 25.Jul.2007 12:38:22 PM >
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 27.Jul.2007 6:48:56 PM
|
|
|
Tony.A
Posts: 18
Score: 0
Joined: 7.May2007
Status: offline
|
I found this on Microsoft's site, it sure does sound familiar. IT doesn't apply to me because it is related to MDAC 2.1 and MDAC 2.5 I am running windows 2003 so the default MDAC on that is 2.8.
http://support.microsoft.com/kb/259691
< Message edited by Tony.A -- 30.Jul.2007 10:19:38 AM >
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 5.Feb.2008 7:18:52 PM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
Was a solution for this ever found? I am having the same issue.
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 6.Feb.2008 9:53:17 AM
|
|
|
Tony.A
Posts: 18
Score: 0
Joined: 7.May2007
Status: offline
|
As far as I am aware, no recent builds, patches or kb articles resolve this issue.
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 7.Feb.2008 3:42:29 AM
|
|
|
Mark Busuttil
Posts: 4836
Score: 0
Joined: 16.Oct.2005
Status: offline
|
Hi,
Have you applied the patch which is mentioned below?
http://kbase.gfi.com/showarticle.asp?id=KBID003212
However, should you apply the patch above and the problem persists, please contact support as discussed in the following thread:
http://forums.gfi.com/General_Information/m_900748004/tm.htm
Thank you!
_____________________________
Regards,
Mark Busuttil
GFI Software Ltd - www.gfi.com
Messaging, Content Security & Network Security Software
GFI: MailEssentials - MailSecurity - MailArchiver - FAXmaker - LANguard – WebMonitor
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 22.Feb.2008 11:28:57 AM
|
|
|
mcabrera
Posts: 3
Score: 0
Joined: 23.Jan.2008
Status: offline
|
After working with a tech guy at GFI their solution seems to be "Install the BETA version 8.X", which seems unacceptable to me.
I will have to wait until version 8 comes out and see if it fixes all these problems before even consider renewing this product.
I do not like the idea of running beta software on my production servers.
_____________________________
Luis M. Cabrera
CTO
Tanaseybert LLC
|
|
|
|
|
RE: ODBC SQL Server Driver errors "Invalid date fo... - 26.Feb.2008 4:38:55 AM
|
|
|
Mark Busuttil
Posts: 4836
Score: 0
Joined: 16.Oct.2005
Status: offline
|
Hi,
GFI EventsManager 8 has been released. For further information please click on the following link:
http://forums.gfi.com/Version_and_Build_Information_-_GFI_EventsManager/m_900759705/tm.htm
Thank you
_____________________________
Regards,
Mark Busuttil
GFI Software Ltd - www.gfi.com
Messaging, Content Security & Network Security Software
GFI: MailEssentials - MailSecurity - MailArchiver - FAXmaker - LANguard – WebMonitor
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Printable Version
