I am trying to connect my TDatabase object to ODBC via FileDSN in Delphi5. I already created a DSN file and it works very fine when connecting to it via C# or VB6.
For example, the syntax in C# is:
private string GetConnectionString(string fileDSNPath, string userName, string password)
{
return string.Format("ODBC;DATABASE=library;FILEDSN={0};UID={1};PWD={2};ALLOWUNSCHAR=0;", fileDSNPath, userName, password);
}
Using Delphi 5 IDE, I tried to define TParams but it doesn't work: TParams: FILEDSN=[my DSN file path]
I am getting the error:
"Unknown Database. Alias: db"