473,385 Members | 1,472 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

"There is no source code available for the current location"

Hello All,
I've got an app which performs a simple query to a web service and stores
the returning data in a DataSet. The first time through it works find and as
expected. The problem is that the second time I step through and I step on
the line
myDataAdapter1.Fill(tempds);
I get the IDE error...
"There is no source code available for the current location".
If I run the app (not under the debugger) I get no error messages but this
problem usually messes up the web service as I get an error saying "Server
was unable to process request. -> Object reference not set to an instance of
an object". I'm sure this is causing the error because when I comment out
the code hitting the web service, the app runs fine.
The code to hit the web service is simple...

DataSet tempds = new DataSet();
OleDbConnection myOleDbConnection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + dbpath +
";Persist Security Info=False");

OleDbDataAdapter myDataAdapter1 = new
OleDbDataAdapter(query,myOleDbConnection);
myDataAdapter1.Fill(tempds);

And the query is simple..."select field1, field2 from mytable order by
field2".
Has anyone gotten this before or know how I may correct it?

Thanks
Cheers :)
Nov 16 '05 #1
1 5611
Actually, the code in my first post hits an Access database. But I've got
the same situation occuring on the web service too. The same thing happens.

"Randy" <te**@temp.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Hello All,
I've got an app which performs a simple query to a web service and stores
the returning data in a DataSet. The first time through it works find and as expected. The problem is that the second time I step through and I step on
the line
myDataAdapter1.Fill(tempds);
I get the IDE error...
"There is no source code available for the current location".
If I run the app (not under the debugger) I get no error messages but this
problem usually messes up the web service as I get an error saying "Server
was unable to process request. -> Object reference not set to an instance of an object". I'm sure this is causing the error because when I comment out
the code hitting the web service, the app runs fine.
The code to hit the web service is simple...

DataSet tempds = new DataSet();
OleDbConnection myOleDbConnection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + dbpath +
";Persist Security Info=False");

OleDbDataAdapter myDataAdapter1 = new
OleDbDataAdapter(query,myOleDbConnection);
myDataAdapter1.Fill(tempds);

And the query is simple..."select field1, field2 from mytable order by
field2".
Has anyone gotten this before or know how I may correct it?

Thanks
Cheers :)

Nov 16 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Phil Powell | last post by:
I'm sorry but I can't figure out how to explain this any better than this. In PHP we have a command "require()" that obtains a file and logically places it into another file. I cannot figure...
0
by: Joe Helmick | last post by:
This weird error started showing up as I was developing an email-enabled program. Once it occurs, I cannot set breakpoints in my code. Quitting Visual Studio does not help, nor does restarting my...
3
by: David Cohen | last post by:
Is there a function that returns the html source of a given page as a string? Preferably, I'm looking for a function that takes a URL as an argument. Alternatively, is there such a function that...
2
by: rollasoc | last post by:
Hi, When I load my application I get the the above first chance exception. Stepping through my code it appears to be on the last line of the these two lines Process current =...
0
by: Randy | last post by:
Hello, I have a project that I've been working on for quite some time. I've been adding code along. Now, all of a sudden at certain points...I'm getting the above message while debugging (stepping...
3
by: nan | last post by:
Hi All, I am trying to connect the Database which is installed in AS400 using DB2 Client Version 8 in Windows box. First i created the Catalog, then when i selected the connection type...
1
by: TC | last post by:
Every time I open my project, I get a warning which says "There are updated custom wrappers available for the following referenced components: Office." When I double-click on the warning, I get...
2
by: Serman D. | last post by:
Hi all, I'm trying to complete the samples from the excellent 2003 developerWorks article "Bringing the Power of Regular Expression Matching to SQL" by Knut Stolze: http://tinyurl.com/3bhrnn...
0
by: Bobzilla | last post by:
Ok, so I've looked around and I can't seem to find an answer to my specific question, so here goes... I am using VS 2003 and I have a solution with code and all that I am steping through. When...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.