Data source connection to SAS via SS05

Hi all, does anyone have a sample (or knows of one on the web, maybe screenshots) of how to connect via SQL Server 2005 to a SAS box? The SAS machine is Unix, I am able to connect via Enterprise Guide from my local machine - which is also runing SS05 Developer. I'm investingating the possibility of building a cube of off a SAS dataset.

Thanks in advance.

Mark

Two things to keep in mind when building a cube. First, you have to have a driver with which SSAS can connect to the data source and through which SSAS can build objects within the DSV. Next, you need to have a cartridge with which SSAS can construct query statements to pull data from the data source.

You might be able to present SAS objects through SQL Server views using the OPENROWSET function. (This may be where you are already headed.) So, is there a way to connect SQL Server Database Engine to SAS using OPENROWSET?

One other thing, SAS has their own OLAP solution. Is that an option for you?

B.

|||

Ho Bryan,

I went in a different direction (FTP text files for awhile), but am re-visiting this now. We don't have the SAS OLAP Server in house, so unfortunately that isn't an option. However, is there a SAS/MSFT web-site where cartriges can be obtained from? I'm able to connect to the SAS box and can see the SAS datasets, but, I can't render them. Its literally the last step that's blowing up, and I believe it may be cartrige driven.

Thanks,

Mark

|||

Sorry to say I'm not aware of any cartridges other than those provided by default. Worst case, can you perform an OPENROWSET query through SQL Server? If so, you might be able to construct a query in SQL Server using OPENROWSET against SAS which would faciliate processing. Still, no guarantees that would work.

B.

Data source connection to SAS via SS05

Hi all, does anyone have a sample (or knows of one on the web, maybe screenshots) of how to connect via SQL Server 2005 to a SAS box? The SAS machine is Unix, I am able to connect via Enterprise Guide from my local machine - which is also runing SS05 Developer. I'm investingating the possibility of building a cube of off a SAS dataset.

Thanks in advance.

Mark

Two things to keep in mind when building a cube. First, you have to have a driver with which SSAS can connect to the data source and through which SSAS can build objects within the DSV. Next, you need to have a cartridge with which SSAS can construct query statements to pull data from the data source.

You might be able to present SAS objects through SQL Server views using the OPENROWSET function. (This may be where you are already headed.) So, is there a way to connect SQL Server Database Engine to SAS using OPENROWSET?

One other thing, SAS has their own OLAP solution. Is that an option for you?

B.

|||

Ho Bryan,

I went in a different direction (FTP text files for awhile), but am re-visiting this now. We don't have the SAS OLAP Server in house, so unfortunately that isn't an option. However, is there a SAS/MSFT web-site where cartriges can be obtained from? I'm able to connect to the SAS box and can see the SAS datasets, but, I can't render them. Its literally the last step that's blowing up, and I believe it may be cartrige driven.

Thanks,

Mark

|||

Sorry to say I'm not aware of any cartridges other than those provided by default. Worst case, can you perform an OPENROWSET query through SQL Server? If so, you might be able to construct a query in SQL Server using OPENROWSET against SAS which would faciliate processing. Still, no guarantees that would work.

B.

Data not displaying (in DataList) from SQL on GoDaddy

Everything works great on my development box. I am using GoDaddy for production (ASP.Net v2, SQL 2000).

I am not receiving any errors, so I am stumped; no data from the database is displaying on the GoDaddy pages.

I updated the connection string in web.config to this:

<addname="snsb"connectionString="

Server=whsql-vXX.prod.mesaX.secureserver.net;

Database=DB_42706;

User ID=username;

Password=pw;

Trusted_Connection=False

"providerName="System.Data.SqlClient" / >

But I am unsure if this is the issue?? Any insights? This is the page I am working on:www.sugarandspicebakery.com/demo/bakery/default.aspx. So, the page displays fine, but it should be showing data from the database. This particular page uses a DataList with ItemTemplate. There is definitely data in the database, and I have even ran the same exact query from the code using the Query Analayzer on GoDaddt and it returned results

I know there isn't much info to go by, but I am hoping someone has some insight since I have been trying to figure this out for days now!

Thank you

JenniferPost the code that you bind the datalist with the data source.
|||

Here is the code:

<asp:SqlDataSourceID="snsb"runat="server"ConnectionString="<%$ ConnectionStrings:snsb %>"SelectCommand="SELECT [itemNumber], [name], [shortDescription], [category], [imageFileName] FROM [snsb] WHERE ([category] = @.category)"EnableCaching="true"><SelectParameters><asp:QueryStringParameterDefaultValue="Cakes"Name="category"QueryStringField="cat"Type="String"/>
</SelectParameters></asp:SqlDataSource><asp:DataListID="DataList1"runat="server"RepeatColumns="3"RepeatDirection="Horizontal"CellPadding="25"AlternatingItemStyle-BorderWidth="1"DataSourceID="snsb"><ItemTemplate>

<asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl='<%# "~/bakery/item.aspx?item=" + Eval("itemNumber") %>'>
<asp:Imagerunat="server"BorderColor="#000000"BorderStyle="solid"BorderWidth="1"ImageUrl='<%# "../images/page/" + Eval("itemNumber") + "_a.jpg" %>'Width="123"Height="82"/></asp:HyperLink><br/>
<%# Eval("name") %><br/>
<%# Eval("shortDescription") %>
</ItemTemplate></asp:DataList>

Sorry it looks all over the place here on the forum, the insert code option doesn't appear to be working correctly.

Thanks,

Jennifer

Data migration

