Help connection

[momo]

Hello all,

I am getting 500 Internal Server Error. I have tried disabling the show
friendly error in IE and I have tried it on Firefox. It will not give me the
reason why it will not work, I only get 500 Internal Server Error. I have
tested the code up to the point of Set objConn and it works but when it gets
to the objConn.open dsn that's when I get the error. I wish to find out why
it is not allowing it to get pass this point. I have control of the server
where this is hosted and if there is anything I need to do, I can do it.
Please help!

<!--#include file="dsn.asp"-->
<%

Dim objConn
Set objConn = Server.CreateOb ject("ADODB.Con nection")

objConn.open dsn <======== My Problem Is Here

+++++++++++++++ +++++++++++++++ ++++++++++++
+ file: dsn.asp +
++++++++++

<%
dim dsn
dim Conn
dsn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=C:\Inetp ub\vhosts\mydom ain.com\httpdoc s\_private\data base\books.mdb;
Jet OLEDB:Database; "
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open dsn
%>
+++++++++++++++ +++++++++++++++ ++++++++++++

[Tim Slattery]

"momo" <ma***@seeourwe b.com> wrote:

++++++++++++++ +++++++++++++++ +++++++++++++
+ file: dsn.asp +
++++++++++

<%
dim dsn
dim Conn
dsn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=C:\Inet pub\vhosts\mydo main.com\httpdo cs\_private\dat abase\books.mdb ;
Jet OLEDB:Database; "

VSScript doesn't work like this. Statements end at end-of-line unless
you explicitly say otherwise. This statement should look something
like this:

dsn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data" & _
"Source=C:\Inet pub\vhosts\mydo main.com\httpdo cs\_private\" & _
"database\books .mdb;Jet OLEDB:Database; "

The "&" is a concatenation operator, the trailing "_" tells the
interpreter that the statement continues on the next line

--
Tim Slattery
MS MVP(DTS)
Sl********@bls. gov

[momo]

Thanks Tim for replying. The statement is on continious line. The strange
thing is that dsn.asp works when used in another .asp page.

dsn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=C:\Inetp ub\vhosts\mydom ain.com\httpdoc s\_private\data base\books.mdb;
Jet OLEDB:Database; "
"Tim Slattery" <Sl********@bls .gov> wrote in message
news:kr******** *************** *********@4ax.c om...

"momo" <ma***@seeourwe b.com> wrote:

+++++++++++++ +++++++++++++++ ++++++++++++++
+ file: dsn.asp +
++++++++++

<%
dim dsn
dim Conn
dsn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=C:\Ine tpub\vhosts\myd omain.com\httpd ocs\_private\da tabase\books.md b;
Jet OLEDB:Database; "

VSScript doesn't work like this. Statements end at end-of-line unless
you explicitly say otherwise. This statement should look something
like this:

dsn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data" & _
"Source=C:\Inet pub\vhosts\mydo main.com\httpdo cs\_private\" & _
"database\books .mdb;Jet OLEDB:Database; "

The "&" is a concatenation operator, the trailing "_" tells the
interpreter that the statement continues on the next line

--
Tim Slattery
MS MVP(DTS)
Sl********@bls. gov

[Bob Barrows [MVP]]

momo wrote:

Hello all,

I am getting 500 Internal Server Error. I have tried disabling the
show friendly error in IE and I have tried it on Firefox. It will not
give me the reason why it will not work, I only get 500 Internal
Server Error.
It sounds as if you have to turn it off at the web site using IIS Manager.
Barring that, you will need to use some error-trapping to find the error

on error resume next objConn.open dsn <======== My Problem Is Here

if err <> 0 then
response.write err.description
response.end
end if

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.

[momo]

Thanks Bob,

I tried that and got error "Could not use ''; file already in use." I could
not find where it is in use. Could you help and could you tell me how to
turn it on in IIS Manager.
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:O6******** ******@TK2MSFTN GP14.phx.gbl...

momo wrote:

Hello all,

I am getting 500 Internal Server Error. I have tried disabling the
show friendly error in IE and I have tried it on Firefox. It will not
give me the reason why it will not work, I only get 500 Internal
Server Error.

It sounds as if you have to turn it off at the web site using IIS Manager.
Barring that, you will need to use some error-trapping to find the error

on error resume next

objConn.open dsn <======== My Problem Is Here

if err <> 0 then
response.write err.description
response.end
end if

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.

[Bob Barrows [MVP]]

momo wrote:

Thanks Bob,

I tried that and got error "Could not use ''; file already in use." I

This is usually a permission problem: all users of an mdb file need Modify
permissions for the folder containing the file, not just the file itself. If
your site uses Anonymous access, then you need to grant this permission to
the IUSR_machinenam e account.

could not find where it is in use. Could you help and could you tell
me how to turn it on in IIS Manager.
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:O6******** ******@TK2MSFTN GP14.phx.gbl...

momo wrote:

Hello all,

I am getting 500 Internal Server Error. I have tried disabling the
show friendly error in IE and I have tried it on Firefox. It will
not give me the reason why it will not work, I only get 500
Internal Server Error.

It sounds as if you have to turn it off at the web site using IIS
Manager. Barring that, you will need to use some error-trapping to
find the error

on error resume next

objConn.open dsn <======== My Problem Is Here

if err <> 0 then
response.write err.description
response.end
end if

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.

--
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.

[Bob Barrows [MVP]]

momo wrote:

Could you help and could you tell
me how to turn it on in IIS Manager.

It's in the Application Configuration dialog in the Debugging tab
--
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.

[momo]

Thanks Bob,

That did it. The permission on the folder.
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

momo wrote:

Thanks Bob,

I tried that and got error "Could not use ''; file already in use." I

This is usually a permission problem: all users of an mdb file need Modify
permissions for the folder containing the file, not just the file itself.
If
your site uses Anonymous access, then you need to grant this permission to
the IUSR_machinenam e account.

could not find where it is in use. Could you help and could you tell
me how to turn it on in IIS Manager.
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:O6******** ******@TK2MSFTN GP14.phx.gbl...

momo wrote:
Hello all,

I am getting 500 Internal Server Error. I have tried disabling the
show friendly error in IE and I have tried it on Firefox. It will
not give me the reason why it will not work, I only get 500
Internal Server Error.

It sounds as if you have to turn it off at the web site using IIS
Manager. Barring that, you will need to use some error-trapping to
find the error

on error resume next
objConn.open dsn <======== My Problem Is Here
if err <> 0 then
response.write err.description
response.end
end if

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.

--
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.

[momo]

In the debugging tab "Send detail ASP error messages to clients" is already
selected. But it still does not show me the error. Do I have to check either
of the two boxes under "Debugging flags"?
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:OZ******** ******@tk2msftn gp13.phx.gbl...

momo wrote:

Could you help and could you tell
me how to turn it on in IIS Manager.

It's in the Application Configuration dialog in the Debugging tab
--
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.

[Bob Barrows [MVP]]

No.
As long as the browser is configured correctly, you should receive the
detailed errors.

You should probably be using error-trapping anyways. Many users find it very
jarring to be sent to the generic error pages.
momo wrote:

In the debugging tab "Send detail ASP error messages to clients" is
already selected. But it still does not show me the error. Do I have
to check either of the two boxes under "Debugging flags"?
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:OZ******** ******@tk2msftn gp13.phx.gbl...

momo wrote:

Could you help and could you tell
me how to turn it on in IIS Manager.

It's in the Application Configuration dialog in the Debugging tab
--
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.

--
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.