Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_beginners thread: Namespace or type 'Odbc' for the Imports 'Microsoft.Data.Odbc' cannot be found


Message #1 by "Datatal AB - Gauffin, Jonas" <Jonas@d...> on Thu, 25 Apr 2002 14:10:21 +0200
Why do I get "BC30466: Namespace or type 'Odbc' for the Imports 
'Microsoft.Data.Odbc' cannot be found." when I try to run my codebehind 
project. I've added a reference to microsoft.odbc.net in my asp.net 
project (by using the references tree in solutions explorer)

aspx page:
<%@ Page Language=3D"vb" Codebehind=3D"WebForm1.aspx.vb" 
Inherits=3D"WebForm1" Src=3D"WebForm1.aspx.vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
		<title>WebForm1</title>
		<meta name=3D"GENERATOR" content=3D"Microsoft Visual Studio.NET 7.0">
		<meta name=3D"CODE_LANGUAGE" content=3D"Visual Basic 7.0">
		<meta name=3D"vs_defaultClientScript" content=3D"JavaScript">
		<meta name=3D"vs_targetSchema" 
content=3D"http://schemas.microsoft.com/intellisense/ie5">
	</head>
	<body>
	 <form action=3D"WebForm1.aspx" method=3D"post" runat=3D"server" 
ID=3D"Form1">

		<asp:DataGrid ID=3D"cases">
			<Columns>
				<asp:BoundColumn DataField=3D"name"></asp:BoundColumn>
				<asp:BoundColumn DataField=3D"caseid"></asp:BoundColumn>
			</Columns>
		</asp:DataGrid>
	</form>
	</body>
</html>

.vb page:
Imports Microsoft.Data.Odbc
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls

Public Class WebForm1
    Inherits System.Web.UI.Page

    Protected cases As System.Web.UI.WebControls.DataGrid

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub 
InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As 
System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As 
System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim cmd As OdbcCommand
        Dim sql As String =3D "SELECT name,caseid FROM case_info"
        Dim conStr As String =3D 
"driver=3D{MySQL};server=3Dsql3;uid=3Droot;database=3Dsupport3;OPTION=3D1
7923"

        Dim da As OdbcDataAdapter =3D New OdbcDataAdapter(sql, conStr)
        Dim ds As New DataSet()

        da.Fill(ds, "case_info")
        'dim bldr as

        Dim dt As DataTable =3D ds.Tables(0)

        cases.DataSource =3D dt
        cases.databind()


    End Sub

End Class
Message #2 by "John Hamman {Hamman Interactive}" <johnhamman@C...> on Thu, 25 Apr 2002 09:43:00 -0400
did you import the reference in the bin?
and rebuild.
john

-----Original Message-----
From: Datatal AB - Gauffin, Jonas [mailto:Jonas@d...]
Sent: Thursday, April 25, 2002 8:10 AM
To: aspx_beginners
Subject: [aspx_beginners] Namespace or type 'Odbc' for the Imports
'Microsoft.Data.Odbc' cannot be found


Why do I get "BC30466: Namespace or type 'Odbc' for the Imports
'Microsoft.Data.Odbc' cannot be found." when I try to run my codebehind
project. I've added a reference to microsoft.odbc.net in my asp.net project
(by using the references tree in solutions explorer)

aspx page:
<%@ Page Language="vb" Codebehind="WebForm1.aspx.vb" Inherits="WebForm1"
Src="WebForm1.aspx.vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
		<title>WebForm1</title>
		<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
		<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
		<meta name="vs_defaultClientScript" content="JavaScript">
		<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
	</head>
	<body>
	 <form action="WebForm1.aspx" method="post" runat="server" ID="Form1">

		<asp:DataGrid ID="cases">
			<Columns>
				<asp:BoundColumn DataField="name"></asp:BoundColumn>
				<asp:BoundColumn DataField="caseid"></asp:BoundColumn>
			</Columns>
		</asp:DataGrid>
	</form>
	</body>
</html>

.vb page:
Imports Microsoft.Data.Odbc
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls

Public Class WebForm1
    Inherits System.Web.UI.Page

    Protected cases As System.Web.UI.WebControls.DataGrid

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim cmd As OdbcCommand
        Dim sql As String = "SELECT name,caseid FROM case_info"
        Dim conStr As String 
"driver={MySQL};server=sql3;uid=root;database=support3;OPTION=17923"

        Dim da As OdbcDataAdapter = New OdbcDataAdapter(sql, conStr)
        Dim ds As New DataSet()

        da.Fill(ds, "case_info")
        'dim bldr as

        Dim dt As DataTable = ds.Tables(0)

        cases.DataSource = dt
        cases.databind()


    End Sub

End Class



  Return to Index