Error:Type 'adoconnection' is not defined

[Kunchesm]

iam getting Compiler Error Message: BC30002: Type 'adoconnection' is not defined at line 6..

------------------------------------
1. <%@ Page Language="vb" %>
2. <%@ import Namespace="system.data" %>
3. <%@ import Namespace="system.data.ado" %>
4. <script runat="server">
5.
6. dim cnn as adoconnection
7. dim cmd as adodatasetcommand
8. dim ds as new dataset
....
....
------------------------------------
can anyone pl help me!..

ThanX in advance

[Patoooey]

Your trying to mix old ASP code with new ASP.NET.

Check out ASP.Net for tutorials.

John

[Kunchesm]

then can u give me an example for using ADO recordsets in ASP.NET?? ...


thanX in advance

[Cander]

actually that code is dirt old..like beta 1 code.

there are tutorials at the link he gave you.

[Kunchesm]

i hav checked that link already.. but it consists of example with SQL server database .. and i wanted connection to Oracle databse... any other good web sites for that??

[Negative0]

You can use an OLEDB.OleDBConnection.

Here is a great site for all of your connection needs:

http://www.able-consulting.com/ado_conn.htm

Hope this helps,