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;"