I made the website locally using PWS (Access Database). Everythings seems to be okay locally but when I upload it to ftp13.websamba.com and I tried to view it and this message comes out :
==========================
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/mysoccer/newslist.asp, line 5
===================
Here are the few first lines on my page :
===================
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Msodatas.asp" -->
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_Msodatas_STRING
Recordset1.Source = "SELECT * FROM localnews"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
==============================
Can someone help me on this?

Here is the URL
www.websamba.com/mysoccer/newslist.asp

ANy help will be most appreciated

CHECKLIST

Have you set up a DSN at the Web Host?

Does the database need to be in a specific directory at websamba.com? Some hosts require that it is.

Did you upload Connections/Msodatas.asp?

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

I have uploaded the file msodatas.asp in the connection directory (in fact I have uploaded the entire site)

I thought when it all okay locally than it'll be okay too remotely (just like what the Help section says, UD takes care the rest)

But still I think I still didn't set up a DSN at the web host....do I have to ask them for it? How?





Edited by - mysoccer on 09/16/2001 05:13:37

It varies, some hosts provide a control panel so you can set one up yourself, others you have to ask and they'll do it for you.

However there is an alternative. You could set up an OLE DB conection, provided you know the directory structure at the host you can set the file up locally and upload it to the site. This saves waiting for a host to set up a DSN. There is a section on setting up an OLE DB in the tutorial, link at the bottom of the page.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo