Using RDS... - Web Development Discussion Boards

Hi!

I want to populate a dropdownlist with values and then, when select Value1 it should execute the Stored Procedure "1" and so forth.

Can someone please assist in this regard?

Thanks Guys!!

Illegal Operation

Making Computer Software Talk

Hi ,

I want to open a new window when i press a F9 key.

please if you know then answer me with code.

Thanks,

Chetan Visodiya

You can call a javascript function onkeypress and this function will check whick key is pressed by the user.
and you can check this key is F9 key or not

function chkKey(){
var chkkeycode=e.charCode? e.charCode : e.keyCode
if (chkkeycode==120){ //120 is a keycode for F9 key.
//open new window here
}
}

Sushant Mathur
Bangalore,
INDIA.
<a href="http://n.domaindlx.com/fun2ssh/HOME.htm">http://n.domaindlx.com/fun2ssh/HOME.htm</a>

Hi shushant,

Thanks for giving me the answer.

Chetan Visoidya

Hey welcome dude..but name is Sushant not shushant Laugh | :laugh:

Sushant Mathur
Bangalore,
INDIA.
http://n.domaindlx.com/fun2ssh/HOME.htm

on the WEB page , for an JavaScript's onClick event , for example , i want to set up request to the Database, without refreshing the page .. how can i did it ?
Thanks in advance !

AJAX...figure it out Smile | :)

It's frustrating being a genius and living the life of a moron!!!

[edit#2]
More weirdness: If I run the sample shown below using Server=http://myserver I get no errors and no data. However, if I change it to //MyServer, I get a confirm dialog warning me about accessing a machine on another domain (MyServer is indeed in a different domain from my desktop. Further, if I remove the slashes (Server=MyServer), I get the same message but also get another one from my RDS.OnError handler saying:
---------------------------
VBScript
---------------------------
Error: sCode: 4100; Description: Business object cannot be created.; Source: Microsoft ADO/RDS; CancelDisplay: True
---------------------------
OK
---------------------------
[/edit#2]

[edit]
Well, I've learned more and consequently I'm more confused!

I found a reference in my MSDN Library called Configuring RDS on Windows 2000. I followed the instructions found there and noted section 2: From the Start menu, select Run. Type msdfmap.ini and click OK to open the msdfmap.ini file in Notepad. Check the [CONNECT DEFAULT] section, and if the ACCESS parameter is set to NOACCESS, change it to READONLY. I did that and now I no longer get RDS errors! However, the recordset still is not returned! I think I'm getting close, but boy, this stuff is complicated!
[/edit]

Folks,

I'm trying to learn how to manage recordsets on the client side and I found several references to RDS, which seems like just the ticket. However, I've tried running some of the examples I've found on MSDN, here on CodeProject and from Google searches and I just can't seem to get data from my server. My IIS and SQL Server are running on the same machine, a Windows 2000 server on our intranet. My desktop login has admin rights to the server, so I use TrustedConnection=yes.

Here's an example that I'd like to get running:

<br />
<body><br />
Data Control Object Example (VBScript)<br />
RDS API Code Examples<br />
Remote Data Service Run Time<br />
<br />
<TABLE DATASRC=#RDS><br />
<TBODY><br />
  <TR><br />
    <TD><SPAN DATAFLD="au_lname"></SPAN></TD><br />
    <TD><SPAN DATAFLD="au_fname"></SPAN></TD><br />
  </TR><br />
</TBODY><br />
</TABLE><br />
<% ' RDS.DataControl with no parameters set at design time %><br />
<OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID=RDS HEIGHT=1 WIDTH=1></OBJECT><br />
<br />
<FORM name="frmInput"><br />
<Input Size="70" Name="txtServer" Value="http://<%=Request.ServerVariables("SERVER_NAME")%>"><BR><br />
<Input Size="100" Name="txtConnect" Value="SERVER=<%=Request.ServerVariables("SERVER_NAME")%>;DRIVER={SQL Server};DATABASE=pubs;TrustedConnection=yes;"><br />
<BR><br />
<Input Size="70" Name="txtSQL" Value="Select au_lname,au_fname from Authors"><br />
<INPUT TYPE="BUTTON" NAME="Run" VALUE="Run"><BR><br />
Show grid with these values or change them to see data from another ODBC data source on your server<br />
</FORM><br />
<br />
<Script Language="VBScript"><br />
<br />
' Set parameters of RDS.DataControl at Run Time<br />
Sub Run_OnClick<br />
<br />
   RDS.Server = document.frmInput.txtServer.Value<br />
   RDS.Connect = document.frmInput.txtConnect.Value<br />
   RDS.SQL = document.frmInput.txtSQL.Value<br />
<br />
   RDS.Refresh<br />
<br />
End Sub<br />
<br />
</Script><br />
<br />
</body><br />

It loads fine but when I click the Run button nothing seems to happen! I can see some text being printed to the status bar but when it finally says Done, there are no script errors listed, so I don't have any idea what's happening behind the scenes.

Funny, when I load the .asp file into Visual InterDev 6.0, it pops up a message window saying the following:
---------------------------
Microsoft Development Environment
---------------------------
An object has failed to load. The object will be displayed as text.
---------------------------
OK
---------------------------

If I load the file into VS 2005, I get no such message.

I found another sample using the same object, which builds a recordset locally. That runs ok, even though VID 6.0 also complains about the object in that sample. So, I'm guessing the object is available and I'm just having problems getting the parameters right for a remote query.

I just figured out how to see errors from the RDS object and I'm getting Error: 8447, which seems to indicate I've got RDS installed wrong. I found a page of info on that in my MSDN Library (Q249719; Oct. 2001) and followed the instructions to repair it, but to no avail.

I should say that I'm running SQL 7.0, otherwise I'd try using VS 2005's asp:xxx components. Alas, they require SQL 2000 or better and won't connect to SQL 7.

Am I just barking up the wrong tree?

'til next we type...
HAVE FUN!! -- Jesse

-- modified at 18:12 Wednesday 29th March, 2006

We have a document library application on the web. Currently if a user wants to edit a document they have to download it, make the edits, then reupload the file. I would like to make the edit process easier for users; I am thinking that if I could create a URL that would launch the document using web folders/webdav then they could just open the file, make changes and save - and the document would automatically be updated on the server.

Does anyone know if this can be done or how to do it? (Or any better ideas on how to make the editing process easier for our users...)

(I was formerly a software developer but have being doing UI design for the last 7 years and am not up to date on all the latest programming techiques.)

Thanks!

It's possible to open a document on remote server using an application on a desktop, by simply clicking the file or a link which points at the files URL the file "should" download to local computer and launch appropriate application.

However, when the document is saved or modified, it can not be automatically uploaded back to the server, without some special desktop software which can:

1) Capture the applicaiton in questions "Save" command
2) Have knowledge of where the file is going to re-uploaded too

