thereis nospecialmove fromSQL2005to SQL2008 see belowthe connection string
[Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=yourdatabase;Data Source=your name server;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=your name server;Use Encryption for Data=False;Tag with column collation when possible=False]';
Could you please give me the details on how to setup the connection to a SQL server 2008 ? From the Edit Script menu in Qlikview I am not too sure where to start, in the Database box there are 2 options ( OLE DB and ODBC ) ...which one should I use ? Do I need to install any special drivers in my laptop ? ( I am just using developer version 8.5 and need to connect to a remote SQL server 2008 ( I know server name, port ( not sure the port number is needed ) and user login crdentials ).
Please advice , I have some experience working with QlikView but just reading from flat files. Connections to a database is totally new for me .
Do you mean I need to install SQL server 2008 in my laptop ? What for ? The database I need to get access from Qlikview is in a remote server in my corporate network . Not sure I understand your advice. Unfortunately I can´t see the picture you attach...it´s too small and the resolution is really poor.