Re: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers

[Michael M. <m.m...@mb...>]

Maybe it helps if you replace “IP or HOSTNAME of YOUR server” with your
values! Its either the IP or the hostname of the server ;-)))

 

From: Ing. Alfredo Jimenez [mailto:sa...@gm...] 
Sent: Monday, October 04, 2010 6:22 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers

 

Thank you very much for the code, but not that I put in DbName

I get the following error:

-2147217843
[ODBC Firebird Driver] Unable to complete network request to host
"IPorHOSTNAMEofYOURserver."
Failed to locate host machine.
The name specified was not found in the hosts file or Domain Name Services.


This is the code I'm using

Function connect ()
    ConFirebird As String Dim
    ConDB As ADODB.Connection Dim
    On Error GoTo out
    
    conFirebird = "DRIVER = (Firebird / InterBase (r) driver);" & _
                  "Uid = SYSDBA;" & _
                  "Pwd = masterkey;" & _
                  "DIALECT = 3;" & _
                  "Dbname = IPorHOSTNAMEofYOURserver: \ \ PCDC02 \ Data \
DBNAME.FDB"
    
    September conDB = New ADODB.Connection
    
    conDB.CursorLocation = adUseClient
    conFirebird conDB.Open
    Exit Function
Output:
    MsgBox Err.Description
End Function

 

2010/10/2 Michael Möhle <m.m...@mb...>

Hi Alfredo,

 

this way:

Dim conFirebird as string

 

conFirebird = "DRIVER={Firebird/InterBase(r) driver};" & _

                                   "Uid=SYSDBA; " & _

    "Pwd=YOURPASSWORD; " & _

    "DIALECT=3;" & _

 
"DbName=IPorHOSTNAMEofYOURserver:C:\pathToYourDB\DBNAME.fdb"

 

Dim conDB as new ADODB.Connection

 

conDB.CursorLocation = adUseClient

conDB.Open conFirebird

DIALECT depends on your Database, newer ones should have DIALECT=3 older
ones coming from Interbase maybe have DIALECT=1

 

Br

Michael

 

From: Ing. Alfredo Jimenez [mailto:sa...@gm...] 
Sent: Friday, October 01, 2010 5:09 PM
To: fir...@li...
Subject: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers

 

Hi I need help
Use Visual Basic and I need to create a connection via ODBC to a firebird
database 2.1,
as I can do it?


----------------------------------------------------------------------------
--
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel