ADOMD.Connection error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Koni <kkogan@xxxxxxxxxx>
Date: Mon, 22 Jan 2007 18:17:41 -0600

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.
.

Prev by Date: Re: Source Safe Integration W Analysis Services Crashing
Next by Date: attn: gabrielle - highly tempting finances - pofna jurte wed - (1/1)
Previous by thread: Re: Source Safe Integration W Analysis Services Crashing
Next by thread: attn: gabrielle - highly tempting finances - pofna jurte wed - (1/1)
Index(es):
- Date
- Thread

Relevant Pages

ADOMD.Connection error
... We are getting this error: 'ADODB.Connection: Provider is not specified and there is no designated default provider' on a 64 bit machine with ... Dim oConnectionServer ... Dim arrDatabase ... Set oRS = oConnectionServer.OpenSchema ...
(microsoft.public.sqlserver.connect)
ADODB.Connection error on W2003 64bit
... We are getting this error: 'ADODB.Connection: Provider is not specified and there is no designated default provider' on a 64 bit machine with ... Dim oConnectionServer ... Dim arrDatabase ... Set oRS = oConnectionServer.OpenSchema ...
(microsoft.public.sqlserver.olap)
ADODB.Connection error
... We are getting this error: 'ADODB.Connection: Provider is not specified and there is no designated default provider' on a 64 bit machine with ... Dim oConnectionServer ... Dim arrDatabase ... Set oRS = oConnectionServer.OpenSchema ...
(microsoft.public.sqlserver.odbc)
Re: ADOMD.Connection error
... Dim oConnectionServer ... Dim oRS ... Dim arrDatabase ... Set oRS = oConnectionServer.OpenSchema ...
(microsoft.public.sqlserver.datawarehouse)
Re: Need WMI script
... WinNT provider reveals the "primary" group, ... I also assume that strGroupName ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes, ... However, if you use the cscript host, ...
(microsoft.public.windows.server.scripting)