Subject | Error: [Microsoft][ODBC Driver Manager] Datasource name not found... |
---|---|
Author | delphigurusam |
Post date | 2005-07-26T23:26:10Z |
WinXP Pro, SS, Delphi7 Ent/ADO
FB1.5.2 server installed on computer named NSTI-2
FB client installed (using same CD) on computer named NSTI-5
NSTI-2 FB file settings:
FIREBIRD.CONF
DatabaseAccess = None
ALIASES.CONF
AUCT-TR_AT=C:\Program Files\AUCT-TR\AuctionTracker.fdb
MS ODBC MANAGER DSN Definition:
Database: NSTI-2:AUCT-TR_AT
On Server NSTI-2, MS ODBC MANAGER reports successful connection when
creating this DSN.
The server, NSTI-2 runs an app that uses this database from its "D"
drive (not mapped) just fine.
The client, NSTI-5 can successfully ping the server NSTI-2 and
successfully TELNET NSTI-2 3050, but gets the following error on the
"dm.AuctionTracker.open" statement when it attempts to execute the
same EXE.
Error: [Microsoft][ODBC Driver Manager] Datasource name not found and
no default driver specified
... APP CODE SNIPPET ...............................
dm:=Tdm.create(application);
dm.AuctionTracker.ConnectionString:='Provider=MSDASQL.1;Password=nologin;Persist
Security Info=True;User ID=nologin;Data Source=AUCT-TR_AT;Extended
Properties="DSN=AUCT-TR_AT;Driver=Firebird/InterBase(r)
driver;Dbname=NSTI-2:AUCT-TR_AT;CHARSET=NONE;UID=nologin"';
if not (dm.AuctionTracker.Connected) then
dm.AuctionTracker.open;
......................................................................
How is this possible to receive this msg when I have fully specified
the connection string at runtime?
Sam Hunt
FB1.5.2 server installed on computer named NSTI-2
FB client installed (using same CD) on computer named NSTI-5
NSTI-2 FB file settings:
FIREBIRD.CONF
DatabaseAccess = None
ALIASES.CONF
AUCT-TR_AT=C:\Program Files\AUCT-TR\AuctionTracker.fdb
MS ODBC MANAGER DSN Definition:
Database: NSTI-2:AUCT-TR_AT
On Server NSTI-2, MS ODBC MANAGER reports successful connection when
creating this DSN.
The server, NSTI-2 runs an app that uses this database from its "D"
drive (not mapped) just fine.
The client, NSTI-5 can successfully ping the server NSTI-2 and
successfully TELNET NSTI-2 3050, but gets the following error on the
"dm.AuctionTracker.open" statement when it attempts to execute the
same EXE.
Error: [Microsoft][ODBC Driver Manager] Datasource name not found and
no default driver specified
... APP CODE SNIPPET ...............................
dm:=Tdm.create(application);
dm.AuctionTracker.ConnectionString:='Provider=MSDASQL.1;Password=nologin;Persist
Security Info=True;User ID=nologin;Data Source=AUCT-TR_AT;Extended
Properties="DSN=AUCT-TR_AT;Driver=Firebird/InterBase(r)
driver;Dbname=NSTI-2:AUCT-TR_AT;CHARSET=NONE;UID=nologin"';
if not (dm.AuctionTracker.Connected) then
dm.AuctionTracker.open;
......................................................................
How is this possible to receive this msg when I have fully specified
the connection string at runtime?
Sam Hunt