topic Re: Plz help to develop a connection string on my local machine in QlikView

Plz help to develop a connection string on my local machine

datanibbler — Wed, 07 Oct 2015 10:00:05 GMT

Hi,

I need some help in doing this, I don't have any idea:

- I need to develop a connection string to our company's database so I can use my local machine to retrieve data
(up to now I have always used the string made by a colleague and that only works on the server, so I always have to run
corr. apps in the QMC, so I cannot debug and stuff)

- I don't really know even what type of connection I need.

- The string generated by my colleague starts with >> ODBC CONNECT <<, followed by the source_name in square brackets,
including a > DBQ < and an XUserID and XPassword

When I select >ODBC< in the script_editor, the dialog opens and I have to select the type of my data - dBase or Excel or so - but there

is no possibility to set up the company database as a data_source.

Can anybody help me there?

Thanks a lot!

Best regards,

DataNibbler

Re: Plz help to develop a connection string on my local machine

marcus_sommer — Wed, 07 Oct 2015 11:37:44 GMT

Hi DataNibbler,

i hope this will help you: The Great ODBC Confusion

- Marcus

Re: Plz help to develop a connection string on my local machine

datanibbler — Wed, 07 Oct 2015 12:47:15 GMT

Hi Marcus,

that definitely took me a step further - but I'm not done yet.

Firstly, System_DSNs can only be generated with ADMIN privileges on the machine which I don't have, so I will have to contact IT about this.

But before I do so, I'd like to know what they will see. I'll do some more experimenting.