Guy Pilk's Q&A profile

• SQL Server BOL Package example Errors

  Hi There Ok i realize this may not be exactly the correct place to post this, but i seem to get good advice here. I am trying to follow the SMO Tables DBCC Package Sample in BOL. I have copied the Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SmoEnum.dll to my latest .NET Framework folder as specified in BOL example. Problem is when i try to run the package i get the following error: -------------------------------------------------------- ...Show All

• SQL Server ODBC Data Source

  I am new to SSIS packages and want to use an ODBC data source connected to an old Btrieve set of data files. I set up the ODBC DSN, and my SQL Server Data Connection, and can browse the tables in the Server Explorer. However with regards to my SSIS package, I'm not sure whether to use an OLE DB Source or Data Reader Source. I have futzed with both of them but haven't had any luck at seeing the tables. Can someone please give me some tips. Tha ...Show All

• Smart Device Development How to play MPEG File ?

  Hi, I'm able to play a .WAV file in the Pocket PC using C#, by using pinvoke method. In which i 've imported the "coredll", and then PlaySound() function. Like this, is there any ways to play an MPEG file or Even the other ways like streaming of MPEG file Plz give me suggestions as soon as possible. Thanks, ramakrishna. to play a wave file: http://msdn2.microsoft.com/en-us/library/ms229685.aspx ...Show All

• Visual Studio Adding Files (Doc, xls, ...) to a Project a a folder of a sourcesafe database through the Internet Access plugin.

  Hi all, i'd like to know if someone could tell me how to add files to a folder of a vss db through the internet access. Thx Internet access is supported only through Visual Studio. If this is what you'd like to do then you can add those files to your project and then check them in. ...Show All

• Windows Forms Determine loading completed

  Is there anyway that I can determine whether a loading is completed. I've a textbox which has a initial text string. What I'm going to do is to make it invisible when user change its text. However, I found that the initial text string assignment has already trigger the event of making the textbox invisible. So, I would like to know is there anyway that I can check whether the loading is completed or not and add this code into the event handle ...Show All

• SQL Server Assembly Clash between June and July CTP in VS.NET/SQL Express

  Hi!  How do I upgrade the assemblies in a databases between the Framework that came in VS.NET June CTP and VS.NET July CTP.  I've created a fairly extensive database in the former which I'd like to use in the later.  All of the non-CLR stuff seems to be accessible just fine.  Unfortunately I no longer have the June CTP installed and the assemblies are running into versioning problems.  I'd be happy to delete the offendin ...Show All

• Visual C++ Changing the Console Text Color

  I've come across an issue that I'm sure I can solve if I could change the console text colors at runtime.  I've spent a couple of nights trying to find something online but all I've learned is that you can do it in C#.  I still havent found one source that tells me how to do it in C++.   Any help will be greatly appreciated.  I have .net 2003 ----------------------------------------------------  ...Show All

• Visual Studio Express Editions NewLine in a TextBox

  I have a text box on a form that im appending text to. How do i put a new line in. Code: Textbox1.AppendText("blah") I want to put a Return before and make it its own line. You made a mistake in the command. You should use Environment.NewLine instead of Enviroment.NewLine (missing the 'n'). Grtz, Tom. ...Show All

• Windows Forms App icon

  Hi,  I'm creating my 1st winform .NET app & have some problems with it (it'd be strange if I hadn't  :)  )   During creating new app under VS there is default app.ico icon file. I've altered it to my needs & informed&nbs ...Show All

• SQL Server New RDL Spec differences

  Is there somewhere that explains the major differences between the 2003 RDL spec and the new one released in November I will be going through the two specs in detail in January looking at the differences but I was just wondering if there's a quick synopsis out there somewhere. Are there any major differences Darren I guess I'll answer my own post in case anyone else out there is interested.   F ...Show All

• Visual Basic Interesting Calculations

  Hello everyone, I have a interesting problem. I'm trying to calculate how many pallets, boxes and units I need out of a ordered number of pieces. Let's clarify this by an example: I need 6852 pieces in total: (I keep this info in a database, so this info is available for use) * 1 pallet = 4000 pieces (20 boxes) * 1 box = 200 pieces * 1 unit = 1 piece The goal is to calculate how many pallets, how many boxes and ...Show All

• SQL Server Populating and passing multi-value param from a url

  I have a rs report with a parameter(named Site) that is defined as multi-value. What I am trying to do is call the report from an html form with the parameter populated with a comma seperated list of values. The html code is a minimally modified version of the code found in ch. 11 of the hitchhikers guide(code included below after the solid line). If I don't select any items, then execution is fine.  When ...Show All

• SQL Server Changing ports sql 2005 listens on.

  Menu chain on sql 2005 standard server side: "Sql Server Configuration Manager"> "Sql Server 2005 Network Configuration"> "Protocols for MSSQLSERVER"> "IP Addresses" tab> Changed the IP1, TCP Port (didn't change IPAll, whatever that is used for) Stopped/restarted sql server Client side: "Sql Server Configuration Manager"> "Sql Native Client Configu ...Show All

• Visual Studio Tools for Office VSTO 2005 Hands on Excel Lab Problems

  I'm having some trouble with trying to run through the Hands-on Labs for Excel 2003 which I downloaded from the MS VSTO 2005 site. Not sure if my problem is an installation problem with VSTO 2005, VS 2005 or Excel 2003. I can create the Hands-on project using the Excel Workbook template. However when I run the project in Debug mode I receive the following error message. Problem #1: A call to PInvoke function 'WRDomainSetup!WRDomainSetup ...Show All

• Visual C++ Checkbox problem

  I have a simple dialog box with a check box. When the checkbox is clicked I intercept the click in the message procedure and attempt to get the current state, however the call only ever returns 0 i.e. unchecked. Here is the call I am using, any ideas why this might be happening int PRINTER_CONNECTED = (int)SendMessage(hwndPrinterConnected, BM_GETCHECK, 0, 0); Thanks in advance, Mark Coleman ...Show All