Can someone check small code - see why it doesn't work?

slakker · Nov 3, 2003

Hey guys.. I'm trying to make a very small TEST site with DW MX 2004, the point-and-click way.. without manually writing any code (not that i'm good at it anyway)

But I can't get it to work, i've tried to create and recreate sites, keep changing little things, but still nothing..

===========================================================

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
Dim rsRecentNews
Dim rsRecentNews_numRows

Set rsRecentNews = Server.CreateObject("ADODB.Recordset&quot

rsRecentNews.ActiveConnection = MM_db_STRING
rsRecentNews.Source = "SELECT * FROM Table1 ORDER BY newsDate DESC"
rsRecentNews.CursorType = 0
rsRecentNews.CursorLocation = 2
rsRecentNews.LockType = 1
rsRecentNews.Open()

rsRecentNews_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
rsRecentNews_numRows = rsRecentNews_numRows + Repeat1__numRows
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "

http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
My Homepage
Recently, I've added a number of things to my site:
<%=(rsRecentNews.Fields.Item("newsDate&quot

.Value)%>
<%=(rsRecentNews.Fields.Item("newsText&quot

.Value)%>
</body>
</html>
<%
rsRecentNews.Close()
Set rsRecentNews = Nothing
%>
==========================================================

----------------- My Connection file --------------------

<%
' FileName="default_oledb.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_db_STRING
MM_db_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\folder\test\news.mdb;Persist Security Info=False"
%>
----------------- My Connection file --------------------

I upload the index.asp in the Root
news.mdb into the Root
and /Connections/db.asp

I try to access via the internet, I get http 500 internal error.

I don't understand how the connections file is supposed to locate my database when i'm trying site on the internet, when it thinks the location is c:\folder\etc..

But I did try changing that to just local path.

lebisol · Nov 3, 2003

different ways to connect to your DB...on your Loacl machine it will work but not on the "internet"-production server.
u need to use 2 connection strings...1 at home the other for the server.
use DSN-less and 'map the path' to the db location on the server

MM_MY_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Persist Security Info=False; Data Source=" & Server.MapPath("/fpdb/MY_DATABASE.mdb&quot

& ";

notice that folder 'FPDB' can be anywhere as long as the server has is recognised as part of the site.Actuall phisycal loaciton can be C:\websites\users\user_z\

http://wwwroot\fpdb

but the "Map.Path" command tells the server to "not worry" about the structure but simply point to 1 folder (which should have appropriate rights) where the DB is loacted......
take a look at :

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm

sorry if the post is confusing...I am in a bit of rush but these concepts should get u going
ALl the best!

> need more info?
:: don't click HERE ::

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Can someone check small code - see why it doesn't work?

slakker

MIS

lebisol

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor