I'm getting the error message "The parameter is incorrect" when I'm trying to perform "Show Table Data" from the SQL Server Compact Edition" within VS 2008. Any ideas? Thank you in advance,
.
I linked an SQL server table into Access, but when I open the table in Access, no data shows. Do I need to set some permissions on the sql table?
View 1 Replies View RelatedThis is my first attempt to use SQL Server Compact with Visual Studio 2005.
I wrote a program for Inventory Scaning which requires the database to be stored on an SD Card. As long as the device is left powered on, the programs function normally. However, if the device powers off and is then turned back on the 0xC0000005 error is displayed when the program attempts to do anything with the SQL Connection.
I have also written a small sample program to test and the results are repeatable each time.
The sample program consists of a single form with six buttons (Create Database, Open Database, Insert Records, Delete Records, Close Database, Dispose Database).
Both programs are written in VB.
Here is the code for the sample program.
Public Class frmSQLTest
Private cnDB As System.Data.SqlServerCe.SqlCeConnection
Private connString As String
Private Sub frmSQLTest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.txtDB.Text = "Storage CardTest.sdf"
End Sub
Private Sub txtDB_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtDB.LostFocus
connString = "Data Source=" & Me.txtDB.Text
Me.txtStatus.Text = "Connection String Set"
End Sub
Private Sub btnCreate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreate.Click
If Me.txtDB.Text = Nothing Then
MessageBox.Show("Unable to Create Database")
Exit Sub
End If
Dim eng As New System.Data.SqlServerCe.SqlCeEngine(connString)
eng.CreateDatabase()
eng = Nothing
Me.txtStatus.Text = "Database Created"
End Sub
Private Sub btnOpenDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpenDB.Click
Dim sqlDB As New System.Data.SqlServerCe.SqlCeCommand
If cnDB Is Nothing Then
cnDB = New System.Data.SqlServerCe.SqlCeConnection(connString)
End If
cnDB.Open()
Me.txtStatus.Text = "Database Opened"
sqlDB.Connection = cnDB
sqlDB.CommandText = "CREATE TABLE Master (Item nvarchar(12), Description nvarchar(19))"
sqlDB.ExecuteNonQuery()
sqlDB.CommandText = "CREATE INDEX idx_Master on Master (Item)"
sqlDB.ExecuteNonQuery()
Me.txtStatus.Text = "Master Table Created"
sqlDB = Nothing
End Sub
Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click
Dim RecCount As Long
Dim sqlDB As New System.Data.SqlServerCe.SqlCeCommand
sqlDB.Connection = cnDB
For RecCount = 1 To Me.nudRecs.Value
sqlDB.CommandText = "INSERT INTO Master ([Item], [Description]) " _
& "VALUES ('" & RecCount.ToString & "','Test Item " & RecCount.ToString & "')"
sqlDB.ExecuteNonQuery()
If RecCount Mod 100 = 0 Then
Me.txtStatus.Text = "Updating Record..." & RecCount.ToString
End If
Next
Me.txtStatus.Text = "Records Inserted"
sqlDB = Nothing
End Sub
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Dim sqlDB As New System.Data.SqlServerCe.SqlCeCommand
sqlDB.Connection = cnDB
sqlDB.CommandText = "Delete FROM Master"
Me.txtStatus.Text = "Master Table Cleared"
sqlDB = Nothing
End Sub
Private Sub btnCloseDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCloseDB.Click
cnDB.Close()
Me.txtStatus.Text = "Database Closed"
End Sub
Private Sub btnDispose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDispose.Click
cnDB = Nothing
System.IO.File.Delete(Me.txtDB.Text)
Me.txtStatus.Text = "Database Diposed"
End Sub
End Class
In my tests, I start the program (loaded on the Storage Card in the same directory as the database). SQL Server Compact is also installed on the SD Card to save space in Main Memory.
Steps to Re-Create the Error:
1. Click the Create Database button. Database is created properly.
2. Click the Open Database button. Database connection opens properly.
3. Click the Insert Records button. Records are inserted into the table properly.
4. Turn off the Symbol MC3000 unit.
5. Turn the unit back on.
6. When I click on any of the following buttons, the error is displayed. Close Database, Insert Records, Delete Records.
I have also tried closing the database (as well as closing and disposing the database) prior to step 4 above, but when I try to re-open the database (or create the database) again, the error displays.
Is there anyway to correct this issue?
With the real program, the database must be kept open as long as each form is open to prevent speed issues and the database must be stored on the SD Card since there is not enough storage space available on the device.
Hi,
I have tried to convert my SQL Server Express Database file to SQL Server Compact Edition database file and it successfully. But I have some problem with the FK, I could not see the FK symbol in my new SQL Server Compact Edition database file. So i tried another method to implement the FK which is this code of line here
ALTER TABLE EQMetaData ADD CONSTRAINT Reference FOREIGN KEY ([EQID]) REFERENCES Equipments ([ID])
The second method also has no error but I could not see any FK show. Does anyone has this problem? Any suggestion to solve it? Please do share with me.
Thanks,
Bombie
ps: I attached to sreen shots of my DB, 1 is (SQL Express DB) and another is SQL Compact DB.
http://www.fileden.com/files/2007/5/24/1109807/SQLExpress.png
http://www.fileden.com/files/2007/5/24/1109807/SQLCompactEdition.png
I have a simple table data i want want to show row data in to column data.
     Â
