asp to asp.net conversion issues

10 Sep 2006 4:29 PM

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;DATABASE=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

10 Sep 2006 4:49 PM

Mark Rae

"John" <John@nospam.infovis.co.uk> wrote in message
news:u$HHeZP1GHA.2036@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;DATABASE=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&rls=GGLG%2CGGLG%3A2006-28%2CGGLG%3Aen&q=%22ADO.NET%22+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-Everyday-Apps-Dummies-Computer/dp/0764597760/sr=8-1/qid=1157906894/ref=pd_bbs_1/104-5740038-0751132?ie=UTF8&s=books

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

10 Sep 2006 8:20 PM

Juan T. Llibre

Start here :
http://msdn.microsoft.com/asp.net/migration/aspmig/aspmigasst/default.aspx

Also, watch this video :
http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050310aspnetss/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/
===================================
Show quoteHide quote

"John" <John@nospam.infovis.co.uk> wrote in message news:u$HHeZP1GHA.2036@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;DATABASE=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
>
>
>
>
>
>