.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SharePoint BDC- Oracle ODBC connection with SSO

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

Can someone help me with LOBSystemInsance for Oracle ODBC connection with SSO?

View Complete Post

More Related Resource Links

Configuring ODBC Database connection in Sharepoint Designer 2010


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.



Need Oracle Data Provider .CS File for Oracle 10g Database connection !



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 !    

Basic ODBC Connection to connect to Crystal ???


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

How to Establish a Remote Web Site Connection in SharePoint Designer 2007


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

odbc connection failed

i have microsoft sql server 2000. i am using program based on VB.when i try to run the components like  import database design, link table, etc then the message get displayed " ODBC connection failed".please give me the solution.please.....

Connection to Oracle

I am currently working on the connection between ASP.NET and Oracle. I tried to search over the net and know there are many ways. Is there any 'normal practice' on which method to be used? Or it depends? I tried with OLEDB connection provided by .NET and it appears to be fine.   Thanks a lot!

odbc connection to sql server c#

How can I use ODBC to connect to sql server 2005 in c# windows forms ??  Please post a code snippet as example ....  

ODBC connection to SQL Server 2005 Standard (on windows xp) with Windows authentication does NOT wor

I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.

Sharepoint Filter Web Part Connection to Picture Libary Web Part

It seems that a sharepoint or choice filter web part can connect to any list object in sharepoint that is displayed in a web part on a page but the picture library.  I want to allow the user to select a value so that only the image that applies is viewed (along with any correlating information stored in its library). Is there a work around for this?  I've looked all over the web and can only find where someone else has asked in another forum and has not yet received an answer.  I'm sure this isn't the first time this has come up, so what are folks doing to accomplish this?

Can Not Add Sharepoint Connection in VS2010 Ultimate

I installed VS 2010 Ultimate yesterday on my desktop. I select 'New Project' for C# > Select SharePoint > 2010  > 'project' , then get an error " A SharePoint Server is not installed... " When I go to Server Explorer and select SharePoint connections > Add Connection, I get the same error. It will not let me connect to my SP server which is 2010 version. Do I have to have VS on the actual server? If so, why? I want to program from Desktop not server Any Help is appreciated

2-Way Connection between SharePoint List and SQL Database?

We currently have a SQL database with an Access front-end.  It's clunky and everyone hates it, of course.  Is there a reasonably simple way to tie a SharePoint list to a table in the database so that items can be entered in the SharePoint List and show up in the database, and vice-versa?  The reason for keeping the database is that some data is entered by users in Access, but some comes from an external source - thus, the need for a 2-way connection. It's MOSS 2007.

Sharepoint 2010 - The Managed Metadata Service or Connection is currently not available. The Applica

So I've already installed hot fix http://support.microsoft.com/kb/976394.  Rebooted server and I still get this message.  The account being used is part of local adminstrators group and has full connection permissions for managed metadata service.  Is there anything else I'm missing or needs to be done?

ODBC connection in group policy

Hello, We want to apply ODBC connection setting for all users in AD. We did googling but could not able to find any help. We've SQL 2005 database package which will be used by all users and users have very limited access i.e., only to run this package. Nothing else access given to users. User unable to use package as ODBC connection is set fo them. We do ODBC setting for every users one by one giving control panel setting and then again revert it with limited access. It is very difficult task to for 100 users. Please suggest GP where in we can set the ODBC for all users at the time. Your early response will great and appreciated. Thanks!!!   Regards, Shaikh Sameer

Infopath bug in windows 7 to convert datasource to data connection library in sharepoint?

Any ideas about this bug: Windows 7, infopath 2007, did not check in the data connection file when converting a data source? Also it did not set title and kept the file checked out so that you can not even update the items by SharePoint UI. I did everything successfully with Infopath 2007 on a windows xp machine. Is the OS related in this case? Thanks,

BIDS Connection Manager Cannot Connect to Remote Oracle Db

Hi All,
I'm not having much luck getting an 'Oracle Provider for OLE DB' remote connection in connection manager to work when creating an SSIS package in BIDS.

I've covered off all the steps in the following link

The local machine is running SQL 2005 Sp2 Enterprise Edition on W2003 Sp2 Standard Edition X64

Using the Oracle 'Net Configuration Assistant' I can connect successfully to the remote service

I'm using ODAC 10g Release 2.

The steps to reproduce the error are as follows

1. in BIDS after creating an SSIS Solution
2. Right click in the  Connection Manager and select new OLE DB Connection
3. Click 'New'
4. Select 'Oracle provider for OLE DB'
5. Under server I enter the service name that I created in the Oracle 'Net Configuration Assistant'
6. Enter the user name and password as I entered in the Oracle 'Net Configuration Assistant'
7. When I click 'Test Connection' I get the following error

Test connection failed because of an error in initializing provider. ORA-12154: TNS could not resolve the connect identifier specified

I've spent a lot of time trying to get this to work and tried othe

Server 2003 prompting for credentials when connection to Sharepoint document library via UNC

Hi all

I have a sharepoint document library http://mycompany/sites/documentLibrary. When browsing to this site through Internet Explorer on a terminal server I can get to the site without being prompted for a username and password, which is what I want. The site appears as "local intranet"  according to IE.

When browsing to the UNC path \\mycompany\sites\documentLibrary we are being prompted for a username and password. After putting in the credentials the document library displays. I need for the server to be able to access the site via UNC path without being prompted for credentials as we have several in house applications relying on doing so

The funny thing is this was working until recently. What's changed? I have no idea. I have an almost identical terminal server on the same subnet/OS/windows patch level that allows access without prompting for a username or password, and the only thing I had to do for that server was enable the web client service..

Things I have tried so far:

- Checked the Web Client service is enabled, started and set to automatic. Restarted the server just to make sure.
- Added http://mycompany, \\mycompany etc to the trusted zone.
- Set the truste

SharePoint 2010 sync with Oracle OID


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.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend