Search results for query: *

Hi I have a subscription that is hanging with the following: The merge process retried a total of 112 rows out of which 0 passed and 112 failed. The subscription sit there and does nothing. Any ideas Ive check conflicts and cleared them.

I bound DataGrid with Adodc. DataGrid has enabled AllowUpdate, AllowDelete etc. When an adodc.recordset isn't empty (table has records) everything works fine. However, if that recordset is empty (BOF, EOF = true, table in database has no records) I can't fill row in DataGrid to add new (first)...

Hi All The subject says it all realy. I need to pass 10 19" as a string to a stored procedure. any ideas? Thanks

Hi I have an application that connects to sql 2005 express. On 3 pcs it works fine but on on windows 7 pc it fails to connect to the sql server express I have tested using ODBC. setup this using named pipes with the sa user and it works fine but the application doesn't work. Can anyone point...

Im trying to do this which is working fine. But every so often the mdb file keeps getting corrupt. Could there be reason for this? Thanks inn advance.

hi has anyone got any ideas how to split the following mrz string of passport data: P<GBRMANSELL<<BILLY<DOMANIC<<<<<<<<<<<<<<<9996757772GBR7501112M2006040<<<<<<<<<<<<<<08 Thanks

Hi All I have windows 8.1 and VS 2010. I have been running projects for around 3 months no problem. Today however I get the following error when I open my project: The project 'ProjectName' is under source control. This version of visual studio .NET does not support source controlled...

Hi Is it possible to select all columns from a table excluding certain columns? i.e. SELECT * from Table1 Except Columns(ID, EmployeeName) ?? Thanks in advance

Hi I'm trying to install SQL 2005 on my windows 8 pro pc with a instance so I can create databases. during setup I get an error cannot start MS SQL Service and the setup has to be cancelled. I'm running everything as administrator. Any help would be appreciated. Thanks

Hi I'm applying a filter to a recordset (old from somebody else) using the rs.filter property The columns all exists and this filter works: rs.filter = "(Agent LIKE 'MIES%' OR [Air Agent] LIKE 'MIES%')" This also works: rs.filter = "(Agent LIKE 'MIES%' OR [Air Agent] LIKE 'MIES%') OR (Origin...

Hi I have the following code Dim cFromColour As Color Dim sFromColour As String = "Cyan" Dim iFromInt As Integer = 0 Dim cToColour As Color Dim sToColour As String cFromColour = System.Drawing.Color.FromName(CStr(sFromColour)) iFromInt =...

Hi We need to rebuild two publications to a remote PC. The users on the remote PC are stopping using then system at 15:30. Can you create a snapshot before this time and copy to the remote pc before 15:30? If so what happens to data edited after the snapshot? OR does the snapshot need to be...

hi I have the following: Dim infoArray As PropertyInfo() = GetType(Color).GetProperties Dim info As PropertyInfo For Each info In infoArray Dim info2 As MethodInfo = info.GetGetMethod If ((Not info2 Is Nothing) AndAlso info2.IsStatic) Then...

Hi i have the routine below. when called from vb.net i get CustomerID cannot be null. issue with iNewCId. if a replace iNewCId with a number it works. Please help Thanks -- -------------------------------------------------------------------------------- -- Routine DDL -- Note: comments...

hi i have the foolowing code Dim pm1 As New MySqlParameter Dim pm2 As New MySqlParameter cmdMain = New MySqlCommand("rInsertCustomer", cnMain) cmdMain.CommandType = CommandType.StoredProcedure ''cmdMain.Parameters.Add(AddSQLParam("CustomerId"...

hi i have the folowing in excel, 12 rows , 1 column 07-jan-2012 08-jan-2012 09-jan-2012 10-jan-2012 11-jan-2012 12-jan-2012 13-jan-2012 14-jan-2012 15-jan-2012 16-jan-2012 17-jan-2012 25-jan-2012 i have coloured the forecolour based on > Today is red, > today + 2 weeks is yellow else black...

hi Im starting to learn asp .net How do i create a web site that has the same buttons at the top of each page. i dont what to ahve to add them to each page, as i would have to edit each page if i needed to chnage something. Thanks

hi how do i get a ribbon bar in vb.net thanks

Hi I have setup 5 pcs to a workgroup called workgroup. I craeted a share on the d drive of 1 pc (server pc) and the mapped a drive from the other 4 pcs to this new share all ok. Pcs rebooted over night. now when i browse to the server pc i get path not found! yet the server pc can see the pc...

Hi i have the following code: Dim cn As ADODB.Connection Dim lngOldCommitMode As Long Set cn = New ADODB.Connection If bUseSlash = True Then cn.Open "OLE DB Services=-4;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" & DBServer & "\" & DBPath & "\" &...