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

[Ing. A. J. <sa...@gm...>]

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
>
>