So other ideas on how to view sp values from an app:
1. If your stored procedure isn't currently returning a select statement, one thing you could do is build a SELECT statement inside the stored procedure, made up of variables that you want to view the values of.
So the last line of the sp...
Hi,
On our Internet site we have a handful of pages that are called using https:// as secure pages. These pages are listed in an if statement, which calls them as https:// if they are in the list.
We added a new .asp page to this if statement, and for some reason, with this page only, the...
Thanks much k,
That helped me figure out what was going on; when I tried a different way of connecting (using OLE DB) I found one of the tables didn't have proper permissions for the SQL account we were using....
Thanx again [thumbsup2]
Hi,
We are creating a new Crystal Report (8.5) that uses a dsn, with a stored procedure from SQL Server 2000. The stored procedure uses a linked server in the select statement, with a fully qualified name in the join, something like
Select LTABLE.field1, local.field2 from local join...
Hi,
We have an asp.net project that we're copying from our development web server to the live web server (IIS 5.0, Windows 2000). This was giving us some problems just moving the pages, so we created a deployement project within Visual Studio .NET and it worked great. Now we want to use...
Hi,
I have an .asp page that submits to an .aspx page, which has a COM+ component call to a .dll created with VS .NET. I made a change in code to the .dll, changing the connection string for what server the database is on, and the SQL user it uses. So I re-created all the COM+ stuff (server...
Thanx, that makes sense;
probably easier with the number of views we have to just change them but that could really help in the case of more of them....
Hi,
Another thread had the following, for tables. Is there something like this for views?
from another thread:
The followig script changes the table owner for all tables in the current database to 'dbo' if not already 'dbo'. The script uses the undocumented system stored procedure...
Hi,
We're wanting to bring up an pop-up when the user clicks on a hyperlink, and have the user select an item on the pop-up screen. Then, once they select this item and click on a button (or a link or whatever) it would close this window and, on the original screen, the info from this pop-up...
Hi,
Check out the following link, in the section on Windows Installer. This enables you to create your project in a virtual directory that you create on the new web server. This is very useful for moving a project from one server to another...
Hi,
We have .asp pages on our Intranet with an application that we want to be able to send e-mails through. How would we access the Global Address List (and the e-mail addresses in it) through script on this .asp page?
We're on Exchange 2000.
Thanks much,
Ray
Well, this is resolved now! It was an .aspx issue, that I found while debugging through the code.
I needed to add the dispose method call to the component, and this fixed it.
I guess it was using a cached copy of the component, so it was calling the code, but it hung in the .aspx page at...
Hi,
Thanks much for the input. I am returning the ID from the component (which has error trapping), and it returns fine to the page, which also means I'm getting no errors from the component. I added a trasaction to the component, and am committing it right after the Insert. When I've made...
Well, the connection problem is resolved:
.Winsock1.Close
.Winsock1.RemoteHost = strServer
.Winsock1.RemotePort = Val(strPort)
.Winsock1.Connect
Do Until .Winsock1.State = 7 Or .Winsock1.State = 9 ' 9 for sckError
DoEvents
Loop
This took care of it.
Now I'm having problems...
Hi,
I have a winsock control (VB6 SP5) that I'm using to connect to a server with the following lines of code:
with frmWin
.Winsock1.RemoteHost = strServer
.Winsock1.RemotePort = Val(strPort)
.Winsock1.Connect
If .Winsock1.State = 7 Then...
Hi,
I have an .aspx page that calls a com+ component and performs an insert to a database in the page load. The page loads successfully and the component returns an id from the insert (which it is supposed to do on success). However, the row isn't in the database. (This is on our live web...
Hi,
I have an .aspx page (asp.net) that calls a COM+ component, which performs an insert into a SQL Server 2000 database (3 Servers, all Windows 2000). When the code in the component successfully works (no errors) it returns the ID of the row just entered into the database (this id was an...
Thanks, Blaxo....
That didn't change anything. I changed machine.config as well, just in case, and search on the machine for all web.config files, which were all already set correctly. I have no idea what's going on here.
Any help would be greatly appreciated!!
Thanks,
Ray
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.