Search results for query: *

Hi, I previously used an XP computer on the domain wth a name like 'mylaptop'. I replaced the drive and have Windows 7 Ultimate installed and am unable to join the computer 'mylaptop' to the domain. I've done these things... 1. Ran NSLOOKUP to verify I can see the domain controller 2...

Hi, I was able to configure the Content Editor Web part in SPS2003 to display Visio diagrams using Microsoft's vviewer.exe and the follwing code. However, I can't seem to figure out the proper clsid for Excel to do the same with Microsoft's xlviewer.exe. I used the clsid I found in the registry...

Hi, Is there a way to create a gantt chart that automatically updates the diagrams based upon changes to the source (such as Excel Spreadsheet)? Thanks,

Hi, Is there a way for Visio to import data from a MS Excel Web Query (.iqy) source? I can go from .iqy --> .xls --> Visio Gantt, but I'm trying to cut out a step. Thanks,

Hi, I just found this forum after I posted to the SPS forum. Please excuse the cross-posting. I have an demo Project Server 2003 install that is pointing to a live SPS2003 server. I initially pointed project server to portal1/sites/. However, after I found that all sites autocreated on the...

Hi, I have an demo Project Server 2003 install that is pointing to a live SPS2003 server. I initially pointed project server to portal1/sites/. However, after I found that all sites autocreated on the portal1 could not be nested (exist flat under the 'sites' area, I created a new 'portalB'...

Hi, I have a script that no longer works with Outlook 2003. Used to work before the upgrade. Has MS changed the object model for Outlook 2003? I get a "Variable is undefined: 'olMailItem'" Sub SendMailOutlook(aTo, Subject, TextBody, aFrom, aAttachment) 'Create an Outlook object Dim...

Hi, We're running SPS2003 on WinXP2003. The users have Office XP on Windows 2000. If a user checks out and edits a shared document (in a services site document libarary), checks it in, and then views it the previous version is displayed. If the user quits IE and returns, after checkin, the...

Hi, Is there a way to build a formula using the Excel range.offset function? My experiments so far have created a formula like... =123+456 Instead of what I want... =B4+B7 I need to return a column/row reference instead of the value in the cell. Since I'm building the spreadsheet...

Hi, I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB drives and Windows Server 2003 sp1. I'm running a fairly simple stored proc and I get the following error: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State...

Hi, I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB drives and Windows Server 2003 sp1. I'm running a fairly simple stored proc and I get the following error: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State...

Hi, We have many SQL2k servers and need to change userid/passwords for several systems level accounts. Some reports may have the userids embedded into the reports. Is there a way to audit access to SQL server and identify not only the user id but the workstation that the request is coming from...

Hi, We have a user account that is used across the windows 2000 domain to start services, support linked servers (sql2k), and handle other system wide processes. We need to be able to audit which workstations on the domain are using this account login...either manually or as part of a service...

Hi, I'm trying to use VBScript in DTS to convert a time string, with tenths of a second, to a sql 2k datetime value. The standard ISO format of "yyyy/mm/dd hh:mm:ss AM/PM" doesn't seem to support fractions of a second. Is there a way in DTS Active-X script to assign a string value...

Hi, I'm using Crystal 8.5 against SQL2k data. I have a number of call records. Group 1 is the date and group 2 is the calling number. I'm calculating the minutes of use per subscriber per day with a formula field. The @sub_billable_mins is a formula that sums the call seconds and divides by...

Hi, I'm running VB.NET on XP. I'm also connected to corporate with a VPN on DSL. When I try to open and run a solution/project it takes forever to load and run (sometimes 3 to 10 minutes). I see intermittent traffic on the VPN while it's trying to load (like VS is searching for something)...

Hi, I'm unable to display XML attributes in Crystal. Elements appear to work fine. When I create an XML ODBC connection and try to open it in Crystal it says there are no fields in the file. Is there something I need to do to the XML file to get Crystal to display attributes? Any adivce...

Hi, I'm unable to display XML attributes in Crystal. Elements appear to work fine. When I try to use an XML file with attributes an error reports there are no fields in the file. Any ideas? Any examples of how to format attributes in XML to be recognized by Crystal? Thanks for any...

Hi, I've been able to construct an XML file in vb.net and create a report in Crystal off the XML file. However, I've only been successful using elements. When I try to write the data to attributes Crystal barks and says there are no fields to display. When I display the attribute data in XML...

Hi, From the documentation it appears I should be able to display XML data in Crystal. The XML file is in a local directory. I tried to set up an ODBC connection, but it wants a login/password to configure. What's the purpose for the login/password and what do I feed it to make it happy? Do I...