Subject Re: Connection String Problem with Firebird 2.0
Author jasonw3877
--- In firebird-support@yahoogroups.com, "tacsgroup" <tacsgroup@...>
wrote:
>
> CORRECTION:
>
> I use the following connection:
>
> Dim myConn As New ADODB.Connection
> Dim sConnStr As String
>
> sConnStr = "Provider=LCPI.IBProvider;Data Source=D:\MPM ---
> \EMPLOYEES.GDB; user=SYSDBA;password=masterkey"
>
> myConn.ConnectionString = sConnStr
> myConn.Open
>

I'm not very familiar with VB, but do you need to escape the '\'
character above in your connection string? Does

sConnStr = "Provider=LCPI.IBProvider;Data
Source=D:\\MPM\\EMPLOYEES.GDB; user=SYSDBA;password=masterkey"

solve your problem? Again, I'm not very familiar with VB, but in most
programming languages the '\' is a special character.

>
> I'm a new user of Firebird. How can i fix this bug?
>