Error !! There is no source code available for current location.

Question

0.00/5 (No votes)

See more:

Below is my code snippet.
This code runs behind an ASP GUI. Backend is Mysql
When I debug this code and reach the line

VB

Do Until rec_ddas_Feedback.EOF = False

It gave me following error
"There is no source code available for current location."

VB

Dim rec_ddas_Feedback As New ADODB.Recordset
Dim msgString As String
Dim msgcounter As Integer
If rec_ddas_Feedback.State = ADODB.ObjectStateEnum.adStateOpen Then
  rec_ddas_Feedback.Close()
  rec_ddas_Feedback.Open("SELECT dtofadd,dtofacc,remarks,Feedback from DDAS_remarks WHERE dtofadd BETWEEN ADDDATE(CURDATE(),INTERVAL -10 DAY) AND CURDATE() AND therapsitname='" + mdlusername + "' AND Feedback <> ''", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
  msgString = ""
  msgcounter = 1
  Do Until rec_ddas_Feedback.EOF = False
    msgString = msgString + "<b>Message #" + msgcounter + " :</b><br>"
    msgString = msgString + "<Pre>For your remark on dated <b>" + Format(rec_ddas_Feedback.Fields("dtofadd").Value, "DD MMMM YYYY") + " </b>about amount mismatches in account of " + Format(rec_ddas_Feedback.Fields("dtofacc").Value, "DD MMMM YYYY") + "</Pre></br>"
    msgString = msgString + ". Your reply :" + rec_ddas_Feedback.Fields("remarks").Value
    msgString = msgString + "<br>. Feedback : " + rec_ddas_Feedback.Fields("remarks").Value
    rec_ddas_Feedback.MoveNext()
    msgcounter = msgcounter + 1
  Loop
  lblMsg.Text = msgString

But, when I place the query in immediate window to replace the variable name with variable value and I ran the query on mysql QA it gave me one record.

Posted 18-Dec-10 22:22pm

RDBurmon

Updated 19-Dec-10 18:54pm

JF2015

v3

Add a Solution

Comments

Manfred Rudolf Bihy 24-Dec-10 12:54pm

Hi, have you resolved your issue?
If Brij answer helped you solve your problem it would be very nice of you to mark his answer as accepted.
Thank you!

RDBurmon 25-Dec-10 9:10am

no i still have the issue

3 solutions

Solution 2

Could it be that when you are on said line that you try to "step into" (F11)? What happens when you press "Step over" F10?

Posted 18-Dec-10 23:17pm

Manfred Rudolf Bihy

Solution 3

Simple try this.
How to Fix VS Error "There is No Source Code Available for the Current Location"[^]

Posted 19-Dec-10 18:38pm

thatraja

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)

Brij · Accepted Answer · 2010-12-18T22:32:00

Solution 1

Probably, you have not build your solution.
First,in solution explorer right click on solution and Clean Build.
Second Rebuild application
If problem still persists:
Close Visual studio and reopen it again..

Posted 18-Dec-10 22:32pm

Brij

Comments

RDBurmon 19-Dec-10 4:38am

Thanks man , for quick and accurate solution.

Brij 19-Dec-10 4:40am

Your welcome :)

RDBurmon 19-Dec-10 4:44am

No man, previously i tested with removing loop statement , but when i tried with loop statement it gave me same error. i tried your solutions but fail. Please suggest me another solution if any.

Brij 19-Dec-10 7:58am

As the error says, This occurs only if "There is no source code available for current location". Here yo are using ADODB.Recordset and the statement rec_ddas_Feedback.EOF, if there is no pdbs available for the assembly then you will not be able to debug.