Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mowog74

    IIS 5, win XP client authentication issue

    It's resolved, but I don't think I did it. :) The two things that I think might have fixed it are: 1) I switched to basic authentication on the development site at first, which was a good enough workaround for a while, but then I had other problems with win2K clients using the development...
  2. mowog74

    IIS 5, win XP client authentication issue

    I've got a single intranet server running IIS5, with the production site on port 80 and the development site on port 81. I'm generally the only one using the dev site, so assigning a different port number seemed like a simple way to implement a separate development site. Both sites depend...
  3. mowog74

    Outlook/Exchange public folders from ASP

    I'm trying to add appointments to a public calendar folder from ASP for an intranet application, but the web server I'm using (IIS 5) is not also the company's Exchange (2000) server, so I don't have access to CDO for Exchange 2000 from the ASP pages. 1) Is it possible to install CDOEX on the...
  4. mowog74

    Sending messages to VB from SQL 2000 using triggers

    I don't know of any easy way for sql server to send a message to a vb app. I would have your trigger(s) update a single "last updated datetime" value in a table somewhere, and then have your app check this value periodically to see if its last refresh is stale.
  5. mowog74

    Does SQL Server 2000 support hierarchial queries?

    I'm not sure what you're using for a front end, but if it can use OLEDB you can use the MSDataShape provider to return a hierarchical recordset, in which certain fields in the parent recordset are actually sub-recordsets themselves. Here's a VB/ADO example from the MSDN help that uses the pubs...
  6. mowog74

    Opinions on join syntax?

    Thanks Terry. Also, I think I had it backwards--after reading the article you suggested and others it looks like the first syntax in my original post (using the JOIN keyword) is ANSI style. Thanks for straightening me out!
  7. mowog74

    Opinions on join syntax?

    I typically use the JOIN keyword when joining tables, e.g.: SELECT [...] FROM Orders o INNER JOIN OrderStatus os ON o.OrderStatusId = os.Id WHERE o.Id = 5 But lately I've been seeing (esp. in Books Online) syntax like: SELECT [...] FROM Orders o, OrderStatus os WHERE o.OrderStatusId = os.Id...
  8. mowog74

    Checking for new files in project

    If you're talking about checking within a single project, you can just click the Add Files button in VSS Explorer. The Add Files dialog only shows files from the project's working directory that aren't yet included in the project. Unfortunately I don't know of a way to scan several projects...
  9. mowog74

    How do I easily maintain separate Development and Production versions of project files?

    Here's a simple, and I think novel, method I came up with recently to deal with the issue of maintaining a development version of a website, while leaving the working production version intact until changes in development have been tested and are ready for rollout. It involves sharing the files...
  10. mowog74

    Long connect times over VPN

    I was originally using TCP/IP. Just a little while ago I created a new alias to the same server using named pipes as the protocol (wasn't sure if this would work over the VPN, but it did), which has shortened the login time just enough so that QA will connect without timing out. It still takes...
  11. mowog74

    Long connect times over VPN

    Some extra information: Both server & client are running win2K professional, and SQL version is 2000. VPN is win2k as well. Also, although login times have always been longish and sometimes have taken 2-3 tries for success, only today has it gotten to the point where i could not connect at all...
  12. mowog74

    Long connect times over VPN

    I'm using a VPN connection to develop and administer a SQL server database. When i connect using EM, the login process takes abnormally long (~20-30 seconds). This is only a minor annoyance in EM, but in query analyzer, even though i've set the login timeout to 30 seconds, the login attempt...
  13. mowog74

    Passing variables (URGENT)

    I believe that instead of just redirecting to the newacct3 page with this line: > Response.Redirect &quot;newacct3.asp&quot; You need to be submitting the form you've just created. You can do this by Response.Write-ing a snippet of javascript like the following: <SCRIPT> <!--...
  14. mowog74

    How can I access Scalable SQL data from VB/ASP?

    Apparently the DDFs already in place were ok, because the Pervasive ODBC driver is working just fine for my ASP pages. Since I am in fact just writing fairly simple reporting pages, and also since in the next few months we'll be upgrading to the current version of Solomon IV which uses a SQL...
  15. mowog74

    How can I access Scalable SQL data from VB/ASP?

    First let me apologize if this is posted in the wrong place. I'm trying to access my company's accounting data from both a VB app and ASP pages, and our accounting package is Solomon IV v2.06, which uses Scalable SQL, which I've found has some connection (?) to btrieve and/or pervasive.SQL. In...
  16. mowog74

    &quot;There is no server on port 80 at...&quot;

    I'm getting the &quot;Unable to open web project X. There is no server on port 80 at 'nnn.nnn.nnn.nnn' when trying to open a file on that server or create a new project. I'm trying the work-from-home thing connecting to the LAN at work over VPN, and was having no trouble until I installed a...

Part and Inventory Search

Back
Top