Recent content by griffitd

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

Sorry I was a bit vague. The application fails to connect to the SQL Server. It is windows 7. we have 4 pcs 3 connect ok. and 1 doesn't. In the code I create a sql command and set the connection string. when I execute the open connection it just hangs and after 30 seconds fails. application...

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

this now works. thanks for the reply

Hi Thanks for the reply.

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...