Subject | Firebird Server Access |
---|---|
Author | dkoder2 |
Post date | 2007-01-15T16:09:26Z |
I have installed Firebird 2.0 on both a W2K and Linux (Fedora 4)
Servers. Using iSQL I can gain access to the database and execute a
Select statements on the W2K Server with no problem. I have yet to
access Firebird on the Linux box using iSQL. It seems no matter what
combination of parameters I use it returns an error. By combination of
parameters I mean -U/user, -P/password and upper/lower case database
name etc.
Now for connection strings. I am writing a program in Visual Basic
6.0. My intention is to utilize both Embedded and TCP/IP Client/Server
to access the data. I have connected to the embedded database on my
(W2K)work station but cannot connect to the database on either the W2K
Server or the Linux Server.
I used the Firebird/InterBase(r) ODBC driver in all my attemps to
access these database(s). Regardless of the connect string format I
get can't connect to the database type errors.
Frustrated, I just installed the IBProvider hoping that would solve
the problem. When looking at the example connection strings they are
very similar to the ones used in the ODBC connection strings. Seeing
that I initiated this cry for help.
The connection string examples I have found on the internet for
connecting to TCP/IP Client/Servers include the drive letter. I find
that rather odd since normal TCP/IP connections require either the
host name or IP Address. I don't understand. Unix(s) don't use drive
letters at all and the nearest example I've found is <host>:<database>
which generates error on both the W2K Server or the Linux Server. I
confused, frustrated growing more anti-Firebird by the minute. Could
someone please point me in the right direction? Surely I not the only
one to have this problem. (and then again...).
TIA dkoder2
PS I also used GSEC on the W2K Server and added a user/password. I did
that in response to error messages I received in some of the
connection attemps.
Servers. Using iSQL I can gain access to the database and execute a
Select statements on the W2K Server with no problem. I have yet to
access Firebird on the Linux box using iSQL. It seems no matter what
combination of parameters I use it returns an error. By combination of
parameters I mean -U/user, -P/password and upper/lower case database
name etc.
Now for connection strings. I am writing a program in Visual Basic
6.0. My intention is to utilize both Embedded and TCP/IP Client/Server
to access the data. I have connected to the embedded database on my
(W2K)work station but cannot connect to the database on either the W2K
Server or the Linux Server.
I used the Firebird/InterBase(r) ODBC driver in all my attemps to
access these database(s). Regardless of the connect string format I
get can't connect to the database type errors.
Frustrated, I just installed the IBProvider hoping that would solve
the problem. When looking at the example connection strings they are
very similar to the ones used in the ODBC connection strings. Seeing
that I initiated this cry for help.
The connection string examples I have found on the internet for
connecting to TCP/IP Client/Servers include the drive letter. I find
that rather odd since normal TCP/IP connections require either the
host name or IP Address. I don't understand. Unix(s) don't use drive
letters at all and the nearest example I've found is <host>:<database>
which generates error on both the W2K Server or the Linux Server. I
confused, frustrated growing more anti-Firebird by the minute. Could
someone please point me in the right direction? Surely I not the only
one to have this problem. (and then again...).
TIA dkoder2
PS I also used GSEC on the W2K Server and added a user/password. I did
that in response to error messages I received in some of the
connection attemps.