DSN less connection fro ASP pages

I have installed Microsoft SQL server 2000 on a server.
My web server is having windows NT having all asp pages.
I want to connect to SQL Server 2000 using a DSN less
connection for my asp pages. Could anyone help me with
that?
Also, if I try to create system DSN on windows NT, it
gives me an error message and does not create DSN. What
could be the reason?
ThanksThe syntax depends on whether you are using OLE DB or ODBC,
it you are connecting using a standard SQL login or Windows
Authentication, etc. You can find sample ADO connection
strings which cover different scenarios at:
http://www.able-consulting.com/ADO_Conn.htm
The problem creating the DSN would depend on what the error
message is that you are receiving - it's hard to say without
more information about the error.
-Sue
On Wed, 25 Feb 2004 13:43:59 -0800, "namita"
<anonymous@.discussions.microsoft.com> wrote:

>I have installed Microsoft SQL server 2000 on a server.
>My web server is having windows NT having all asp pages.
>I want to connect to SQL Server 2000 using a DSN less
>connection for my asp pages. Could anyone help me with
>that?
>Also, if I try to create system DSN on windows NT, it
>gives me an error message and does not create DSN. What
>could be the reason?
>Thanks|||Hello,
<%
set conn1=server.CreateObject("adodb.connection")
conn1.cursorlocation=3
conn1.Open "Provider=sqloledb;" & _
"Data Source=Server;" & _
"Initial Catalog=DB;" & _
"User Id=ayaz;" & _
"Password=ayaz"
%>
and also
try this one too.
conn1.open " dsn=ayaz;uid=ayaz;pwd=ayaz;DATABASE=ayaz
;APP=ASP Script"
i hope its will help you , if any problem then email me.
Thanks,
Warm Regards,
Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Dropping a set of tables

Hi
I am using SQL server 7 database and ASP as front end. I run an application where a text file is loaded into database. After this is done procedures are run to create a set of tables that have snapshots of the data in the text file.. each time i load a new text file i want to create the snapshots.. i hve written a stored procedure to create tables and insert values into the tables.. however how do i delete the tables i created the previous time.. the number of snapshots and their names will depend on the size of the text file.. how do i refer to all the snapshots created and drop them all before creating new ones?
plese guide
regdsIn your stored procedure, you should drop the temporary tables you created when you do not need them. If I'm not wrong, SQL server 2000 will drop the temporary tebles for you. But I suggest that you should drop them in the code if you do not need them.

DropDown List values

For a controlParameter in the ASP code, how do I retreive the selectedValue of the drop down list?
Would this work?

<asp:controlParameterName="InvoiceNumber"Type="String"ControlID="ddAdSize.Value"/>

Hi

I 'm a beginner at this, but I solved what I think is the same problem as you have, by looking athttp://authors.aspalliance.com/aspxtreme/.
There you will find solutions to many problems.
This is part of my html code:
<Asp:DropDownList Id="ddlCarrier" TabIndex="17" onSelectedIndexChanged="ShowCarrier" Width="150" autopostback runat="server">
</Asp:DropDownList>
And part of the ASP.NET code:
Dim Selection1 As String = _
"SELECT Carrier, Used, Manufacturer, Material, ManufacturedDate " & _
"FROM Carriers " & _
"WHERE Carrier = '" & ddlCarrier.SelectedItem.Text & "'"
Hope this will help you
Rolf Dahlstr?m

dropdown list and data from a table

Hi masters

well got a SQL server 7 and a table

and got drop down list in my asp page

what I want to do is that the content and value of the drop down list will be grabbed from the database, when page loads.

can you please guide me

many thanks

STry these links:

http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20738865.html

http://www.codeguru.com/net_data/0672325241_ch13a.html

HTH

Drop a Global Temporary Table using Classic ASP

Good Afternoon,
I am hoping someone can help me out. I want to drop a global temporary
table in classic asp after my recordset has completed printing out
it's rows.
I tried executing the following statement and I get the following
error:
Drop Table tmm_a03_gtt_YYYJCO3_0611154125
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-14452: attempt to
create, alter or drop an index on temporary table already in use
FYI; We are using Oracle 10 g.
Thanks,
Juan
Not sure about Oracle. But in SQL Server you cannot delete a global
temporary table even if one connection references it. So I would check if
there are connections that access it, and kill those. Or wait until those
connections are completed then delete it.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"juan.oceguera@.nav-international.com" wrote:

> Good Afternoon,
> I am hoping someone can help me out. I want to drop a global temporary
> table in classic asp after my recordset has completed printing out
> it's rows.
> I tried executing the following statement and I get the following
> error:
> Drop Table tmm_a03_gtt_YYYJCO3_0611154125
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-14452: attempt to
> create, alter or drop an index on temporary table already in use
> FYI; We are using Oracle 10 g.
> Thanks,
> Juan
>

Drilldowns with SOAP rendering or SSRS 2005?

We are running SSRS with SQL Server 2000 and are working on developing an
ASP.NET application that would use SOAP web access to render the reports.
However, I was wondering how this works with linked or drill down reports,
which we are thinking will be an important part of our design.
Has anyone done this successfully? How does it work? Normally, the
reportingservice.render method is called, but I read about an issue that
occurs when a drill down report is encountered. Apparently the user is
redirected to the Report Manager, as there is no way to tell the Report
Server that the drill down destination should be mapped to the calling
application. I also read that there may be something better for this in SQL
Server 2005, but I wonder when we should expect that?
Can anyone shed some light on this issue?
Thanks,
nickpupwell i ve been using SSRS 200 with SQL Server 2000 n ASP.Net for my
reports n i had the same problem of handling linked n toggle reports
as far as linked reports r concerned those were settled by changing the
path of the linked report to my application's webpage that shows the
specified linked report with parameters in URL through JUMP TO URL
PROPERTY however i couldnt resolve the toggled report problem i tried
but couldnt succeed if u get the idea plz let me know as well|||I will - thanks.
"** Spirits **" wrote:
> well i ve been using SSRS 200 with SQL Server 2000 n ASP.Net for my
> reports n i had the same problem of handling linked n toggle reports
> as far as linked reports r concerned those were settled by changing the
> path of the linked report to my application's webpage that shows the
> specified linked report with parameters in URL through JUMP TO URL
> PROPERTY however i couldnt resolve the toggled report problem i tried
> but couldnt succeed if u get the idea plz let me know as well
>

