|
hi,
I had a c# windows application that connects to IBM DB2 using OleDb, and it works just fine. However, the same piece of code doesn't work in a c# web application and following is the error I got
"The 'IBMDADB2.1' provider is not registered on the local machine"
following is my code
System.Data.OleDb.OleDbCommand oCmd;
System.Data.Odbc.OdbcCommand oODBCCmd;
String sConnString="";
try
{
sConnString="Provider=IBMDADB2.1;Password=MYPASSWORD;Persist Security Info=True;User ID=db2admin;DSN=MYDSN;Location='';Extended Properties=''";
oCmd = new System.Data.OleDb.OleDbCommand();
oCmd.Connection = new System.Data.OleDb.OleDbConnection(sConnString);
oCmd.Connection.Open();
}
catch(Exception err){
String strErrorMsg = err.Message;
}
Please help!!! I did google the error but coudln't resolve the issue.
Thank you very much!!!!!!!!!
|
|
|
|
|
|
Hi, I read a tutorial about sending email from ASP.NET application using SMTP server .... I wrote the following;
SmtpMail.SmtpServer.Insert(0,"127.0.0.1");
SmtpMail.Send(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text);
In the text boxes i am providing appropriate values while when I execute this code, I receive the following error:
Server Error in '/EmailTestHere' Application.
--------------------------------------------------------------------------------
The "SendUsing" configuration value is invalid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: The "SendUsing" configuration value is invalid.
Source Error:
Line 56: SmtpMail.SmtpServer.Insert(0,"127.0.0.1");
Line 57:
Line 58: SmtpMail.Send(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text);
Line 59: }
Line 60: }
Source File: c:\inetpub\wwwroot\emailtesthere\webform1.aspx.cs Line: 58
Stack Trace:
[COMException (0x80040220): The "SendUsing" configuration value is invalid.
]
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters) +0
System.RuntimeType.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParameters) +473
System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args) +58
[HttpException (0x80004005): Could not access 'CDO.Message' object.]
System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args) +112
System.Web.Mail.CdoSysHelper.Send(MailMessage message) +1846
System.Web.Mail.CdoSysHelper.Send(String from, String to, String subject, String messageText) +74
System.Web.Mail.SmtpMail.Send(String from, String to, String subject, String messageText) +171
EmailTestHere.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\emailtesthere\webform1.aspx.cs:58
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
|
|
|
|
|
hi
can you provide your total code??
thanks,
Bhasker P
|
|
|
|
|
Hi, well thanx for your concern but that was my total code except the header files .... and I got it right using the following;
SmtpMail.SmtpServer = "localhost";
It is not working by using "127.0.0.1" for some reason!
Thanx a lot!
|
|
|
|
|
setting the smtpserver to localhost or 127.0.0.1 wont work for this.
you must have a configured SMTP server in your sysstem.
for us the SMTP server is "hlssrvdcmer008"
below is code for sending mail. check it.
System.Web.Mail.MailMessage msg = new System.Web.Mail.MailMessage();<br />
msg.Subject=Sub;<br />
msg.BodyFormat=System.Web.Mail.MailFormat.Text;<br />
msg.Body=bodyText;<br />
msg.To=mailTo;<br />
msg.From=mailFrom<br />
System.Web.Mail.SmtpMail.SmtpServer= "hlssrvdcmer008"<br />
System.Web.Mail.SmtpMail.Send(msg);
where variables Sub,bodyText, mailTo and mailFrom should be set with apprpriate values.
first of all find out your SMTP server name(if any);
hope this helps you
cheers
Ramesh.Kanjinghat
|
|
|
|
|
Hi,
I am using File Upload Control, and i want to place the file in APP_Code folder.
I have made the solution in InetPub-> WWWRoot.
But when i try to upload the file it gives a security error.
What i want is that anyone who wants to upload the file in this folder can upload the file regardless of the Rights he have.
I am using WIn 2k and iis5.
Thanks in Adv.
Deepak Surana
|
|
|
|
|
deepaks3 wrote: What i want is that anyone who wants to upload the file in this folder can upload the file regardless of the Rights he have.
You can't do that. You must grant the rights to do this. I might add that this sounds like a very stupid idea and a sure fire way to compromise your server. Security exists for a purpose.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
 Umm.. why oh why would you want to even think about doing something like this?
