topic Re: databse connection in macro in QlikView

databse connection in macro

Fri, 27 Dec 2013 10:01:57 GMT

Hi,

I want to connect to oracle database in macro. Can anybody please tell me how do i do this??

Thanks in advance!!!

Re: databse connection in macro

Fri, 27 Dec 2013 10:32:24 GMT

hi kavita,

try to using vb script

Dim strCon

strCon = "Driver={Oracle in Oracle in Orahome10g}; " & _

"CONNECTSTRING=(DESCRIPTION=" & _

"(ADDRESS=(PROTOCOL=TCP)" & _

"(HOST=SERVERNAME)(PORT=1521))" & _

"(CONNECT_DATA=(SERVICE_NAME=TEST))); uid=username;pwd=password;"

Dim oCon: Set oCon = WScript.CreateObject("ADODB.Connection")

Dim oRs: Set oRs = WScript.CreateObject("ADODB.Recordset")

oCon.Open strCon

Set oRs = oCon.Execute("SELECT 1 from dual")

While Not oRs.EOF

WSCript.Echo oRs.Fields(0).Value

oRs.MoveNext

Wend

oCon.Close

Set oRs = Nothing

Set oCon = Nothing

Re: databse connection in macro

Fri, 27 Dec 2013 10:55:18 GMT

Hi Dushan,

Thanks a lot for your reply..

"Oracle in Oracle in Orahome10g"--> is this driver name ??

And where do you give the IP address of database server?

Re: databse connection in macro

Fri, 27 Dec 2013 11:00:31 GMT

Hi,

yes it is and HOST=SERVERNAME. there you can Place your Server IP.

Best rgrds,

Dushan

Re: databse connection in macro

Fri, 27 Dec 2013 11:07:35 GMT

hi,

replace DRIVER, SERVERNAME, SERVICE_NAME, username and password.

Best rgrds,

Dushan

Re: databse connection in macro

Fri, 27 Dec 2013 11:10:59 GMT

Hi Dushan,

I have written following statement but there is some problem in what I have written can you please help me to correct it as I'm new to this.

strCon = "Driver={Oracle in OraDb 10g_home1}; " & "CONNECTSTRING=(DESCRIPTION=" & "(ADDRESS=(PROTOCOL=TCP)" & "(HOST=127.0.0.1)(PORT=1521))" & "(CONNECT_DATA=(SERVICE_NAME=DB11G))); uid=usr;pwd=pwd;"

Re: databse connection in macro

Fri, 27 Dec 2013 11:19:10 GMT

hi,

what s the error u are having?

Re: databse connection in macro

Fri, 27 Dec 2013 11:28:02 GMT

Edit macro dialog box opens every time I try running the macro by clicking on it.

Re: databse connection in macro

Fri, 27 Dec 2013 11:31:05 GMT

hi,

select allow system access and click ok

Re: databse connection in macro

Fri, 27 Dec 2013 11:53:20 GMT

Yes I have done it. Still its not working.