"Koni" <kkogan@haiint.com> wrote in message
news:uAgqmPoPHHA.1152@TK2MSFTNGP03.phx.gbl...
> We are getting this error: 'ADODB.Connection: Provider is not specified
> and there is no designated default provider' on a 64 bit machine with both
> Sql 2K 32bit and Sql 2K5 64bit installed. It happens from Vbscript that
> backs up our Olap databases. The script (below) works fine on a 32 bit
> server with Sql 2K installed.
>
> Function QueryDatabaseList()
>
> Dim oConnectionServer
> Dim oRS
>
> Dim arrDatabase
>
>
> Set oConnectionServer =CreateObject("ADODB.Connection")
> oConnectionServer.ConnectionString = "Data Source=" & ServerName & ";
> Provider=MSOLAP.2"
> oConnectionServer.Open
> Set oRS = oConnectionServer.OpenSchema(adSchemaCatalogs)
>
> arrDatabase = oRs.GetRows
>
> oConnectionServer.Close
> Set oConnectionServer = Nothing
>
> QueryDatabaseList = arrDatabase
>
> End Function
>
> I am pretty sure the problem has to do with the fact that the right driver
> can not be found. But which one???
>
>
> Thanks in advance,
> Koni.