Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm looking for help (tutorial) to Qlikivew to Sql Azure.
I tried different tutorial (like http://community.qlik.com/thread/36971), but they are not complete for me.
Is there a real guide to complete this?
What is the problem? Maybe I can guide you a bit but I dropped my Azure account in the meantime..
- Ralf
I did this :
Tried to connect with :
CUSTOM CONNECT TO "Provider='C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar';jdbc:sqlserver://name.database.windows.net:1433/dbname;ssl=true;XUserId=XX;XPassword=ZZ;";
Delete all old .dll files of the JDBC Connector and download the newest version which has an installer and config dialogs:
Thank for your help !
I have this error :
No suitable driver found for sqlserver://ZZ.database.windows.net:1433 (Good url?)
(I added Microsoft JDBC driver Microsoft SQL Server 3.0 on JDBC Connector)
You'll need a class 4 JDBC driver. You can download the one I used here: http://bit.ly/NkXOJd
The connect string is:
CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:sqlserver://<your_account>.database.windows.net?databasename=<your_db>;XUserId=<xxx>;XPassword=<yyy>;";
You can use the connect dialog with this URL: jdbc:sqlserver://<your_account>.database.windows.net?databasename=<your_db>;
Hope this helps..
- Ralf
Ralf,
Thank's a lot,
Unfortunately don't work for me..
Same error :
No suitable driver found for ZZ.database.windows.net
String like this :
CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;ZZ.database.windows.net;XUserId=ZZ;XPassword=ZZ;";
JDBC connector :
Wrong URL, you have to use a URL like this:
CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:sqlserver://ZZ.database.windows.net;XUserId=ZZ;XPassword=ZZ;";
it works!
Thank you very much for your help
Btw, you also have to specify your database:
jdbc:sqlserver://<your_account>.database.windows.net?databasename=<your_db>;