inetserver asp db: 'weekday' is not a recognized built-in function name -- inetserver asp db

'weekday' is not a recognized built-in function name

Bart
3/29/2007 12:00:00 AM

inetserver asp db:

Hi,

I ran this code first with OLEDB provider for ACCESS without problem. Now i
switched to Sql Server 2005 express but i get the error: "
Microsoft OLE DB Provider for SQL Server (0x80040E14)
'weekday' is not a recognized built-in function name.

Thanks for help
Bart

global.asa:
----------
Sub Application_OnStart
Application("newconn") = "Provider=SQLOLEDB;Data
Source=laptop\sqlexpress;Integrated Security=SSPI;Initial Catalog=mydb"
End Sub

code:
-----
strsql="delete from studres where weekday(dag)="& dag & " ;"

RE: 'weekday' is not a recognized built-in function name

Grinning Crow
3/29/2007 1:12:00 AM

Here's a page with some helpful stuff:

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

[quoted text, click to view]

Re: 'weekday' is not a recognized built-in function name

Bart
3/29/2007 6:29:01 PM

Thanks, interesting article ...

"Grinning Crow" <GrinningCrow@discussions.microsoft.com> schreef in bericht
news:B6EAD44B-E0B0-4BF1-B7DD-D212C820C6F1@microsoft.com...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the inetserver asp db group.