locked
VS 2012 Express support database RRS feed

  • Question

  • Does VS 2012 Express support to connect MySQL or other Database?

    I tried to connect a database connection and realized that the only option is to link SQL Server.

    It looks like express version only can connect MS SQL Server.

    My question would be does Prefession verison can connect MySQL or other database?

    Does Preofessional version have report function?

    Your help and information is great appreciated,

    Sourises,

    Sunday, September 30, 2012 4:45 PM

Answers

  • The Professional Edition of VS 2012 includes MS Reporting.

    As far as Crystal Reports for VS 2012 is concerned, SAP appears to be dragging their feet (as usual):

    http://scn.sap.com/thread/3185805

    Riced answered your other question.

    • Marked as answer by sourises Sunday, September 30, 2012 8:38 PM
    Sunday, September 30, 2012 8:28 PM

All replies

  • You can certainly connect to dbs other than SQL Server. Try looking at OleDB functions. Or google for MySQL VB.Net - that will give you plenty to look at.

    Regards David R
    ---------------------------------------------------------------
    The great thing about Object Oriented code is that it can make small, simple problems look like large, complex ones.
    Object-oriented programming offers a sustainable way to write spaghetti code. - Paul Graham.
    Every program eventually becomes rococo, and then rubble. - Alan Perlis
    The only valid measurement of code quality: WTFs/minute.

    • Proposed as answer by pvdg42 Sunday, September 30, 2012 8:28 PM
    Sunday, September 30, 2012 4:54 PM
  • The Professional Edition of VS 2012 includes MS Reporting.

    As far as Crystal Reports for VS 2012 is concerned, SAP appears to be dragging their feet (as usual):

    http://scn.sap.com/thread/3185805

    Riced answered your other question.

    • Marked as answer by sourises Sunday, September 30, 2012 8:38 PM
    Sunday, September 30, 2012 8:28 PM
  • You absolutely can connect to MySQL using Oracle's own MySQL Connector/NET using the Express editions of Visual Studio.

    The limitation, however, is that you can't use the tools in the designer as, like you've noticed, only Microsoft's own connectors are available. However, if you do your database connectivity in code (just add the MySql.Data.MySqlClient namespace then the MySQL ADO.NET datatypes will become available to you) then it'll work fine.



    • Edited by ResidentSD Tuesday, October 9, 2012 1:04 PM Correct typo
    Thursday, October 4, 2012 7:51 AM
  • Thanks again for the message,

    Once I import MySql.Data.MySqlclient namespace, I can use designer to access MySQL or I need write code to connect MySQL.

    Thanks again for help,

    Sorrises,

    Tuesday, October 9, 2012 4:34 PM