7 Replies Latest reply: Jul 19, 2010 6:02 AM by Sravan Puppala RSS

    ODBC connection with no user name


      Historically we have been loading all our data into QlikView via multiple .csv files, the decision was recently taken to try and improve this by loading in as much data as we can via a ODBC connection. A problem arose when we tried to connect to a database without any users, we have 3 databases in our package and only one has user records on, the other 2 rely on the authentication of the first ( not sure why, some historical reason ). The Microsoft OTBC manager connects & tests fine with all 3 databases unfortunately this does not seem to be the case inside QlikView, QlikView refuses to connect to the database with NO users and just hangs without a error message. Any help would be appreciated