Andew Foster's Q&A profile

• SQL Server snapshot isolation and ADO (VBA)

  Hi, could somebody please provide me with an example of snapshot isolation level for ADODB (VBA) Because ADODB.Connection.IsolationLevel does not included snapshot as a new level. May be it is possible to add something to connection string like Conn.Open "PROVIDER=MSDASQL;driver={SQL Native Client};server=localhost;database=dbone;" Thank you. You might be able to set the isolation level directly via TSQL command: ...Show All

• Software Development for Windows Vista Microsoft Platform SDK Feb 2003

  When I try to install this SDK I get the follwoing error: The currently installed SDK is not in its original dirctory.  The installation can not continue. Please go to Add/Remove Programs, uninstall the SDK, and try again. I did have this SDK installed once and I uninstalled it, there must be an .ini or .msi file left over somewhere.  I'm using this with Windows XP, SP2 - Visual C++ 6.0 i wrote for oth ...Show All

• Software Development for Windows Vista Is there any way to time procedures in vb2005.

  Is there any way in vb2005 to time procedures to closer than a millisecond.  I have an application running in the background and I would like to get a handle on how much computer time it is hogging. Thanks Dick Hello again. > mix C# with vb My advice to you is to create a new C# classlibrary in your existing solution (not the project) and add into the class... #region "Timer routines"   [S ...Show All

• Visual FoxPro foxpro dos to visual foxpro 9 conversion

  I am trying to convert an existing application I created many years ago in foxpro 2.5 for dos, but when I try to run my programs I get this error: File 'get_last_key.prg' does not exist. Can anyone help me. I'm completely new to visual foxpro any help will be greatly appreciated. Thanks, bertle I assume you have a function called get_last_key() with some parameter that is treated as a file name by Visual Fox ...Show All

• Visual Basic Open the default email client with attachment? or SmtpClient send email with prompt dialog?

  Hi there, I want to open the default email client with attachment. But mailto doesn't support attach. so is there anyway to accomplish it Thanks in advance. Joseph Liu Just like the email function provided by winzip. I need the exact function to open a default email client, and adding my attachments on! Thanks, Joseph ...Show All

• Smart Device Development Windows CE Shared Sources Premium - what's included?

  There is a web site outlining the MS shared sources initiative: http://msdn.microsoft.com/embedded/usewinemb/ce/sharedsrccode/default.aspx , but it's not detailed enough to allow a developer to make suggestions re purchasing decision. Can anyone answer (an MVP perhaps), what exactly is included into the Premium sources, for example does it include TAPI, RIL, cellcore, and so on Thx. VB. I would ...Show All

• Windows Forms Data extraction from online websites

  I remmember trying a visual studio add in a while ago. it allowed u to extract information from static, dynamic or even secure sites using table structures and other methods. it even allowed you to fill in forms and some other stuff, now i ...Show All

• Visual C# Getting what is after the Decimal place, in any number

  hello people I am trying to get what is after the decimal place in any number for example 3.99939204820498, i want to get 99939204820498 i am aware of the % (mod) when i divide, but what about when i multiply 1458/365.25 = 3.9995646 (what ever the result is) i wan tto then get the 0.9995646 lets say i multiply the 0.9995646 by 12 = 11.90545654 (some number) now i want to get the 0.90545654 how do i do this in C# 2.0 i can use strings to sp ...Show All

• .NET Development SQL views and procedures - SQL statements

  How does one read the SQL source statement for views and Procedures I can read the collection e.g. Dim schemaTable As DataTable = cnnoledb.GetOleDbSchemaTable(_ (System.Data.OleDb.OleDbSchemaGuid.Tables, New Object () { Nothing , Nothing , Nothing , "VIEW" }) But there is no way I can find to get to the SQL source statements to EDIT the text and "CREATE VIEW" a new one Any clues would be appreciated jimbo(nospam)@csh.co ...Show All

• SQL Server The Publisher failed to allocate a new set of identity ranges for the subscription

  Hi All, The following is the report from the SQL Server Mobile Subscription wizzard, Any Ideas New Subscription Wizard - Beginning Synchronization (Success) - Synchronizing Data (100%) (Error) Messages A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006) The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republ ...Show All

• .NET Development How to dynamically change connection string in generated dataset class?

  I have a project with database classes which are generated from database objects. That is I add a dataset to the project and drag and drop a database object onto it. The problem with this is that I have to give a connectionstring which is stored in the code. This is ok while developing the application. But runtime I want to use another connectionstring, both for security reasons and because each user of the application will correspond to a datab ...Show All

• Visual Basic VB Application Settings

  Im trying to build a program that runs on a database.  I have tryed everything i can think of to change my connection string at runtime.  What i want to do is enable a user to select a local SQL server that containes a copy of my database, and save it to the application settings.  i keep getting a read only message when i try to change the app settings connectionstring setting.  im not sure if i worded that right, if you need ...Show All

• Visual Basic Code for letting the user change the color and font for whole application

  I am making a application program in vb.net 2005. I want the user to select the font and the color which he/she wants for the application. Once the user select the color changes should occur to the whole application. or if possible the list come from the display property and user can select from scheme which is in apperance. Please help....... Hi Puneet Create one Labelfont variable with global access. Public lblAppFont As New L ...Show All

• SQL Server Installed .NET 1.1 Framework and MSDE stopped working

  I just upgraded the .NET 1.0 to 1.1 today and now when I launch the Web Data Administrator for MSDE it hangs up as soon as I hit the login button. I reinstalled MSDE and the Web Data Administrator and that didn't correct the problem. Help! Try this: Cause This problem occurs if the following registry subkey is missing: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI This issue may also occur if this ...Show All

• .NET Development confused by generic methods

  Hi, in the code sample that follows how do i get from the MethodInfo object given the variable name 'method' in main (this method takes a string as its parameter) to the MethodInfo object that took the generic parameter in the class MyGeneric (i.e. the MethodINfo that originally described the method) I would guess by using MethodInfo.GetGenericMethodDefintion() but is says this isn't allowed due top the state of the object. I think ...Show All