Answer Questions
Yogesh Kumar Dhiman Adding SDF data into a Listview - C#
Hello everyone, I finally got the SDF file on my pocket pc, and now am having trouble loading the data into the listview. I am not sure where I am going wrong, but the code is listed below. Any ideas Thanks so much, everyone. private void LoadList( string szSQL) { // Clear out anything that might already be in the list CollectionList.Items.Clear(); // save off the SQL Statement m_szCurrFilter = szSQL; ...Show All
ed dolan Scripting objects.
in 2000 I used OleAutomation objects to script database objects. In 2005 I run into a weirdness trying to use the same.. (example: varchar(MAX) is scripted as varchar(-1) which is the value in sys.columns, but the script will fail if you try to run it). I'm trying to write a C# proc to do the scripting. Unfortunately, I'm not a C# programmer -- and I'm having a lot of trouble finding documentation on scripting objects. If anyone can point m ...Show All
GregV Quick Question Importing
Two Quick Question's, Are you better off importing data through Excel or through Text files in terms of ease of use \ Speed \ Efficency etc or does it make a differance Also if I am loading data into a SQL database should I always use the "SQL Server Destination" rather than the "OLE DB Destination" Hope Q's aren't too basic, both seem to work for me, but I just want to make sure im using the right one. Thank you ...Show All
Windust SSIS Access from SQL Server Management Studio
I am trying to develop a package using SSIS to get rid of Informatica. But I am not able to connect to the SSIS from the SQL Server Management Studio. The error message is 'Connect to SSIS Service on machine XXXXX failed: Access denied'. I am using Windows authentication and I am in the DTSADMIN role. I have 'dbo' privileges in all the databases in the Server where the SSIS Service is running (Yes, I checked and the SSIS Service is running). ...Show All
campo Full Text Issues
Hi i am really new to full text searching, I have created a catalog using: sp_fulltext_catalog 'textcatalog','create' and now i want to add a table with: sp_fulltext_table 'Product', 'create','textcatalog', 'ProductID' where product is a table in my database and productID is the primary key to that table. The primary key cannot be null, But i get an error: 'ProductID' is not a valid index to enforce a full-text search key. You must specify a u ...Show All
clint440 error on server
TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer2005 . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta ...Show All
Geci WMI Configuration error on install of Sept CTP
I get the following error in the when I run setup of the sept CTP. The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine RICHJ Error:2148007941 (0x80080005). The checkResult returned is 2148007941 I also tried running all of these: Mofcomp.exe %windir%\system32\wbem\cimwin32.mof Regsvr32 wbemupgd.dll regsvr32 wbemsvc.dll But I still get the same error. Anyone have any ideas Thanks Rich ...Show All
bktan DTC problem with Linked servers between SQL2k and MSDE
Hi, can someone help me on this I have two servers linked with each others - ServerA and ServerB. ServerA located in trust area while ServerB located in DMZ behind firewall. I am able to run query from both servers without performance issue. However, when I start using BEGIN TRAN or BEGIN DISTRIBUTED TRAN, it always return the following error: Server: Msg 7391, Level 16, State 1, Line 4 The operation could not be performed because t ...Show All
Josh Bernard SqlServer2005 can support merge replication with SqlCe2.0??
Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. ...Show All
Harris Sayed attempted to divide by zero
hi, i had this formula written for a textbox in a table, but yet still encounter the following error: expression: =iif(countdistinct(Fields!room.Value)=0,0, sum(Fields!rate.Value)/countdistinct(Fields!room.Value)) error: attempted to divide by zero. any way i can solve this problem thanks! HI Everyone, I generally use the following statement =IIF(Fields!Profit.Value<> ...Show All
Rick_Parker using WriteNotifyEventHandler with tracefiles
I've a fined tuned trace running that outputs the result to a tracefile. Currently I'm using the TraceTable class to read back the trace, which works fine. However I'm trying to use the WriteNotify event to react when this file changes, but it never appears to fire. I'm using the beta2 of SQL 2005, does this work in it Would anyone having a working example if it does Thanks, Cathal Cathal, First of all, I ass ...Show All
danb2005 Pass a Parameter into a textbox on a report?
I have a report that is unsing a multi-value parameter selection list. Based on the parameter I select, I would like to display the selection in a textbox directly on the report. Would someone know what statement I place into the textbox to capture the parameter: Some details: 'read_perflvl' is the data field in the original database. 'perflvl' is the name of my report parameter. I dropped the 'read_perflvl' field into the text box on my r ...Show All
dnilepharaoh How to dynamically change width?
Folks, We have some reports that have optional columns. We have them working very nicely, with the column showing or hiding based on values in the report -- works great. Except -- when the columns are present, the report spans onto two pages, when exported to PDF, in width. That's understandable, as there's a lot of extra data, and exactly what we want. However, when the columns are not present, we get empty pages instead, beca ...Show All
Gardini DBSTATUS_UNAVAILABLE with OLEDB Command
Hello, I have an issue with the OLEDB Command in a package of mine where it used to work and now it doesn't. I had 4 different packages where I was bringing in a flat file, massaging the data, and calling 1 of 4 Stored procedures using the OLEDB Command. Everything was working great, then we decided to use the SSIS EBCDIC conversion in the flat file connection rather than converting to ASCII outside of SSIS. This w ...Show All
eKoast Is XmlTextReader marked with HPA
Hi all, I want to know if the System.Xml.XmlTextReader is marked with Host Protection Attributes(HPA) in the SQL Server 2005 CLR. I ask this because when I add a custom class that inherits from System.Xml.XmlTextReader, I get a code access security error at runtime. I am able to register the assembly just fine. I have tested it with all the cases and pretty much sure my code breaks in this class. My code snippet is shown below: public ...Show All