Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
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
Today is April 24, 2024, 6:15 pm This article has been viewed 35117 times. Google search has resulted in 324 hits on this article since January 25, 2004.
|
|