OLAP Connection error

Below code at web.config file, when i change Data Source to other pc name....an error occur 'The data provider didn't supply any further error information'...
let said change the datasource 'localhost' to 'webserver' error will occur...so i cannot run the program at my pc and link the olap database at server...

<add key="OLAPConnectionString" value="Provider=MSOLAP.2;Data Source=localhost;Initial Catalog=Foodmart 2000;" />The other PC that you are trying to connect should have the same users and user rights as the first one.

In addition to that, the Analysis Server on your second PC should know about these users as well.

I found that security with Analysis Server is very tight.

Good Luck

ODBC SQL Server error

I have a ASP.Net application. I'm trying to access access data using SQL Server

my web config has

<addkey="connectionString"value="DRIVER={Sql Server};Server=(local);initial catalog=ymquizco_registration;User ID=sa;pwd=test"/>

MY CONNECTION STRING HAS THIS VALUE

"DRIVER={Sql Server};Server=localhost;initial catalog=ymquizco_registration;User ID=sa;pwd=test"

But the conn.Open();is throwing this error:

{"ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\\ASPNET'.\r\nERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute\r\nERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\\ASPNET'.\r\nERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute" }

My SQL Server is configured at mixed mode authentication. This seems like a install issue. Can someone think of something.

Fromhttp://www.connectionstrings.com, your connection string should look more like this:
Standard Security:

"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

ODBC from unix client to MSSQL server?

Anyone support a config where you have an unix/linux (AIX here) ODBC
client connection to SQL Server database? I am looking for a simple,
supportable configuration that does not require me to learn perl or
instal a bunch of crap gnu shareware on enterprise class machines.
Please help!
You can try the JDBC driver for SQL Server 2000 - watch out
for line wrap on the link:
http://www.microsoft.com/downloads/d...displaylang=en
You can find more information on other alternatives at:
http://www.sommarskog.se/mssql/unix.html
-Sue
On Thu, 29 Jul 2004 12:34:38 -0700, "sumGirl"
<sumGirl@.discussions.microsoft.com> wrote:

>Anyone support a config where you have an unix/linux (AIX here) ODBC
>client connection to SQL Server database? I am looking for a simple,
>supportable configuration that does not require me to learn perl or
>instal a bunch of crap gnu shareware on enterprise class machines.
>Please help!
|||Have you checked out FreeTDS at www.freetds.org.
"sumGirl" <sumGirl@.discussions.microsoft.com> wrote in message
news:8F5C9D39-C780-4A29-B305-DA598CB760EC@.microsoft.com...
> Anyone support a config where you have an unix/linux (AIX here) ODBC
> client connection to SQL Server database? I am looking for a simple,
> supportable configuration that does not require me to learn perl or
> instal a bunch of crap gnu shareware on enterprise class machines.
> Please help!
>

ODBC from unix client to MSSQL server?

Anyone support a config where you have an unix/linux (AIX here) ODBC
client connection to SQL Server database? I am looking for a simple,
supportable configuration that does not require me to learn PERL or
instal a bunch of crap gnu shareware on enterprise class machines.
Please help!You can try the JDBC driver for SQL Server 2000 - watch out
for line wrap on the link:
AA54BFDC03A&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
You can find more information on other alternatives at:
http://www.sommarskog.se/mssql/unix.html
-Sue
On Thu, 29 Jul 2004 12:34:38 -0700, "sumGirl"
<sumGirl@.discussions.microsoft.com> wrote:

>Anyone support a config where you have an unix/linux (AIX here) ODBC
>client connection to SQL Server database? I am looking for a simple,
>supportable configuration that does not require me to learn PERL or
>instal a bunch of crap gnu shareware on enterprise class machines.
>Please help!|||Have you checked out FreeTDS at www.freetds.org.
"sumGirl" <sumGirl@.discussions.microsoft.com> wrote in message
news:8F5C9D39-C780-4A29-B305-DA598CB760EC@.microsoft.com...
> Anyone support a config where you have an unix/linux (AIX here) ODBC
> client connection to SQL Server database? I am looking for a simple,
> supportable configuration that does not require me to learn PERL or
> instal a bunch of crap gnu shareware on enterprise class machines.
> Please help!
>