Printable View
Help!
I've moved asp-db application from a w2000 server with SQL7 to a w2003 server with SQL2000 and now every time I try to modify a table with a Date field... I obtain this kind of error:
ASP error '800a0003'
Return without GoSub
/_inc/pangest/macchine.inc.asp, line 98
The same application with access db works... if i write the code in asp to insert data in the db it works... but the combination ASP-db classic, W2003 Server and SQL 2000 crashes...
Any idea?
Thanks
access #date# fields and SQL 'date' fields are different by the wrapper. You have to specify dbDBType to let the system settle the difference for you.
Fk
Yes... I know.... the dbType is correctly set... and the same application worked before with SQL7 on W2000 server... but it crashed... and I only moved to a new server with W2003 and SQL2000.
When I write in the same database from an ASP page without ASP-db I have no problem (I need to use the GetDate() function)
make a small code to modify the MS-SQL pubs or northwind DB and illustrate the problem.
Fk
This is the code of example:
Set MyDb = Server.CreateObject("ASP.db")
MyDb.dbUnit = 150
MyDb.dbDSN = "DSN=panini_pangest_sql;UID=;PWD=;DATABASE=NORTHWI ND"
MyDb.dbDBType = "SQL"
MyDb.dbSQL = "select * from Orders"
MyDb.dbImageDir = "en/pangest/images/"
MyDb.dbOptions = "(;|)HeaderFontTag='face=Arial size=3'|CellFontTag='face=Arial size=3'|Localdecimal=,"
MyDb.dbButtonAnchor = False
MyDb.dbMode = "dual-horiz"
MyDb.dbColor = "10,auto"
MyDb.dbGridTableTag = "BORDER=1"
MyDb.dbGridInc = 10
MyDb.dbGridIncMax = 100
MyDb.dbFormHideFlds = "OrderId"
MyDb.dbEditParams = "TableName=Orders, BookMarkFlds=OrderId, InputSize=80"
MyDb.dbEditHideFlds = "OrderId"
MyDb.dbNavigation = "bottom"
MyDb.dbNavigationIcon = "std"
MyDb.dbNavigationItem = "top, prev, next, bottom, reload, update"
MyDb.ASPdb
Every time I try to upload I obtain an error about conversion from char type to datetime type.
You can see directly at this address: http://www.paninidirect.com/test_northwind.asp
I'm sure is a problem with italian date format (dd/mm/yyyy) rather than US date format or something like that... but I can't resolve as I normally do, using DateFormat in dbOptions and MagicCell with Format options... it gives me other errors...
ASP error '800a0003'
Return without GoSub
/_inc/pangest/macchine.inc.asp, line 98
Is this ->
/_inc/pangest/macchine.inc.asp, line 98
Your code as the error os from there?
Frank