Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - HTA RDS Data Control problem

Reply
 
Old 11-17-2008   #1 (permalink)
YukonJuan


 
 

HTA RDS Data Control problem

I am trying to extract data from an .mdb file on my local HD using
an .hta file with a RDS data control.
No errors occur but no data is displayed either. I have tried several
different connection strings but nothing works. I have also tried
setting the Server parameter to various things but I still get the
same result. Here is what I have in my .hta file.

<blockquote>
<span id=DataArea></span>
</blockquote>
<OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID=dsoComposer HEIGHT=0 WIDTH=0>
<PARAM NAME="Connect" VALUE="Driver={Microsoft Access Driver
(*.mdb)};Dbq=c:\temp_2\db1.mdb;Uid=admin;Pwd=;">
<PARAM NAME="SQL" VALUE="select * from myResults">
</OBJECT>
<table border='1' width='100%' cellspacing='0' datasrc=#dsoComposer>
<THEAD><TR>
<TD>Field1</TD>
<TD>Field3</TD>
<TD>Field4</TD>
</TR>
</THEAD>
<TBODY>
<TR>
<TD><DIV datafld="Field1"></DIV></TD>
<TD><DIV datafld="Field3"></DIV></TD>
<TD><DIV datafld="Field4"></DIV></TD>
</TR>
</TBODY>
</TABLE>


My System SpecsSystem Spec
Old 11-17-2008   #2 (permalink)
YukonJuan


 
 

Re: HTA RDS Data Control problem

On Nov 17, 9:57*am, YukonJuan <jvstew...@xxxxxx> wrote:
Quote:

> I am trying to extract data from an .mdb file on my local HD using
> an .hta file with a RDS data control.
> No errors occur but no data is displayed either. *I have tried several
> different connection strings but nothing works. *I have also tried
> setting the Server parameter to various things but I still get the
> same result. *Here is what I have in my .hta file.
>
> <blockquote>
> <span id=DataArea></span>
> </blockquote>
> <OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> * * *ID=dsoComposer HEIGHT=0 WIDTH=0>
> * * <PARAM NAME="Connect" VALUE="Driver={Microsoft Access Driver
> (*.mdb)};Dbq=c:\temp_2\db1.mdb;Uid=admin;Pwd=;">
> * * <PARAM NAME="SQL" * * VALUE="select * from myResults">
> </OBJECT>
> <table border='1' width='100%' cellspacing='0' datasrc=#dsoComposer>
> <THEAD><TR>
> <TD>Field1</TD>
> <TD>Field3</TD>
> <TD>Field4</TD>
> </TR>
> </THEAD>
> <TBODY>
> <TR>
> <TD><DIV datafld="Field1"></DIV></TD>
> <TD><DIV datafld="Field3"></DIV></TD>
> <TD><DIV datafld="Field4"></DIV></TD>
> </TR>
> </TBODY>
> </TABLE>
I also have tested the connection string with vbscript in a .vbs file
and I can retrieve the data with no problem.
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Which data control gives me this view? .NET General
User Account Control & Data in the Program Files Folder Vista account administration
Missing Data - Control Panel\Programs and Features Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46