ODBC problem

[pj_whi...@hotmail.com]

Domino 6.5.4 / Notes 6.5.4

I have created some LS routines to retrieve data from our ERP system
(MSSQL2000). The routines all work. One of the LS routines uses ODBC
to run a SQL stored procedure that creates rows in a table. Using LSX
I can read the rows and manipulate them for display in my Notes DB.
Another SQL stored procedure is then accessed via ODBC to remove these
records from the table.

However ... when a normal network user run the scripts on a different
PC the (System DSN) ODBC does not function through Notes. Testing
with nlctest does however is OK.

Under the same network account, but using my Lotus Notes admin
account, also fails.

To recap:

Network Admin account / Notes Admin user - OK
Network STD account / Notes STD user - Fail
Network STD account / Notes Admin user - Fail

No doubt I am missing something very obvious - but with the heatwave
has come brain-meltdown. If anyone has a solution could they please
put me out of my misery.

Thanks in advance.

Paul

[Joerg Mertens]

"pj_whi...@hotmail.com" <pj_whi...@hotmail.com> writes:

> However ... when a normal network user run the scripts on a different
> PC the (System DSN) ODBC does not function through Notes. Testing
> with nlctest does however is OK.

Where is the DSN defined? On each Client PC?
Does the Script run on the Notes Client?

> Under the same network account, but using my Lotus Notes admin
> account, also fails.

You can retrieve detailed error messages through the LSX classes. What
do they say?

[pj_whi...@hotmail.com]

On Jul 2, 11:21 pm, Joerg Mertens <joerg-mert...@t-online.de> wrote:

Joerg

Thanks for taking the time to reply to my posting - sorry its taken so
long to get back but I've dealing with a couple of things at work and
this got put on the back burner.

I have now rewritten the code from scratch without using ODBC DSN -
not many lines so not too bad - and it now works. It's a pity that
the original requester no longer wants the functionality! However, I'm
sure I'll get to use the methodolgy for something, for someone, at
some time.

Once again, thanks for your time. It's nice to know that there are
people 'out there' willing to lend a helping hand.

Best regards

Paul