View Complete Post
I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.
In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.
I've created a dimension based on this query with object_id as the key.
I've deployed the solution to the server. All is working fine for the moment.
But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :
"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."
Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.
Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.
Serveur : L'opération a été annulée.
Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O
We are running a SharePoint 2007 farm and we have staff that want to use a dataview to connect to an Oracle Database as well as a SQL database. The SLQ connection worked fine. When we try an Oracle Connection using a custom connection string we recieve
an error retriving the list of databases.
Some of the information I have read mentions installing the Oracle Client on the SP Web Front End servers and others do not.
Is there a way to connect to an Oracle database without installing the Oracle Cleint on the SP Web Front End servers?
I've read about using BDC, but that seems to involve having the Oracle.dll in the GAC which I believe would require the Oracle client to be installed.
I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where
i can just call the method with my SQL Query
Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");
Plz Post the link if there is any open source !
Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.
MSDN Magazine September 2004
Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?
I need to display a List of Hyperlinks that are stored in a database. I want it to be a SharePoint List so it can be Indexed and Search properly in SharePoint.
SharePointSite Table - Columns:SiteName(nvarchar(256)), URL(nvarchar(256))
Example: Acme Foods, http://www.acme.com
I need a List that shows:
Acme Foods and is a clickable hyperlink to
What is the best way to get access to the data and feed it to a List and then host it on a Site landing page?
This is meant to be a directory of Site Collections. We have 175 Site Collections that host our customers Report Libraries.