locked
Missing Oracle data source RRS feed

  • Question

  • Hi,

    here is what help says:

    The Add Connection dialog box for Oracle allows you specify settings, such as database file name and passwords, for this connection. This dialog box is available when Oracle Database is selected under Data Source in the Choose/Change Data Source ....

    where can I find it? I can only see Access and SQL server?

    Thanks

    Martin
    Friday, November 11, 2005 2:22 PM

Answers

  • You're in the correct menu, the issue is that this feature is not enabled for Visual Basic, C#, C++, or J# Express as these products can only support connecting to local data sources. It is, however, enabled in Visual Web Developer Express and Visual Studio Standard Edition or higher.

    Thanks,
    Dan Fernandez
    Product Manager
    http://blogs.msdn.com/danielfe/

    Saturday, November 12, 2005 1:46 AM
  • Yes you can use oracle, but you will have to code the connections manually as non of the wizards will be able to connect to the system. One way is to create yourself a data layer for the application and expose your data sources as objects, then you will be able to bind to the objects. For an example of the have a look at the Personal Web Site starter kit as this package uses a simple data layer to connect to its database engine and exposes the objects to the rest off the application. Yes, I know that the PWS uses a sql express back end but as the only reference to it inside the database layer is the connection string and the other objects are just general db code it should be easy to change.

    If you are planing on using the Oracle system for web design and are needing to use the membership and profile system, you will have to learn to use custom providers. With these you will be able to connect to any database back end.

    Custom Providers
    ----------------
    Here is a direct Link to the custom providers page on MSDN
    http://msdn.microsoft.com/asp.net/downloads/providers/
    From here you are able to download an example Access provider,
    With this you can use access for your membership databases.
    ( as well as other providers )

    MySQL Membership Providers
    http://www.codeproject.com/aspnet/MySQLMembershipProvider.asp

    Information on Membership Providers and SQL 2000
    ------------------------------------------------
    http://forums.asp.net/1115801/ShowPost.aspx
    http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005
    Saturday, November 26, 2005 1:46 AM

All replies

  • You're in the correct menu, the issue is that this feature is not enabled for Visual Basic, C#, C++, or J# Express as these products can only support connecting to local data sources. It is, however, enabled in Visual Web Developer Express and Visual Studio Standard Edition or higher.

    Thanks,
    Dan Fernandez
    Product Manager
    http://blogs.msdn.com/danielfe/

    Saturday, November 12, 2005 1:46 AM
  • Does this mean that there is no way to use Oracle with the Express editions?  Or is there some other way to access Oracle data?
    Friday, November 25, 2005 6:12 AM
  • Yes you can use oracle, but you will have to code the connections manually as non of the wizards will be able to connect to the system. One way is to create yourself a data layer for the application and expose your data sources as objects, then you will be able to bind to the objects. For an example of the have a look at the Personal Web Site starter kit as this package uses a simple data layer to connect to its database engine and exposes the objects to the rest off the application. Yes, I know that the PWS uses a sql express back end but as the only reference to it inside the database layer is the connection string and the other objects are just general db code it should be easy to change.

    If you are planing on using the Oracle system for web design and are needing to use the membership and profile system, you will have to learn to use custom providers. With these you will be able to connect to any database back end.

    Custom Providers
    ----------------
    Here is a direct Link to the custom providers page on MSDN
    http://msdn.microsoft.com/asp.net/downloads/providers/
    From here you are able to download an example Access provider,
    With this you can use access for your membership databases.
    ( as well as other providers )

    MySQL Membership Providers
    http://www.codeproject.com/aspnet/MySQLMembershipProvider.asp

    Information on Membership Providers and SQL 2000
    ------------------------------------------------
    http://forums.asp.net/1115801/ShowPost.aspx
    http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005
    Saturday, November 26, 2005 1:46 AM
  • Thanks, Glenn, for the quick and helpful response.  This was my first post on this forum, so it's good to know help is available here.  I'm new to the .net environment, but I've been using Oracle for 18 years now.  I already started using the manual approach after I sent my post.  I found the following link on the Oracle site which was helpful to me and I'm including it here in case it might be helpful to others in the forum:

    http://www.oracle.com/technology/pub/articles/cook_dotnet.html
    Saturday, November 26, 2005 4:46 AM
  • Steve,

    Did you manage ending up getting an Oracle connection from the C# Express Edition? If you did, I'd be really interested in getting some help. I'm not an advanced programmer at all and am pretty stuck getting a connection.

    Many thanks,

    Aj
    Saturday, December 3, 2005 12:09 PM
  • Aj;

    After many attempts that didn't work, I was finally able to get an example that did work.  I downloaded the sample code referenced in the link I gave in my last post.  I wasn't able to just open it and run it.  Instead, I had to create a new Windows project and copy the contents into the program.cs file (in both cases, everything after the namespace line was copied from the example and replaced the same in the program.cs file).

    I then deleted the file form1.cs and was able to get it to execute.  This probably wasn't the cleanest way to do it, but it worked.  I still had to change the oradb definition so it matched one of the TCP entries in my tnsnames.ora file.  When I tried to use the short form for the connection string, it wouldn't work (I think it can't find my tnsnames.ora file).  Finally, I had to add a Reference to Oracle.DataAccess under the Solution Explorer.

    Let me know if this works for you.  If not, let me know more about the environment you're working in and I'll try to help out.

    Steve
    Monday, December 5, 2005 9:32 PM