|
AJAX...figure it out
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
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...
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
Hi All,
Is there anyone help me how to draw graphic by javascript?
Thanks
|
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
But VML is only supported by IE 5.0 and over.
|
|
|
|
|
Hello,
How do we pass a severside object (e.g a listbox) to a client-side javascript function?
I have an idea that it could be this:
//string variable
string objectID;
//get the object's control identifier
objectID = listbox.ClientID;
//pass the object's control identifier
ctl1.attribute["onClick"] = "returnContextMenu({0},objectID);";
Is it correct?
|
|
|
|
|
Hi,
I know this is a simple piece of code, but I'm a little brain dead at the moment.
I have a basic HTML table. If I resize the Internet Explorer window, I want the table to also resize so that it "fits to screen" instead of having to scroll from side to side in order to see the whole table.
What's the code for that again?
Thanks!!
Jane
|
|
|
|
|
If your scrolling side to side or horizontal scrolling...
It's likely because you have a PRE tag or html entities causing that...or anything that doesn't allow line breaks.
You could possibly have a DIV or a SPAN tag width set to greater than the TABLE width, which will also causes HScrolling...which is really annoying
Show your code in question and I'll try and show you what I mean...
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
Thanks! I do have a span tag. I'll remove it.
|
|
|
|
|
<table width="100%" height="100%">
....
</table>
-- modified at 16:45 Tuesday 28th March, 2006
|
|
|
|