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: "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, 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





Archive powered by MHonArc 2.6.24.

Top of Page