8 Replies Latest reply: Sep 27, 2010 4:29 AM by brijeshvaidya RSS

    security with sql server

    brijeshvaidya

      Hello,

       

      When i want to achieve the security with excel file it is possible with personal edition,

      but when i make the same structure of table with the sql server then it cannot accept the user name which i already given in the sql server data table.

       

      ===================================

      Section Access; // Start of section access part

      Directory;

      LOAD [USERID],

      [PASSWORD],

      [ACCESS],

      [GROUP]

      FROM

      SECURE.xls

      (biff, embedded labels, table is Sheet1$);

      Section Application; // End of section access part

       

      Directory;

      LOAD [GROUP],

      SHEET1,

      SHEET2,

      SHEET3

      FROM

      GROUP.xls

      (biff, embedded labels, table is Matrix$);

      =======================================
      this code for the excel file...
      and the below code when i use the sql server data table to achieve the same.
      ===========
      CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Test;Data Source=BISRVR;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BISRVR;Use Encryption for Data=False;Tag with column collation when possible=False];
      Section Access;
      Directory;
      LOAD [USERID], [PASSWORD], [ACCESS], [Region];
      SQL SELECT * FROM Test.dbo.SECURE;
      Section Application;
      Directory;
      LOAD [Region], "Sales Data 1", "Sales Data 2", "Sales Data 3";
      SQL SELECT * FROM Test.dbo.Regions;
      ===========
      Prob Description: when i use excel as a table it accept the username and password, but when i use sql server tables, then it cannot accepts the user name and it says that access denied, it will ask three time to enter perfect user name and then show
      error loading image

      pls help...