database connectivity in IIS

For some reason I am unable to display my database entries, whether i display them blindly or are choosen. I think it has something to do with the connection statement. I am using Vbscript and the IIS seems like it is running properly as it will do minor randomize tasks and Response.Write statements. but when it comes to calling up the database entry it will not do it. i recieve this

HTTP 500 - Internal server error
this is my connection statement yet it will not do even the simplest tas

<

myConn.Open "Provider=MSDASQL; Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:/test/business.mdb;

%>

Tom
Tue Jan 13 11:03:17 CST 2004

"annoyed" <anonymous@discussions.microsoft.com> wrote in message
news:3C262C05-ECAB-4C87-8DAC-DB1B37739D32@microsoft.com...
> For some reason I am unable to display my database entries, whether i
display them blindly or are choosen. I think it has something to do with
the connection statement. I am using Vbscript and the IIS seems like it is
running properly as it will do minor randomize tasks and Response.Write
statements. but when it comes to calling up the database entry it will not
do it. i recieve this
>
> HTTP 500 - Internal server error

FAQ. Start here:
http://www.aspfaq.com/show.asp?id=2109
http://support.microsoft.com/?id=311766
http://support.microsoft.com/?id=309051

> this is my connection statement yet it will not do even the simplest task
> myConn.Open "Provider=MSDASQL; Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:/test/business.mdb;"

You're mixing a SQL connection with the ODBC Access Driver. I would suggest
moving to OLEDB and the native Jet Driver ...
http://www.aspfaq.com/show.asp?id=2126

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

anonymous
Tue Jan 13 12:46:15 CST 2004

Thanks! I got the messages to appear now. and I have switched to OLEDB where do I go to find out what
Microsoft VBScript runtime error '800a01a8'

means?

Tom
Tue Jan 13 12:57:32 CST 2004

"annoyed" <anonymous@discussions.microsoft.com> wrote in message
news:8AF3B686-7B7E-494E-A679-129EACFA10AD@microsoft.com...
> Thanks! I got the messages to appear now. and I have switched to OLEDB
where do I go to find out what
> Microsoft VBScript runtime error '800a01a8'
>
> means?

http://www.aspfaq.com/search.asp
http://support.microsoft.com/default.aspx?scid=fh;rid;kbinfo

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/