An "Import" Feature - alas - so close!

gbianchi · October 19th, 2007, 08:19 AM

you have the sql server surface area configuration. Inside that you can configure how will you connect to it in remote...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Andrew.Berry · October 19th, 2007, 08:55 AM

ARRRGGGGGHHHH

Sorry, I'm still getting nowhere with this damn problem!

I'm debugging, and I watch MyConnection.State.

When I open the connection, it states that MyConnection.State=1 :)

But the very next line, my watch is still saying state=1, but an exception pops up! :(

gbianchi · October 19th, 2007, 09:29 AM

excume.. but isn't easier to use a command object instead of a dataadapter???

what happend if you don't open the connection, the dataadapter should open it by itself... or that's only when it's filling tables???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Andrew.Berry · October 19th, 2007, 10:05 AM

The connection is definately open, however, for some reason, the connection is not available for me to use.

gbianchi · October 19th, 2007, 10:48 AM

I'm clueless.. sorry.. :(

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Andrew.Berry · October 19th, 2007, 11:10 AM

No Worries, makes 2 of us!

Here's the stack Trace, in case of any flashes of brilliance that could come your way ;)

[InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.]
   System.Data.SqlClient.SqlConnection.GetOpenConnect ion(String method) +920816
   System.Data.SqlClient.SqlConnection.ValidateConnec tionForExecute(String method, SqlCommand command) +9
   System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method, Boolean async) +99
   System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +75
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   _Default.Button2_Click(Object sender, EventArgs e) in u:\Visual Studio 2005\WebSites\WebSite2\Default.aspx.vb:50
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

dparsons · October 19th, 2007, 11:25 AM

Instead of .ExecuteNonQuery() try .ExecuteReader()

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

woodyz · October 19th, 2007, 11:56 AM

Are you sure you are opening working with the connection properly?

Without going into too much detail, here is something to think about:

Code:

  
Dim cmdTest As New SqlDataAdapter("dbo.thar_HIP_importcusts", MyConnection )

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems

dparsons · October 19th, 2007, 12:07 PM

Either of the overload here should work with the connection since the DataAdapter has 4 different overloads, 2 of which have the following signatures:

SqlDataAdapter(string, SqlConnection)
SqlDataAdapter(string, string)

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

woodyz · October 19th, 2007, 12:39 PM

Ah. So the connection object is not being used and does not need to be used. In that case it should be removed. In other words, the connection "MyConnection" is declared and opened, and then closed, but it is not actually doing anything - and is therefore dead code.

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems