Click here to Skip to main content
16,011,754 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: two simple questions: DataGrid Pin
devvvy17-Feb-03 20:43
devvvy17-Feb-03 20:43 
QuestionAdding video to the Web page?? Pin
Kant14-Feb-03 13:26
Kant14-Feb-03 13:26 
AnswerRe: Adding video to the Web page?? Pin
devvvy17-Feb-03 4:30
devvvy17-Feb-03 4:30 
QuestionHow does one go about proposing a new HTML tag? Pin
Ray Cassick13-Feb-03 5:18
Ray Cassick13-Feb-03 5:18 
AnswerRe: How does one go about proposing a new HTML tag? Pin
leppie13-Feb-03 6:56
leppie13-Feb-03 6:56 
GeneralRe: How does one go about proposing a new HTML tag? Pin
Ray Cassick13-Feb-03 6:59
Ray Cassick13-Feb-03 6:59 
AnswerRe: How does one go about proposing a new HTML tag? Pin
markkuk13-Feb-03 11:52
markkuk13-Feb-03 11:52 
GeneralProblem connecting to Access database Pin
Chris LaQuerre13-Feb-03 3:12
Chris LaQuerre13-Feb-03 3:12 
I am getting a Server 500 error whenever I try to connect to an Access DB.

I've used the code below in an Intranet test environment and it works fine. However, when I moved this over to our external Intranet site, I get the server error. (This is the first time that I've tried to connect to a DB on this server. I can run regular ASP scripts fine). Does anyone have any clues about why this would happen? Does anything need to be set up on this server to allow it to connect to an Access DB? The web server that we are trying to get this running on is Microsoft-IIS/5.0 on Windows 2000.

Here is the code that I am using to connect:

<br />
<% @Language = VBScript %><br />
<br />
<%<br />
	Dim MyConn, SQL, RS, id<br />
	Set MyConn=Server.CreateObject("ADODB.Connection")<br />
	MyConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("test.mdb")<br />
	SQL = "SELECT * From TEST;"<br />
	Set RS = MyConn.Execute(SQL)<br />
%><br />
<br />
<html><br />
<body><br />
<table width="100%"><br />
	<!-- displays news item info from database --><br />
	<% <br />
		While Not RS.EOF <br />
	%><br />
 	<tr><br />
		<td valign="top"><%= RS("DATA") %></td><br />
	</tr><br />
<br />
	<% <br />
		RS.MoveNext<br />
		Wend<br />
	%><br />
</table><br />
<br />
<%<br />
	RS.Close<br />
	MyConn.Close<br />
	Set RS = Nothing<br />
	Set MyConn = Nothing<br />
%><br />
<br />
</body><br />
</html><br />


Chris LaQuerre
eBusiness Consultant
GeneralRe: Problem connecting to Access database Pin
palbano13-Feb-03 5:18
palbano13-Feb-03 5:18 
GeneralRe: Problem connecting to Access database Pin
Ray Cassick13-Feb-03 5:23
Ray Cassick13-Feb-03 5:23 
GeneralRe: Problem connecting to Access database Pin
Chris LaQuerre13-Feb-03 6:21
Chris LaQuerre13-Feb-03 6:21 
GeneralRe: Problem connecting to Access database Pin
Ray Cassick13-Feb-03 6:32
Ray Cassick13-Feb-03 6:32 
GeneralRe: Problem connecting to Access database Pin
Richard Deeming13-Feb-03 23:55
mveRichard Deeming13-Feb-03 23:55 
GeneralRe: Problem connecting to Access database Pin
Zeeshan Mehmood17-Feb-03 8:36
Zeeshan Mehmood17-Feb-03 8:36 
Generalsimple question on SQL CURSOR Pin
devvvy12-Feb-03 19:40
devvvy12-Feb-03 19:40 
GeneralGot it. Here's the code. Pin
devvvy12-Feb-03 19:59
devvvy12-Feb-03 19:59 
GeneralProblem! dynamic table name. Pin
devvvy12-Feb-03 20:11
devvvy12-Feb-03 20:11 
GeneralRe: Problem! dynamic table name. Pin
Jeremy Oldham13-Feb-03 1:47
Jeremy Oldham13-Feb-03 1:47 
GeneralRe: Problem! dynamic table name. Pin
devvvy13-Feb-03 1:49
devvvy13-Feb-03 1:49 
GeneralRe: Problem! dynamic table name. Pin
Jeremy Oldham13-Feb-03 2:54
Jeremy Oldham13-Feb-03 2:54 
GeneralRefreshing a page Pin
ohioskip12-Feb-03 13:56
ohioskip12-Feb-03 13:56 
GeneralRe: Refreshing a page Pin
Paul Watson12-Feb-03 21:01
sitebuilderPaul Watson12-Feb-03 21:01 
Generalstore data Pin
Drawil12-Feb-03 9:16
Drawil12-Feb-03 9:16 
GeneralRe: store data Pin
DFU2314-Feb-03 4:03
DFU2314-Feb-03 4:03 
GeneralRe: store data Pin
Anonymous14-Feb-03 7:56
Anonymous14-Feb-03 7:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.