4 Replies Latest reply: Jul 9, 2014 7:55 AM by Hans Lindström RSS

    Problems with OLEDB connection to SQL server

      Hi, I am trying to connect to a SQL server from my computer.

       

      I have done this before (but not from this computer) and I know the basics.

       

      I am using the "Microsoft OLE DB Provider for SQL Server" and I have all necessary info such as ServerName, UserName and password. The connection works and the OLE DB string is created but once I try to access the database no tables or views are visible or accessible.

       

      I have also tried using ODBC with the same result.

       

      When I try to do the same thing using Xls it works and I can see all of the tables and views in the data base.

       

      Does anyone know what to do?

       

      Thanks!

       

      //Hans