Search code examples
sqlsql-serverodbcc++builderparadox

From Paradox to SQL Server in Borland C++ 5

I'm in the process of converting an old application to work with SQL Server instead of hundreds of Paradox DB files.

I'm using ODBC and most of the stuff is working.

However I do have a problem.

In some forms, is asking for password. I've double checked the TDatabase and TTable components, added USER NAME=sa and PASSWORD=****** to the Parameters and turned OFF the LoginPrompt

What's missing?

Is there any other way to initialize just once all the 5 databases and don't ever ask for password again?!

I've checked other questions here at StackOverflow, but didn't find a suitable one :(

Thank you

Solution

  • You can use SQL Server "Windows Authentication" mode. You can assign the database permissions to a Windows Domain group/groups or individual Windows users. In this case the users will be automatically authenticated to the databases without prompts.