news:6A**********************************@microsof t.com...
Hello, I have a code that I did in ASP and need to migrate to ASP.Net.OK, first things first: ASP.NET is *TOTALLY DIFFERENT* from ASP Classic. If
This
is my code in ASP 3.0:
you're just moving from ASP Classic to ASP.NET, the worst mistake you can
make is to imagine that ASP.NET is the "next version" of ASP Classic. It
isn't - not even close...
As a general rule, there is no point whatsoever in even trying to "migrate"
your ASP Classic code to ASP.NET because the two systems share almost no
common ground. Microsoft published a migration tool with the very first
release of ASP.NET back in 2002, but it was an unmitigated disaster...
The best advice I can give you is to use this learning process as an
opportunity to re-engineer your ASP Classic app from the ground up and don't
even try to migrate. I would suggest that you get a copy of this:
http://www.amazon.com/Beginning-ASP-...5020020&sr=8-1
and work your way through it from beginning to end. It will cover everything
you need to know.
set conn=server.CreateObject ("ADODB.connection")Presumably, that's not your real connection string? I.e. you haven't just
conn.Open ("Driver={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=proyectos;UID=ro ot;PWD=4116734")
published your database access credentials on a public forum...?
Also, what version of MySQL are you using? That will make a difference in
determining which connectivity method you use. If you're using version 5.x,
then you can take advantage of the native .NET data provider which means
that you don't need to use ODBC / OleDb:
http://dev.mysql.com/downloads/connector/net/5.2.html
--
Mark Rae
ASP.NET MVP
http://www.markrae.net