7,388
社区成员
发帖
与我相关
我的任务
分享关于asp访问数据仓库的简单问题,高分请教!!
我在ASP中显示一个简单数据仓库时,为什么连接老是说找不到数据库
cat.ActiveConnection = "Data Source=LOCALHOST;Initial Catalog=data;Provider=msolap;"
一直提示data找不到
cat.ActiveConnection = "Data Source=LOCALHOST;Initial Catalog=data;Provider=msolap;"
一直提示data找不到
...全文
请发表友善的回复…
发表回复
jhliu500 2003-11-07
- 打赏
- 举报
感謝各位
newmcz 2003-11-06
- 打赏
- 举报
你先写个静态的调试一下
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 1</title>
</head>
<SCRIPT language="VBScript">
<!--
sub OnLoad()
PivotTable1.DisplayToolbar=false
PivotTable1.ConnectionString="Provider=MSOLAP.2;Data Source=demo;Initial Catalog=Broker_OLAP"
PivotTable1.DataMember="资产分析_交叉分析"
'Set pv = PivotTable1.ActiveView
'pv.FilterAxis.InsertFieldSet pv.FieldSets("年季月日")
'pv.FilterAxis.InsertFieldSet pv.FieldSets("营业部")
'pv.FilterAxis.InsertFieldSet pv.FieldSets("币种")
-->
</SCRIPT>
<body onload="OnLoad()">
<p>
<object classid="clsid:0002E552-0000-0000-C000-000000000046" id="PivotTable1">
<param name="XMLData" value="<xml xmlns:x="urn:schemas-microsoft-com:office:excel">
<x:PivotTable>
<x:OWCVersion>10.0.0.4109 </x:OWCVersion>
<x:NoDisplayExpandIndicator/>
<x:DisplayScreenTips/>
<x:CubeProvider>msolap.2</x:CubeProvider>
<x:CacheDetails/>
<x:PivotView>
<x:IsNotFiltered/>
<x:Label>
<x:Caption>Microsoft Office PivotTable 10.0</x:Caption>
<x:NotVisible/>
</x:Label>
</x:PivotView>
</x:PivotTable>
</xml>">
<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'><tr><td bgColor='#336699' height='25' width='10%'> </td><td bgColor='#666666'width='85%'><font face='宋体' color='white' size='4'><b> 缺少 Microsoft Office Web Components</b></font></td></tr><tr><td bgColor='#cccccc' width='15'> </td><td bgColor='#cccccc' width='500px'><br> <font face='宋体' size='2'>此网页要求 Microsoft Office Web Components。<p align='center'> <a href='file:E:/新建文件夹/officexp/files/owc/setup.exe'>单击此处安装 MMicrosoft Office Web Components。</a>.</p></font><p><font face='宋体' size='2'>此网页同时要求 Microsoft Internet Explorer 4.01((SP-1)或更高版本。</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> 单击此处安装最新的 Internet Explorer</a>.</font><br> </td></tr></table></object>
</p>
</body>
</html>
"Provider=MSOLAP.2;Data Source=demo;Initial Catalog=Broker_OLAP"
修改一下,
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 1</title>
</head>
<SCRIPT language="VBScript">
<!--
sub OnLoad()
PivotTable1.DisplayToolbar=false
PivotTable1.ConnectionString="Provider=MSOLAP.2;Data Source=demo;Initial Catalog=Broker_OLAP"
PivotTable1.DataMember="资产分析_交叉分析"
'Set pv = PivotTable1.ActiveView
'pv.FilterAxis.InsertFieldSet pv.FieldSets("年季月日")
'pv.FilterAxis.InsertFieldSet pv.FieldSets("营业部")
'pv.FilterAxis.InsertFieldSet pv.FieldSets("币种")
-->
</SCRIPT>
<body onload="OnLoad()">
<p>
<object classid="clsid:0002E552-0000-0000-C000-000000000046" id="PivotTable1">
<param name="XMLData" value="<xml xmlns:x="urn:schemas-microsoft-com:office:excel">
<x:PivotTable>
<x:OWCVersion>10.0.0.4109 </x:OWCVersion>
<x:NoDisplayExpandIndicator/>
<x:DisplayScreenTips/>
<x:CubeProvider>msolap.2</x:CubeProvider>
<x:CacheDetails/>
<x:PivotView>
<x:IsNotFiltered/>
<x:Label>
<x:Caption>Microsoft Office PivotTable 10.0</x:Caption>
<x:NotVisible/>
</x:Label>
</x:PivotView>
</x:PivotTable>
</xml>">
<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'><tr><td bgColor='#336699' height='25' width='10%'> </td><td bgColor='#666666'width='85%'><font face='宋体' color='white' size='4'><b> 缺少 Microsoft Office Web Components</b></font></td></tr><tr><td bgColor='#cccccc' width='15'> </td><td bgColor='#cccccc' width='500px'><br> <font face='宋体' size='2'>此网页要求 Microsoft Office Web Components。<p align='center'> <a href='file:E:/新建文件夹/officexp/files/owc/setup.exe'>单击此处安装 MMicrosoft Office Web Components。</a>.</p></font><p><font face='宋体' size='2'>此网页同时要求 Microsoft Internet Explorer 4.01((SP-1)或更高版本。</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> 单击此处安装最新的 Internet Explorer</a>.</font><br> </td></tr></table></object>
</p>
</body>
</html>
"Provider=MSOLAP.2;Data Source=demo;Initial Catalog=Broker_OLAP"
修改一下,
illfe 2003-11-04
- 打赏
- 举报
但仍是有如下錯誤提示﹕高手看看如此解決﹖
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Source Error:
Line 30:
Line 31:
Line 32: amdCat.ActiveConnection = "Provider=msolap;DataSource=local;Initial Catalog=FoodMart 2000;"
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Source Error:
Line 30:
Line 31:
Line 32: amdCat.ActiveConnection = "Provider=msolap;DataSource=local;Initial Catalog=FoodMart 2000;"
bigddaddy 2003-10-31
- 打赏
- 举报
datasource=local
or
datasource=service name
or
datasource=ip address
or
datasource=service name
or
datasource=ip address
jhliu500 2003-10-31
- 打赏
- 举报
还是不行啊,
chump 2003-10-31
- 打赏
- 举报
“Data Source”变为“DataSource”看看！！！
