asp to asp.net conversion issues

[John]

Hi

I am trying to convert my asp app tp asp.net and I have a few issues;

1. I have the following code for a db connection;

onn = New ADODB.Connection
conn.Open("PROVIDER=SQLOLEDB;DATA
SOURCE=mysqlserver;UID=username;PWD=password;DATAB ASE=mydb")

I am getting a 'ADODB.Connection' is not defined.' error on the first line.
What is the fix for this?

2. I have a lot of Name xxxx is not declared. Do I need to define all these
variable?

Thanks

Regards

[Mark Rae]

"John" <Jo**@nospam.infovis.co.ukwrote in message
news:u$**************@TK2MSFTNGP05.phx.gbl...

I am trying to convert my asp app tp asp.net and I have a few issues;

1. I have the following code for a db connection;

onn = New ADODB.Connection
conn.Open("PROVIDER=SQLOLEDB;DATA
SOURCE=mysqlserver;UID=username;PWD=password;DATAB ASE=mydb")

I am getting a 'ADODB.Connection' is not defined.' error on the first
line. What is the fix for this?

The fix for this is to use ADO.NET, not ADO.
http://www.google.co.uk/search?hl=en...tutorial&meta=

2. I have a lot of Name xxxx is not declared. Do I need to define all
these variable?

You certainly do! Ain't no VBScript no more...!

I'd suggest you get yourself a copy of this:
http://www.amazon.com/ASP-NET-Everyd...e=UTF8&s=books

And read it from beginning to end before you do anything else...

[Juan T. Llibre]

Start here :
http://msdn.microsoft.com/asp.net/mi...t/default.aspx

Also, watch this video :
http://msdn.microsoft.com/msdntv/epi...s/manifest.xml


Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"John" <Jo**@nospam.infovis.co.ukwrote in message news:u$**************@TK2MSFTNGP05.phx.gbl...

Hi

I am trying to convert my asp app tp asp.net and I have a few issues;

1. I have the following code for a db connection;

onn = New ADODB.Connection
conn.Open("PROVIDER=SQLOLEDB;DATA SOURCE=mysqlserver;UID=username;PWD=password;DATAB ASE=mydb")

I am getting a 'ADODB.Connection' is not defined.' error on the first line. What is the fix for
this?

2. I have a lot of Name xxxx is not declared. Do I need to define all these variable?

Thanks

Regards

[Jason Kester]

John wrote:

I am trying to convert my asp app tp asp.net and I have a few issues;

First off, if you have not yet done so, track down a copy of ReSharper.
I couldn't imagine trying to port from ASP to ASP.NET without it.

>
1. I have the following code for a db connection;

I am getting a 'ADODB.Connection' is not defined.' error on the first line.
What is the fix for this?

You have two options. The simple way to get your app up and running
(that will cripple you down the road) is to add a reference to the old
ADO library. In the project, under References, add a new reference and
dig around in the COM tab.

The real solution however, is to port your database stuff over to
ADO.NET. It's really not that hard (assuming you have ReSharper to
track down and fix your broken references. otherwise, next to
impossible), and will allow you to take advantage of all the cool
features for which you're porting to .NET in the first place.

>
2. I have a lot of Name xxxx is not declared. Do I need to define all these
variable?

Yes.
Good luck!

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

---
Get your own Travel Blog, with itinerary maps and photos!
http://www.blogabond.com/

[Mark Rae]

"Jason Kester" <ja*********@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

The real solution however, is to port your database stuff over to
ADO.NET. It's really not that hard (assuming you have ReSharper to
track down and fix your broken references. otherwise, next to
impossible)

???

Porting from ADO to ADO.NET without ReSharper is next to impossible...???

What utter, utter nonsense!!

IMO, ADO.NET is one of the least complex areas of the entire .NET Framework.

[Jason Kester]

Mark Rae wrote:

Porting from ADO to ADO.NET without ReSharper is next to impossible...???

No. ASP, not ADO. Porting ASP to ASP.NET without ReSharper is
thoroughly no fun. In fact, C# development in general goes a lot
faster if you have the right tools. That's why I told the guy to make
sure his development environment was up to speed before tackling a
port.

But yeah, ADO.NET is nothing special. If you remove the ADODB from the
front of everything, it's essentially a matter of hitting alt+enter a
bunch of times while ReSharper hands you the correct library
references.

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/
---
Get your own Travel Blog, with itinerary maps and photos!
http://www.blogabond.com/