|
 |
aspx thread: Free ASP.net ?? ASP.net and ODBC??
Message #1 by "Yu, Kevin" <kyu@N...> on Tue, 2 Oct 2001 13:50:45 -0400
|
|
hi. I download the ODBC.net for asp.net. but i got problem including the
odbc namespace.
it said :
error BC30466: The Namespace or type 'ODBC' for the Import
'System.Data.ODBC' cannot be found.
how can I fix the problem. by the way, is asp.net a stand along server or it
need
.net frame to run and asp.net is free, is that true?
Message #2 by Scott Watermasysk <swatermasysk@C...> on Tue, 2 Oct 2001 14:07:16 -0400
|
|
No such namespace exists. If you found this in a book or another resource
then it is likely a beta one source. Beta two: System.Data.OleDb
-Scott
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Tuesday, October 02, 2001 1:51 PM
To: ASP+
Subject: [aspx] Free ASP.net ?? ASP.net and ODBC??
hi. I download the ODBC.net for asp.net. but i got problem including the
odbc namespace.
it said :
error BC30466: The Namespace or type 'ODBC' for the Import
'System.Data.ODBC' cannot be found.
how can I fix the problem. by the way, is asp.net a stand along server or it
need
.net frame to run and asp.net is free, is that true?
Message #3 by Tim Heuer <TimH@i...> on Tue, 2 Oct 2001 11:21:32 -0700
|
|
Regarding if ASP.NET can stand alone...
If you downloaded ASP.NET Premium Edition you have the necessary framework
to get everything working with one exception. The one thing not included in
the download is MDAC 2.7 which you will need if you do data interaction.
Aside from that, however it will run (as it includes the framework).
Regarding the second question, did you add a reference as well as importing
the namespace?
Tim
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Tuesday, October 02, 2001 10:51 AM
To: ASP+
Subject: [aspx] Free ASP.net ?? ASP.net and ODBC??
hi. I download the ODBC.net for asp.net. but i got problem including the
odbc namespace. it said : error BC30466: The Namespace or type 'ODBC' for
the Import 'System.Data.ODBC' cannot be found.
how can I fix the problem. by the way, is asp.net a stand along server or it
need .net frame to run and asp.net is free, is that true?
Message #4 by Todd Carrico <ToddC@m...> on Tue, 2 Oct 2001 13:45:55 -0500
|
|
The ODBC is a separate download
Tc
From my personal Archive:
[Juan T. Llibre]
As you may or may not know, odbc.NET was released yesterday.
http://www.microsoft.com/downloads/release.asp?ReleaseID=31125
Be aware that "out of the box" installation will not work
unless you reference the assembly name, over and above
referencing the namespace.
i.e.,
<%@ Import Namespace="System.Data.Odbc" %>
does NOT work by itself.
You also need to reference the assembly's name :
<%@ Import Namespace="System.Data.Odbc" %>
<%@ Assembly Name = "System.Data.Odbc" %>
Adding the following to the <compilation> <assemblies> section of
machine.config,
will allow odbc.NET to work without an assembly name reference :
<add assembly="System.Data.Odbc, Version=1.0.2411.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"/>
I wish they'd included a line, in the documentation, which specified that
the assembly has to be referenced, over and above importing the namespace.
Then again,
the examples don't include the <%@ Import Namespace=" ..." %> line,
either...;>)
This is confusing, because all other System.* assemblies
only need for the namespace to be imported to work.
regards,
Juan T. Llibre
Microsoft MVP [IIS/ASP]
"Beginning ASP.NET", Wrox Press - Look for it in August!
-----Original Message-----
From: Scott Watermasysk [mailto:swatermasysk@C...]
Sent: Tuesday, October 02, 2001 1:07 PM
To: ASP+
Subject: [aspx] RE: Free ASP.net ?? ASP.net and ODBC??
No such namespace exists. If you found this in a book or another resource
then it is likely a beta one source. Beta two: System.Data.OleDb
-Scott
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Tuesday, October 02, 2001 1:51 PM
To: ASP+
Subject: [aspx] Free ASP.net ?? ASP.net and ODBC??
hi. I download the ODBC.net for asp.net. but i got problem including the
odbc namespace.
it said :
error BC30466: The Namespace or type 'ODBC' for the Import
'System.Data.ODBC' cannot be found.
how can I fix the problem. by the way, is asp.net a stand along server or it
need
.net frame to run and asp.net is free, is that true?
Message #5 by "Albert Davis" <albertdavis@h...> on Tue, 02 Oct 2001 14:46:17 -0400
|
|
Well Scott in fact this namespace does exist as an add-on namespace. This
is found @ (watch for broken links)
http://www.msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-FILES/027/001/668/msdncompositedoc.xml&f
rame=true
Kevin you need to follow the instructions for adding this namespace to the
Global Assembly Cache by using the Gacutil.exe tool which is provided within
the .NET Framework SDK Beta 2... If you click on the link provide above
Microsoft gives all of the necessary instructions to install and use the
ODBC namespace with Beta2. Also to run ASP.NET you need to have at least
the server components on the server you wish to run ASP.NET...
Hope this helps,
Al
>From: Scott Watermasysk <swatermasysk@C...>
>Reply-To: "ASP+" <aspx@p...>
>To: "ASP+" <aspx@p...>
>Subject: [aspx] RE: Free ASP.net ?? ASP.net and ODBC??
>Date: Tue, 2 Oct 2001 14:07:16 -0400
>
>No such namespace exists. If you found this in a book or another resource
>then it is likely a beta one source. Beta two: System.Data.OleDb
>
>-Scott
>
>-----Original Message-----
>From: Yu, Kevin [mailto:kyu@N...]
>Sent: Tuesday, October 02, 2001 1:51 PM
>To: ASP+
>Subject: [aspx] Free ASP.net ?? ASP.net and ODBC??
>
>
>hi. I download the ODBC.net for asp.net. but i got problem including the
>odbc namespace.
>it said :
>error BC30466: The Namespace or type 'ODBC' for the Import
>'System.Data.ODBC' cannot be found.
>how can I fix the problem. by the way, is asp.net a stand along server or
>it
>need
>.net frame to run and asp.net is free, is that true?
>
>
>
Message #6 by "Yu, Kevin" <kyu@N...> on Tue, 2 Oct 2001 15:55:47 -0400
|
|
I have setup the ODBC.net and try it out.
the code is:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import namespace="System.Data.Odbc" %>
<%@ Assembly Name = "System.Data.Odbc" %>
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
<html>
<head>
<link rel="stylesheet"href="intro.css">
</head>
<script language="VB" runat=server>
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As odbcConnection
Dim MyCommand As odbcDataAdapter
MyConnection = New odbcConnection("Provider=ODBC.NET Data
Provider;DSN=wrc")
MyCommand = New odbcDataAdapter("select * from employees",
myConnection)
DS = new DataSet()
MyCommand.Fill(DS, "empid")
MyList.DataSource = DS.Tables("empid").DefaultView
MyList.DataBind()
End Sub
</script>
<body>
<center>
<form action="timesheet.aspx" method="post" runat="server">
<asp:button text="Lookup" OnClick="SubmitBtn_Click"
runat="server"/>
<p>
<ASP:DataGrid id="MyList" HeaderStyle-BackColor="#aaaadd"
BackColor="#ccccff" runat="server"/>
</form>
</center>
</body>
</html>
now I got this error message:
ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon
denied ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null
password given; logon denied
it seems that the password didn't get pass to the logon interface. how can I
fix that problem.
by the way, is the "server components on the server" you are talking about
IIS and asp.net?
I also have .net frame sdk setup. I don't know if that is necessary. thanks
for your tip.
-----Original Message-----
From: Albert Davis [mailto:albertdavis@h...]
Sent: Tuesday, October 02, 2001 12:46 PM
To: ASP+
Subject: [aspx] RE: Free ASP.net ?? ASP.net and ODBC??
Well Scott in fact this namespace does exist as an add-on namespace. This
is found @ (watch for broken links)
http://www.msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.as
p?url=/MSDN-FILES/027/001/668/msdncompositedoc.xml&frame=true
Kevin you need to follow the instructions for adding this namespace to the
Global Assembly Cache by using the Gacutil.exe tool which is provided within
the .NET Framework SDK Beta 2... If you click on the link provide above
Microsoft gives all of the necessary instructions to install and use the
ODBC namespace with Beta2. Also to run ASP.NET you need to have at least
the server components on the server you wish to run ASP.NET...
Hope this helps,
Al
Message #7 by "Yu, Kevin" <kyu@N...> on Tue, 2 Oct 2001 16:04:23 -0400
|
|
thanks for the tip. i download MDAC 2.7 and it seems to work fine.
so ASP.NET is Free. cheers!!
I have found out what I did wrong for the namespace part from MS .net
newgroup. but now I got new problem, maybe I got my connection string wrong.
the password didn't get passed properly to the oracle DSN in ODBC, my
connection
string is
Dim MyConnection As odbcConnection
Dim MyCommand As odbcDataAdapter
MyConnection = New odbcConnection("Provider=ODBC.NET Data Provider;DSN=wrc")
MyCommand = New odbcDataAdapter("select * from employees", myConnection)
i got this error message:
ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon
denied ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null
password given; logon denied
any idea how I can fix it?
-----Original Message-----
From: Tim Heuer [mailto:TimH@i...]
Sent: Tuesday, October 02, 2001 12:22 PM
To: ASP+
Subject: [aspx] RE: Free ASP.net ?? ASP.net and ODBC??
Regarding if ASP.NET can stand alone...
If you downloaded ASP.NET Premium Edition you have the necessary framework
to get everything working with one exception. The one thing not included in
the download is MDAC 2.7 which you will need if you do data interaction.
Aside from that, however it will run (as it includes the framework).
Regarding the second question, did you add a reference as well as importing
the namespace?
Tim
Message #8 by Todd Carrico <ToddC@m...> on Tue, 2 Oct 2001 16:11:14 -0500
|
|
I think you still need to pass a username and Password.
Try replacing them in this string:
MyConnection = New odbcConnection("Provider=ODBC.NET Data
Provider;DSN=wrc;User ID=<UserName>;Password=<password>")
Hth
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Tuesday, October 02, 2001 3:04 PM
To: ASP+
Subject: [aspx] RE: Free ASP.net ?? ASP.net and ODBC ??
thanks for the tip. i download MDAC 2.7 and it seems to work fine.
so ASP.NET is Free. cheers!!
I have found out what I did wrong for the namespace part from MS .net
newgroup. but now I got new problem, maybe I got my connection string wrong.
the password didn't get passed properly to the oracle DSN in ODBC, my
connection
string is
Dim MyConnection As odbcConnection
Dim MyCommand As odbcDataAdapter
MyConnection = New odbcConnection("Provider=ODBC.NET Data Provider;DSN=wrc")
MyCommand = New odbcDataAdapter("select * from employees", myConnection)
i got this error message:
ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon
denied ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null
password given; logon denied
any idea how I can fix it?
-----Original Message-----
From: Tim Heuer [mailto:TimH@i...]
Sent: Tuesday, October 02, 2001 12:22 PM
To: ASP+
Subject: [aspx] RE: Free ASP.net ?? ASP.net and ODBC??
Regarding if ASP.NET can stand alone...
If you downloaded ASP.NET Premium Edition you have the necessary framework
to get everything working with one exception. The one thing not included in
the download is MDAC 2.7 which you will need if you do data interaction.
Aside from that, however it will run (as it includes the framework).
Regarding the second question, did you add a reference as well as importing
the namespace?
Tim
|
|
|
View Cart
