LopuX's Q&A profile

• SQL Server Why the Text property of DefaultConstraint is enclosed in (())?

  Can anyone please explain why DefaultConstraint.Text value is enclosed in (()) For example, I set the Default value for a smallint column to 55. When I display it using  oColumn.DefaultConstraint.Text it is displayed as ((55)) Regards, Joginder Nahil www.starprint2000.com       What's going on here is that the server first needs to look at your default value definition to make sure it makes sense. At that point it has the definition in an internal format, rather than the text you entered, so before we store a text form of the constraint, we have to call a general purpose function for converting our i ...Show All

• SQL Server Printing report produces .25 inch horizontal offset

  When I print my report to the printer it is not centered correctly.  It is offset around .25" (or more) to the right.  I have my page setup as 8.5" x 11".  I have all my margins set to 0.5".  My body is exactly 7.5" x 5".  When I export to pdf everything is centered.  When I view the report in the 'print preview' type view it is centered.  However, when I actually print it is offset.  I measured the output with a ruler, the actual report is still 7.5", it just that there is a bigger margin on the left end and a smaller one of the right end!  The page setup seems correct, I'm going crazy here.  ...Show All

• SQL Server SQL Server 2005 JDBC Driver 1.0 error in using XA datasource

  We are in the process of configuring a j2ee application with SQL Server 2005. We have downloaded the new version of SQL Server 2005 Java Database Connectivity (JDBC) Driver 1.0. We are having some issues in getting it to work using the XA datasource. Description of the error is as follows: javax.transaction.xa.XAException: java.sql.SQLException: Failed to create the XA control connection. Error: Could not find stored procedure 'master..xp_sqljdbc_xa_init'.. at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(Unknown Source) Has anyone else has encountered this and possibly found a solution. Regards, Bindu ...Show All

• Visual C++ How to build unmanaged windows forms?

  Hii.. i am new in c++, i have learned c# and vb .net but i want to have unmanaged exe so that can run at any machine without the .net framework.. to build an unmanaged console using c++ is easy but now i want an easy way to build unmanaged exe in c++ with easy way to design windows forms.. i knew that i can select a windows application from .net category in c++ .net but the output will also be managed .. so if i changed the unmanaged extensions to NO from the project proberties will give a native exe or i can only have managed exe if i chose one of the .net projects in c++ .net so please help me!! and i heard about some applications that ...Show All

• .NET Development just in time debugger

  Hello, we run a nighlty testsuite of hundreds of console applications, and if such an application crashes, it shall simply die and not create a popup window asking what program to use as JIT debugger. I unmarked Tools->Options->Debugging->Just-In-Time Debugging in VC8 and VC 2003. I run drwtsn32.exe -i so that the registry entries for Aedebug are set. I then get a popupwindow that the unhandled exception cannot be forwarded to a debugger: "No installed debugger has Just-In-Time debugging enabled". It is not a VC8 problem as it works as expected on XP32 Thanks in advance, andreas . In case of native application the i ...Show All

• SQL Server SQL Server 7.0 with SQL Server 2005

  I have SQL Server 7.0 and SQL Server 2005 installed on the same machine. When i try to backup SQL Server 7.0 it gives me following error, can anybody help and explain me a resolution: "Backup or restore operation terminating abnormally" I read from one of the KB articles on MSDN that when SQL Server 7.0 and SQL Server 2000 exist on the same machine this error comes and there is a work around for that. This is explained here: http://support.microsoft.com/kb/q280759/ Is there any similar workaround for SQL Server 2005 also. Please let me know. The error, -2139684854 = 0x 8077000A indicates a memory allocation fa ...Show All

• Smart Device Development database and Application on MicrosoftR Windows Mobile? 2003 Second Edition

  Hi, I hope to ask a mobile device, whose platform is MicrosoftR Windows Mobile 2003 Second Edition, to connect with a database on a PC. The PC's name and the sql Server's name are both "sql123". The following is my codes. But I get the following error: "Specified SQL server not found: sql123." Could anyone help me out Thanks in advance. The codes: Private Sub ReadOrderData() Dim strConnection As String = "Server=sql123;UID=sa;database=AdventureWorks" Dim queryString As String = "select * from Person.Address where AddressID < '10'" Using connection As Ne ...Show All

