SQL Select in ODBC

Having SQL select statements like this

select 'p' as col1, projectname from projects

giving a memory exception

In XP and previous operating systems this worked well. Using VC++ with ODBC
and MS Access driver. Have tried some general ODBC SQL querytools like
qtodbc, same problem.
Any ideas?

You probably would get some expert answers posting this in the following
ngs:
microsoft.public.sqlserver.odbc
microsoft.public.access.odbcclientsvr
--
Andre
Blog: http://adacosta.spaces.live.com
My Vista Quickstart Guide:
http://adacosta.spaces.live.com/blog...3DB!9709.entry

"JohnL" <> wrote in message
news:12D9F2AF-EAB5-482E-8C58-...
> Having SQL select statements like this
>
> select 'p' as col1, projectname from projects
>
> giving a memory exception
>
> In XP and previous operating systems this worked well. Using VC++ with
> ODBC
> and MS Access driver. Have tried some general ODBC SQL querytools like
> qtodbc, same problem.
> Any ideas?