Drill-down in ASP.NET with iframes

Hello all I pretty new to SRS. I've got an asp.net application that uses
iframes to display reports. I'm trying to get the reports to drill down.
I've tried using the 'Jump to report' option but it opens the report on top
of my application so I loose my iframe (and app header and navigation). I
can't work out how to change this behaviour. I also tried the 'Jump to URL'
but ran into some issues with this too. I had to hardcode my server name in
the link. I also have to put code in my page to handle the parameters. Is
there a better way?What about using the _self target rather than the _top target, which is
default. ?
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick P via SQLMonster.com" <forum@.nospam.SQLMonster.com> schrieb im
Newsbeitrag news:53526a45e0544eb1a51ed6169737ca1a@.SQLMonster.com...
> Hello all I pretty new to SRS. I've got an asp.net application that uses
> iframes to display reports. I'm trying to get the reports to drill down.
> I've tried using the 'Jump to report' option but it opens the report on
> top
> of my application so I loose my iframe (and app header and navigation). I
> can't work out how to change this behaviour. I also tried the 'Jump to
> URL'
> but ran into some issues with this too. I had to hardcode my server name
> in
> the link. I also have to put code in my page to handle the parameters. Is
> there a better way?|||I couldn't find where this property is stored. The Link is generated as
follows:
<a style="color:Blue" href="http://links.10026.com/?link=http://localhost/myreport/Reports/Summary.aspx?
ReportName=rptNoRevisions&BeginDate10/10/2003" TARGET="_top">Day
Shift</a>
So even if I set the target at a page level the element level will override
it. Is there a way to change the default target for report links?|||http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/54a5075b1e3f48e7/55e040db2460e6b1?q=iframe+open+target&rnum=3&hl=de#55e040db2460e6b1
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick P via SQLMonster.com" <forum@.SQLMonster.com> schrieb im Newsbeitrag
news:a5299fd9cb314afbbb5d64a4a7493296@.SQLMonster.com...
>I couldn't find where this property is stored. The Link is generated as
> follows:
> <a style="color:Blue"
> href="http://links.10026.com/?link=http://localhost/myreport/Reports/Summary.aspx?
> ReportName=rptNoRevisions&BeginDate10/10/2003" TARGET="_top">Day
> Shift</a>
> So even if I set the target at a page level the element level will
> override
> it. Is there a way to change the default target for report links?|||Thanks for the link but unfortunately google groups is blocked by our
firewall, which makes it really hard to get technical research done (very
annoying). Could you please cut and paste relevant bits for me. Thanks
again!
--
Message posted via http://www.sqlmonster.com|||Let me be your proxy :-)
Bryan Keller [MSFT] 19 Mär. 2004 19:39 Optionen anzeigen
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Von: "Bryan Keller [MSFT]" <brya...@.online.microsoft.com> -
Nachrichten von diesem Autor suchen
Datum: Fri, 19 Mar 2004 10:37:32 -0800
Lokal: Fr 19 Mär. 2004 19:37
Betreff: Re: href TARGET property defaults to "_top"
Antwort an Autor | Weiterleiten | Drucken | Einzelne Nachricht |
Original anzeigen | Missbrauch melden
What action are you using to generate the URL? Jump to Report will not
work
with LinkTarget. Jump to URL will. So in your example below, when a
user
clicks on the link, any URL's in the Consolidated report will have
target = _self. But unless the parent report of Consolidated has
rc:LinkTarget=_self,
your link below will open in _top. Where are you running into a
problem?
Please be more specific about parent reports, child reports and the
expected
navigation of users. This will help me to better answer your question.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick P via SQLMonster.com" <forum@.SQLMonster.com> schrieb im Newsbeitrag
news:4f06f19c226447c0bc25587933cc43c3@.SQLMonster.com...
> Thanks for the link but unfortunately google groups is blocked by our
> firewall, which makes it really hard to get technical research done (very
> annoying). Could you please cut and paste relevant bits for me. Thanks
> again!
> --
> Message posted via http://www.sqlmonster.com
begin 666 dot_clear.gif
K1TE&.#EA`0`!`( ``/___P```"'Y! $`````+ `````!``$```("1 $`.P``
`
end|||Thanks for the help. I worked out the solution. For anyone struggling with
the same issue here is what I did.
1. Use 'Jump to URL' instead of the other options.
2. Open Report Viewer project and add the following code:
Private _linktarget As String = "_self"
<Category("HTMLViewer Commands"), Description("Sets rc:linktarget to change
iFrame target")> _
Public Property LinkTarget() As String
Get
Return Me._linktarget
End Get
Set(ByVal Value As String)
Me._linktarget = Value
Me.SetParameter("rc:LinkTarget", Value)
End Set
End Property
3. Recompile and place dll in project bin.
Now the default is _self and you have the option to change the target from
your code.
This solution isn't ideal because you have to use the jump to url which
means more work in creating the url with params, and you may have to hard
code your servername.
If anyone comes up with a better solution please post it.
--
Message posted via http://www.sqlmonster.com