• Windows Forms Strongly-typed access to a resources (satellite assemblies) .dll from other projects?

  I can't figure out if it is possible, (using VS 2005 and .Net 2.0), to get strongly-typed access (including IntelliSense at design-time) to resources stored in a seperate .dll. Our project has about 5 seperate executable programs. Each has it's own VS Project. Many of the resources (strings and icons) need to be shared between these Projects, and they need globalization/localization. We have an assembly consisting of a single resources.resx file, which compiles into CoName.Applications.MyAppsGroup.Resources.dll. We also have a couple of Satellite Assemblies that translate many of the resources in the Neutral Culture .dll I can include ...Show All

• SQL Server Forcing Users to log out of SQL 2000

  I am a begginer to SQL. I am truly limited with SQL language. Every month we have to do a month end closing for our company. In order for us to do this we need to get everyone off the database to proceed. This process is horrible and generally takes at least 1/2hr to 45 min. to do so. i am looking for a command that i can use in query analyzer if possible to force the users out of the database. if that isnt an option can you recommend another program in which i can do this. i am at a loss and need some help..... thanks ok thank you i will try this at the end of the month i do appriciate your time!! ...Show All

• Visual Studio Team System Another event log error

  Is there any reason I get this error in the System event log Event ID: 10016 User: NT AUTHORITY\NETWORK SERVICE The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {BA126AD1-2166-11D1-B1D0-00805FC1270E} to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool. The CLSID you referenced is the GUID for the Netman. These pages may offer some assistance: http://www.tek-tips.com/viewthread.cfm qid=1042889&page=10 htt ...Show All

• SQL Server Date/time field accessing

  I am at the begin with SQL-server, so for the begin i want to test the value of a datetime field in a table. For example if the content of the field named "danast" is equal with '02.01.1983'. In the documentation witch I've downloaded for SQL-server are explained many things but i did not find any example for a comparation of this type. I've tried such a comparation also in MSAccess (danast=#02.01.1983#) and in C++ (on a ODBC connection at a MSAccess database) and I received errors. My experience with SQL language is limited at 6-7 years with Oracle and FoxPro but in those programs exists explicit convertion functions from string t ...Show All

• Software Development for Windows Vista Is the window class DV2ControlHost only for Start Menu?

  Hi members forums, I’m looking the windows classes that a common user activates, and found when activates the start menu appears a window class called DV2ControlHost, Is this only for Start Menu or there are other windows of the same class, and why , thanks Do not rely on the window class names. They are internal and can change at any time. ...Show All

• SQL Server How can I script object data in SMO?

  Hi could somebody give a suggestion or post some example on how I can script table Data Suppose I have a Customer Table I need to produce something like : INSERT INTO [dbo].[Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES('ALFKI', 'Alfreds Futterkiste', 'Maria Anders', 'Sales Representative', 'Obere Str. 57', 'Berlin', null, '12209', 'Germany', '030-0074321', '030-0076545') INSERT INTO [dbo].[Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [ ...Show All

• Smart Device Development What happens when you hit the 32 Process Limit

  Does a message come up, does the device explode ;) Thanks! ...Show All

• SQL Server creating access database with tables fail in SSIS package

    I'm writing a package for SSIS and need to create a destination access database with a table on the fly. I've tried the code below - whcih works to create a database - but it doesn't create a table in that database to send data to. Instead of tbl.Parentcatalog = cat I've also used cat.Tables.Append(tbl) but this fails with a type problem. What is going wrong here private static void CreateDatabase( string currentDirectory) { if (! File .Exists(currentDirectory + DESTINATIONNAME)) { // Create Database ADOX. Catalog cat = new ADOX. CatalogClass (); cat.Create( "Provider=Microsoft.Jet.OLEDB.4.0; ...Show All