This is the proper coding for the Connection to VB6


'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

dim SERVER 'This stores the name of machine acting as our DB
server...
'for local Databases use SERVER="LOCALHOST"
'for remote system...use SERVER = ip address
of the other computer

dim fname 'This is the name of the Database File..........it
shud be as local filepath...i.e. if its on a Server..i.e. a remote computer
on C:\DB\Hello.gdb

'It shud be written as
fname="c:\db\hello.gdb" and not using the mapped path to that computer...for
locals its normal db path.

dim conHO as ADODB.Connection

Dim sConnStr as String

If SERVER <> "LOCALHOST" Then
sConnStr = "Provider=ZStyle IBOLE Provider;Password=masterkey;User
ID=SYSDBA;SQL Dialect=3; Logging Level=0;Silent mode=True;Character
Set=WIN1251;Data Source=" & _
"\\" & SERVER & "\" & fname & ";Open Mode=0"
Else
sConnStr = "Provider=ZStyle IBOLE Provider;Password=masterkey;User
ID=SYSDBA;SQL Dialect=3; Logging Level=0;Silent mode=True;Character
Set=WIN1251;Data Source=" & _
fname & ";Open Mode=0"
End If
conHO.Open sConnStr

dim rs as new ADODB.Recordset

rs.open "select * from Tablename", conHO

....blah blah blah....normal ADODB stuff


if u still find probs just send me an email and i will send u the
complete test application with all reqd. files.


Amarjit Singh
Project Manager
MSoft.



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Sivarasa Visakan
Sent: Thursday, May 10, 2007 6:46 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] VB6 Connection String



Thank you Amarjit,

I've downloaded as you said, I got the IBOLE.DLL and 2 batch files, one to
register the dll in the registry & the other one is to unregister, then
there is two text files one is the version update the other one is for
license agreement. I could't find any connection sting here for vb6 to use
with IBOLE.DLL

Thank you

Regards
Visa

AJS <softhut@gmail. <mailto:softhut%40gmail.com> com> wrote: Hello There,

download the zip file:

http://jupiter. <http://jupiter.host.ac/~amarjits/ibfree5.zip>
host.ac/~amarjits/ibfree5.zip

It has all the guddies and demos u need for VB6 to connect to FIREBIRD .

Happy coding

Amarjit Singh

Voice: +91-98766-39035

Yahoo!!!: amarjit_mayfair@ <mailto:amarjit_mayfair%40yahoo.co.in>
yahoo.co.in

skype: amarjit_mayfair

_____

From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of visakan13
Sent: Tuesday, May 08, 2007 6:49 AM
To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
Subject: [firebird-support] VB6 Connection String

Hi There,

Does anyone know the connections String through vb6 for firebird &
what is the ODBC driver I need to use?

Thank you

[Non-text portions of this message have been removed]





---------------------------------
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up
for your freeaccount today.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]