Re: Access Query w/VBScript

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

  • Dts von adp ausführen
    ... Ich habe folgenden Code ... Set oConn = oPKG.Connections ... Beim Setzen der Datasource kommt als Fehlermeldung "ungültige ... und auf dem Server, auf dem der SQL Server läuft. ...
    (microsoft.public.de.access.clientserver)
  • 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)
  • Re: Best approach to locking down a single file on a public website?
    ...  Windows 2003 Server w/ IIS 6. ... The .asp scripts need access to the encrypted file. ... while you have disabled directory browsing in IIS. ... You can upgrade to windows 2008, where the rootdirectory and all but one ...
    (microsoft.public.inetserver.asp.general)
  • 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)