Last month I rebuilt my pc, (xp pro) as it was a bit sluggish but now I cant submit anything to the SQL database through IE although my colleagues are fine. I have checked the date on my PC which is fine and I'm not too keen to rebuild my pc again! Any ideas?
I am using IIS and ASP but nothing has changed on that front and all was well before I formatted my drive so I am sure it is related to my new build. As I mentioned my colleagues can enter data as usual.
screen grab of what happens when you try to submit the data ?
Also did you check the check box for virtual directories and install IIS correctly ?
When you submit the page do you get any error page ?
Also if you use firefox or another browser does that have issues ?
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
/joblist/addjob2.asp, line 23
This is the error I get but everything was fine a for me few weeks ago, it only affects my computer. Everything works fine as usual for everyone else except me and the only change is the rebuild to my pc... grrr! There haven't been any changes to the asp/database/IIS for years.
That is line 23, not very helpful but it must fail at the connection because something isn't conforming to the timeline between the database and my pc. The error only appears if I try to add a job to the list...... I think I might have to zap mt pc again but I was hoping for a quick fix..
QuoteFix = Replace(strSource, "'", "''")
Set objConnection = server.CreateObject("ADODB.Connection")
sql="INSERT INTO Calls (ReportedByUser, MachineName, ProblemDescription, DateLogged, JobStatus, PriorityRating) values ('" & Username & "','" & MachineName & "','" & ProblemDescription & "','" & Now & "', 0,0);"
I think it is tripping up here, (bold)
My comuter somehow is not giving the correct info althogh I have checked it several times.
Am I correct in thinking that the database and asp are not on your machine?
If you are just a client accessing the asp code through IE then surely that points to a problem on your computer (if other clients are ok then the asp/database must be ok)
Perhaps something is messed up or not correct version with your ODBC drivers?
There are currently 1 users browsing this thread. (0 members and 1 guests)