Subject | Re: Connection string for XTG Systems IB6 ODBC driver |
---|---|
Author | Bob C <rc_11@yahoo.com> |
Post date | 2002-12-30T04:03:42Z |
David,
I've used this bit of VBScript with good success to generate
connection strings for DSN-less connections for a variety of data sources:
'-- BEGIN VBSCRIPT --
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
'-- END VBSCRIPT --
--- In ib-support@yahoogroups.com, "David A. Frischknecht"
<fishnet39@h...> wrote:
I've used this bit of VBScript with good success to generate
connection strings for DSN-less connections for a variety of data sources:
'-- BEGIN VBSCRIPT --
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
'-- END VBSCRIPT --
--- In ib-support@yahoogroups.com, "David A. Frischknecht"
<fishnet39@h...> wrote:
> Hello,could you
>
> If anybody else out there uses the XTG Systems IB6 ODBC driver,
> give me an example of a connection string for use in VB6. I'mworking on a
> VB front end for a database, and I'd like to use a non-DSNconnection to the
> firebird database. Any input would be greatly appreciated.
>
> David A. Frischknecht
> http://fishnetonline.tripod.com