A.F.B's Q&A profile

• .NET Development (MDAC) 2.6 or later required

  Recieving error OleDb Data Provider requires Microsoft Data Access Componenets(MDAC) version 2.6 or later. This is isolated to a few machines in the network. These machines are running XP sp1. I have checked the version using the tool provided via Microsofts MDAC area. This application is telling me that 2.8 is install, which makes sense consider that ships with XP. I have tried re-regestering the dlls in the oledb folder. This doesn't work. The application is created in using 2005 written in VB. Using Oracle. Works great on 90% of the machines. Any ideas would be appreciated. Try downloading and reinstalling on the problem machines http://msdn.microsoft.com/data/ref/mdac/downloads/ ...Show All

• SQL Server Mirror Backup

  Hello All! I have a very simple question. Im studying for 40-431 and just finished reading about Log Shipping. It says in the book that when using Log Shipping you cannot run any other log backups because that would affect the LSNs. Can one do log backups with mirroring - principle and mirror Because mirroring uses log to keep the mirror up-to-date and synchs on LSN. Thank you ...Show All

• Windows Forms Unbound Datagridview

  Hi all, I am new to using this control (datagridview), in fact I am new to VB.Net. I have created a datagrid view control that has a textbox (col1), a checkbox (col2) and a combobox(col3). How do I populate the grid My only issue is the combobox column. here's what I did. dim comboData as datagridviewcomboboxcell comboData.add("Data1") comboData.add("Data2") dim dgvData(2) as object dgvData(0) = "Data" dgvData(1) = TRUE dgvData(2) = combodata Datagridview1.rows.add(dgvdata) Is this wrong Because I am getting error for on the combobox.. Hi, Even though you don't bind your DataGridView to a database, there's nothing keeping you from using the data ...Show All

• SQL Server Three level replication schema

  Hi I have to questions\problems I would need help with. First I am creating a three level merge replication. I mean I have a main publisher with its distributor, a subscriber/publisher and also with it's own distributor and lastly a subscriber. I start by creating the relation between subscriber/Publisher and the subscriber and than I move up to the main Publisher and Subscriber\Publisher relation. After this second merge I get the following errors and the articles in my Subscriber\Publisher are lost... The merge process could not retrieve article information for publication 'I-Test-Publisher'. (Source: Merge Replication Provider (Agent); Error number: -2147201017) -------------------------------------------------------------------- ...Show All

• Software Development for Windows Vista Manual Frame Capture using DirectShow

  In Vfw there there are three operations that one can use to capture frames one by one and store them to a single capture avi file. These operations are: WM_CAP_SINGLE_FRAME_OPEN WM_CAP_SINGLE_FRAME WM_CAP_SINGLE_FRAME_CLOSE So, between open and close operations we can issue WM_CAP_SINGLE_FRAME to capture multiple frames. Is there a way do do the same using DirectShow As far as i understand IMediaDet specs it doesn't help me because I want to store only choosen frames in a single avi file during a capture session. Any sugestions for my problem ...Show All

• Windows Forms Print Windows Forms using a scanned Image

  Good day. I have a Windows Form in C# 2005 that I want to print. I have a receipt(delivery Form) that i would like to fill in some values and print it out with the form. I have scanned the form into a jpg file, then I tried to set the background Image property of the winform to the image. However, the image appears very large, it won't display the exact size of the image which is about 5.5 w X 7.5 h inches . I also set the backgroundimage layout, setting it stretch and zoom will make the image quite smaller. And what command do i use to print the form. Also, there are some other forms and receipts that needs direct printing with winforms without using Crystal Reports. How Can i solve this kind of problem.. Any help would be greatly appre ...Show All

• SQL Server stored procedure parsing comments incorrectly

  For a second time I encountered a strange problem with a stored procedure, which is simply not parsing and executing correctly. On both occasions the problem occurred with pretty long stored procedures - the one I have now is 2000 lines long. The first time I saw this I was working on SQL Server 2000, now I have a SQL Server 2005, but the database is in SQL Server 2000(80) compatibility level. The problem is that a regular SQL comment is sometimes merged with the line under it. --some comment some SQL code is parsed as --some comment some SQL code You can see how this can be a huge problem. From what I know the contents of a sp are stored in the system table syscomments, which splits the longer stored procedures into several ...Show All

