does anybody knows how to create a ADO connection to a Firebird database?

        

____________________________
Funny thought:

Practice makes perfect.....
But nobody's perfect......
so why practice?

noycez, what is a Firebird database?

would you mind telling us?(me and others who don't know)

    

____________________________
Been busy trying to take a second degree <--it's not working out...

its like an SQL Database,actually...you can also make a database on it. my company will be using Firebird database, since it can be used for both Visual Basic and Delphi (i think   )

The company i am working for has many branches and some of those brances are using a Linux OS. we're developing a DTR or Daily Time Report System together with the Payroll System, and currently we're using MySQL Database, but the brances with Linux OS is having a problem in connecting in the MySQL database, and they can't use our systems that are developed in VB,and it's because MySQL and VB are made for Microsoft OS. so i am trying to work it out by using a Firebird database, since Firebird is as a friendlyuser  

but my problem is when my DTR system (developed in VB) connects to the Firebird database, it's having this problem, it can connect to the connection but in opening a recordset it prompting this error "Unspecified error". i'm still working on it and hoping i could finish it immediately.

    

____________________________
Funny thought:

Practice makes perfect.....
But nobody's perfect......
so why practice?

Not completely sure, but at the address:
http://firebird.sourceforge.net/

There's info on the ODBC driver...
Also at (win32 stuff also):
http://www.xtgsystems.com/linux/ofbodbc/download.php

http://ofbodbc.sourceforge.net/

Everything seems to be beta though... Hope it's at least somewhat helpful.



____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

that's the ODBC installer i used.

____________________________
Funny thought:

Practice makes perfect.....
But nobody's perfect......
so why practice?

On the FAQ pages, it has (although I'm sure you've seen it):

Sample connection string: (remove space before UID=, added for it to be displayed properly on the page) "DRIVER={XTG Systems InterBase6 ODBC driver};DB=myserver:c:mypathmydb.gdb; UID=myname;PWD=secret;CHARSET=WIN1250;ROLE=myrole;" If you are using Firebird, you can specify a port number too, like: "DRIVER={XTG Systems InterBase6 ODBC driver};DB=myserver/1234:c:mypathmydb.gdb; UID=myname;PWD=secret;CHARSET=WIN1250;ROLE=myrole;"

If they don't work like that, maybe switching 'Driver=' to 'Provider=' might work.

Or you could set up a DSN, then use it.

If you add a ADODC control, you can build the connection string with it. It may have the provider listed, or if you have to use ODBC by itself it does provide some assistance for using a DSN and system data sources.

Unfortunetely without it being installed on my PC, I can't test it.



[Edited by JLRodgers on 02-01-2003 at 09:27 PM GMT]

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

i already have this codes, and i tried using the adodc contol. the DSN connection works fine,but whenever i will open a recordset

mRec.open "select PREVPAYFR, PREVPAYTO, PREVREFNO from PAYCUTOFF", gConn, adOpenStatic, adLockReadOnly

...it will display a Run-time error "Unspecified error".

I still finding the cause of the error,i can't figure it out if the problem is in my codes or in the database users.


    

____________________________
Funny thought:

Practice makes perfect.....
But nobody's perfect......
so why practice?