Se connecter
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique >
> 
> 
No database connection possible for Visual Web Developer ???

Unanswered No database connection possible for Visual Web Developer ???

  • jeudi 14 juin 2012 09:08
     
     
    Connectez-vous pour voter
    0

    GD All,

    So here I am, having used Wavemaker & MySQL for some nice apps I am trying to make the jump to Visual Web Developer with any sort of database.

    Having been programming in VB for some time it seemed to be the appropriate solution...

    So using the Web Platform Installer, I installed the Visual Web Developer, which failed to install the SQL Server Express 2008 (unfortunately) but being not easily despared, I staggered on...:-)

    However:

    Visual Studio 2010 Express does not connect (directly) to a MySQL database, which has already a lot of data in it and for which I would like to re-write the application...:-)

    So onwards the quest, downloading MySQL connector from the MySQL website, to no avail....:-( As the MySQL connector does not work with the Express version of Visual Web Developer 2010...

    Onwards...
    So ok, I'll try making the jump to working with a SQL database, surely there must be a way to translate the data between the two database formats ?? Trying to download the 2008 version of SQL Server 2008 Express, mmm, most easily found solution seems to be SQL Server Express 2012...?? Alright, surely it must be backwards compatible...?

    After installing SQL Server Express 2012, and translating my MySQL database to SQL Server Express 2012 format, the flippin' Visual Web Developer 2010 DOES NOT WORK with 2012 as it supports only databases upto SQL Server 2008 !!!
    Alright, alright, stay calm, take another cup of coffee...

    Unistall SQL Server Express 2012 -and yes, trying to get all of it of is quite a challenge- but succeeded, so the quest for SQL Server Express 2008 begins, found it on the Microsoft website...yeah !!!
    So, download, install...

    WTF !!!??? a warning comes up that the software has known compatibility issues with my Windows version -being Win7 pro 64 bit- Fortunately it advises me to run the SQL Server Express SP1 patch after the install...wow, great !!
    But after starting the install...there is a critical error message which halts the installation process...!!!!

    So...here I am, I have Visual Web Developer 2010 that will not work with MySQL, but will work with SQL 2008, but SQL 2008 does not run on my system, being Win 7 Pro 64b, and SQL 2012 is not supported by VWD2010 ????

    Can anybody tell me how I can develop a webapplication while testing it in localhost envrionment using VWD-2010 with any -preferably MySQL- databases...???

    Helps is much appreciated...!!!

    Kindest regards

    Martijn (Jumbo)

     

Toutes les réponses

  • vendredi 15 juin 2012 08:24
    Modérateur
     
     
    Connectez-vous pour voter
    0

    Hi Martijn,

    I’m afraid that the VS 2010 is not compatible with SQL Server 2012 now.

    So, uninstall SQL Server Express 2012 and install SQL Server Express 2008 is a correct solution for your scenario.
    Could you post the error message you have received when you are installing the SQL Server 2008? I suspect that there is something wrong between uninstalling SQL 2012 and installing SQL 2008. SQL Server 2008 Express is supported on windows 7 server, we can confirm it in:
    http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspx#SSE_x64

    Please ensure that you have installed 64bit SQL Server, the download website is:
    http://www.microsoft.com/en-us/download/details.aspx?id=1695

    Post the error message is the key to solve the issue. Waiting for your response!

    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

     
  • lundi 18 juin 2012 06:20
     
     
    Connectez-vous pour voter
    0

    GD Iric,

    I had tried to install the SQLEXPRWT_x64_ENU file as I would need SQL tools as well. I thought this would be the 64bit option.

    I will try to install the 2008 version again and see if I get the same error message.

    From what I read last time it indicated that there was a known compatibility error with my windows version (WIN 7 Pro 64 bit)

    I'll see, thanks for your reply, I will let you know the result.

    brgds

    Martijn

     
  • mardi 26 juin 2012 02:28
    Modérateur
     
     
    Connectez-vous pour voter
    0
    Any progress Martijn?

    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.