Ashish Panwar Posted May 8, 2011 Share Posted May 8, 2011 Hello , im a ASP.NET (C#) user. I use MS-SQL Express for maintain database for website. But i think in your domain you not provide MS-SQL service. there are two types of databse in you CPANEL "MySQL" & "Postgre SQL". i want to know that what i have to use as an Alternate of MS-SQL SERVER?? which is compatible with ASP.NET(3.5) Thankx Link to comment Share on other sites More sharing options...
Krydos Posted May 8, 2011 Share Posted May 8, 2011 im a ASP.NET (C#) user. I use MS-SQL Express for maintain database for website. But i think in your domain you not provide MS-SQL service. there are two types of databse in you CPANEL "MySQL" & "Postgre SQL". i want to know that what i have to use as an Alternate of MS-SQL SERVER?? which is compatible with ASP.NET(3.5) I've used MySQL quite a bit and I like it. Perhaps this link might help you? Link to comment Share on other sites More sharing options...
jje Posted May 8, 2011 Share Posted May 8, 2011 According to the recent survey, 31 prefer MySQL and 3 prefer PostgreSQL. Link to comment Share on other sites More sharing options...
Ashish Panwar Posted May 8, 2011 Author Share Posted May 8, 2011 According to the recent survey, 31 prefer MySQL and 3 prefer PostgreSQL. I just try the MySQL... i think this is same as MSSQL just little bit of keywords change. but dont know how to connect with ASP.NET Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 8, 2011 Share Posted May 8, 2011 See http://www.mono-project.com/MySQL Link to comment Share on other sites More sharing options...
MardukCorp Posted May 8, 2011 Share Posted May 8, 2011 Which MySQL .NET Connector version is at the moment compatible with Johnny? Maybe it can solve my problem posted here also: http://www.helionet.org/index/index.php?showtopic=9241 Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 8, 2011 Share Posted May 8, 2011 It's already installed. You should be able to import it with: using MySql.Data.MySqlClient; Link to comment Share on other sites More sharing options...
MardukCorp Posted May 8, 2011 Share Posted May 8, 2011 I must import it in my website project in VS2010 to test my site. Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 8, 2011 Share Posted May 8, 2011 Please see http://dev.mysql.com/doc/refman/5.0/es/con...on-windows.html Link to comment Share on other sites More sharing options...
MardukCorp Posted May 8, 2011 Share Posted May 8, 2011 Sorry for asking again, but the version on Johnny is 5.0? And where would I see this when its updated? And a little sidequestion: When I try to debug my website on Johnny in VS2010, it gives me an error that VS can't debug because the debugger can't connect to the remote-PC. Any tips for me? Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 8, 2011 Share Posted May 8, 2011 Sorry for asking again, but the version on Johnny is 5.0? It should be the latest version; I know our MySQL version is 5.0. And a little sidequestion: When I try to debug my website on Johnny in VS2010, it gives me an error that VS can't debug because the debugger can't connect to the remote-PC. Any tips for me? You need to debug locally. This setup is for a developer team that has the money for a spare dedicated server. Link to comment Share on other sites More sharing options...
MardukCorp Posted May 8, 2011 Share Posted May 8, 2011 Ok, thanks for the fast reply! Link to comment Share on other sites More sharing options...
MardukCorp Posted May 13, 2011 Share Posted May 13, 2011 So, asp is running again but now I'm back with my MySql error: Compilation Error Description: Error compiling a resource required to service this request. Review your source file and modify it to fix this error. Compiler Error Message: CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference? gmcs /target:library /lib:"/home/nerias/public_html/bin" /debug+ /optimize- /warn:4 /out:"/tmp/nobody-temp-aspnet-0/bceabcb3/App_Code.4b28eec.dll" /r:"/opt/mono/lib/mono/gac/System/2.0.0.0__b77a5c561934e089/System.dll" /r:"/opt/mono/lib/mono/gac/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll" /r:"/opt/mono/lib/mono/gac/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll" /r:"/opt/mono/lib/mono/gac/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll" /r:"/opt/mono/lib/mono/gac/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll" /r:"/opt/mono/lib/mono/gac/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll" /r:"/opt/mono/lib/mono/gac/System.Runtime.Serialization/3.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll" /r:"/opt/mono/lib/mono/gac/System.IdentityModel/3.0.0.0__b77a5c561934e089/System.IdentityModel.dll" /r:"/opt/mono/lib/mono/gac/System.ServiceModel/3.0.0.0__b77a5c561934e089/System.ServiceModel.dll" /r:"/opt/mono/lib/mono/gac/System.ServiceModel.Web/3.5.0.0__31bf3856ad364e35/System.ServiceModel.Web.dll" /r:"/opt/mono/lib/mono/gac/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll" /r:"/opt/mono/lib/mono/gac/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll" /r:"/opt/mono/lib/mono/gac/System.Web.Extensions/3.5.0.0__31bf3856ad364e35/System.Web.Extensions.dll" /r:"/opt/mono/lib/mono/gac/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll" /r:"/opt/mono/lib/mono/gac/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll" /r:"/opt/mono/lib/mono/gac/Microsoft.Build.Framework/3.5.0.0__b03f5f7f11d50a3a/Microsoft.Build.Framework.dll" /r:"/opt/mono/lib/mono/gac/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll" /r:"/opt/mono/lib/mono/gac/System/2.0.0.0__b77a5c561934e089/System.dll" /r:"/opt/mono/lib/mono/gac/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll" /r:"/opt/mono/lib/mono/gac/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll" /r:"/opt/mono/lib/mono/gac/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll" /r:"/opt/mono/lib/mono/gac/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll" /r:"/opt/mono/lib/mono/gac/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll" /r:"/opt/mono/lib/mono/gac/System.Runtime.Serialization/3.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll" /r:"/opt/mono/lib/mono/gac/System.IdentityModel/3.0.0.0__b77a5c561934e089/System.IdentityModel.dll" /r:"/opt/mono/lib/mono/gac/System.ServiceModel/3.0.0.0__b77a5c561934e089/System.ServiceModel.dll" /r:"/opt/mono/lib/mono/gac/System.ServiceModel.Web/3.5.0.0__31bf3856ad364e35/System.ServiceModel.Web.dll" /r:"/opt/mono/lib/mono/gac/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll" /r:"/opt/mono/lib/mono/gac/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll" /r:"/opt/mono/lib/mono/gac/System.Web.Extensions/3.5.0.0__31bf3856ad364e35/System.Web.Extensions.dll" /r:"/opt/mono/lib/mono/gac/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll" /r:"/opt/mono/lib/mono/gac/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll" /r:"/opt/mono/lib/mono/gac/Microsoft.Build.Framework/3.5.0.0__b03f5f7f11d50a3a/Microsoft.Build.Framework.dll" /r:"/opt/mono/lib/mono/gac/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll" /d:DEBUG -- "/tmp/nobody-temp-aspnet-0/bceabcb3/App_Web_79d000ca_0.cs" /home/nerias/public_html/App_Code/DbConnection.cs(5,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference? /home/nerias/public_html/App_Code/DbConnection.cs(11,5): error CS0246: The type or namespace name `MySqlCommand' could not be found. Are you missing a using directive or an assembly reference? /home/nerias/public_html/App_Code/DbConnection.cs(22,30): error CS0246: The type or namespace name `MySqlDataReader' could not be found. Are you missing a using directive or an assembly reference? /home/nerias/public_html/App_Code/DbConnection.cs(5,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference? Anyone an idea? Link to comment Share on other sites More sharing options...
jje Posted May 13, 2011 Share Posted May 13, 2011 Is your app written in ASP.NET 3.5 or below? We don't support any higher version Link to comment Share on other sites More sharing options...
MardukCorp Posted May 13, 2011 Share Posted May 13, 2011 Ah, sorry for that. My site is written in 3.5. Link to comment Share on other sites More sharing options...
Recommended Posts