So this is odd. For the last month my application has been running fine. Today it starts reporting that it failed to log in to the server, because the server is reporting the username or password is invalid. I can log in with EDB Manager just fine using that username/pswd combination, but the application cannot. I noticed the server was v229 Build 1 and I'm using the latest 238 B2 with D12, so I updated the server to 238 B2 as well, but that didn't help.

Kind of at a loss as to understand what the issue might be.

Olybino


The main thing to remember is that EDBManager is just another Delphi application so there will be either some difference in your application or some external factor. Almost invariably with this sort of problem there is a difference.

You've probably tried the obvious things but just in case:

1. Path (ie looking at a different version of the database, don't know if this would give a 501 error)
2. One set to ansi and the other to unicode
3. Some test code left in the application which alters the username/password before its sent to the server
4. Signature or Encryption different between EDBManager and the application
5. Engine set to local in the application (don't know if this would give a 501 error)

Roy Lambert

For fun I dropped a Session component on the main form, and that works. So it's something about creating the session in the TThread that is raising the error. I set the Characterset by hand, so that's not it, but there's a whole lot of other properties to verify.

Olybino


If you're using ElevateDB in a thread you need full isolation - you need to create the sessions, databases, tables, queries in the thread. The only component you don't need to (and shouldn't)  create is the engine.

Roy Lambert

yeah, it's not my first time at the rodeo. Turns out the issue is either the encryption password or the flag itself, One of those is a different default than what appears when you drop a component on a form. It all works now.