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

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

Here's a page with some helpful stuff:

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



"Bart" wrote:

> 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

Thanks, interesting article ...

"Grinning Crow" schreef in bericht
news:B6EAD44B-E0B0-4BF1-B7DD-D212C820C6F1@microsoft.com...
> Here's a page with some helpful stuff:
>
> http://sqlserver2000.databases.aspfaq.com/what-are-the-main- differences-between-access-and-sql-server.html
>
>
>
> "Bart" wrote:
>
>> 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 & " ;"
>>
>>
>>
>>