topic Re: Access support in QlikView

Access support

Thu, 22 May 2014 15:42:05 GMT

I am new to QV and trying to connect ole db into my laptop but unable to connect. can someone help me understand why am i getting error msg "[DBNETLIB][Connection open(Connect()),]SQL Server does not exist or access denied. Can some one explain me what does this mean and how can i rectify this mistake. tks

Re: Access support

ashfaq_haseeb — Thu, 22 May 2014 15:48:36 GMT

hi,

Hi is sql server installed your local machine or some other machine?

Try by connecting after you turn off your firewall.

Regards

ASHFAQ

Re: Access support

Thu, 22 May 2014 15:53:16 GMT

Hi I did download sql server but i am not sure how to turn off firewall, can u guide me. i can give u access to my laptop if you provide me ur email or the way to connect to you. tks

Re: Access support

ashfaq_haseeb — Thu, 22 May 2014 15:58:26 GMT

ashfaqhaseeb@gmail.com

Re: Access support

Thu, 22 May 2014 16:08:15 GMT

hi, Can i send you email on it. tks

Re: Access support

Thu, 22 May 2014 16:09:51 GMT

Hi Ashfaq,

Narendra here. Do you have team viewer to chat live. Call me or skype me at kumarkumar1989.

tks

Re: Access support

ramasaisaksoft — Fri, 23 May 2014 10:02:00 GMT

Hi Nagendra ,

Delete u r DNS connection and Create fresh DNS connection.May be it will help to u.

if u want , i attached Doc for , how to create a ODBC connection .Please check

Re: Access support

ramasaisaksoft — Fri, 23 May 2014 10:06:23 GMT

Hi Narendra,

if u give u r contact number i will help u on this, and send me to ramasaiqvw@gmail.com

Re: Access support

Ronnie_Taborn — Fri, 23 May 2014 13:07:49 GMT

Make sure you use a system DSN and not a User DSN. Make sure you connection is correct and account has access to the database.

Re: Access support

Fri, 23 May 2014 22:10:03 GMT

Hi Sai,

I follow the instruction as you have sent to me but could not connect to ODBC connection. I have a teamviewer, if you want we can connect via it. Pl let me know. If you need to call me before let me know what number i can expect from so i can pick up the phone. tks a lot for ur help and support.

Tks

Narendra

Re: Access support

Fri, 23 May 2014 22:27:41 GMT

HI there, I have nothing on User DSN and System DSN but under file DSN i see visual studio 2010 sitting. How can i remove it from file DSN. I am really having issue connecting sql server. I have downloaded but i am unable to open management studio. Is there any way u can help me fix this problem if you can. I really appreciate. tks

Re: Access support

Fri, 01 Aug 2014 15:35:19 GMT

Hi Ronnie, I still have same issue for connecting ODBC connection to the sql server. Is their any way you can help me connecting sql server to this QV server. I ll appreciate if you could respond to me. I am missing out real practice working on QV dashboard. Tks in advance.