Macro connection string to write to database

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

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

[Gysbert_Wassenaar]

Try the support site of the vendor of your database.

[petter]

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