Author: customer22 | Posted on: 7/7/2010 5:17:31 PM | Views : 470

Hello:

I need to connect to different servers. My first connection string works, but I
alsway got error for my second one: OleDbException was unhandled by user code, Invalid object name 'TableTwo..CLASSID'. However, I query this object from query analysis. It no errors.

public partial class _Default : System.Web.UI.Page
{
    OleDbConnection myConnection = new OleDbConnection("Provider=SQLOLEDB;Data Source=ServerONE;Password=PASSWORD;User ID=Test");

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            OleDbCommand myCommand = new OleDbCommand("select * from OBJECT..TABELONE");
            myCommand.Connection = myConne ...

Go to the complete details ...