• Visual Studio Tools for Office Word 2007 content control event sinking in VSTO

  I am confused on whether (and if) Word 2007 Content Controls will be supported as a first class object in VSTO (similar to how Ranges and Bookmark objects are currently implemented using VSTO against Word 2003). For instance, I can create a Word 2003 template project in VSTO, and hook into the Bookmark events of the template using VSTO code. I am seeking similar functionality in Word 2007 using VSTO, but with Content Controls. At the moment, the only obvious way that I can find to access content control events is using VBA behind the Word template. (I am seeing other posts that refer to the use of "ThisDocument_ContentControlOnExit", but since VSTO SE currently supports Add-ins and not Template projects for Word 2007, I am ...Show All

• .NET Development How to create a script for creation of users and roles in a DB?

  Hi all, I was looking to create a script for users and roles of my database so that I can run the script whenever I am in need and if it exist it will drop and recreate again. What I am looking now is how to create the script for users and roles. I am using sql sever. Thank you in advance.  What database are you using If SQL Server you can create a text file with the CREATE USER command to create users http://msdn2.microsoft.com/en-us/library/ms173463.aspx And CREAT ROLE to create roles: http://msdn2.microsoft.com/en-us/library/ms187936.aspx ...Show All

• Visual Studio Team System Team project structure; build and deployment strategy.

  Hi. At our company we have one Team Project containing multiple solutions each containing multiple projects. Our primary solution contains 29 projects. Many of these projects are interdependent due to required project references. For example, several projects(website, webservices, client apps) all depend on a BLL project, DAL projects, plus a few others. It’s a typical n-tier setup supporting multiple apps of different types. Due to the way we currently have this setup, we’re encountering the following problems: 1.        Loading the primary solution is getting slower and slower. 2.        Team builds are slow. 3.        When addin ...Show All

• SQL Server Slow connection to sql server 2005

  I have a linked tables from access 2003 to sql server 2005 connected using odbc. the connection is very slow. when i use the same linked tables to sql server 2000 the connection is fine. what seems to be the problem I'm also experiencing the same problem. Using a SQL Server 2000 instance as source for the linked tables in MS Access is going smoothly and fast, mapping the tables to SQL server 2005 (running on Vista), dramatically reduces the respons times. SQL Profiler does not produce any relevant info, it just takes a heck of time to perform an adodb.recordset open call (5 sec) on a simple select, producing 1 record. SQL Server 2005 and MS Access 2003 all running on vista, using a ODBC conne ...Show All

• Visual C++ SetDPI

  How do I fixed SetDPI to 96 in my MFC Application Regards Manoj Jangid Please use the MSDN newsgroups for Win32 programming questions.  In particular, for your question, this is the best location: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.win32.programmer.gdi&lang=en&cr=US Thanks. ...Show All

• SQL Server How do I insert data from a flat file or .csv file into an existing SQL database???

  How do I insert data from a flat file or .csv file into an existing SQL database Here what I've come up with thus far and I but it doesn't work. Can someone please help Let me know if there is a better way to do this... Idealy I'd like to write straight to the sql database and skip the datset all together... strSvr = "vkrerftg" StrDb = "Test_DB" 'connection String strCon = "Server=" & strSvr & ";database=" & StrDb & "; integrated security=SSPI;" Dim dbconn As New SqlConnection(strCon) Dim da As New SqlDataAdapter() Dim insertComm As New SqlCommand( "INSERT INTO [Test_DB_RMS].[dbo].[AIR_Ouput] ([Event], [Year], [Contr ...Show All

• Visual Basic RichTextBox and StatusStrip

  I am tryin to make a status strip continuously update and show the location of the keyboard cursor at all times. For example, 3:33 would mean the curson is on the 3rd line and at the 33rd character. line : character on line Can someone please help me.....!!!!! This is clipped from my editor (I may call statusline in a few more places.) Private Sub RichTextBox1_KeyUp( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles RichTextBox1.KeyUp statusline() End Sub Private Sub statusline() Dim Ln As Integer = RichTextBox1.GetLineFromCharIndex(RichTextBox1.SelectionStart) Dim Cn As Integer = (RichTextBox1.SelectionStart) - (R ...Show All

• Visual Studio Express Editions Openfiledialog blues.

  I have looked on this forum for this and found some stuff but i am a noob and dont understand how it would be done. I am making a web browser and have it set up so i can save the web page. When I save the web page it will show up in the folder i saved it to just fine but i can't get the openfiledialog to work. I have been testing this using a .htm file. I can't even begin to get this to work, i can't even get the dialog to open. my dialog is openfiledialog1, and my browser window is webbrowser1. if anyone may be able to help guide me along that would be great. yes this was exactly what i was looking for, now if i would add tabs to my browser how would i get it to work then, each tab has its own name. this was a feature i wanted to ad ...Show All