Re: MS SQL Server OLAP data access with oledb
From: Frans Bouma [C# MVP] (perseus.usenetNOSPAM_at_xs4all.nl)
Date: 02/15/05
- Next message: Tor Bådshaug: "Re: How To Force Static Method Implementation"
- Previous message: Frans Bouma [C# MVP]: "Re: Formatting & Data Binding"
- In reply to: vla75: "MS SQL Server OLAP data access with oledb"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 10:20:29 +0100
vla75 wrote:
> Hi there,
> I made a webpage in asp.NET that access data trough Oledb and everything
> works fine if the webpage and the Olap database are on one and the same
> computer. When I moved the OLAP Database to a different computer our Database
> Server I get an error when I try to open the OledbConnection. I am accessing
> the data trough a connection string like this:
> string myConnStr="Provider=msolap.2;Data Source=192.168.0.10;Initial
> Catalog=VendorReport;";
> The ip address 192.168.0.10 is for our database server.
1) if you get an error, please state this error. We can't help you if
we don't know what's wrong. Any error info can be helpful.
2) you don't specify any username/password. This means you've used
integrated security. While this might work on one system, the user
you're using with asp.net is likely ASPNET. This is a local user, not a
domain user. This means that on the system your database is on now,
ASPNET isn't known. Either use a domain user for the website and for
logging on at the database (not recommended, a website shouldn't be in a
domain together with the db server) or use sql server security (i.e.:
UID=foo;PWD=bar; )
Frans
-- ------------------------------------------------------------------------ Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com My .NET blog: http://weblogs.asp.net/fbouma Microsoft MVP (C#) ------------------------------------------------------------------------
- Next message: Tor Bådshaug: "Re: How To Force Static Method Implementation"
- Previous message: Frans Bouma [C# MVP]: "Re: Formatting & Data Binding"
- In reply to: vla75: "MS SQL Server OLAP data access with oledb"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
