Hi to all
Can someone please help me.
I have writen the program and wanted to deploy, to the rest of the company, on my machine which is the server also then my DBLOOKUP works, but as soon as I deploy the program on another PC and open the program to work on it. The program give me a ERROR: B1:B0(Could not excute a DB function) why is this happening if it is working on my machine.
Regards
Heinrich Lubbe
Subject: ODBC @dblookup fail
Does the new PC have the correct ODBC drivers/connections?
Subject: RE: ODBC @dblookup fail
Hi Mike
I hope you are doing well my friend, I had a look on the pervasive engine on my machine as well as the other pc’s and the prevasive engines are exactly the same.
Heinrich
Subject: RE: ODBC @dblookup fail
Is your ODBC connection formula in script? Can you turn the debugger on to get the exact function it is trying to execute?
Subject: RE: ODBC @dblookup fail
Hi Mike
The @DBLookup is been written under a submit button.
How do you turn the debugger on?
Subject: RE: ODBC @dblookup fail
The debugger will only work for script
(BTW - to switch it on, you would click File…Tools…Debug LotusScript)
Does the new PC have the same permissions to the target data source?
Subject: RE: ODBC @dblookup fail
Yes, I gave the user Admin rights. So I don’t know where I am going wrong.
Subject: RE: ODBC @dblookup fail
What is your code? Paste it.
Subject: RE: ODBC @dblookup fail
Did you check the server events log for any login errors, the database log for errors? Also, on the client machine, did you TEST the DSN connection?
A thought… if the user has MS Access, see if Access can hit the Data Source using the DSN.
Another stupid question… was the DSN on the client configured for all users?
Subject: RE: ODBC @dblookup fail
Hi to all
Thanks it was only I needed to add the DSN on the User PC
Thanks for all your help.
Heinrich
Subject: That’s not exactly what Mike asked.
Are the ODBC Data Sources the same?
Subject: ODBC @dblookup fail
Stupid questions…
What are you looking up to? Does the target exist on a different server?
If so, then I once had this problem - the target server required user authentication in addition to the DB authentication. If the users could not authenticate with the server using their network ID, then they couldn’t get to the database to authenticate with the database user.