It's not possible that way.

There may be a work around depending on the types of files that need editing.

Text files could be edited using a HTML TEXTAREA or if it's HTML you could use WYSIWYG editors...

If you document is PDF or word, etc...thats much more difficult...the only solution I can think of is write a PDF -> HTML converter (Edit contents in WYSIWYG) and convert HTML back to PDF, etc...and save contents back to file...

This is not a trivial task however...I'm not even sure if HTML WYSIWYG contain enough stle information to re-build a PDF exactly as it was Smile | :)

Cheers

It's frustrating being a genius and living the life of a moron!!!

Hi,
I am trying to develop a user control in .NET (alternate to ActiveX)which can use the FindWindow() ,Windows APi func.. i do have the .dll now and it does basic stuff like string concatenation etc fine ...the FindWindow() call works fine with a windows form project but in a user control, it gives me a Security Exception at run time...
i THINK, i need to sign it or something but i donno how... i tried using the 'signtool signwizard' tool from .NET but it didnt serve my purpose...remember, this is a student project so i need to create a test sign only...
can anyone help me?
plz reply...even if u are not sure if ur solution wud work... Frown | :(

Wajih
FAST-NU,Pakistan

I am not absolutely sure of this but you must allow your application to do this via the Microsoft .NET Framework Configuration tool in the Control Panel of the client's system. However, I won't attempt this!

I am using the CDO.Message object to send mail from an ASP page but the mail does not get delivered, how can I view debug information to see where the problem is occuring?

Thanks in advance!

Have you used Err Object to find Error on the ASP page?
Some of the web server currently not supporting the CDO Component
You can try by using CDONTS.

N.Rajakumar B.E.,
Application Developer,
www.newdreamz.tk

Hi,

I have a problem with my menu. I have a css menu staying visible on all the application.

Though, I created a page using iframes and whenever I open a pop up from this new window my menu disappear.
With no reason at all. When I look in the code of the page it is equal before and after the opening.

Any idea of what would do that? A javascript bog? A IE bog? A conception to review?

Thanks in advance

Pierre

can u provide source code of sha1 in 'c' language and ASP.
i will be highly obliged
thanks

123

Simple way:
string ht = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile("Code Project", "sha1");

See also:
http://www.developerfusion.co.uk/show/4601/[^]

http://www.freevbcode.com/ShowCode.Asp?ID=2565[^]

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At:
http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

hai all,
in my appln i've two listbox L1 and L2 and two butons"add" and "remove"

in L1 i bind data from database when click "add" the selected items from L1 are added to L2

when i press "remove" button the selected item from L2 is removed

is there any javascript availble for adding and renmoving item from listbox??

any help appriciatable...

All I ever wanted is what others have....

CrazySanker

Below link will give you all u need Smile | :)

http://www.mattkruse.com/javascript/selectbox/[^]

Sushant Mathur
Bangalore,
INDIA.
http://n.domaindlx.com/fun2ssh/HOME.htm

Hi All,
Is there anyone help me how to draw graphic by javascript?

Thanks Smile | :)

chk this link:

http://www.javaworld.com/javaworld/jw-08-1996/jw-08-javascript.html[^]

Sushant Mathur
Bangalore,
INDIA.
http://n.domaindlx.com/fun2ssh/HOME.htm

Thank for your help!
But it's not my needs. I'm finding drawing 2D(have functions such as drawLine, fillPolygon) library in Javascript. I had entered your recommended site.

Thanks,
Tran Thai Nam

now chk this also..hope you had not entered this site Laugh | :laugh:

http://www.webreference.com/programming/javascript/gr/column2/index.html[^]

Sushant Mathur
Bangalore,
INDIA.
http://n.domaindlx.com/fun2ssh/HOME.htm

-- modified at 4:25 Thursday 30th March, 2006

If you need Graphical output over webpage you can go for VML (Vector Markup Language)

Reference:http://msdn.microsoft.com/library/default.asp?
url=/workshop/author/vml/shape/data/vmlom.asp

N.Rajakumar B.E.,
Application Developer,
www.newdreamz.tk