Can someone help me with LOBSystemInsance for Oracle ODBC connection with SSO?
View Complete Post
We are trying to connect the simple way from Sharepoint Designer 2010 to an external Pervasive SQL version 10 database.
Normally this is a trivial excercise in any other development tool, you supply an ODBC connection and away you go.
Using Sharepoint Designer 2010 (or the previous version) it is not possible to get a working connection that will get you past the "Configure Database Connection" dialog. We have to use the "Use custom connection string option" as that is the only place
there appears to be a Provider for ODBC or OleDB.
No connection string works, I have tried connection strings that work fine in Visual Studio, no joy.
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 !
I have visual studio 2008 professional with the inbuilt crystal reports version 10 I think. I create everything from my laptop and IIS runs from my laptop as well.
I have created the most basic report to try and figure out a problem I have, anyways the report contains one database field that is it .... which I connect to by ODBC. I then create a web form add the crystal report viewer to the report and the crystal report source run the web page and it loads the data from the field as I would expect to the crystal report viewer !!
I have several ODBC connections setup on my machine one using integrated security the other using SQL authentication both are system DSNs. Now when I publish my application and access it from IIS and not the localhost I can access everything from my application ok except when I go to form that has the crystal reports I get this error (ODBC used here is the 'sa' account)
Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error in File
If I use the other ODBC that uses Windows authentication I get this error message
Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested by the login. T
I am modifying a SharePoint site and so far so good. Some of the objects were created using Visual Studio 2008 (C#). I was able to modify these objects and implement them on the targete machine without issue. The final step is to implement
the ASPX pages that were modified using SharePoint Designer 2007. These are aspx pages that are used to modify items in lists. All the pages involved in this upgrade are customized. I need to upgrade the target site with the modified version
of these pages. My intent is to copy the code from the page in the source site and past it into the same page on the target site. I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:
"Unable to open 'https://(site address)'. Server Error: Could not find a Web server at 'website'. Please check to make sure that the Web server name is valid and your proxy settings are set correctly. If you are sure that everything
is correct, the Web server may be temporarily out of service."
I am not sure how to first check to see if the Web Server is temporarily out of service. I would appreciate your input on how to verify this.
Background information of target machine: WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80
Can anyone have information to share on,
As to how SharePoint 2010 sync with Oracle OID?
Is it supported from Microsoft? and
What are the ramifications?
Any help is highly appreciated.