internetworkers AT lists.ibiblio.org
Subject: Internetworkers: http://www.ibiblio.org/internetworkers/
List archive
RE: [internetworkers] ASP/access works locally but not on ISP
- From: "Kurt Schlatzer" <kurt AT kurtschlatzer.com>
- To: "Internetworkers: http://www.ibiblio.org/internetworkers/" <internetworkers AT lists.ibiblio.org>
- Subject: RE: [internetworkers] ASP/access works locally but not on ISP
- Date: Thu, 4 Dec 2003 11:11:18 -0500
internetworkers-bounces AT lists.ibiblio.org wrote:
> Hello everybody, Im very very new to the ASP world, so please
> bear with me.
>
> Ive just created a very simple ASP/javascript dynamic site,
> using MS access
> for my database. I did test everything locally on my XP IIS, and it
> works fine. But once I uploaded to the host server, it doesnt work.
> It returns this error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Driver Manager] Data source name not found and
> no default
> driver specified
>
> I have contacted the hosting place, and they said they ran a test on
> my datasource, and it did check out, and as far as they know, the
> page should be
> working. And here's how I'm calling the datasource from my ASP page:
>
> <%
> Recordset1 = Server.CreateObject("ADODB.Recordset");
> SQLQuery = "SELECT * FROM tb_tipo ORDER BY tipo_nome";
> Recordset1.Open(SQLQuery,"receitas");
> %>
>
I'm a assuming "receitas" is your DSN. Use this:
<%
Dim DBConn, Recordset1, SQLQuery
Set DBConn = server.createobject ("ADODB.Connection")
DBConn.open "DSN=receitas;"
Recordset1 = Server.CreateObject("ADODB.Recordset")
SQLQuery = "SELECT * FROM tb_tipo ORDER BY tipo_nome"
Recordset1.Open SQLQuery, DBConn,1,2
%>
Kurt
www.kurtschlatzer.com
-
[internetworkers] ASP/access works locally but not on ISP,
Marcia, 12/04/2003
-
RE: [internetworkers] ASP/access works locally but not on ISP,
Kurt Schlatzer, 12/04/2003
-
RE: [internetworkers] ASP/access works locally but not on ISP,
Marcia, 12/04/2003
-
RE: [internetworkers] ASP/access works locally but not on ISP,
Kurt Schlatzer, 12/04/2003
-
Re: [internetworkers] ASP/access works locally but not on ISP,
James Manning, 12/04/2003
- RE: [internetworkers] ASP/access works locally but not on ISP, Kurt Schlatzer, 12/04/2003
- RE: [internetworkers] ASP/access works locally but not on ISP, Marcia, 12/04/2003
-
Re: [internetworkers] ASP/access works locally but not on ISP,
James Manning, 12/04/2003
-
RE: [internetworkers] ASP/access works locally but not on ISP,
Kurt Schlatzer, 12/04/2003
-
RE: [internetworkers] ASP/access works locally but not on ISP,
Marcia, 12/04/2003
-
RE: [internetworkers] ASP/access works locally but not on ISP,
Kurt Schlatzer, 12/04/2003
Archive powered by MHonArc 2.6.24.