topic Re: Macro connection string to write to database in QlikView

Macro connection string to write to database

Thu, 02 Jul 2015 13:02:23 GMT

Hi there,

i hope you can help me:

i had written a new macro to write test-data to a database:

Public Sub WriteSQL

dim sConn, oConn

Set oConn = CreateObject("ADODB.Connection")

oConn.Open "Provider=MSDASQL.1;Data source=QLIKVIEW_DATA:44444;Catalog=QLIKVIEW_SERVICE;User Id=ABC;Password=CDE;"

sSQL="INSERT INTO dba.qlikview_test (pkid,Testfeld) VALUES (null,'Testwert')"

oConn.Execute(sSQL)

oConn.Close

Set oConn = Nothing

end sub

We are using Sybase Central 6 and SQL Anywhere 12.

When i test the macro, i get always the information: the provider is not known.

Anybody an idea how to set the connecting string?

Thanks and regards,

Sabrina

Re: Macro connection string to write to database

Gysbert_Wassenaar — Thu, 02 Jul 2015 13:14:55 GMT

the provider is not known.

Then either you didn't install the correct driver or you're using the wrong provider name. If you're using a 64-bit OS you also need a 64-bit OLEDB driver.

Re: Macro connection string to write to database

Thu, 02 Jul 2015 13:16:55 GMT

Yes we are using a 64bit OS, where QV and sybase are running.

Where can i find the 64bit driver to install?

Thanks and regards

Re: Macro connection string to write to database

Gysbert_Wassenaar — Thu, 02 Jul 2015 13:24:20 GMT

Try the support site of the vendor of your database.

Re: Macro connection string to write to database

petter — Thu, 02 Jul 2015 13:39:24 GMT

The website www . connectionstrings . com coluld be a helpful resource....