February 2, 2006 at 4:35 pm
I posted this topic under Administration too, but I know all of the real Gurus hang out here:
I am running SQL Server 2000 on a 64 bit machine with a 64 bit OS (windows). Several of my applications or mid-tier objects connect to the database with MS OLE DB Providers. The problem I am having is that these Providers are not made available through Data Sources so I cannot create a DSN. The only ODBC driver that is displayed is SQL Server. Any ideas on what is needed here?
Thanks!
February 3, 2006 at 11:49 am
Aren't DSN's for ODBC-sources only?
You can use DSN-less connections however
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21009195.html
February 3, 2006 at 11:54 am
You are correct. However, when I try to use a DSN-less connection, I receive an error saying that the Provider is not available or was not found.
February 3, 2006 at 11:59 am
Can you give an example of your connectionstring?
February 3, 2006 at 12:26 pm
Here you are:
set conn = server.CreateObject("ADODB.Connection")
conn.Open ("Data Source=" & serv & ";initial catalog=" & catalog & ";Provider=MSOLAP")
February 3, 2006 at 12:38 pm
I don't have experience with MSOLAP but
http://support.microsoft.com/default.aspx?scid=kb;en-us;218592
To query a local or a remote OLAP server database from SQL Server, you have to install the MSOLAP OLE DB provider on the computer that is running SQL Server. The MSOLAP OLE DB provider is installed when you install the OLAP client components from the SQL Server 7.0 CD.
seems to explain it in great detail of what is necessary.
You can find a list of possible connectionstring
on http://www.connectionstrings.com
http://www.codeproject.com/database/connectionstrings.asp
This link mentions something about olap & ado at the bottom
*olap https
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply