I have ran into an issue when trying to generate classes for ES with a VistaDB table with a password. When I set my connection information in MyGeneration I am providing the password in the connection string. The "Test Connection" works with the connection string. However, When I run the execute function to build the classes, the dialog form does not show any tables or views. If I remove the password from the VistaDB, then everything works fine.

 

 

"Setting the password for a database does much more than just prevent access to the file.  It actually encrypts the entire database using BlowFish.  The password is requested at startup as an encryption key, not just as a simple access restriction."

I'm not sure how MyGeneration would deal with that. It needs to get the schema in order to execute. You may have to decrypt in order to generate your EntitySpaces classes. Our EntitySpaces unit tests pass against an encrypted VistaDB database, with the password in the connection string.

---

David Neal Parsons
www.entityspaces.net

Correct. The password is working correctly with the database and the generated classes. It just seems that MyGeneration is not passing the password to the database when it tries to retrieve the schema to show in the generation form. It would seem that the connection made to the database to retrieve the schema would first have to be sucessful which would include the password.

As you mentioned, I have copied the database and removed the password so that MyGeneration could get the schema.

 

 

 

How strange, I will fix this in MyGeneration.

---

EntitySpaces | Twitter | BLOG | Please honor our Software License

This problem exists with ES 2008 also. Is there an ETA as to when this will be fixed? I was hoping it would be fixed with ES 2008.