Subject | Confusing ISQL Error Messages |
---|---|
Author | Richard Thomas |
Post date | 2006-04-22T17:08:46Z |
Hello Again All:
I'm getting the following error messages.
I format and run ISQL from within a Liberty Basic program.
The Liberty Basic Executable is in the following directory:
<c:\OFBG\PC>
The Following statement is run from within the Liberty Basic program:
I think you might be able to read it, if not I'll chop out the Liberty Basic
but it might be relevant to my problem.
Start of Liberty Basic Code:
LinkParm$ = _
"c:\Program Files\Firebird\Firebird_1_5\bin\" + _
"isql.exe " + _
"> RtISQLStdOutput.txt" + _
" -m " + _
"-ex " + _
"-t " + chr$(34) + "%%" + chr$(34) + _
" " + _
chr$(34) + "c:\program files\firebird\firebird_1_5\examples\" + _
"employee.fdb " + _
"-u SYSDBA " + _
"-p masterkey " + _
chr$(34) + _
" -o c:\RtIsqlSQLLog.txt"
run LinkParm$
End of Liberty Basic Code:
Here are the ISQL Error Messages when I run the above:
Note: they are the same messages I got when I tried to run an ODBC
connection to the same database.
I/O error for file "C:\OFBG\PC"
-Error while trying to open file
-Access is denied.
Rick Note: This is the path where LibertyBasic.exe is located, not a file.
Statement failed, SQLCODE = -902
I/O error for file "C:\PROGRAM
FILES\FIREBIRD\FIREBIRD_1_5\EXAMPLES\EMPLOYEE.FDB -U SYSDBA -P MASTERKEY"
-Error while trying to open file
-The system cannot find the file specified.
Statement failed, SQLCODE = -902
I/O error for file "C:\OFBG\PC"
-Error while trying to open file
-Access is denied.
End Of ISQL Messages:
Any Pointers on what might be happening or where I might look for a clue?
Thank You:
Rick Farmington Mich. USA
I'm getting the following error messages.
I format and run ISQL from within a Liberty Basic program.
The Liberty Basic Executable is in the following directory:
<c:\OFBG\PC>
The Following statement is run from within the Liberty Basic program:
I think you might be able to read it, if not I'll chop out the Liberty Basic
but it might be relevant to my problem.
Start of Liberty Basic Code:
LinkParm$ = _
"c:\Program Files\Firebird\Firebird_1_5\bin\" + _
"isql.exe " + _
"> RtISQLStdOutput.txt" + _
" -m " + _
"-ex " + _
"-t " + chr$(34) + "%%" + chr$(34) + _
" " + _
chr$(34) + "c:\program files\firebird\firebird_1_5\examples\" + _
"employee.fdb " + _
"-u SYSDBA " + _
"-p masterkey " + _
chr$(34) + _
" -o c:\RtIsqlSQLLog.txt"
run LinkParm$
End of Liberty Basic Code:
Here are the ISQL Error Messages when I run the above:
Note: they are the same messages I got when I tried to run an ODBC
connection to the same database.
I/O error for file "C:\OFBG\PC"
-Error while trying to open file
-Access is denied.
Rick Note: This is the path where LibertyBasic.exe is located, not a file.
Statement failed, SQLCODE = -902
I/O error for file "C:\PROGRAM
FILES\FIREBIRD\FIREBIRD_1_5\EXAMPLES\EMPLOYEE.FDB -U SYSDBA -P MASTERKEY"
-Error while trying to open file
-The system cannot find the file specified.
Statement failed, SQLCODE = -902
I/O error for file "C:\OFBG\PC"
-Error while trying to open file
-Access is denied.
End Of ISQL Messages:
Any Pointers on what might be happening or where I might look for a clue?
Thank You:
Rick Farmington Mich. USA