Subject | Re: [firebird-support] How to connecto to an embedded Firebird? |
---|---|
Author | W O |
Post date | 2011-07-08T08:19:46Z |
Hello Helen
Thank you for answering me.
I am using Visual FoxPro 9 in a Windows XP machine.
Usually I connect to the database with something like the following:
Local lcCadenaConexion, lnHandle
lcCadenaConexion = "DRIVER={Firebird/InterBase(r) driver};" ;
+ "SERVER=localhost;" ;
+ "USER=WALTER;" ;
+ "PASSWORD=123456;" ;
+ "DATABASE=E:\VISUAL
FOXPRO\SQL_COLEGIO\FBEMBEDDED\ADMIN.FDB;" ;
+ "OPTIONS=131329;"
lnHandLe = SQLSTRINGCONNECT(lcCadenaConexion)
? lnHandle && if lnHandle > 0, the connection is OK, if it is -1, then
had a problem
Return
*
*
and it works right, lnHandle has a value greater than zero
However I don't know how to connect to the same database using the embedded
version.
I had copied the database and all the files of:
Firebird-2.5.0.26074-0_Win32_embed.zip in a folder, but still the connection
is rejected, lnHandle shows me - 1 (connection error).
How I should to write the connection string?
Thanks in advance.
Walter.
Thank you for answering me.
I am using Visual FoxPro 9 in a Windows XP machine.
Usually I connect to the database with something like the following:
Local lcCadenaConexion, lnHandle
lcCadenaConexion = "DRIVER={Firebird/InterBase(r) driver};" ;
+ "SERVER=localhost;" ;
+ "USER=WALTER;" ;
+ "PASSWORD=123456;" ;
+ "DATABASE=E:\VISUAL
FOXPRO\SQL_COLEGIO\FBEMBEDDED\ADMIN.FDB;" ;
+ "OPTIONS=131329;"
lnHandLe = SQLSTRINGCONNECT(lcCadenaConexion)
? lnHandle && if lnHandle > 0, the connection is OK, if it is -1, then
had a problem
Return
*
*
and it works right, lnHandle has a value greater than zero
However I don't know how to connect to the same database using the embedded
version.
I had copied the database and all the files of:
Firebird-2.5.0.26074-0_Win32_embed.zip in a folder, but still the connection
is rejected, lnHandle shows me - 1 (connection error).
How I should to write the connection string?
Thanks in advance.
Walter.
On Fri, Jul 8, 2011 at 3:57 AM, Helen Borrie <helebor@...> wrote:
> **
>
>
> At 06:13 PM 8/07/2011, you wrote:
> >Hello everybody
> >
> >I want to connect to a database using the embedded version of Firebird 2.5
> >
> >Mi language is Visual FoxPro 9.
> >
> >Do you know how to do that?
> >
> >Or, how to do that with Java, C, Python?
> >
> >I have no problem with "normal" Firebird, it is just with the "embedded"
> >version.
>
> Same as for the full server, but use the serverless connection. String
> depends on platform, which you didn't mention.
>
> ./hb
>
>
>
[Non-text portions of this message have been removed]