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?