Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
triashasman
Starting Member
1 Post |
 Posted - 2007-07-20 : 00:34:53
|
| I have some problem with my ASP and SQL 2000 Server.I put the SQL 2000 and IIS on Win 2000, but when I run the web page ( ASP File) I got this error message.Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime. After I check the code, I think there is no error code, then I try runing the ASP on Win XP (with IIS), and the SQL 2000 still on the win 2000, The web page is runing well and no problem there.I try to run this code (ASP) on XP and Win 2000response.write date()for 20 July 2007 there is 2 diffrent output7/20/2007 ===> XP ( the ASP runing and no error )20/7/2007 ===> win2000 ( the error come from )Then I think the problem in on the regional and date setting, but after change the regional setting and date format on win 2000 like the Xp, there is no change, still got error code.So, What is the main problem?This is the source of ASP=============================session("akhir")=request.form("month") & "/" & request.form("day") & "/" & request.form("year")mulai=cdate(session("akhir"))-day_counts+1sql_text="execute amr_view_pelanggan '" & APJ & "','" & mulai & "','" & day_counts & "','" & sql_meter & "'"db_detail_rec.open sql_text,db_detail_con,1,3This is the source of stored procedure on SQL 2000 (just the header)=============================CREATE PROCEDURE amr_view_pelanggan @APJ char(20), @mulai datetime, @day_counts numeric,@type_meter char(250) AS ...... Thanks |
|
|
|
|
|
|
|
ASP,SQL 2000, XP and Win 2000