Subject Re: Connection string for XTG Systems IB6 ODBC driver
Author Bob C <>
I've used this bit of VBScript with good success to generate
connection strings for DSN-less connections for a variety of data sources:


Dim oDataLinks, sRetval
Set oDataLinks = CreateObject("DataLinks")
On Error Resume Next 'trap the cancel
sRetVal = oDataLinks.PromptNew
On Error Goto 0
If Not IsEmpty(sRetVal) Then 'no cancel click
InputBox "Your Connection:", "OLEDB Connection String", sRetVal
End If
Set oDataLinks=Nothing


--- In, "David A. Frischknecht"
<fishnet39@h...> wrote:
> Hello,
> If anybody else out there uses the XTG Systems IB6 ODBC driver,
could you
> give me an example of a connection string for use in VB6. I'm
working on a
> VB front end for a database, and I'd like to use a non-DSN
connection to the
> firebird database. Any input would be greatly appreciated.
> David A. Frischknecht