Home > Lotus Notes > Lotus Notes Odbc Error 720

Lotus Notes Odbc Error 720

I'm getting an error updating the SQL server for each document accessed. i.e. at line number 12Posted by Santas Lei on 26.Sep.02 at 11:19 PM using a Web browserCategory: Domino Designer -- LS:DORelease: 5.0.4aPlatform: Windows 2000 1) I think first you need to test Have you any idea to correct this problem ? Source

It may be holding something open , so that you can not access it from the server. We have proved the ODBC connection words as we can connect via Excel and run our query, and apparently there has been no changes made to the platforms. LEARN MORE Suggested Solutions Title # Comments Views Activity lotus domino server console error 1 62 333d Lotus notes Formula to trigger Lotusscript 1 482 272d Email Forward: Get Around Relay In this particular case, access was through a web browser (web-based application) and the URL was being redirected by an internal DNS server to a failover server that did not have

Running a connectivity test from the SystemDSN (locally) from the Lotus Domino server to the SQL server worked each time, proving that the SystemDSN for the MS SQL ODBC datasource was import-bot (20212) Offline Oct 29, 2000 @ 10:00 PM #2 [Originally posted by h-ramos] I am trying to write a manually activated agent to update a MS-SQL server with data from If you have any ideas please forward it. What is the difference (if any) between "not true" and "false"?

And if I change user/pass I get: Authorization failure on distributed connection attempt. Line 25 -> connect.Connect Answer This problem can arise due to many factors. Using LS:DO to connect to DB2 on AS/400 getting error 720 Im trying to connect to a DB2 database on an AS/400 server. Then report here the lines before the error.

There is an LEI scheduled task that will update the SQL server. Create new registration RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support The agent work properly when it is manually run but always stop at line 12 with the following error message : Error 720 : LS:DO- ODBC could not complete the requested http://www-10.lotus.com/ldd/46dom.nsf/0/87c9f05285447d9485256c40004ea21e Marc -- Use our news server 'news.foorum.com' from anywhere.

I have a scheduled agent that should gather on a regular basis data from an MS Access database. Also see if you can find a program that shows the status of all ODBC connections, from the OS I hope this helps ! 0 LVL 46 Overall: Level 46 you can try the c:\lotus\domino\nlctest utility to test the ODBC connection by your DSN. 2) As in your code, I think you can try to hardcode the password in your script RE: Error 720 : LS:DO- ODBC could n... (Santas Lei 26.Sep.02) . .

It might produce HUGE files, by the way. 0 LVL 46 Overall: Level 46 Lotus IBM 44 Message Active 1 day ago Expert Comment by:Sjef Bosman2005-09-15 Hey thanks! NotesSQL Error: "[Lotus][ODBC Lotus Notes]Error in assignment" (numeric field) 6. On local machine nothing run with planning. Macafee has been the only thing that has been run recently.

Forgot your user name? this contact form Then start the procedure locally, so if it's an agent, go to the agent list, right-click on it and select Run. at line number 12 Error 720 : LS:DO- ODBC could not complete the requested operation. But what was in fact the problem? 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with

Im using a Lotusscript agent and LS:DO. (*LSXODBC) Ive done this before in other environments without problems, but this time I cant get it to work. How to know if a meal was cooked with or contains alcohol? Compression Specs 3. have a peek here Problem: When running the new agent locally (during testing and debugging), everything related to establishing the connection, making a query and returning a resultset is working fine (I have a local

Then start the procedure locally, so if it's an agent, go to the agent list, Go to Solution 4 Comments LVL 46 Overall: Level 46 Lotus IBM 44 Message Active Call con.ConnectTo("PRODFEATSET","GTS","PSW123") Good luck. Return to top

Error 720 : LS:DO- ODBC could not c... (Daniela Inverni... 26.Sep.02) . . RE: Error 720 : LS:DO- ODBC could n... (Santas Lei 26.Sep.02) . .

Used to be in the ODBC properties in the Control Panel.

Error occurred .... 720 : LS:DO -ODBC could not complete the requested operation. Privacy Policy Site Map Support Terms of Use Workarounds: There are two ways to work around this issue: 1. more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science

Not the answer you're looking for? Related information Document information More support for: IBM Domino Software version: 6.0, 6.5, 7.0, 8.0 Operating system(s): Windows Software edition: All Editions Reference #: 1280094 Modified date: 08 January 2009 Site Watson Product Search Search None of the above, continue with my search Error: "...ODBC ResultSet...could not complete the requested operation" when running LSXODBC agent lei; LSXODBC; agent; HTTP; errors; error; Error http://edvinfo.com/lotus-notes/lotus-notes-mapi-set-up.html Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use.

Join them; it only takes a minute: Sign up ODBC could not complete the requested operation up vote 0 down vote favorite I am having a problem with an a lotus More details at: http://nnrpinfo.go.foorum.com/ Top Error 720 by ODBC by ezra » Sat, 30 Nov 2002 07:06:50 > hey, > Some problem with task with lotus. Ive got 3 other scheduled agents connecting to the same OBDC source, so all the initial code its taken from these agents. mailboxes in $HOME 8.