-
Feb 4th, 2006, 10:31 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Pls see this error message.
The error occurs at here :
rs.Open sql, conn, adOpenStatic, adLockOptimistic, adCmdText
Anyone experienced it before or have any clue to this?
Last edited by macky^^; Feb 7th, 2006 at 10:25 PM.
-
Feb 4th, 2006, 10:36 PM
#2
Re: Pls see this error message.
That is a very self-explanatory error message - connection must be open.
So, is your conn object set and open yet? You should have some like the following:
Set conn = New ADODB.Connection
conn.Open ...
-
Feb 4th, 2006, 10:46 PM
#3
Thread Starter
Hyperactive Member
Re: Pls see this error message.
[QUOTE=RhinoBull]That is a very self-explanatory error message - connection must be open.
So, is your conn object set and open yet? You should have some like the following:
Great!
I just realise I spot my error on my ConnectDB function.
I wrote cn in the ConnectDB while under the SQL i wrote Conn.
A big Thanks you again to your hints.
-
Feb 4th, 2006, 10:49 PM
#4
Re: [Resolved] Pls see this error message.
No problem! You're welcome.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|