Bisjom's Q&A profile

• SQL Server Conversion failed when converting the varchar value

  I keep receiving this error: Conversion failed when converting the varchar value 'INSERT INTO temp_tableZ (Customer_Category_Key, Item_Category_Key, Sales_Rep_Key, time_member_key, Revenue, Fiscal_Year ) select Customer_Category_Key, Item_Category_Key, Sales_Rep_Key, ' to data type int When running the code below. I believe the problem has something to do with the @time_member_key in the dynamically created SELECT statement. However, I don't understand the problem or how to fix it. Can anyone provide some advice thank you, Erik drop table temp_tableZ go create table temp_tableZ ( Customer_Category_Key INT NULL, Item_Category_Key INT NULL, Sales_Rep_Key INT NULL, Revenue money NULL, time_member_key ...Show All

• Windows Forms Maximum width of a panel

  I find that the maximum value I can assign to the width property of a panel is 32,767 which implies that the parameter is a type short and not int . I have tried in both the designer and at runtime. Does anyone know how to make a larger panel Obviously, for the wrong reason! My application includes the drawing of a "timeline" which shows some simple graphical objects that represent events. I wanted the user to be able to scroll the timeline and zoom in and out the time scale. The technique that I used to do this was to put a large (in width) panel (double buffered) inside a fixed size panel which was scrollable. I would draw the entire timeline on the first panel and use the containing ...Show All

• Visual C# How can I prevent usercontrols from all projects loading into the toolbox?

  I have made a few tries at googling for this, with no luck. The problem is that we have a large solution with dozens of projects, most containing 1 - 3 usercontrols. Every time I open the Toolbox, every project displays on its own tab. Each tab is open to show an item for each usercontrol. This not only takes a long time to load, but it makes it difficult to find the tabs I actually want to use. I have tried removing most of the tabs from the Toolbox, but it doesn't seem to stick. After I once close both the Toolbox and the solution, the very next time I open the Toolbox, it again brings up an open tab for every project. I guess what I really need is a quick easy way to put the control or component I need on a form (if there is a ...Show All

• .NET Development Microsoft SQL and MySQL servers

  Hello, I have an application which connects to a Microsoft SQL Server 2005 database. After a recent company merger 2 MySQL Servers were acquired. The company has no plans to upgrade the MySQL Servers to Microsoft SQL Servers any time soon. I have been instructed to make changes to my application to make it work with both Microsoft SQL 2005 and MySQL (MySQL will be used for backup in the event of a primary server failure). My application uses a normal connection string and uses normal INSERT UPDATE DELETE commands with Parameters being used to mitigate injection attacks. There are no stored procedures used at all. Will I need to make any changes and if so, what sort of changes will I need to make. I have never programmed for a MySQL Ser ...Show All

• Windows Live Developer Forums MapControl.Features documentation?

  In this thread , I have notice of MapControl.Features... I have not found documentation on this subject in SDK. Where I can find documentation about MapControl.Features Thanks in advance! Alex That thread provides a nifty hack for tweaking the map. It is not documented because it is not a supported hack. Basically, with any javascript you find on the Web, if you are clever enough and spend enough time, you can read through it and do all sorts of things (hacks). In the case of the VE Map control, we document the stuff that is supported. Everything else is considered unsupported, which means it might break in the next release of the control. If we rename the MapControl.Features object in the next release, for example, this trick wi ...Show All

• SQL Server Trouble installing sql express

  Hi, I was trying to install visual studio 2005 and as part of it I wanted to install sql express as well. It installed the rest okay but not the sql express. Going through the log file I figured out that there was some incompatible beta version installed and hence had to be removed. In the log file I got the following error messages. Going through the forum suggestion I was trying to use msiexec /x to deinstall each of them but got the error message that "The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is unable to write property into cache: flagCommit. Unable to write property into cache: "flagCommit" XmiRW Error: Failure loading xmlrw.dll CheckAllProcedures. returne ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Why do commas, periods count as separate words?

  I'm using the Direct3D Font object to draw a paragraph of text to the screen, and I'm finding that for some reason the lines don't break on punctuation like they should... // _msg = the string to draw, _size is a vector2, x/y are integers _font.DrawText(null, _msg, new Rectangle(_x, _y, (int)_size.X, (int)_size.Y), D3D.DrawTextFormat.Left | D3D.DrawTextFormat.WordBreak, _shadowColor); It beats me why this is happening, but i get the following kind of line break: Joey went to the store , and then he realized that this line starts with a comma. Standard line breaking suggests that either the comma should appear right after the word "store", or else the entire word "store" should appear on the next line, with ...Show All

