cannabis
07-17-02, 23:26
| Set cat = Server.CreateObject("ADOMD.Catalog") Set cst = Server.CreateObject("ADOMD.CellSet") OLAPServerName = "RICKBOOK" cat.ActiveConnection = "Data Source=" & OLAPServerName & "; Initial Catalog=Chapter 6;Provider=msolap;" HI, I like to ask why my connection fail, when I change the Inital Catalog to FoodMart 2000, it work fines. I have set the system data sources, also there is a "Chapter 6" database on my analysis manager. thx~ Rick |