Re: Access Query w/VBScript

I have been usinging a Windows Remote Server to exercise the ASP scripts -
was waiting for one of the universitie's departments to provide us web space
on their IIS server. Well, we have got the space now. Of course, none of
the scripts (including the one I have posted) now work.

More information: Some ASP pages will be accessing Access data and others
MySql - both databases will reside on servers, but not the web server. I
have experimented with the code for connecting to MySql, but have not been
successful. I have tried using a DSN and DSN-less with no luck. Below is
the code and error messages.

<%Option Explicit%>
<HTML>
<HEAD>
<TITLE>Testing our connection</TITLE>
</HEAD>
<BODY>

<%
Dim oConn, oRS
Set oConn = Server.CreateObject("ADODB.Connection")
set oRS = Server.CreateObject("ADODB.Recordset")
oConn.Open "DSN=pers_dbOdbc"

oRS.Open "tblEmployees", oConn

While Not oRS.EOF
Response.Write oRS("LastName") & ", "
Response.Write oRS("FirstName") & "<BR>"
oRS.MoveNext
Wend

oRS.Close
oConn.Close
Set oRS = Nothing
Set oConn = Nothing
%>

</BODY>
</HTML>

The DSN(UID/PASSWORD not really *):
[ODBC]
DRIVER=MySQL ODBC 3.51 Driver
UID=*****
STMT=
OPTION=2
PORT=
PASSWORD=*****
SERVER=asthma.arc.arizona.edu
DATABASE=theDbNameHere
DESC=

The error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/temp.asp, line 12

Thanks for looking.


.

Relevant Pages

  • Re: Where does processing take place when executing a remote package?
    ... here's my code that modifies the Job on server 2. ... Dim oConn, strSQL ... Set oConn = CreateObject ...
    (microsoft.public.sqlserver.dts)
  • IIS 5 stops serving coldfusion pages
    ... where they stop serving our coldfusion content. ... Am no IIS genius so would love some ... Win 2K server. ... But as mentioned above there are no ASP scripts on our server so this ...
    (microsoft.public.inetserver.iis)
  • ASP script debugging XMLHTTP component issue
    ... pagethrough MSXML2.XMLHTTP or MSXML2.ServerXMLHTTP in ASP scripts. ... IIS 5.0 (Windows 2000 standart server) ... IIS 5.1 (Windows XP Professional) ...
    (microsoft.public.inetserver.iis)
  • ASP script debugging XMLHTTP component issue
    ... pagethrough MSXML2.XMLHTTP or MSXML2.ServerXMLHTTP in ASP scripts. ... IIS 5.0 (Windows 2000 standart server) ... IIS 5.1 (Windows XP Professional) ...
    (microsoft.public.inetserver.iis.activeserverpages)
  • Re: filter guestbook to block URLs?
    ... It is unusual for ASP scripts to require physical access to the ... In the meantime, if your guestbook is named guestbook.htm, try ... > physical server, which I don't, so I'll have to see. ...
    (microsoft.public.frontpage.programming)