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 ...