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: Marcia <msmartin AT ccbeunet.br>
- To: kurt AT kurtschlatzer.com, "Internetworkers: http://www.ibiblio.org/internetworkers/" <internetworkers AT lists.ibiblio.org>
- Cc:
- Subject: RE: [internetworkers] ASP/access works locally but not on ISP
- Date: Thu, 4 Dec 2003 14:47:32 -0200
It tells me "The page cannot be displayed".
There is a problem with the page you are trying to reach and it cannot be
displayed.
-------------------------------------------------------------------------------
blah blah blah....
HTTP 500 - Internal server error
Internet Explorer
Is that still javascript or is it VBscript?
I simply substituted:
<%@LANGUAGE="javascript"%>
<%
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
%>
for
<%@LANGUAGE="javascript"%>
<%
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
%>
And yes, "receitas" is tha name of my DSN.
Thanks again!
-Marcia
Quoting Kurt Schlatzer <kurt AT kurtschlatzer.com>:
> 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
>
> ---
> Come and play at the InterNetWorkers Web site!
> http://www.ibiblio.org/internetworkers/
> You are currently subscribed to InterNetWorkers mailing list
> To unsubscribe visit
> http://lists.ibiblio.org/mailman/listinfo/internetworkers
>
-------------------------------------------------
WebMail Litoral Internet
www.litoral.com.br
-
[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.