Search results for query: *

Hi All, I am looking at attending the Kimball University class: ‘Data Warehouse Lifecycle in Depth’ and would like comments from anyone who has attended a Kimball University class. Last year, I attended the TDWI world conference in Las Vegas and was impressed with the quality. This year I...

By the way, Microsoft Knowledge base article - 287932 "TCP Ports Needed for Communication to SQL Server through a Firewall", gives a good description of the communication process of sql server and the use of ports for both single and multiple instance setups.

Well it turned out to be the port. My instance was not using the default (1433) port, once the client DSN and firewall were set to communicate on the correct port then my login worked. I appreciate your tips -- I've learned several new things about sql server. All the Best, Mike

Rob, SQLBill, Thanks for the tips. I am using SQL authentication. The sql server that I want to connect to is one of 3 instances on the machine. I can connect to the localhost instance but can't to the desired instance. Yesterday I finally figured out that the localhost was assigned to...

Apologies, I re-read my post -- I wasn't very specific. I'm not making an ASP connection. Simply trying to set up a system DSN from within: Administrative tools --> Data Sources (ODBC). My 'web server' as i called it, is a Win2000 box with Cognos tools that need to read data from the sql...

I have a sql server 2000 installation on a Win2003 server. I am trying to connect via ODBC from my web server (a Win2000 box). I get error message: " Login failed for user '<username>' ". I think the trouble is that the web server sits outside the domain from where the ss2k is installed. I...

Reebo - Crystal User manual states that only one data source is allowed when using a query file as the data source. I tried anyway - but wasn't able to use that method. For now it looks like there is not a way to issue my SET Role statement.

synapsevampire - crystal reports 8.5 developer ed. with Informix database Thanks for the response -- I wouldn't use SQL Designer by choice, but I am trying to accomodate our DBA and his security concerns. I believe a UNION could combine two of my SQL statements into one, but that won't solve...

Using: Crystal Reports 8.5 with Informix database I want the Crystal SQL Designer to issue 2 or 3 separate SQL statements against my database. From what I can tell SQL Designer can only handle one SQL statement, is there a work around? My first statement will be to set the user role to read...

Hello, using: CR v8.5(dev) with SQL Server7.0 I would like to graph the contribution toward each month's total Units Sold by individual product line. I need my x-axis to change on date (&quot;for each month&quot;) and the y-axis to show the &quot;market share&quot; of the months total...

I am looking for a method to find all records of those who &quot;qualified&quot; for 3 or more CONSECUTIVE months. If an employee &quot;qualified&quot; in a particular month there will be a record in the table with the month and their ID. If they did not qualify--no record. MyTable: ID...

Ken, Your method works great! Thanks for your response, it is very helpful. One note: The order the fields appear in the IF ...Else must be considered, or a conversion of datatype needs to be used. If {?SortField} = &quot;UnitsSold&quot; Then {SalesUSA.OrderQuantity} Else...

Using SQL Server 7.0 and CRv 8.5 My report is grouped by a product Number (i.e. the left 4 characters of [SalesUSA].item). I want the sort order as a parameter field. My problem, as far as I can tell, is the two fields I want to sort on are summary fields. Creating the formula field below...

Access 2000 I'm looking for a routine to remove spaces in a text field. Example: 52 36 89 becomes 523689. The spaces do appear in the same place in each record. I'm familiar with the basics of SQL, but no other languages. Thanks in advance for any help you can offer.