Can you try this code:
Dim sqlite As New SQLiteDb.Connection
With sqlite
.Open "Data Source=c:\temp\test.db"
If .State = slStateOpen Then
.Execute "CREATE TABLE [A3Test8CA_F] ([PATIENT_ID] INTEGER,
[ENTRY_ID] INTEGER, [READ_CODE] TEXT, [TERM_TEXT] TEXT,
I don't really need the loop and I could just do:
If SQLiteConn.State <> slStateOpen Then
SQLiteConn.Open
End If
Will try that in a bit. Still, the connection gets closed and opened all the
time with the same routine and no problem at all, except for in that shown
On Sat, 9 Dec 2006 23:38:47 -, you wrote:
> On Error Resume Next
> Do While SQLiteConn.State = slStateClosed
> SQLiteConn.Open
> Loop
I has been quite some time since I wrote VB, but I'll give it a
try.
You seem to assume that SQLiteConn.Open raises an error when it
fails.
If
This is the full Sub that sets the connection, except for leaving out a
msgbox text:
Sub SetSQLiteConnection(Optional bNoRecords As Boolean, _
Optional strDBFile As String, _
Optional lPageSize As Long = -1)
Dim strDBPath As String
If
On Sat, 9 Dec 2006 22:24:59 -, you 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
Please show
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-
Yes, I am using the VB wrapper from TerraInformatica and I am coding in VBA
and using ADO. The error doesn't show in the help and nil found with a
websearch either.
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 09 December 2006 22:36
To:
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
"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
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
Thanks for any advice
RBS
10 matches
Mail list logo