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
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. I´ve 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.