Board index » delphi » Alias vs. Path in SQL Database Calls

GreatLand Technology

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Alias vs. Path in SQL Database Calls

Anybody know why I can programmatically connect to sql servers only when I
specify a literal path to the database as opposed to using a BDE Alias? When
I used to write ObjectPAL (sorry for the curse word!!!) I was always able to
reference datasets with aliases (if I remember correctly). What could I be
doing wrong or, more importantly, what do I need to do right?

TIA.

Dave

Team

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Alias vs. Path in SQL Database Calls

Quote

>Anybody know why I can programmatically connect to sql servers only when I
>specify a literal path to the database as opposed to using a BDE Alias?

Please give an example where you're trying to make the connection...??

Are your using TDatabase?

FWIW, the Alias should show up in the list for the DatabaseName
property of DBDatasets in the Object inspector.... even without using
TDatabase.

=Bill=

Other Threads

1. Extracting path from BDE alias or database?

2. Reading the database path from the BDE Aliases

3. Unusual characters in alias database path

4. How to get the database's path of an alias that setup in ODBC

5. Unusual characters in alias database path

6. Database Alias Path - UNC?

7. BDE Alias path from Alias name?

8. Creating MS SQL Server database in the specific path Using SQL-DMO

9. ALIAS vs. ODBC Alias

10. Robustness of SQL Databases vs Desktop Databases