SELECT clblcode,mlblmsg
FROM warninglabels
My expected result will beÂ
0001Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 0002Â 0003Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 0004
-------Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ------- --------Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â --------
May Cause....       Important..... Take madi...........         Do Not Take.......
I have a table history of Employee data.
id | EmpNo | EmpName | MobileNo | Email | EmpSSS | UpdateDate | UpdateUser
I have to make a stored procedure that will show the history and changes made to a given EmpNo, with the UpdateDate, UpdateUser and indicate which field is modified. Ex. Employee Mobile number was changed from '134151235' to '23523657'.
Result must be:
EmpNo | UpdateDate | UpdateUser | Field changed | Change from | change to
I have a table with a datetime field 'TheDate'. Currently dates are stored as 'mm-dd-yyyy 00:00:00'. Is there a way to get just the month, day and year parts, '01/01/2008' into the field without changing the field data type to varchar? I'm asking because when I do this:
declare @MyDate as datetime
set @MyDate = '04/02/2008 18:00:00'
select substring(convert(varchar,@MyDate,101),1,10)
I get '04/02/2008', but when I do this:
update TheTable
set TheDate = substring(convert(varchar,TheDate,101),1,10)
I'm still getting a date in the format 'mm-dd-yyyy 00:00:00' stored in the table. I'd like to be able to lose the time portion, but I'd like to be able to keep the datetime datatype for date math purposes. Can it be done?
I am using the default ASPNETDB.MDF database for a project in SSE 2005 and VWD 2005. I need to use the UserName field from the aspnet_Users table as a foreign key in another table I have in the database. I am doing this so that I can grab data generated from additional fields that I'm adding to the membership registration wizard. However, I am obviously missing some steps since the user name doesn't show up in my second table. What should I do besides creating a relationship between the two fields and tables? Should I be writing some sort of SQL statement to accomplish this?
View 6 Replies View RelatedI can't install SQL 2005 Delveloper edition and show error with MSXML component
It shows these massage:
=== Verbose logging started: 6/11/2007 17:17:36 Build type: SHIP UNICODE 3.01.4000.4003 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (A8:90) [17:17:36:545]: Resetting cached policy values
MSI (c) (A8:90) [17:17:36:545]: Machine policy value 'Debug' is 0
MSI (c) (A8:90) [17:17:36:545]: ******* RunEngine:
******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
******* Action:
******* CommandLine: **********
MSI (c) (A8:90) [17:17:36:545]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (A8:90) [17:17:36:545]: Grabbed execution mutex.
MSI (c) (A8:90) [17:17:36:555]: Cloaking enabled.
MSI (c) (A8:90) [17:17:36:555]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (A8:90) [17:17:36:555]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:AC) [17:17:36:575]: Grabbed execution mutex.
MSI (s) (30:40) [17:17:36:575]: Resetting cached policy values
MSI (s) (30:40) [17:17:36:575]: Machine policy value 'Debug' is 0
MSI (s) (30:40) [17:17:36:575]: ******* RunEngine:
******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
******* Action:
******* CommandLine: **********
MSI (s) (30:40) [17:17:36:675]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:40) [17:17:36:906]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (30:40) [17:17:37:176]: File will have security applied from OpCode.
MSI (s) (30:40) [17:17:39:119]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: Verifying package --> '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi' against software restriction policy
MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi has a digital signature
MSI (s) (30:40) [17:17:41:702]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (30:40) [17:17:41:702]: End dialog not enabled
MSI (s) (30:40) [17:17:41:702]: Original package ==> \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
MSI (s) (30:40) [17:17:41:702]: Package we're running from ==> C:WINDOWSInstaller3afbb9.msi
MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'.
MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (30:40) [17:17:41:722]: MSCOREE already loaded, using loaded copy
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'TransformsSecure' is 0
MSI (s) (30:40) [17:17:41:732]: User policy value 'TransformsAtSource' is 0
MSI (s) (30:40) [17:17:41:732]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisablePatch' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'.
MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (30:40) [17:17:41:732]: Transforms are not secure.
MSI (s) (30:40) [17:17:41:732]: Command Line: STPSETUPTHREADID=3708 STPSETUPPROCESSID=424 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={982DB00A-9C4E-436B-8707-18E113BAA44C} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=424
MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{A60D52F8-FAAB-4544-AF65-EAC1A22E5435}'.
MSI (s) (30:40) [17:17:41:732]: Product Code passed to Engine.Initialize: ''
MSI (s) (30:40) [17:17:41:732]: Product Code from property table before transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'
MSI (s) (30:40) [17:17:41:732]: Product Code from property table after transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'
MSI (s) (30:40) [17:17:41:732]: Product not registered: beginning first-time install
MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (30:40) [17:17:41:732]: Entering CMsiConfigurationManager:etLastUsedSource.
MSI (s) (30:40) [17:17:41:763]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (30:40) [17:17:41:763]: Adding new sources is allowed.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: Package name extracted from package path: 'msxml6.msi'
MSI (s) (30:40) [17:17:41:763]: Package to be registered: 'msxml6.msi'
MSI (s) (30:40) [17:17:41:763]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (30:40) [17:17:41:763]: Machine policy value 'DisableMsi' is 0
MSI (s) (30:40) [17:17:41:763]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (30:40) [17:17:41:763]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (30:40) [17:17:41:763]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (30:40) [17:17:41:763]: Running product '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' with elevated privileges: Product is assigned.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '3708'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '424'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{982DB00A-9C4E-436B-8707-18E113BAA44C}'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '424'.
MSI (s) (30:40) [17:17:41:763]: TRANSFORMS property is now:
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '300'.
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminApplication Data
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminFavorites
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminNetHood
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy Documents
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminPrintHood
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminRecent
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminSendTo
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminTemplates
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminLocal SettingsApplication Data
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy DocumentsMy Pictures
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsAdministrative Tools
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsStartup
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuPrograms
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart Menu
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminDesktop
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:WINDOWSFonts
MSI (s) (30:40) [17:17:41:803]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Exact'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'Exact Software'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller3afbb9.msi'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (30:40) [17:17:41:803]: Machine policy value 'DisableRollback' is 0
MSI (s) (30:40) [17:17:41:803]: User policy value 'DisableRollback' is 0
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 6/11/2007 17:17:41 ===
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (30:40) [17:17:41:803]: Doing action: INSTALL
MSI (s) (30:40) [17:17:41:803]: Running ExecuteSequence
MSI (s) (30:40) [17:17:41:803]: Skipping action: SkipInstallCA (condition is false)
MSI (s) (30:40) [17:17:41:803]: Doing action: LaunchConditions
Action start 17:17:41: INSTALL.
Action start 17:17:41: LaunchConditions.
MSI (s) (30:40) [17:17:41:803]: Doing action: FindRelatedProducts
Action ended 17:17:41: LaunchConditions. Return value 1.
Action start 17:17:41: FindRelatedProducts.
MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 property. Its value is '{A43BF6A5-D5F0-4AAA-BF41-65995063EC44}'.
MSI (s) (30:40) [17:17:41:813]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)
MSI (s) (30:40) [17:17:41:813]: Doing action: CA_SetRefCountNewerFoundFlag
Action ended 17:17:41: FindRelatedProducts. Return value 1.
MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 property. Its value is '1'.
Action start 17:17:41: CA_SetRefCountNewerFoundFlag.
MSI (s) (30:40) [17:17:41:813]: Doing action: IsPendingRebootKey
Action ended 17:17:41: CA_SetRefCountNewerFoundFlag. Return value 1.
MSI (s) (30:F8) [17:17:41:813]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI68.tmp, Entrypoint: IsPendingReboot
MSI (s) (30:1C) [17:17:41:813]: Generating random cookie.
MSI (s) (30:1C) [17:17:41:823]: Created Custom Action Server with PID 1832 (0x728).
MSI (s) (304) [17:17:41:873]: Running as a service.
MSI (s) (304) [17:17:41:873]: Hello, I'm your 32bit Impersonated custom action server.
Action start 17:17:41: IsPendingRebootKey.
No PendingFileRenameOperations
MSI (s) (30:40) [17:17:41:973]: Skipping action: CA_ErrorDifferentLang (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOW (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWAppendCustomPath (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false)
MSI (s) (30:40) [17:17:41:973]: Doing action: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D
Action ended 17:17:41: IsPendingRebootKey. Return value 1.
MSI (s) (30:50) [17:17:41:983]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI69.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid
Action start 17:17:41: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D.
<Func Name='Sqlmsirc_ValidateAppGuid'>
<EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'>
MSI (s) (30:40) [17:17:42:003]: Doing action: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D
Action ended 17:17:42: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 1.
MSI (s) (30:EC) [17:17:42:013]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI6A.tmp, Entrypoint: Sqlmsirc_RefCountAppGuid
Action start 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D.
<Func Name='Sqlmsirc_RefCountAppGuid'>
<EndFunc Name='Sqlmsirc_RefCountAppGuid' Return='2' GetLastError='0'>
Action ended 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 3.
Action ended 17:17:42: INSTALL. Return value 3.
Property(S): ProductCode = {AEB9948B-4FF2-47C9-990E-47014492A0FE}
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 6.00.3883.8
Property(S): ProductLanguage = 1033
Property(S): UpgradeCode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B}
Property(S): NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 = 1
Property(S): ARPPRODUCTICON = ARPIco
Property(S): PIDTemplate = 53934<````=````=````=````=`````>@@@@@
Property(S): PROMPTROLLBACKCOST = P
Property(S): DiskPrompt = [1]
Property(S): INSTALLLEVEL = 100
Property(S): ALLUSERS = 1
Property(S): InstallMode = Typical
Property(S): ErrorIcon = ErrorIco
Property(S): SuccessIcon = SuccessIco
Property(S): WarningIcon = WarningIco
Property(S): LicenseIcon = LicenseIco
Property(S): SetupIcon = SetupIco
Property(S): CompleteIcon = CompleteIco
Property(S): CustomIcon = CustomIco
Property(S): RepairIcon = RepairIco
Property(S): RemoveIcon = RemoveIco
Property(S): ModifyIcon = ModifyIco
Property(S): NewIcon = NewIco
Property(S): UpIcon = UpIco
Property(S): DialogBanner = BannerBmp
Property(S): WelcomeBmp = WelcomeBmp
Property(S): ApplicationUsers = AllUsers
Property(S): Details = 0
Property(S): AgreeToLicense = No
Property(S): _IsMaintenance = Reinstall
Property(S): _IsMaintenance2 = Modify
Property(S): ReinstallModeText = omus
Property(S): Display_IsBitmapDlg = 1
Property(S): Interrupted = 0
Property(S): ProductID = none
Property(S): ISENABLEDWUSFINISHDIALOG = 1
Property(S): SQLServerText1 = 0
Property(S): SQLServerVersionText1 = 0
Property(S): SQLServerVersionText2 = 0
Property(S): SQLServerVersionText3 = 0
Property(S): CA_ERRORCOUNT = 0
Property(S): CA_WARNINGCOUNT = 0
Property(S): CA_SUCCESSCOUNT = 0
Property(S): MINIMUMOS = true
Property(S): UI_SHOWCOPYRIGHT = yes
Property(S): ShowUserRegistrationDlg = 1
Property(S): ErrorDialog = ErrorDlg
Property(S): DefaultUIFont = Tahoma8
Property(S): NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
Property(S): VersionNT = 501
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52156
Property(S): SecureCustomProperties = NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND2.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1
Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop
Property(S): ButtonTextStyle = {ButtonTextStyle}
Property(S): DlgTextStyle = {DlgTextStyle}
Property(S): DlgTextStyleB = {DlgTextStyleB}
Property(S): DlgTitleStyle = {DlgTitleStyle}
Property(S): DlgTitleStyleB = {DlgTitleStyleB}
Property(S): FixedStyle = {FixedStyle}
Property(S): COMPANYNAME = Exact Software
Property(S): USERNAME = Exact
Property(S): DialogTitleSetup = Setup
Property(S): DialogTitlePatch = Patch
Property(S): DialogTitleUpgrade = Upgrade
Property(S): Text_ArrowLeft = <
Property(S): Text_ArrowRight = >
Property(S): ButtonText_Next = Next
Property(S): ButtonText_Next_Hot = &Next
Property(S): ButtonText_Cancel = Cancel
Property(S): ButtonText_Cancel_Hot = &Cancel
Property(S): ButtonText_Back = Back
Property(S): ButtonText_Back_Hot = &Back
Property(S): ButtonText_Finish = Finish
Property(S): ButtonText_Finish_Hot = &Finish
Property(S): ButtonText_Update = Update >
Property(S): ButtonText_Update_Hot = &Update >
Property(S): ButtonText_Ok = OK
Property(S): ButtonText_Ok_Hot = &OK
Property(S): ButtonText_Yes = Yes
Property(S): ButtonText_Yes_Hot = &Yes
Property(S): ButtonText_No = No
Property(S): ButtonText_No_Hot = &No
Property(S): ButtonText_Abort = Abort
Property(S): ButtonText_Abort_Hot = &Abort
Property(S): ButtonText_Ignore = Ignore
Property(S): ButtonText_Ignore_Hot = &Ignore
Property(S): ButtonText_Retry = Retry
Property(S): ButtonText_Retry_Hot = &Retry
Property(S): ButtonText_Change = Change...
Property(S): ButtonText_Change_Hot = &Change...
Property(S): ButtonText_Help = Help
Property(S): ButtonText_Help_Hot = &Help
Property(S): ButtonText_Install = Install
Property(S): ButtonText_Install_Hot = &Install
Property(S): ButtonText_Exit = Exit
Property(S): ButtonText_Exit_Hot = &Exit
Property(S): ButtonText_Remove = Remove
Property(S): ButtonText_Remove_Hot = &Remove
Property(S): ButtonText_Space = Space
Property(S): ButtonText_Space_Hot = &Space
Property(S): ButtonText_Browse = Browse...
Property(S): ButtonText_Browse_Hot = Bro&wse...
Property(S): ButtonText_DiskCost = Disk Cost...
Property(S): ButtonText_DiskCost_Hot = &Disk Cost...
Property(S): LabelText_Status = Status
Property(S): LabelText_SerialNumber = &Serial Number:
Property(S): LabelText_UserName = &User Name
Property(S): LabelText_PersonName = Name
Property(S): LabelText_PersonOrganization = Company
Property(S): LabelText_InstallTo = Install to
Property(S): LabelText_Modify = &Modify
Property(S): LabelText_Repair = Re&pair
Property(S): LabelText_Remove = &Remove
Property(S): LabelText_Complete = &Complete
Property(S): LabelText_Custom = Cu&stom
Property(S): LabelText_NetworkLocation = &Network location:
Property(S): LabelText_LookIn = &Look in
Property(S): LabelText_FolderName = &Folder name
Property(S): LabelText_FeatureDescription = Feature description
Property(S): LabelText_CopyFilesFrom = Copy Files from
Property(S): LabelText_InstallFor = Install this application for
Property(S): HeadText_AdminWelcome = Welcome to the Install Wizard for
Property(S): HeadText_InstallWelcome = Welcome to the Install Wizard for
Property(S): HeadText_WelcomePatch = Welcome to the Patch for
Property(S): HeadText_SetupWelcome = Welcome to the
Property(S): HeadText_SetupWelcome2 = Setup
Property(S): HeadText_ResumeInstall = Resuming the Install Wizard for
Property(S): HeadText_SetupInterrupted = Setup Interrupted
Property(S): HeadText_LicenseAgreement = License Agreement
Property(S): HeadText_FeatureSelection = Feature Selection
Property(S): HeadText_NetworkLocation = Network Location
Property(S): HeadText_ProgramMaintenance = Program Maintenance
Property(S): HeadText_DiskSpaceRequirements = Disk Space Requirements
Property(S): HeadText_FilesInUse = Files in Use
Property(S): HeadText_DatabaseFolder = Database Folder
Property(S): HeadText_RegistrationInformation = Registration Information
Property(S): HeadText_CompletingSetup = Completing the
Property(S): HeadText_CompletingSetup2 = Setup
Property(S): HeadText_InstallingProduct = Installing
Property(S): HeadText_UninstallProduct = Uninstalling
Property(S): HeadText_ChangeDestinationFolder = Change Current Destination Folder
Property(S): HeadText_ReadyInstall = Ready to Install the Program
Property(S): HeadText_ReadyRepair = Ready to Repair the Program
Property(S): HeadText_ReadyModify = Ready to Modify the Program
Property(S): HeadText_RemoveProgram = Remove the Program
Property(S): HeadText_OutOfDiskSpace = Out of Disk Space
Property(S): DescText_FilesInUse = Some files that need to be updated are currently in use.
Property(S): DescText_RegistrationInformation = The following information will personalize your installation.
Property(S): DescText_ServerImage = Setup will create a server image of
Property(S): DescText_ServerImage2 = at a specified network location. To continue, click Next.
Property(S): DescText_InstallModifyRemove = Setup helps you install, modify or remove
Property(S): DescText_InstallModifyRemove2 = . To continue, click Next.
Property(S): DescText_PatchInstall = The Install Wizard will install the Patch for
Property(S): DescText_PatchInstall2 = on your computer. To continue, click Update.
Property(S): DescText_WizardComplete = The Install Wizard will complete the installation of
Property(S): DescText_WizardComplete2 = on your computer. To continue, click Next.
Property(S): DescText_CompleteSuspended = The Install Wizard will complete the suspended installation of
Property(S): DescText_CompleteSuspended2 = on your computer. To continue, click Next.
Property(S): DescText_SuccessfulInstallation = Setup has installed
Property(S): DescText_SuccessfulInstallation2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRemove = Setup has removed
Property(S): DescText_SuccessfulRemove2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRepair = Setup has repaired
Property(S): DescText_SuccessfulRepair2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulModify = Setup has modified
Property(S): DescText_SuccessfulModify2 = successfully. Click Finish to exit.
Property(S): DescText_SetupInterrupted = Setup was interrupted before
Property(S): DescText_SetupInterrupted2 = could be completely installed.
Property(S): DescText_PreparingSetup = Setup is preparing the Install Wizard which will guide you through the program setup process. Please wait.
Property(S): DescText_FeatureSelection = Select the program features you want installed.
Property(S): DescText_ProgramFeaturesInstall = The program features you selected are being installed.
Property(S): DescText_ProgramFeaturesUninstall = The program features you selected are being uninstalled.
Property(S): DescText_ReadLicense = Please read the following license agreement carefully.
Property(S): DescText_SpecifyNetworkLocation = Specify a network location for the server image of the product.
Property(S): DescText_BrowseDestination = Browse to the destination folder.
Property(S): DescText_ModifyRepairRemove = Repair or remove the program.
Property(S): DescText_ReadyInstallation = Setup is ready to begin installation.
Property(S): DescText_ChosenRemove = You have chosen to remove the program from your system.
Property(S): DescText_DiskSpaceRequirements = The disk space required for the installation of the selected features.
Property(S): DescText_DiskExceedsAvailable = Disk space required for the installation exceeds available disk space.
Property(S): Text_ReRunSetup = Your system has not been modified. To complete installation at another time, please run setup again.
Property(S): Text_FinishExit = Click Finish to exit Setup.
Property(S): Text_RestoreState = You can either keep any existing installed elements on your system to continue this installation at a later time or you can restore your system to its original state prior to the installation.
Property(S): Text_RestoreClick = Click Restore or Continue Later to exit Setup.
Property(S): Text_InstallWait = Please wait while the Install Wizard installs
Property(S): Text_InstallWait2 = . This may take several minutes.
Property(S): Text_UninstallWaitText = Please wait while the Install Wizard uninstalls
Property(S): Text_UninstallWaitText2 = . This may take several minutes.
Property(S): Text_UninstallWait = Please wait while the Install Wizard uninstalls
Property(S): Text_UninstallWait2 = . This may take several minutes.
Property(S): Text_ProgressDone = Progress done
Property(S): Text_Copyright = WARNING: This program is protected by copyright law and international treaties.
Property(S): Text_BeginInstallation = Click Install to begin the installation.
Property(S): Text_ReviewChange = If you want to review or change any of your installation settings, click Back. Click Cancel to exit Setup.
Property(S): Text_AlterFeatureInstall = Click an icon in the following list to change how a feature is installed.
Property(S): Text_ConfirmExit = The installation is not yet complete. Are you sure you want to exit?
Property(S): Text_FeatureSelectionDescription = This feature requires 4 MB on your hard drive.
Property(S): Text_EnterNetworkLocation = Enter the network location or click Change to browse to a location. Click Install to create a server image of
Property(S): Text_EnterNetworkLocation2 = at the specified network location or click Cancel to exit Setup.
Property(S): Text_SelectDifferentDrive = The highlighted volumes do not have enough disk space available for the currently selected features. You can remove files from the highlighted volumes, choose to install less features onto local drives, or select different destination drives.
Property(S): Text_RepairInstallationErrors = Repair installation errors in the program. This option fixes missing or corrupt files, shortcuts, and registry entries.
Property(S): Text_RemoveFromComputer = Remove
Property(S): Text_RemoveFromComputer2 = from your computer.
Property(S): Text_UsingFilesRetry = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue.
Property(S): Text_ClickRemove = Click Remove to remove
Property(S): Text_ClickRemove2 = from your computer. After removal, this program will no longer be available for use.
Property(S): Text_ReviewChangeBack = If you want to review or change any settings, click Back.
Property(S): Text_AllUsers = &Anyone who uses this computer (all users)
Property(S): Text_OnlyMe = Only for &me ([USERNAME])
Property(S): Text_NotAcceptTerms = I &do not accept the terms in the license agreement
Property(S): Text_AcceptTerms = I &accept the terms in the license agreement
Property(S): Text_RegInfoNameAndOrg = Enter your name and the name of your organization in the fields below.
Property(S): Text_RegInfoOrg = Enter the name of your organization in the field below.
Property(S): Upgrade_Confirmation = A lower version of this product has been detected on your system. Would you like to upgrade your existing installation?
Property(S): AdminMessage = Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator group.
Property(S): SupportedOSMessage = Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.
Property(S): ShortCutText = MSXML 6.0
Property(S): DialogTitle = MSXML 6.0 Parser Setup
Property(S): ProductName = MSXML 6.0 Parser
Property(S): ShortName = MSXML 6.0 Parser
Property(S): WrongPackage = This MSXML6.0 package is not supported on the current processor type.
Property(S): DialogPatchTitle = MSXML 6.0 Parser Patch
Property(S): SystemFolder = C:WINDOWSsystem32
Property(S): WdSfpCaMainModId.41646F16_4E6C_4E96_BF1B_772105414B9D = 86F857F6_A743_463D_B2FE_98CB5F727E09
Property(S): AppGuidRegKey = Wdsfpca_Uninstall_RegKey.86F857F6_A743_463D_B2FE_98CB5F727E09
Property(S): PackageCode = {A60D52F8-FAAB-4544-AF65-EAC1A22E5435}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): STPSETUPTHREADID = 3708
Property(S): STPSETUPPROCESSID = 424
Property(S): EXTERNALCONTROL = 1
Property(S): ADDLOCAL = ALL
Property(S): SKIPPENDINGREBOOTCHECK = 1
Property(S): APPGUID = {982DB00A-9C4E-436B-8707-18E113BAA44C}
Property(S): REBOOT = ReallySuppress
Property(S): CURRENTDIRECTORY = C:Program FilesMicrosoft SQL Server90Setup Bootstrap
Property(S): CLIENTUILEVEL = 3
Property(S): CLIENTPROCESSID = 424
Property(S): VersionDatabase = 300
Property(S): VersionMsi = 3.01
Property(S): WindowsBuild = 2600
Property(S): ServicePackLevel = 2
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:WINDOWS
Property(S): WindowsVolume = C:
Property(S): System16Folder = C:WINDOWSsystem
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:DOCUME~1AdminLOCALS~1Temp
Property(S): ProgramFilesFolder = C:Program Files
Property(S): CommonFilesFolder = C:Program FilesCommon Files
Property(S): AppDataFolder = C:Documents and SettingsAdminApplication Data
Property(S): FavoritesFolder = C:Documents and SettingsAdminFavorites
Property(S): NetHoodFolder = C:Documents and SettingsAdminNetHood
Property(S): PersonalFolder = C:Documents and SettingsAdminMy Documents
Property(S): PrintHoodFolder = C:Documents and SettingsAdminPrintHood
Property(S): RecentFolder = C:Documents and SettingsAdminRecent
Property(S): SendToFolder = C:Documents and SettingsAdminSendTo
Property(S): TemplateFolder = C:Documents and SettingsAll UsersTemplates
Property(S): CommonAppDataFolder = C:Documents and SettingsAll UsersApplication Data
Property(S): LocalAppDataFolder = C:Documents and SettingsAdminLocal SettingsApplication Data
Property(S): MyPicturesFolder = C:Documents and SettingsAdminMy DocumentsMy Pictures
Property(S): AdminToolsFolder = C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
Property(S): StartupFolder = C:Documents and SettingsAll UsersStart MenuProgramsStartup
Property(S): ProgramMenuFolder = C:Documents and SettingsAll UsersStart MenuPrograms
Property(S): StartMenuFolder = C:Documents and SettingsAll UsersStart Menu
Property(S): FontsFolder = C:WINDOWSFonts
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 6
Property(S): PhysicalMemory = 1023
Property(S): VirtualMemory = 2183
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-842925246-1580818891-1957994488-500
Property(S): UserLanguageID = 1033
Property(S): ComputerName = CHUN107907-1
Property(S): SystemLanguageID = 1054
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 25
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 17:17:42
Property(S): Date = 6/11/2007
Property(S): MsiNetAssemblySupport = 2.0.50727.42
Property(S): MsiWin32AssemblySupport = 5.1.2600.3019
Property(S): RedirectedDllSupport = 2
Property(S): Privileged = 1
Property(S): DATABASE = C:WINDOWSInstaller3afbb9.msi
Property(S): OriginalDatabase = \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
Property(S): UILevel = 2
Property(S): Preselected = 1
Property(S): ACTION = INSTALL
MSI (s) (30:40) [17:17:42:093]: Note: 1: 1708
MSI (s) (30:40) [17:17:42:093]: Product: MSXML 6.0 Parser -- Installation failed.
MSI (s) (30:40) [17:17:42:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (30:40) [17:17:42:093]: MainEngineThread is returning 1603
MSI (s) (30:AC) [17:17:42:193]: Destroying RemoteAPI object.
MSI (s) (30:1C) [17:17:42:193]: Custom Action Manager thread ending.
=== Logging stopped: 6/11/2007 17:17:42 ===
MSI (c) (A8:90) [17:17:42:193]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (A8:90) [17:17:42:193]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/11/2007 17:17:42 ===
I have a table with some rows and columns what i want is i want to Show sum of particular column in the last row. This is my code.
SELECT DISTINCT Cluster.ClusterName, Gruppe.GruppeName, Arbeitspaket.ArbeitspaketName, BMWProjekt, AnzahlAP, Abgerechnet, InBearbeitung, Billanz FROM Bestellung
INNER JOIN Cluster ON Bestellung.Cluster = Cluster.rowid
INNER JOIN Arbeitspaket ON Bestellung.Arbeitspaket = Arbeitspaket.rowid
INNER JOIN Gruppe ON Bestellung.Gruppe = Gruppe.rowid
WHERE Projekt ="EA-284-Nxx" AND AnzahlAP <> 0 AND Abgerechnet is 1 AND InBearbeitung is NULL AND Billanz is NULL;
Hi Guys,
I've been strugling with this problem all morning today.
Basically I store images in SQL Server 2000 database and then whould like to show them with
<img src="viewImage.aspx?image_id=10" border=1>
My table structure is setup this way
TABLE [userImages] (
[imageFilename] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[imageContentType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[imageFileSize] [bigint] NULL ,
[imageFileImage] [image] NULL )
and in viewImage.aspx I have:
if (dr.Read())
{
Response.ContentType = dr.GetString(dr.GetOrdinal("imageContentType"));
Response.BinaryWrite( (byte[]) dr["imageFileImage"] );
}
I have no prolems retrieving the data from DB. But the image does not display(in IE it shows a broken link image)
What's even more puzzling is I CAN display the same image from HDD like so:
FileStream fs = File.OpenRead("D:\my_image.png");
byte[] buffer = new byte[fs.Length];
fs.Read(buffer, 0, buffer.Length);
fs.Close();
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(buffer);
Am I missing something very obvious. I tried playing around with different ContentType's same result.
In my case I am forced to store images in the DB.
I've seen other examples on the net and theirs work. Please help.
Sincerely,
Vlad Orlovsky
selecting table data in hierarchical XML .
Here is the sample table DDL and data
Declare @continents Table
(
id int identity (1,1)
,continent_id int
,continent_Name varchar(100)
,continent_surface_area varchar(100)
,country_id int
[code]....
I am looking to created a trigger that inserts records into a log table to show the stored porcedure that has updated a specific column to a specific value in a specific table
At present I have:
CREATE TRIGGER [dbo].[trUpdaterTable]
ON [dbo].[t_account]-- A DB level trigger
FOR UPDATE
--Event we want to capture
AS
IF update (document_status)
[Code] ...
However this doesn't appear to bring back the procedure that triggered the update...
The value the trigger should update on is document_status = 0
DDLProcExecutedByEventDate
NULLNULLLOMBDAadministrator2015-06-25 07:42:01.677
NULLNULLLOMBDA im64602015-06-25 07:51:34.503
NULLNULLLOMBDAadministrator2015-06-25 07:52:01.610
NULLNULLLOMBDAadministrator2015-06-25 08:02:01.417
CREATE TRIGGER [dbo].[trTableupdateaccount] ON [DoesMore].[dbo].[t_account]
[Code] ....
I have two tables Costtable (Id,ResourceId, Amount,Date) and ResourceTable (ResourceId,Name) which shows output as below.
I want to show 0 amount for rest of the name in case of September. For e.g. if rest of the Resources does not appear in cost table they should appear 0 in amount
My Desired output
My current query
SELECT
RG.Id AS Id,
RG.Name AS Name,
ISNULL(SUM(AC.Amount), 0) AS Amount,
RIGHT(CONVERT(varchar(10), AC.[Date], 105), 7) AS [YearMonth]
[Code] ....
I'm developing a database-driven program using SQL server 2000 and Visual Basic 2005.
Most of the guys say professional programming is doing the validation stuff (such as the constraints and data integrity stuff like" [0-9][1] " and the use of LIKE IN keywords etc.) in the databse itself.
say i did the data validation contraints in SQL server itself. and now i connect the database with the interface made in 2005. and say a person enters some invalid data through the interface. but the error messages are generated by SQL server. how am i to display the SQL server generated error messages in the VB made interface??
PLS HELP ME .. if the question is not clear pls tell so that i can explain it further.
PLS PLS PLS HELP ME
I'm developing a database-driven program using SQL server 2000 and Visual Basic 2005.
Most of the guys say professional programming is doing the validation stuff (such as the constraints and data integrity stuff like" [0-9][1] " and the use of LIKE IN keywords etc.) in the databse itself.
say i did the data validation contraints in SQL server itself. and now i connect the database with the interface made in 2005. and say a person enters some invalid data through the interface. but the error messages are generated by SQL server. how am i to display the SQL server generated error messages in the VB made interface??
PLS HELP ME .. if the question is not clear pls tell so that i can explain it further.
PLS PLS PLS HELP ME
I am new to sqlserver.
1)I created a linked server to a oracle database, works fine. Now I am writing queries, using "Query Desgner", when I do a "Add table" linked server tables do not appear. Is this a limitation. I can get around the problem by creating a view.
2) When I use "Microsoft OLE DB Provider for Oracle" for linked server, some times connection seems to get lost. On one occassion, the next day it was fine, it re-established itself.
Any ideas thnx.
Hello everybody,
Wrote before but did not go any answer , try again.
I have two question about SQL compact edition (SQLCE) (.sdf) and SQL Express edition (SQLED) (.mdf).
I have been testing SQLED and have many tables and data in it.
I want know to test SQLCD and hopefully be able to communicate with the SQLED.
For this reason I was wondering the following:
1. IIs it possible to move all the tables and it constratints into the SQLCE from the SQED ?
2. Another possibility I was thinking about was to use some tables in the SQLED in the SQLCE and move data between these two databases through RDA .
However, does this two versions aloud this kind of communciation...between them....?
Thanks in forehand,
Matilde
Hi everybody,
View 5 Replies View RelatedTrying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there. I have uninstall all of the Sql Ce stuff and reinstalled it. So I'm missing some key link. What are the magic incantations to get to first base?
Ed Warren
I'm completely new to ASP.NET. I want to insert data to the SQL SERVER EXPRESS database.When the button clicks i want to add the details into database.This is the coding i did with online help.
Can you help me to do a good coding ad some error showing on my 7th line("connection.Open()")..
And can you advise me to do correct coding for how is get data from database and display it on web page.
Thanks in advance.And here is the coding i did to Insert data,
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connection As New SqlConnection(" database=share")
Dim cmd As New SqlCommand("INSERT INTO sdetails (cid, cname, date, qty, pps)VALUES('" & txtcid.Text & "','" & txtcname.Text & "','" & txtdate.Text & "','" & txtqty.Text & "','" & txtpps.Text & "')", connection)
connection.Open()
connection.Close()
End Sub
I have installed SQL Server 2005 CE on my computer, but when I try to add a data connection to a CE database in Visual Studio 2005, I cannot find the option "SQL Server 2005 Combact Edition". Why?
Dear SirI am using SQL Server express edition for my database.i have downloaded sql server mangement studio also .i have my data in access(.mdb) i want to import those data to my sqlserver express .One option i am using using odbc datasource but it doesnot take care for my constraints applied i.e primarykey,indexing no duplicate etc, .Any way if can do it again also in sql server express but the problem is when i try to do it with 2 lacs of data it shows error "time expires " ..Can any body tell how to upload data to an existing table of sql server .since i could not find DTS in express edition.Thanks and regardsmukesh
View 2 Replies View RelatedI developed nice reports using custom data processing extensions. When I deployed the reports on my report server (I am using the express edition of SQL Server 2005) I was surprised to see that my reports were not rendering successfully.
After searching the web, I found this page listing the supported/unsupported features of SQL Server 2005 Express Edition: http://msdn2.microsoft.com/en-us/library/ms365166.aspx
On this page it clearly says €œThe Reporting Services API extensible platform for delivery, data processing, rendering, and security is not supported.€?
Is there a way to get my reports to work on the express edition?
If not, which minimal version of SQL Server should a buy to get it to work (workgroup, standard or enterprise)?
Thanks for your help.
i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
anyway, on the 5th exercise wherein i'm supposed to add a new data
connection through the server explorer.. when i chose the option of
adding a new data source and was prompted to select a data source i
couldnt find the Microsoft SQL Server Mobile Edition data source..
is there anything else that i need to download in order to have that data source?
Hi,
I am using SQLCE and VS 2005 to create a database named "student.sdf" (inside my projects folder, of course). When click on the button, it will test for connection of database.
Everytimes I run the program, it will pop up an error message "The database file cannot be found. Check the path to the database. [File name = .student.sdf]". How do I fix it?
Code Snippet
Imports System.Data.SqlServerCe
Public Class loginForm
Private _conn As SqlCeConnection
Private Sub ButtonLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonLogin.Click
_conn = New SqlCeConnection("Data Source =.student.sdf")
Try
_conn.Open()
MessageBox.Show("Correct")
Catch ex As SqlCeException
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1)
Finally
_conn.Close()
End Try
End Sub
End Class
Hi,
I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD)
The Instance has many logins and jobs etc and I dont want to loose those
A document or some advice on how to go about it would help
Thanks
Hallo
i have two tables, MainTable and MainTableAudit: the second one keeps DML auditing via triggers.
I'm trying to build a query to highlight changes occurred to fields between the MainTable record and its audited records in MainTableAudit, for example, let's suppose i entered an item with some wrong attributes, and edited it three times:
MainTable record contains the latest and current version
ID002|Hitchhikers Guide to the Galaxy|Sci-fi|240 pages
MainTableAudit contains edited ID002 versions
ID002|Hitchhikers Guide to the Galaxy|Sci-fi|232 pages|2006-07-08 08:32:12
ID002|Hitchhikers Guide to the Galaxy|Sci-fi|212 pages|2006-05-08 10:54:02
ID002|Hitchhikers Guide to Galaxy|Sci-fi|222 pages|2006-07-04 11:42:16
I would like to build a report like this:
first insertion: Hitchhikers Guide to Galaxy|Sci-fi|222 pages
modified on 2006-07-04 11:42:16: field "Title" changed from "Hitchhikers Guide to Galaxy" to "Hitchhikers Guide to the Galaxy", field "PageNo" changed from "222" to "212"
modified on 2006-05-08 10:54:02: field "PageNo" changed from "212" to "232"
modified on 2006-07-08 08:32:12: field "PageNo" changed from "232" to "240"
current version: Hitchhikers Guide to the Galaxy|Sci-fi|240 pages
i'd prefer to use T-SQL and keep all into a single place (a view or storedprocedure), or at least to use reporting services; btw i would like to avoid coding web pages or hosted applications.
There are any import/export utilities for SQL Server 2005 Mobile Edition database? Which edition of SQL Server 2005 can do this?
Or we must use publication/subscription to transfer data to the mobile database?
Thank you for your help!
HI,
Does SQL server 2005 Express Edition or
Does SQL server 2005 Express Edition Sp1 supports Data base Mirroring?
Hi all experts,
I have a result set like:
Project
Milestone
Info
Project1
M1
Info1
Project1
M1
Info2
Project1
M2
Info3
Project2
M1
Info4
Project2
M2
Info5
Project3
M1
Info6
I need to create a report like:
M1
M2
Project1
Info1
Info2
Info3
Project2
Info4
Info5
Project3
Info6
But while I use matrix to build this report, I got the result like:
M1
M2
Project1
Info1
Info3
Project2
Info4
Info5
Project3
Info6
The report will not show the multiple records on the row group "Project" like item "Info2".
After I referred to the similar problem mentioned on this forums, I tried to use "RowNumber("Matrix1_Project")" to resolve it. But still I got the result like:
M1
M2
Project1
RowNumer
Info1
RowNumer
Info1
RowNumer
Info3
Project2
RowNumer
Info4
RowNumer
Info5
Project3
RowNumer
Info6
It would be much appreciated if anyone could give me some hints to complete the report I need.
Thanks in advance,
Steve Wang 2007/12/12
Hi
-I have istalled sql server 2005 standard edition , I want to install sql server 2005 enterprise edition on the same machine.
Is it possible? I have Microsoft windows server 2003 SP2 and 1GB RAM.
I want to use partition function with the enterprise edition, will the trial version of sql server work for me?
-If I have already created a database and tables using the standard edition, will I be able to access and use the database using the installed trial version or will I have to start a fresh creating a new database?
- Is it possible to access the same database with any of the installed versions?
BTW, I am prety new to sql server and databases , I am trying to learn by myself
Thanks
After some weeks evaluating tools and platforms for developing an application, I decided to move to SQL Server 2005 Express Edition. Everything was fine till last night, when after creating my tables, I needed to populate them. I tried to find the Import and Export Data Wizard that SQL Server 7.0 and 2000 used to have, but great was my surprise when I found - in this forum - a post that said that it's not available in the Express Edition.
I'll have to move back in time (what I hate) to remember the way BCP worked. Can somebody post some examples to not start from zero ? Does anybody know a third party visual tool that can import/export data from text files to a SQL Server DB via ODBC ?
What's the reason it was not included in the EE ?
THanks !