topic Re: load from dataBase in QlikView

load from dataBase

Wed, 23 Dec 2015 13:19:55 GMT

Hi all

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

Thanks aLL

Re: load from dataBase

maxgro — Wed, 23 Dec 2015 20:29:04 GMT

After the database connection,

did you try with the Select button in the script editor?

Re: load from dataBase

Thu, 24 Dec 2015 12:33:37 GMT

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

thanks

Re: load from dataBase

maxgro — Thu, 24 Dec 2015 13:49:47 GMT

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

Lesson 1: Connecting to the Database Engine

"http://stackoverflow.com/questions/360141/how-to-connect-to-local-instance-of-sql-server-2008-express"

Re: load from dataBase

Thu, 24 Dec 2015 17:37:20 GMT

so i must instal the sql server in my machine ?! if yes why did i could acces in the db in server without any problem

Re: load from dataBase

maxgro — Thu, 24 Dec 2015 18:05:57 GMT

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...

Re: load from dataBase

Thu, 24 Dec 2015 19:03:47 GMT

thank you for your explication maxgro