SQL Select in ODBC

[JohnL]

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?

 

[Andre Da Costa[ActiveWin]]

You probably would get some expert answers posting this in the following
ngs:
microsoft.public.sqlserver.odbc
microsoft.public.access.odbcclientsvr