I am having some problem with the sql odbc- i have created a dsn on my lotus notes server
"SQLTEST". now i have a database on the same server where i have created an agent. in the agent i
am connecting to the sql database.the script is as below
Dim ws As New notesuiworkspace
Dim se As New notessession
Dim db As notesdatabase
Dim doc As notesdocument
Dim dc As notesdocumentcollection
Dim conn As New odbcconnection
now when i run the agent from my client machine i am getting msgbox result as False. and the
geterrormessage returns the below error message:
"[Microsoft][ODBC Driver Manager]Data Source name not found and no default driver specified
LS:DO-ODBC could not complete the requested operation."
When i create the dsn on my client machine it is working fine .
now what is the problem? is it that i have to access the odbc only from the client machine. i want to
have the dsn centralised and kept in the server such that i can access it from any workstation.
Is the problem related with the lotus script or something to do with the ODBC driver manager why i
am asking this because the error message states something like that.
Please help me with a solution immediately.