Unspecified error problem

[Elmo Watson]

I have tried this on multiple computers - - I get
Unspecified error
/search1.asp, line 13

here's the very simple code:

Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"DATA SOURCE=" & server.mappath("\Webdb.mdb")
sql="Select * from Names"
Set MyRs=MyConn.Execute(sql) '<------this is the line where it breaks - -

I'm using IE 6 and I've tried a specific path for the db instead of
server.mappath and it still happens - - - this used to work fine in earlier
versions of IE - - any ideas?

[Aaron Bertrand [MVP]]

> I'm using IE 6 and I've tried a specific path for the db instead of

> server.mappath and it still happens - - - this used to work fine in

earlier

> versions of IE - - any ideas?

A browser doesn't affect what happens in ASP code. Did you upgrade your
operating system?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Meelis Lilbok]

Install Jet4 latest SP


Mex



"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:%23YgbqQgwDHA.1680@TK2MSFTNGP12.phx.gbl...

> > I'm using IE 6 and I've tried a specific path for the db instead of
> > server.mappath and it still happens - - - this used to work fine in

> earlier

> > versions of IE - - any ideas?

>
> A browser doesn't affect what happens in ASP code. Did you upgrade your
> operating system?
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>

[Bob Barrows]

Elmo Watson wrote:

> I have tried this on multiple computers - - I get
> Unspecified error
> /search1.asp, line 13
>
> here's the very simple code:
>
> Set MyConn=Server.CreateObject("ADODB.Connection")
> MyConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
> "DATA SOURCE=" & server.mappath("\Webdb.mdb")
> sql="Select * from Names"
> Set MyRs=MyConn.Execute(sql) '<------this is the line where it
> breaks - -
>
> I'm using IE 6 and I've tried a specific path for the db instead of
> server.mappath and it still happens - - - this used to work fine in
> earlier versions of IE - - any ideas?

The browser is irrelevant. This is server-side code.

Is "Names" a reserved keyword? Let's see ... yes. According to
[url]http://www.aspfaq.com/show.asp?id=2080[/url], "Names" is an ODBC reserved keyword
which should be avoided for database object names.

My recommendation is to change the name of that table ("Names" is not very
descriptive anyways, is it? "Names" of what? Employees? Companies?
Machines?). If you cannot do that for sopme reason, then you will have to
remember to surround it with brackets whenever you use it in a query being
run by ADO:
[Names]

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"