This gives all the right answers, suggesting the object is set fine and the
connection is open:
If SQLiteConn Is Nothing Then
MsgBox "nothing"
End If
MsgBox SQLiteConn.State = slStateOpen
It still got me stumped.
RBS
-----Original Message-----
From: Eric Pankoke [mailto:[EMAIL PROTECTED]
Sent: 09 December 2006 22:47
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Operation is not allowed when the object is closed
It sounds to me like you're using ADO? How do you know for sure that
the connection is truly open?
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 09, 2006 5:36 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Operation is not allowed when the object is closed
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Keep getting this error when trying to create a table in SQLite. There
is a
> valid connection object and it is open and I have no idea what is
causing
> this:
>
> Operation is not allowed when the object is closed.
> Error number: 3704
>
Ain't no such error in SQLite. This must be coming from
whatever wrapper or interface you are using.
--
D. Richard Hipp <[EMAIL PROTECTED]>
------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----
----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
