Trying to ad a new line to a database
I have yet to have success opening the db and updating the file from an asp script
My error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
/manageprofile.asp, line 73
My script
' open the database connection
set
con = server.createobject( "adodb.connection" )
con.open
"accessdsn" <<<<<<<This is my line 73
%>
<
html>
<
head><title>Manage Profile</title></head>
<
body bgcolor="gray">
' add new profiledb
if addprofile <> "" then
sqlstring = "insert into profiledb " &_
"( screenname, password, emailaddress, first, mi, last, age, city, state, areacode, lookingfor, heading, briefdescription, fulldescription, picture ) " &_
values ( " & fixquotes( screenname ) & fixquotes( password ) & fixquotes( emailaddress ) & fixquotes( first ) & fixquotes( mi ) & fixquotes( last ) & fixquotes( age ) & fixquotes( city ) & fixquotes( state ) & fixquotes( areacode) & fixquotes( lookingfor ) & fixquotes( breifdescrtiption ) & fixquotes( fulldescription ) & fixquotes( picture ) & " )
con.execute sqlstring
My dsn name is "accessdsn"
and the root directory points to the correct file
what am I missing????
Edited by rbyikes - 20 February 2006 at 5:19am
Topic Options
Post Options
Thanks(0)
