"No source code available" message comes when the debugger tries to display a part of the program when a problem or exception has occured in code where you do not have the source.
Microsoft.Data.ODBC would just wrap the ODBC binaries where in the real world it would spend most of its time. As you don't have the source for this you can not debug it easily ( there is probably a way but I don't know how to do it). Try turning on odbc logging and tracing and see what it dumps and make sure you try/catch any exceptions and dump them to look at the output. Is the realworld prototype on a different server ? Ben > -----Original Message----- > From: Moderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] Behalf Of Jim Moffitt > Sent: Friday, 7 March 2003 4:53 AM > To: [EMAIL PROTECTED] > Subject: [ADVANCED-DOTNET] "No source code available" using ADO.Net > > > Hi, > > The "half-baked" code sample below is used to simply insert a data point > into a MySQL table using ADO.Net. This code works fine in a small, > standalone test program (implying that connecting to the MySQL > database via > the MySQL ODBC Driver is working)... But when the same code is used in a > real-world prototype, I can not execute or step into this code and instead > get the "No source code available for the current location." dialog box... > It of course compiles OK, and I'm importing the Microsoft.Data.ODBC core > classes... Other details: I'm working in a VB.Net "solution" comprised of > four projects... the prototype is multi-threaded... in the prototype this > source code is called from one of the another VB.Net projects, whereas in > the test program, this code is called directly from within the single test > class... So, I've moved this ADO.Net code into the calling class (so the > below source code is local (and only a few lines away! :)) and still I'm > told the source code is not available... I comment out the three ADO.Net > declarations and the two lines of ADO.Net code and it runs fine... > uncomment those lines, and I hit the "No source code available" > showstopper... > > I've tried several ADO.Net methods to insert the data... These include > setting up and (ExecuteNonQuery) executing a Command object, reading the > target table into the DataSet, adding a new row to the DataSet > and updating > the DataAdapter... All have worked within my test program, but I always > hit the "No source code available" roadblock with the prototype) > > > Help! Thanks in advance... > > ================================================= > > Dim oDS As New Data.DataSet() > Dim oCB As OdbcCommandBuilder > Dim sSQL as String > sSQL = "INSERT INTO ... " (blah, blah, blah) > Dim oDA As New OdbcDataAdapter(sSQL, s_ConnectionMySQL) > > oCB = New OdbcCommandBuilder(oDA) > oDA.Fill(oDS) > > ================================================== > (oh, and here is my connection string, which of course let me in OK via my > small test program) > Private s_ConnectionMySQL As String = "Driver={MySQL ODBC 3.51 > Driver};" & _ > "Server=localhost;" & _ > "Port=3306;" & _ > "Option=16834;" & _ > "User ID=root;" & _ > "Password=;" & _ > "Database=dv3;" > > =================================== > This list is hosted by DevelopMentor� http://www.develop.com > You may be interested in Guerrilla .NET, 24 March 2003, in London > http://www.develop.com/courses/gdotnet > > View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor� http://www.develop.com You may be interested in Guerrilla .NET, 24 March 2003, in London http://www.develop.com/courses/gdotnet View archives and manage your subscription(s) at http://discuss.develop.com
