Skip to Content.
Sympa Menu

internetworkers - RE: [internetworkers] ASP/access works locally but not on ISP

internetworkers AT lists.ibiblio.org

Subject: Internetworkers: http://www.ibiblio.org/internetworkers/

List archive

Chronological Thread  
  • 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, I’m very very new to the ASP world, so please
> > bear with me.
> >
> > I’ve 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 doesn’t 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





Archive powered by MHonArc 2.6.24.

Top of Page