Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
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 May 4, 2024, 10:09 am This article has been viewed 35123 times. Google search has resulted in 324 hits on this article since January 25, 2004.
|
|