Problem with OLEDB over ODBC

[S N]

I have an asp page used to access data from an access database.
When I use the following as connection string (OLEDB)
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbname.mdb;Persist Security
Info=False" to run the following sql string given below the following error
occurs-
Error Type:
(0x80004005)
Unspecified error

The error occured when i run
set myrs=conn.execute("select TOP 10 number,headline,zone,intro,text,file
from news order by number DESC")

However this error does not occur when i use (using the same connection
string)
set myrs=conn.execute("select * from news")

Please note that text is a memo field.

The same error does not occur when i use
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath(database)"

as the connection string. This connection string runs for both the types of
sql strings as mentioned above.

Please help.

[Bob Barrows [MVP]]

S N wrote:

> I have an asp page used to access data from an access database.
> When I use the following as connection string (OLEDB)
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbname.mdb;Persist
> Security Info=False" to run the following sql string given below the
> following error occurs-
> Error Type:
> (0x80004005)
> Unspecified error
>
> The error occured when i run
> set myrs=conn.execute("select TOP 10
> number,headline,zone,intro,text,file from news order by number DESC")
>

You've used reserved keywords for column names (number, text, and maybe
file). the list of reserved keywords can be found here:
[url]http://www.aspfaq.com/show.asp?id=2080[/url]

A couple of these are ODBC keywords, so I'm surprised that you didn't get
the same error when running with ODBC.

My suggestion is to change these column names, but, if you can't change them
for some reason, you will need to remember to surround them with brackets []
when using them in queries run via ADO

"select TOP 10 [number], ...

This tells the parser to ignore the words and assume you know what you are
doing. :-)

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[S N]

it works when i surround all the fields with [].
but when i surround all fields except the field name zone with [], it gives
the same error.however if i enclose only zone with [] the error goes
what is so special with the field zone?


"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:uvCYjK5MEHA.2468@TK2MSFTNGP11.phx.gbl...

> S N wrote:

> > I have an asp page used to access data from an access database.
> > When I use the following as connection string (OLEDB)
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbname.mdb;Persist
> > Security Info=False" to run the following sql string given below the
> > following error occurs-
> > Error Type:
> > (0x80004005)
> > Unspecified error
> >
> > The error occured when i run
> > set myrs=conn.execute("select TOP 10
> > number,headline,zone,intro,text,file from news order by number DESC")
> >

>
> You've used reserved keywords for column names (number, text, and maybe
> file). the list of reserved keywords can be found here:
> [url]http://www.aspfaq.com/show.asp?id=2080[/url]
>
> A couple of these are ODBC keywords, so I'm surprised that you didn't get
> the same error when running with ODBC.
>
> My suggestion is to change these column names, but, if you can't change

them

> for some reason, you will need to remember to surround them with brackets

[]

> when using them in queries run via ADO
>
> "select TOP 10 [number], ...
>
> This tells the parser to ignore the words and assume you know what you are
> doing. :-)
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Egbert Nierop \(MVP for IIS\)]

[url]http://support.microsoft.com/?id=235515[/url]

--
compatible web farm Session replacement for Asp and Asp.Net
[url]http://www.nieropwebconsult.nl/asp_session_manager.htm[/url]

"S N" <uandme72@yahoo.com> wrote in message
news:%239ft%23X6MEHA.2244@tk2msftngp13.phx.gbl...

> it works when i surround all the fields with [].
> but when i surround all fields except the field name zone with [], it

gives

> the same error.however if i enclose only zone with [] the error goes
> what is so special with the field zone?
>
>
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:uvCYjK5MEHA.2468@TK2MSFTNGP11.phx.gbl...

> > S N wrote:

> > > I have an asp page used to access data from an access database.
> > > When I use the following as connection string (OLEDB)
> > > "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbname.mdb;Persist
> > > Security Info=False" to run the following sql string given below the
> > > following error occurs-
> > > Error Type:
> > > (0x80004005)
> > > Unspecified error
> > >
> > > The error occured when i run
> > > set myrs=conn.execute("select TOP 10
> > > number,headline,zone,intro,text,file from news order by number DESC")
> > >

> >
> > You've used reserved keywords for column names (number, text, and maybe
> > file). the list of reserved keywords can be found here:
> > [url]http://www.aspfaq.com/show.asp?id=2080[/url]
> >
> > A couple of these are ODBC keywords, so I'm surprised that you didn't

get

> > the same error when running with ODBC.
> >
> > My suggestion is to change these column names, but, if you can't change

> them

> > for some reason, you will need to remember to surround them with

brackets

> []

> > when using them in queries run via ADO
> >
> > "select TOP 10 [number], ...
> >
> > This tells the parser to ignore the words and assume you know what you

are

> > doing. :-)
> >
> > HTH,
> > Bob Barrows
> > --
> > Microsoft MVP -- ASP/ASP.NET
> > Please reply to the newsgroup. The email account listed in my From
> > header is my spam trap, so I don't check it very often. You will get a
> > quicker response by posting to the newsgroup.
> >
> >

>
>