TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
tiradochristopher
NA
1
0
insert into dbf files from asp.net
Dec 27 2004 12:30 PM
I'M MAKING A WEB PAGE IN VISUAL BASIC .NET, AN ASP PROYECT, OK, IT IS AN EXTENTION OF ANOTHER PROGRAM THAT USES SOME DBF TABLES. OK, I CAN MAKE SELECTS IN THOSE TABLES, BUT I CAN NOT INSERT DELETE OR UPDATE ANYTHING, MY CODE IS THIS: Dim querys As String Dim mistringCon1 As String = "Driver={Microsoft Visual FoxPro Driver}; SourceDB=" + data_path + "; SourceType=DBF;Userid=; Password=" Dim miConexion1 As New Microsoft.Data.Odbc.OdbcConnection(mistringCon1) Dim orden As Microsoft.Data.Odbc.OdbcCommand querys = "Insert Into NETWORK.dbf VALUES ('ghhghdfh')" orden = New Microsoft.Data.Odbc.OdbcCommand(querys, miConexion1) orden.Connection.Open() orden.ExecuteNonQuery() orden.Connection.Close() AND THE ERROR IS Error de servidor en la aplicación '/Trackikt-E/Proyecto/Trakit-E'. ________________________________________ ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]No se puede actualizar el objeto Cursor. Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código. Detalles de la excepción: Microsoft.Data.Odbc.OdbcException: ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]No se puede actualizar el objeto Cursor. Error de código fuente: Línea 38: orden = New Microsoft.Data.Odbc.OdbcCommand(querys, miConexion1) Línea 39: orden.Connection.Open() Línea 40: orden.ExecuteNonQuery() Línea 41: orden.Connection.Close() Línea 42: End Sub I MADE ANOTHER PROYECT, AN APPLICATION PROYECT AND I USED THE SAME CODE, EXACTLY, AND GUESS WHAT, IT RUNS, SO, I CAN INSERT FROM AN APPLICATION PROYECT, WHY IN ASP I CAN´T?, AM I USING THE APPROPIATE CODE? PLEAASE HEEEELP ME, I HAVE NOTHING MORE TO SAY, EXCEPT, THANKS, THANKS FOR READ THIS HAPPY HOLLYDAYS, ATTE: ISC. CHRISTOPHER IVAN TIRADO OSCOY
Reply
Answers (
1
)
Binding CheckBoxList to Database and the returning a SQL statement
Mysterious VS.NET gremlins