Tool ->Option->Environment->Font

I have a web application developed using VS 2008... It creates & reads excel files (the creation part is done using the Enterprise Office object library 12, and the reading part is using the Microsoft.ACE.OLEDB.12.0) when deploying the application to a windows server 2008 R2 64 bit machine we faced "the microsoft.ace.oledb.12.0 provider is not registered" error. So I had to change the application pool in IIS7 to enabled 32 bit applications (which make the web application run in a 32 bit environment) and this solved our problem...

Now we had another requirement that needs to retrieve some data from an Oracle DB after installing the Oracle 10g client 64-bit and redeploying the modified web application to the server I am getting the following error: "Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.", Once seeing this error I tried to switch back the application pool to run on 64 bit and it worked!

Now I am stuck, Microsoft.ACE.OLEDB.12.0 requires 32 bit mode while the Oracle connection requires 64 bit mode. I searched in the net for a 64 bit replacement of ACE and found the Microsoft.ACE.OLEDB.14.0, but installing this requires removing Ms Office 2007 from the machine which I can't do because I am using the object library for creating excel files! So does anyone have any suggestion on how to tackle this? 

I have a web application developed using VS 2008... It creates & reads excel files (the creation part is done using the Enterprise Office object library 12, and the reading part is using the Microsoft.ACE.OLEDB.12.0) when deploying the application to a windows server 2008 R2 64 bit machine we faced "the microsoft.ace.oledb.12.0 provider is not registered" error. So I had to change the application pool in IIS7 to enabled 32 bit applications (which make the web application run in a 32 bit environment) and this solved our problem...

Now we had another requirement that needs to retrieve some data from an Oracle DB after installing the Oracle 10g client 64-bit and redeploying the modified web application to the server I am getting the following error: "Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.", Once seeing this error I tried to switch back the application pool to run on 64 bit and it worked!

Now I am stuck, Microsoft.ACE.OLEDB.12.0 requires 32 bit mode while the Oracle connection requires 64 bit mode. I searched in the net for a 64 bit replacement of ACE and found the Microsoft.ACE.OLEDB.14.0, but installing this requires removing Ms Office 2007 from the machine which I can't do because I am using the object library for creating excel files! So does anyone have any suggestion on how to tackle this?

Am I losing the plot or do the masterpages included in the accessibility toolkit (AKS) not allow you to change the font size in the browser?

I thought that was one of the fixes that this toolkit solves or maybe I misunderstood!

Would appreciate anyones thoughts on this.

I really need someone's help to configure my SharePoint 2007/ Excel services connectioon to SSAS 2008. It surely cannot be that complicated???

MOSS on server 1
SSAS 2008 cube on server 1
Trusted data provider created (OLE DB, MSOLAP.4)
Trusted data connection library created
Trusted File location created - children trusted, allow external data = "Trusted data connection libraries and embedded"
Unattended Service Account - setup

I use Excel and create a new .odc file with athenticated type = NONE and save it to the Trusted data connection library. Using the odc I open a new workbook. I firstly get a security warning saying that "MS Office has identified a potential security concern. Data connections have been blocked. If you choose to enable data connections..."

I click on Enable, and now have access to my cube. I create a pivit table and chart and publish the workbook back to a child folder in the Trusted File location. All okay so far!!

Now I open the new workbook, and as soon as I try and interact with it, I get the dreaded error "Unable to retrieve external data for the following connections:

BI_Cube_PO01

The data sources may be unreachable, may not be responding, or may have denied you access

Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set"

I really think the MOSS guys are missing a trick here. This should not be this difficult to set up and complaints and hassels to get this working is so well documented online!!

I do not want to use SSO -  can someone please help.

 

Hi,

I set up Form Base Authentication in sharepoint 2007.also I create .aspx page with VS.2008 and I want to use URL of list in FBA site in .aspx page. This .aspx page use by anonymous users but when anonymous user use that link (because this link in FBA site) Login.aspx appears. I want to use information of that list in my .aspx page without FBA authentication.(actually users who see this .aspx page don’t know about exists of FBA )

How I can do that? (do you know the way solve this problem without using sharepoint object model?)

I’m very appreciated if anyone help me.

Thanx.

My client would like to restrict users to two or three fonts when creating or editing a page.  I've tried to do it through css, but it's overwritten when a different font is chosen in the edit panel.  Using the css, the dropdown show's the "Theme Fonts" and then the rest of the fonts below it.  Is there a way to show only "Theme Fonts"?  They're looking to do the same thing with sizes.

How to set the font color as "white" to the text

How do I change the environment variables as in this statement :

in the environment variables change both the TEMP and the TMP from the x:\documents and Settings\user\...

To c:\Temp or any other folder

Thank you.

Jegajothy

 

I know that Detect Categories (part of Table Analysis tools) uses the Microsoft_Clustering algorithm in order to compare the similarity of rows in a data set and then categorize them. For the actual Cluster function in the Data Mining tab, you can customize the parameters of the clustering algorithm. This includes the parameter CLUSTERING_METHOD which specifies the clustering method for the Microsoft_Clustering algorithm to use. You can choose from the following clustering methods:

• 1- Scalable EM
• 2- Non-Scalable EM
• 3- Scalable K-Means
• 4- Non-Scalable K-Means

and 1-Scalable EM is the default method for the Clustering part of Data Mining.

When running the table analysis tool Detect Categories you do not have a way to adjust the parameters of the Microsoft_Clustering algorithm, including which clustering method to use.

So my question is what clustering method does Detect Categories use? I assumed it was the default for the Cluster, 1- Scalable EM, but I ran the same data set in Data Mining Clustering using the method 1-Scalable EM, and the cluster analysis gave me 6 clusters. I ran the same data set in the Detect Categories tool and it outputted 9 categories, not 6. So this is leading me to believe that the default parameters for the Microsoft_Clustering algorithm for the cluster tool in data mining are not the same for Detect Categories.

What clustering method does detect categories use? and would there be any other differences in parameters for the Microsoft_Clustering algorithm for both these cluster tools?

Thanks!!

I'm looking for a good Tool for ERD.

I used to work with Power Designer and liked it, but now we need to buy a new tool and we would like to hear from other what tools the advice.

I would like it to:

1. Be user friendly with the Diagram, have the ability to change entity color,

2. have lists of objects like list of all columns in the DB (so that i can find by ordering the list all column with same name/type etc.)

3. know to generate scripts to update the DB with changes after comparing between DB to Model OR model to model

4. Have the ability to be disconnected from the DB (not like the diagrams in SSMS)

5. Shouldn't be too complicate.

Any ideas will be appreciated.

 

Is there any tool included with Visual Studio 2010 or SQL Server 2008 R2 that would allow me to compare a database to see what fields are missing, how stored procs are different etc?

I have a test database and live database. I would like to replicate the changes from test to live but of course i dont want to miss something out. Since the live db has data it would be convenient if i have a check point to ensure all changes from test are replicated to live (other than data).

Thanks