Subject | Alias connection problem. |
---|---|
Author | delphigurusam |
Post date | 2005-07-11T21:12:23Z |
All XP (Home and Pro) in a Peer-to-peer
All PCs IP address dynamically assigned
The Firebird server is DevBox_1.
** CONF settings: **
FIREBIRD.CONF
DatabaseAccess = None
ALIAS.CONF
# List of known database aliases
# ------------------------------
# dummy = c:\data\dummy.fdb
AT6Test=c:\program files\at60test\auctiontracker.fdb
CT6Test=c:\program files\at60test\constituent.fdb
I also have datasources defined on the Firebird PC server DevBox_1 for
AT6Test and CT6Test, since I originally developed this app using a
D7/ADO database connection object and built the connection string with
the MS ODBC manager.
If I use just the "AT6Test" and "CT6Test" (as instructed in THE book)
in the D7/ADO/Database connection object connection string, it runs
fine on the server, but not on the client. If I replace the ODBC
manager-created connection string with the alias address type of
DevBox_1:AT6Test, I get the following error from the server AND client
machine (with approriate FB client installed):
"Error: [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified"
This should be simple, but it evades me.
Thx in adavance.
Sam Hunt
All PCs IP address dynamically assigned
The Firebird server is DevBox_1.
** CONF settings: **
FIREBIRD.CONF
DatabaseAccess = None
ALIAS.CONF
# List of known database aliases
# ------------------------------
# dummy = c:\data\dummy.fdb
AT6Test=c:\program files\at60test\auctiontracker.fdb
CT6Test=c:\program files\at60test\constituent.fdb
I also have datasources defined on the Firebird PC server DevBox_1 for
AT6Test and CT6Test, since I originally developed this app using a
D7/ADO database connection object and built the connection string with
the MS ODBC manager.
If I use just the "AT6Test" and "CT6Test" (as instructed in THE book)
in the D7/ADO/Database connection object connection string, it runs
fine on the server, but not on the client. If I replace the ODBC
manager-created connection string with the alias address type of
DevBox_1:AT6Test, I get the following error from the server AND client
machine (with approriate FB client installed):
"Error: [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified"
This should be simple, but it evades me.
Thx in adavance.
Sam Hunt