Error Writing to SQL Database from Intouch

Longhorn

Member
L
Join Date
Jul 2008
Location
Scotland
Posts
250
I am trying to write values from my Intouch application to an SQL database (2005), the values i am writing i have set-up in the relevant BIND Lists in Intouch and the corresponding fields in SQL Database. I have three bind lists to send to the database and have had all three working fine up until today when one spuriously started giving the following error:

microsoft odbc sql server driver sql server line 1 incorrect syntax near ')'

This is the diagnostic code from the SQL Insert command i get.

I have checked my script which doesnt seem to have any errors as its the same as the others apart from the bind list and table name ofcourse.

Does "Line 1" mean that on line 1 of the script lies the error? as all i have on line 1 is DIM ResultCode AS INTEGER????

Anyone else had this error??

Thanks LH
 
Longhorn said:
I am trying to write values from my Intouch application to an SQL database (2005), the values i am writing i have set-up in the relevant BIND Lists in Intouch and the corresponding fields in SQL Database. I have three bind lists to send to the database and have had all three working fine up until today when one spuriously started giving the following error:

microsoft odbc sql server driver sql server line 1 incorrect syntax near ')'

This is the diagnostic code from the SQL Insert command i get.

I have checked my script which doesnt seem to have any errors as its the same as the others apart from the bind list and table name ofcourse.

Does "Line 1" mean that on line 1 of the script lies the error? as all i have on line 1 is DIM ResultCode AS INTEGER????

Anyone else had this error??

Thanks LH
Click to expand...
SQL files can be repair due to sql database repair. The program restores mdf files after power failures, viruses, malicious software. It can show the results of repairing as a table list. Program works under Windows 98 and higher.
 

Similar Topics

J
Error Writing Port 0, Parameter 122 Value
Good Morning all Using PF 525, FTV 12, Studio 32.11 I am trying to download to the 525 and keep getting this "Error Writing "0" to Port 0...
Replies
8
Views
7,523
laucha13
L
C
FM353 syntax error writing MDI block
I'm struggling to get a stepper motor working. I have it working in inch mode and I can reference the drive and get the sync bit on. When I change...
Replies
0
Views
1,333
cottagewood
C
T
Mitsubishi GOT Communicater Error after reading and writing
Hello All We are running into a series of problems when reading from GOT 15 series HMI's then writing back to the same GOT. After writing to GOT...
Replies
2
Views
2,630
dploof23
D
V
CIP over Ethernet/IP on VMS -- 0x6a error when writing to a tag?
Hi, I've been writing a C program on OpenVMS AXP, to communicate with SoftLogix/1789-SIM module using CIP over Ethernet/IP. In...
Replies
10
Views
13,178
vorfeed
V
R
area length error when writing??
guys, I am trying to commission a software redundant system siemens S7 300. the SF led's are on with both processors, looking in the...
Replies
7
Views
6,484
Manglemender
M
Back
Top Bottom