What is your ODBC driver?

Try like this:

strConn = "Driver={Firebird/InterBase(r) driver};" & _
"Dbname=c:\Program Files\Fishbowl\database\data\AS SOLAR.FDB;"

OpenDBConnection strConn, "XXX", "YYY"


RBS


On Wed, May 2, 2012 at 11:20 PM, Maury Markowitz
<maury.markowitz@...>wrote:

> **
>
>
> On 2012-05-02, at 5:59 PM, Bart Smissaert wrote:
>
> > Post your code and tell where you get the error.
> > Should be something simple
>
> Yeah, normally is simple. Just wish the error was more descriptive!
>
> Const cnn = "Driver={Firebird/InterBase(r) driver};Dbname=c:\Program
> Files\Fishbowl\database\data\AS SOLAR.FDB;UID=XXX;PWD=YYY;"
> Public conn As ADODB.Connection
>
> Sub OpenDBConnection()
> If conn Is Nothing Then
> Set conn = New ADODB.Connection
> End If
> If conn.State = 0 Then
> conn.Open cnn
> End If
> End Sub
>
> Happens right on the conn.open. I assume it's a problem in the cnn string,
> but what? I tried {}'s around the dbname, no luck.
>
> The connection to the DB works when I use ODBC. I have a DSN pointed to it
> as well, but when I try to use the DSN based cnn it doesn't work and gives
> me two errors :-)
>
> Const cnn = "ODBC;DSN=Fishbowl;UID=XXX;PWD=YYY;"
>
>

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