I am using set of lookups in formula language to extract the data from SQL Server,I have tested the application on my local machine by creating the ODBC.But now i have created the ODBC on my domino server and removed the ODBC from my Local machine,but it is giving the error.Do i have to set the ODBC on all the machines.
Subject: ODBC on server
If the @Dblookup is on your form and running in a Notes client then you have to setup an ODBC connection per client. If this is a web application it should work since it runs on server and you may just have an error in the ODBC config on server.
If this @DBlookup is running on a Notes Client you can encapsulate it into an agent(scheduled) or call it using notesAgent.runOnServer you use the server ODBC connection to avoid the admin heavy setup of ODBC per Notes Client.
In general if you need to retrieve data I would suggest writing the code in LC LSX(faster as it has a connection persistence available) or LS:DO(slower performance in general especially since it does not allow connection persistence) and then running the agent as run on server.
Subject: RE: ODBC on server
Rami I am using @dbcommand.Please give me some idea that how to run notesagent.runonserver.
I am new in ODBC Concept
Subject: RE: ODBC on server
Look at Designer help for the NotesAgent methods.