Give anyone, the ability to run arbitrary code on your system..
it's like.. giving the keys to the corvette to the teenager for flunking his driving test..
/shudder
---
Don't be irreplaceable. If you can't be replaced, you can't be promoted.
|
|
|
|
|
How do I get my session state to timeout out at a small interval (for testing purposes)? I tried adding <sessionstate timeout="3"> to my web.config file, but the session does not timeout after 3 minutes. I'm still sitting here 20 minutes later with a fully usable session state.
Any ideas? Thanks in advance.
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
|
|
|
|
|
try this
in global.asax under Session_Start write the following
Session.timeout="3"
Thanks
Bhasker P
|
|
|
|
|
If you are Using Forms Authentication then in You can use it like..
<authentication mode="Forms">
<forms timeout="30" slidingexpiration="true">
|
|
|
|
|
Hi all,
I would really appreciate your help on the following... I am very new to ASP 1.1, been using 2.0, but have to do some edits to asp 1.1 files.
I get the following error when binding my dataset to a datagrid:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Line 23: dgMembers.DataSource = dsMembers
Here is my code:
ASPX:
<br />
<br />
<asp:datagrid id="dgMembers" runat="server" BorderWidth="0px" GridLines="None" BorderStyle="None"<br />
CellPadding="0" Width="100%" AllowPaging="True" PageSize="15" PagerStyle-Visible="False" AutoGenerateColumns="False"><br />
<Columns><br />
<asp:TemplateColumn HeaderText="Name"><br />
<HeaderStyle Width="70%" CssClass="Grid_HeaderStyle"></HeaderStyle><br />
<ItemStyle CssClass="Grid_ItemStyle"></ItemStyle><br />
<ItemTemplate><br />
<asp:Label id="lblFirstName" Text='<%# DataBinder.Eval(Container.DataItem, "FirstName") %>' runat="server" /><br />
</ItemTemplate><br />
</asp:TemplateColumn><br />
<asp:TemplateColumn HeaderText="Age"><br />
<HeaderStyle Width="15%" CssClass="Grid_HeaderStyle"></HeaderStyle><br />
<ItemStyle CssClass="Grid_ItemStyle"></ItemStyle><br />
<ItemTemplate><br />
<asp:Label id="lblAge" Text='<%# DataBinder.Eval(Container.DataItem, "Age") %>' runat="server" /><br />
</ItemTemplate><br />
</asp:TemplateColumn><br />
</Columns><br />
<PagerStyle Visible="False"></PagerStyle><br />
</asp:datagrid><br />
<br />
ASPX.VB class:
All labels and datagrid declared
<br />
<br />
Dim dgMembers As DataGrid<br />
Dim lblFirstName As Label<br />
Dim lblAge As Label<br />
<br />
Public Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
<br />
' Put user code here to initialize the data source <br />
' filling the dataset<br />
Dim dsMembers As DataSet = New DataSet<br />
dsMembers = Member.GetAllMembers()<br />
<br />
'Response.Write(Member.GetAllMembers().ToString)<br />
dgMembers.DataSource = dsMembers<br />
dgMembers.DataBind()<br />
<br />
<br />
End Sub<br />
Member.vb:
<br />
Public Shared Function GetAllMembers() As DataSet<br />
Return MemberDA.GetAllMembers()<br />
End Function<br />
MemberDA.vb:
<br />
<br />
Public Shared Function GetAllMembers() As DataSet<br />
<br />
Dim dsMemberResults As New DataSet<br />
<br />
' Create instance of SqlConnection and SqlDataAdapter object<br />
Dim objConn As SqlConnection = New SqlConnection(Globals.GetConnectionString)<br />
Dim objCmd As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Members", objConn)<br />
<br />
Try<br />
<br />
'Open the connection to the database<br />
objConn.Open()<br />
<br />
' Create and fill a DataSet.<br />
objCmd.Fill(dsMemberResults)<br />
<br />
Catch ex As Exception<br />
Dim strExceptionMsg As String = "Error Executing GetAllMembers(): " + ex.Message + "\r\n"<br />
Throw New Exception(strExceptionMsg, ex)<br />
Finally<br />
'close the connection once retrieving the information is done<br />
objConn.Close()<br />
End Try<br />
<br />
Return dsMemberResults<br />
<br />
End Function<br />
<br />
Playout
|
|
|
|
|
Make sure that the datagrid control declared in the web page .aspx with the ID dgMembers, also in code-behind the variable dgMembers is normally declared with the sample code:
Protected WithEvents dgMembers As System.Web.UI.WebControls.DataGrid
|
|
|
|
|
I love the ASP.NET 2.0 feature which allows one to put the connectionString nodes in the machine.config, but does anyone know how to get those connection strings to show up in the Visual Studio 2005 IDE similar to the way the ones in the local web.config show up? For example, when dragging a SQLDataSource object into the designer, the first step is to configure the datasource, which of course requires that you specify a connection string. The ones that are inherited from machine.config will work, but they aren't available to choose from in the dropdowns of the IDE.
Thanks for you help!
Anthony
|
|
|
|
|
AFAIK, the SqlDataSourceDesginer object (the designer of the SqlDataSource control) uses the object which implements the IDataEnvironment[^] interface to access the connection list of the application at design time and display in the combobox. And it only gets the connections declared in the web.config file of the application, not from the machine.config file which is shared by all applications on the server. Though it's not easy, you may think of customizing the SqlDataSource designer if you want to.
|
|
|
|
|
Thanks for the reply and suggestion. Not sure I'm up to customizing the SqlDataSourceDesginer just for this, but I'll certainly keep that in mind.
Also, the underlying goal I'm trying to achieve might be solved another way if I could get Visual Source Safe 2005 to ignore files that I've excluded from the project. That is, in web.config, I would reference an external file for the connection string, but exclude that file from the project. The problem is, Visual Source Safe still wants to keep that file under source control, so my fellow developers and I would be overwriting each other's connection string file.
The reason we need this is that occasionally one of us will pull in a local copy of the database for the project and hit the road with our laptop. When we get back, we don't want to worry about checking the project back in with connection strings to the portable copy of the DB.
Thanks again
Anthony
Anthony
|
|
|
|
|
Hi Anthony,
Though you can configure the VSS so that it ignores a specified file type, it may affect the other files. There are two work-around options which you may consider:
+ Make the file hidden, the hidden file is automatically excluded from the web site and it's also ignored by the source control.
+ Check in the file, right click the file to open the Properties dialog box, uncheck the Read-only checkbox, you now can edit the file without checking out the file.
|
|
|
|
|
Sweet! Hiding the file works perfectly. Thanks so much!
Anthony
|
|
|
|
|
i want write a number and with click a button convert it for text
for example:
123 convert to: onehundered twenty two
can any body help me???????????
|
|
|
|
|
Goole[^] could bring up a couple of links.
|
|
|
|
|
i have a problem related to dropdown list...
The texts in the dropdown are too long and the width is not sufficient
to show the entire text. Increasing the width is not an option.Is there
a way to show the list without increasing the width.
thanks in advance
|
|
|
|
|
You may reduce the text length, and only display the full text as the tooltip of the item, the article[^] might give you an idea.
|
|
|
|
|
I have images stored in a folder
I use this path
Server.MapPath("~/Avatars") to find it.
I have a method that grabs all of the file names to display.
It works fine on my machine, and shows them perfectly.
I know I can access it because the code created the image and I have checked the access. Its fine.
I tried typing the URL to the image.
I can see it in IE. So I copy this path to my code. The image is still an X. I have even viewed to source to verify the path. and its correct.
Any ideas?
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
Once I also had a similar problem and then it was caused that my local machine wasn't case sensitive but the server was case sensitive ...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
