Ashish Panwar Posted May 8, 2011 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
Krydos Posted May 8, 2011 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?
jje Posted May 8, 2011 Posted May 8, 2011 According to the recent survey, 31 prefer MySQL and 3 prefer PostgreSQL.
Ashish Panwar Posted May 8, 2011 Author 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
MardukCorp Posted May 8, 2011 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
Guest Geoff Posted May 8, 2011 Posted May 8, 2011 It's already installed. You should be able to import it with: using MySql.Data.MySqlClient;
MardukCorp Posted May 8, 2011 Posted May 8, 2011 I must import it in my website project in VS2010 to test my site.
Guest Geoff Posted May 8, 2011 Posted May 8, 2011 Please see http://dev.mysql.com/doc/refman/5.0/es/con...on-windows.html
MardukCorp Posted May 8, 2011 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?
Guest Geoff Posted May 8, 2011 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.
MardukCorp Posted May 13, 2011 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?
jje Posted May 13, 2011 Posted May 13, 2011 Is your app written in ASP.NET 3.5 or below? We don't support any higher version
Recommended Posts