I have SQL 2K (SP3) box with 2 partitions and all of the databases are on
the first one (which is very small), and that is nearing 100% capacity. What
is the best way to point/move the databases to the second parition?
tia,
Garyhmm, should I just detach, move the .mdf and .ldf files to the second
partition and then atach it back? Would that cause any problems with the
front end?
-Gary
"Gary" <gary.rey@.NOOOOSPAM.virtium.com> wrote in message
news:OdOblJPbDHA.1740@.TK2MSFTNGP10.phx.gbl...
> I have SQL 2K (SP3) box with 2 partitions and all of the databases are on
> the first one (which is very small), and that is nearing 100% capacity.
What
> is the best way to point/move the databases to the second parition?
> tia,
> Gary
>

Data is still corrupted with hotfix 840987on Windows Server 2003

looking for high level ideas on this.
We are running SQL Server 2000 sp3a on a Window Server 2003 box with 8
gig memory and the /pae switch enabled.
Applied the 840987 hot fix but still getting corrupted data problems in
SQL Server.
Rebooting the server will correct the problem but need to know what
else to do.
I replied to your previous message..
"mcgillivrayk@.prodigy.net" wrote:

> looking for high level ideas on this.
> We are running SQL Server 2000 sp3a on a Window Server 2003 box with 8
> gig memory and the /pae switch enabled.
> Applied the 840987 hot fix but still getting corrupted data problems in
> SQL Server.
> Rebooting the server will correct the problem but need to know what
> else to do.
>
|||<mcgillivrayk@.prodigy.net> wrote in message
news:1113313047.715004.144880@.l41g2000cwc.googlegr oups.com...
> looking for high level ideas on this.
> We are running SQL Server 2000 sp3a on a Window Server 2003 box with 8
> gig memory and the /pae switch enabled.
> Applied the 840987 hot fix but still getting corrupted data problems in
> SQL Server.
> Rebooting the server will correct the problem but need to know what
> else to do.
I replied to you above, re-posting it again here:
I think that problem is discussed in this KB article.
http://support.microsoft.com/kb/827714
I'm also having the same problem, sometimes daily, sometimes I go nearly a
week without it. It is *supposed* to be fixed in SQL 2000 SP4, which is
still in beta nearly 4 months later!!! WHEN is MS going to release it? I
just had to rebuild AGAIN for about the 100th time!

Data is still corrupted with hotfix 840987on Windows Server 2003

looking for high level ideas on this.
We are running SQL Server 2000 sp3a on a Window Server 2003 box with 8
gig memory and the /pae switch enabled.
Applied the 840987 hot fix but still getting corrupted data problems in
SQL Server.
Rebooting the server will correct the problem but need to know what
else to do.I replied to your previous message..
"mcgillivrayk@.prodigy.net" wrote:

> looking for high level ideas on this.
> We are running SQL Server 2000 sp3a on a Window Server 2003 box with 8
> gig memory and the /pae switch enabled.
> Applied the 840987 hot fix but still getting corrupted data problems in
> SQL Server.
> Rebooting the server will correct the problem but need to know what
> else to do.
>|||<mcgillivrayk@.prodigy.net> wrote in message
news:1113313047.715004.144880@.l41g2000cwc.googlegroups.com...
> looking for high level ideas on this.
> We are running SQL Server 2000 sp3a on a Window Server 2003 box with 8
> gig memory and the /pae switch enabled.
> Applied the 840987 hot fix but still getting corrupted data problems in
> SQL Server.
> Rebooting the server will correct the problem but need to know what
> else to do.
I replied to you above, re-posting it again here:
I think that problem is discussed in this KB article.
http://support.microsoft.com/kb/827714
I'm also having the same problem, sometimes daily, sometimes I go nearly a
week without it. It is *supposed* to be fixed in SQL 2000 SP4, which is
still in beta nearly 4 months later!!! WHEN is MS going to release it? I
just had to rebuild AGAIN for about the 100th time!

Data in table is deleted

Hi!
I have a problem with table in a SQL Server 2000 box. It seems like the
table is truncated from time to time! I don't know why and it has just
started occuring, but it happens maybe once a week now.
Is there any way to monitor if a delete statement occurs on just that table?
Is it possible in Profiler to monitors just action against one table?
Any hint or tips would be greatly appreciated!!
regards
Fredrik
Yes you can have profiler monitor a single table... Set the table in the
filter clause... Delete is not the same as truncate however, so watch for
both...(Delete will run a trigger, if one exists, and truncate does not.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:7631AE53-49D2-4504-8A87-6FB5C61FB517@.microsoft.com...
> Hi!
> I have a problem with table in a SQL Server 2000 box. It seems like the
> table is truncated from time to time! I don't know why and it has just
> started occuring, but it happens maybe once a week now.
> Is there any way to monitor if a delete statement occurs on just that
table?
> Is it possible in Profiler to monitors just action against one table?
> Any hint or tips would be greatly appreciated!!
> regards
> Fredrik

Data in table is deleted

Hi!
I have a problem with table in a SQL Server 2000 box. It seems like the
table is truncated from time to time! I don't know why and it has just
started occuring, but it happens maybe once a week now.
Is there any way to monitor if a delete statement occurs on just that table?
Is it possible in Profiler to monitors just action against one table?
Any hint or tips would be greatly appreciated!!
regards
FredrikYes you can have profiler monitor a single table... Set the table in the
filter clause... Delete is not the same as truncate however, so watch for
both...(Delete will run a trigger, if one exists, and truncate does not.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:7631AE53-49D2-4504-8A87-6FB5C61FB517@.microsoft.com...
> Hi!
> I have a problem with table in a SQL Server 2000 box. It seems like the
> table is truncated from time to time! I don't know why and it has just
> started occuring, but it happens maybe once a week now.
> Is there any way to monitor if a delete statement occurs on just that
table?
> Is it possible in Profiler to monitors just action against one table?
> Any hint or tips would be greatly appreciated!!
> regards
> Fredrik