Problem with Dates in ASP-db Classic

[locusta]

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

[Frank]

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

[locusta]

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)

[Frank]

make a small code to modify the MS-SQL pubs or northwind DB and illustrate the problem.

Fk

[locusta]

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...

[Frank]

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