run time error 3705..............

Question

0.00/5 (No votes)

See more:

VB

Dim startstg As String
Dim EndStg As String
Dim date1 As String
Dim date2 As String

Private Sub Command1_Click()

Call Connect

esql = "select * from bank where Date>=3DCDate('" & DTPicker1.Value & "') AND Date<=3DCDate('" & DTPicker2.Value & "')"
rs.Open esql, con, adOpenForwardOnly, adLockReadOnly

End Sub

msg : ERROR 3705 - Operation is not allowed when the object is open

Posted 25-Jun-15 21:17pm

Member 11757843

Updated 25-Jun-15 22:05pm

Suvendu Shekhar Giri

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2015-06-25T22:22:00

Solution 1

"rs" is probably already open elsewhere in your code because you haven't closed it. This is the problem with using global variables, it becomes very easy to lose track of them and what their state is. Make sure you close things when you no longer need them.

Posted 25-Jun-15 22:22pm

F-ES Sitecore