4 Replies Latest reply: Oct 11, 2011 3:26 AM by Kiran Rokkam RSS

    A Problem with connection to SQL SERVER 2008

      i connected to my DB on SQL Server and couldn't see my tables when used: Ctrl+T.

       

      I might did somethong wrong but don't know what..

       

      here are the steps i took:

      1. opened a new qv document.

      2. Ctrl+E

      3. Changed "Database" to: OLE DB

      4. pressed "Connect"

      5. and then put my local server name (its on my computer) as wall as the server DB

      6. this raw appears:

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=YAEL-PC\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=YAEL-PC;Use Encryption for Data=False;Tag with column collation when possible=False];

       

      now when i click on "SELECT"

      i see all the tables. but when i use ctrl+t i don't see anything.

      What am i missing?

       

      Thanks.