• Windows Live Developer Forums MS VB Run Time Error 429

  Hello List, I hope you can assist me with a problem I created. I have a problem, I think, due to having an ADCenter.dll assembly out of synch with what is found in the system registry. This is based on the help text for the ActiveX component error, my application is throwing. I had to recreate this .dll and .tlb in order to modify the password hardcoded in the below routine. Private Sub SetAuthCredentials(ByRef pAPI As AdCenterAPI) We integrate the XML response from the web service into a Excel spreadsheet, and I believe that this the problem. The VB project contains a reference to the ADCenter, and is included into our Excel macros. The error is found within the following code block Public Sub MSNRequestReport(ByVal AccountID As Long, ...Show All

• Visual C++ executing a program

  How can I execute a program with Visual C++ Hi Fighter92, Did i get ur problem correctly and give u the right solution If not , could u post the question bit elaborated once again Thanx, Ch.T.Gopi Kumar. ...Show All

• .NET Development Asp.net application

  In asp.net apllication I face some problem ,That is i am getting some datas from sqlserver database.sometimes I can't get the datas from database.if I recycle the IISApplication pool of domain where I host my application.after that I can get the datas form database.what is the problem there ...... Code for Database connection In Global.asax: Application( "ConnectionPath" ) = "Data Source=gfh.;Initial Catalog=;User ID=hcllive;Password=dsfy;Max Pool Size=100;Min Pool Size=1;Pooling=false;Connect Timeout=120;"  if I set the pooling=true in above coding ,again I am getting the same problem.             Why is poolin ...Show All

• Visual Studio Team System Plans for sharing project amongst team

  Hello, I just tried importing my work database schema of tens of thousands of objects which went through within minutes, so well done on making the import a lot faster! I was curious as to whether a question I asked a while back has been reviewed. Basically I would really like our team to use data dude for our development, however we all have Team Developer licences (bar a couple of us who have Team Suite licences) and upgrading everyone to Team Suite or switching everyone to DBPro is not an option. All developers develop their own stored procedures, we have no 'Database Professional'. Therefore in order for us to use data dude projects, we would like to know if the scenario below is possible: 1) We have one designated 'Database Prof ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MipMaps

  Hi all Somebody knows where I can find some mipmapping tutorials I'm trying this: texture = content.Load< Texture2D >( "tx" ); Where tx is an asset loaded with de "Texture (mipmapped)" processor. When it loads has 9 levels. Then, in the draw call I do: effect.Texture = texture; Where effect is and object of BasicEffect class The texture is From wikipedia The result is the entire texture drawing. I think that hardware must select the level to draw. Can anyone help me There are not any specific mipmap tutorials becuase as previolsy stated you do not do anything to use them. Mipmaps are prescaled versions of your textures that are chosen by the ha ...Show All

• Visual C++ It appears that C++ developers are abandoned in VS2005.

  As a long time C++ developer, I just recently migrated from 6.0 to 2005. There was a learning curve to get used to the 2005 interface but even after that learning curve, it seems that the 2005 interface was designed without C++ developers in mind. RAD development requires high performing tools, 2005 is not a high performing tool, it is a tool that tries to do too much and is good at very little. A couple of observations, The IDE is extremely slow compared to 6.0, if you want to create a new .cpp in 6.0 you went file->new then file->save as (FILE name). In 2005, you do add new c++ file to system, wait 30 - 60 seconds and then you have a cheap dialog that prompts you for what file type you want. Intellisense broken, with large pr ...Show All

• Smart Device Development Determining if network is available...

  In the article here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetcomp/html/NetworkComponent.asp There is the following code snippet: Public Shared ReadOnly Property Connected() As Boolean Get Dim ret As Boolean Try ' Returns the Device Name Dim HostName As String = Dns.GetHostName() Dim thisHost As IPHostEntry = Dns.GetHostByName(HostName) Dim thisIpAddr As String = thisHost.AddressList(0).ToString ret = thisIpAddr <> _ Net.IPAddress.Parse("127.0.0.1").ToString() Catch ex As Exception Return False End Try Return ret End Get End Property Why do you only have to compare against the IP address in the 0 index. What if ther ...Show All

• SQL Server problem with analysis server connection string

  i have just installed a new version of analysis services 2000 on a test machine. when i try to connect to the local host i get the error "Datasource name is too long". I have set the datasource string to Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\MsOLAPRepository$\msmdrep.mdb This is the same string as i have on other analysis servers, bar the server name, but it still does not work. any ideas The olap service is running correctly, just in case its a detail you need to know. I assume you use Analysis Manager or DSO program to connect, and you change the "Repository Connection String" property from Analysis Manager. Can you check whether you can open msmdr ...Show All