SQL Related Articles: Firebird DSN-less connection 1 2004-06-28 -- Paul Anderson, Tiresoft Newsgroups: softvelocity.clarion.databasedrivers,softvelocity.public.clarion5x Hi all, I am trying to switch my application from using a system DSN to a DSN less connection. I am using Firebird and have input the variable !glo:connectionString in the Owner field and left the name of the table PTG_VEHICLE_MAKE in the full path name field. I have set glo:connection string to the following: glo:ConnectionString = | 'DRIVER=<123>Firebird/Interbase(r) driver<125>;'&| 'JDBCDRIVER=IscDbc;'&| 'QUOTEDIDENTIFIER=Y;'&| 'READONLY=N;'&| 'NOWAIT=N;'&| 'DBANAME=Training1:c:/Firebird Databases/MyDatabase.fdb;'&| 'DIALECT=3;'&| 'CHARACTERSET=ISO8859_1;'&| 'UID=SYSDBA;'&| 'PWD=masterkey' But I can not open the table, I just receive an error. The database resides on a different computer than the program. Does anybody have any ideas what I am doing wrong? Paul Anderson TireSoft, LLC C55 Printed November 21, 2024, 7:25 am This article has been viewed/printed 35228 times. Google search has resulted in 324 hits on this article since January 25, 2004. |