Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
FTP uploading
- Thread starter obaluba
- Start date
do you mean to jsut connect to the DB? or are you having trouble FTPing the files I dare to learn more
admin@onpntwebdesigns.com
admin@onpntwebdesigns.com
- Thread starter
- #3
- Thread starter
- #4
if this helps, my code is as follows
<% Response.buffer = true %>
<html>
<head>
<title>gallery</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body bgcolor="#FF0000" text="#CCCCCC">
<p><font color="#FFFFFF" size="2" face="Tahoma"><font color="#666666">Welcome
to the Astra-sport online ASP gallery</font></font></p>
<p><font face="Tahoma"><font size="2">
<% Dim rs
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\rob\mk4.mdb"
rs.Open "mk4", "DSN=mk4"
While Not rs.EOF
Response.Write "ID : " & rs("Username" & "<br>"
Response.Write "Name : " & rs("Name" & "<br>"
Response.Write "e-mail : <a href=""mailto:" & rs("e-mail" & """>" & rs("e-mail" & "<br>"
Response.Write "URL : <a href=""" & rs("URL" & """>" & rs("URL" & "</a><br>"
Response.Write "Location : " & rs("Location" & "<br>"
Response.Write "Modifications : " & rs("Modifications" & "<br>"
Response.Write "images : <img src=""" & rs("images" & """ border=""0""><br>"
Response.Write "<br>"
rs.MoveNext
Wend
rs.Close
Set rs = Nothing %>
</font></font></p>
<p> </p>
<p> </p>
<p> </p>
<div align="center"></div>
</body>
</html>
the error message i get is:
ADODB.Connection.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/rob/mk4.asp, line 12
any help would be appreciated!!
thanks in advance
<% Response.buffer = true %>
<html>
<head>
<title>gallery</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body bgcolor="#FF0000" text="#CCCCCC">
<p><font color="#FFFFFF" size="2" face="Tahoma"><font color="#666666">Welcome
to the Astra-sport online ASP gallery</font></font></p>
<p><font face="Tahoma"><font size="2">
<% Dim rs
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\rob\mk4.mdb"
rs.Open "mk4", "DSN=mk4"
While Not rs.EOF
Response.Write "ID : " & rs("Username"
& "<br>"Response.Write "Name : " & rs("Name"
& "<br>"Response.Write "e-mail : <a href=""mailto:" & rs("e-mail"
& """>" & rs("e-mail" & "<br>"Response.Write "URL : <a href=""" & rs("URL"
& """>" & rs("URL" & "</a><br>"Response.Write "Location : " & rs("Location"
& "<br>"Response.Write "Modifications : " & rs("Modifications"
& "<br>"Response.Write "images : <img src=""" & rs("images"
& """ border=""0""><br>"Response.Write "<br>"
rs.MoveNext
Wend
rs.Close
Set rs = Nothing %>
</font></font></p>
<p> </p>
<p> </p>
<p> </p>
<div align="center"></div>
</body>
</html>
the error message i get is:
ADODB.Connection.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/rob/mk4.asp, line 12
any help would be appreciated!!
thanks in advance
The problem is probably your DSN.
This DSN is most likely not set on your server so it is not resolving. Try using the connection object that you set up rather than the DSN. Before doing so, however, check the path in the connection string to make sure it will still be valid on the remote server.
<-- Check this
<-- Change this
<-- To this
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
This DSN is most likely not set on your server so it is not resolving. Try using the connection object that you set up rather than the DSN. Before doing so, however, check the path in the connection string to make sure it will still be valid on the remote server.
Code:
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\rob\mk4.mdb")
Code:
rs.Open "mk4", "DSN=mk4"
Code:
rs.Open "mk4", Conn-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
Oh, and instantiate you recordset object, sorry, missed that one:
<--
--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
Code:
<% Dim rs, Conn
Set rs = Server.CreateObject("ADODB.RecordSet")
Code:
Set Conn = Server.CreateObject("ADODB.Connection")- Status
Similar threads
