Search results
-
C
Cannot Insert A Null Value Into Table Record
Using the sql profiler gives me no clue. This is the insert query from the profiler. exec sp_executesql N'INSERT INTO "ENVIS_GSD".."wat_springflow" ("result_dt","site_id","result_va","remark_tx") VALUES (@P1,@P2,@P3,@P4,@P5,@P6)', N'@P1 datetime,@P2 int,@P3 float,@P4 nvarchar(4),@P5... -
C
Run time Error 2147467259 Could Not Find File
Hi I am running Access 2000 with MDAC 2.8 and SQL Server 2000 database. I have linked the tables of the database in Access. The problem is that it would not allow me to insert/update/delete but only to select from the database. Here is the code: Dim strSQL As String Dim con As ADODB.Connection...