SQL Data posting issue (Urgent help needed)

HCL Domino Domino Forum
1

Hi There,

I am trying to insert / update rows in SQL table from a lotus notes database using LSX LC scripts.

  • Able to connect successfully.

  • Able to do select query successfully.

  • Fail to Insert / Update rows in SQL table.

Error is: 12336 - Error: This connection has been dropped, Connector ‘oledb’, Method -Insert-

SQL Server is 10.0.2531

Lotus notes client is 8.5.3 Version .

Using a sql user account I am connecting to SQL database and this user is an owner of the SQL database where trying to insert/update.

src is a connection string, before insert data in a table checked the isconnection property is set as true.

count = src.Insert(FldList,1,1)

Thanks in advance… please help.

Thank you,

Nanda

2

Subject: SQL Data posting issue (Urgent help needed)

chk below link… may give you the clue :wink:

http://www-10.lotus.com/ldd/nd85forum.nsf/0/9987a769e1adf1e4852579de0051dd2e?OpenDocument

3

Subject: SQL Data posting issue (Urgent help needed)

Given that your Notes client is 8.5.3, it would make sense to post this question in the Notes 8.5 forum.