Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Into
Message
From
28/03/2002 07:35:36
Fabian Belo
Independent Developer
Argentina
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Insert Into
Miscellaneous
Thread ID:
00638325
Message ID:
00638325
Views:
68
I've spent 3 hours+, and....Access ODBC piss me off!
Please, somebody have any clue to fix it?

set conn = Server.Createobject("ADODB.Connection")
conn.open "lista1"
SQLstmt = "INSERT INTO lista (Name,City,State,Country,Email,Usuario,Password)"
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt & "'" & Name & "',"
SQLstmt = SQLstmt & "'" & City & "',"
SQLstmt = SQLstmt & "'" & State & "',"
SQLstmt = SQLstmt & "'" & Country & "',"
SQLstmt = SQLstmt & "'" & Email & "',"
SQLstmt = SQLstmt & "'" & Usuario & "',"
SQLstmt = SQLstmt & "'" & Password & "'"
SQLstmt = SQLstmt & ")"

Set RS = conn.execute(SQLstmt)


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
"Since I've read that alcohol is bad... I quit reading."
Me


http://www.fabianbelo.com.ar
Next
Reply
Map
View

Click here to load this message in the networking platform