moving code from one server to another - HUGE problem

i have this in the database section of devshed - but noone seems to know... so i'll put it in here now!

the link is here

i'm stumped!!

background check:

are you using ODBC or strings to connect?

are these files being constantly replicated or are you just doing a one time migrate to another server?

i think odbc. here's what my connections look like ( i'll put in multiple ones that have worked ).

and they won't be replicated, i'm just putting them there for operation alone on this server.

strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & accessDB & ";"
set aconn=Server.CreateObject("ADODB.Connection")
aconn.Open(strconn)

set arec=server.createobject("ADODB.Recordset")
set arecM=server.createobject("ADODB.command")


and here's another

set conn = Server.CreateObject("ADODB.Connection")
accessdb=server.mappath("Guestbook.mdb")
DSNtemp="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & accessDB & ";"
conn.Open DSNtemp

have you done a simple read query? Select * from table and see if you got any results?

yes - that's what i meant by this: "i can get the response.write commands to work, but not an insert command"

sorry

if it's a one time move i'd create a .udl file and compare that to your current connection string.

after that, what error message are you getting? any?

i'm not familiar with udl files - the message i'm getting is "insert into command error".

uh oh, is this a SQL error? Print out your strSQL line and let's see the syntax.

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/mailinglist/mail2.asp, line 20

before that error, print out the actual sql line you created and are running aginst the DB is what i meant.

newfn = replace(request.form("First_Name"),chr(39),"")
newln = replace(request.form("Last_Name"),chr(39),"")
newem = replace(request.form("EMail_Address"),chr(39),"")
set conn = Server.CreateObject("ADODB.Connection")
accessdb=server.mappath("mailinglist.mdb")
DSNtemp="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & accessDB & ";"
conn.Open DSNtemp
SQLstmt = "INSERT INTO list (first_name, last_name, e-mail)"
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt & "'" & newfn & "',"
SQLstmt = SQLstmt & "'" & newln & "',"
SQLstmt = SQLstmt & "'" & newem & "'"
SQLstmt = SQLstmt & ")"

this exact code - works on another server... so the syntax is right for that server - when i move it here - it gives that error.... i've been stumped.

since we are basically chatting - i have aim on as: supimadam if you use aim