Discussion Board for collaboration on QlikView Scripting.
i want to load value from table in dataBase in server , but i don't know how i write in scrip to load value from table from data base.
i insert in the script the connexion with my database and the connexion is good,
the name of database is DataBaseFormation
the name of table : Personne
and i want to load ID from personne from databaseFormation
Any one can help i need help please
Solved! Go to Solution.
thank you verry mutch it work perfectelly,
other demand if you dont mind,i have a database sql server in my harddisk .mdf ,i couldn't succed to connect with it, what i write at the name of server and other field
I don't have a local sql server db available at the moment
I guess you have to start one or more service to start the sql db
You can connect to a sql server
- on a remote server; in this case the sql server is installed on the remote server and the database is usually there or on an attached storage
- on your local pc, on your machine; in this case you need a sql server (standard, express, etc, there are some versions, types) on your machine and the database .mdf is (usually) on your machine
Look at the connection in QlikView (oledb or odbc); you can see a server name or ip address; if is the name or ip of your machine you're connecting to a sql on your machine
if it's a name or ip of a server, you're connecting to a remote sql server
you can have as many connection you want: one for remote sql server, one for local, one for a different remote sql server, etc...