Thanks so much for your responses on this subject.
The reason for wanting to install SQL 2005 is they are currently on Pervasive and upgrading to Sql. They would like to be on the most current version. In addition the reporting services and business intelligence will provide greater...
Does anyone know of an easy way to prevent ordered from being entered against a parent account. Our use of parent is to designate a headquarters for billing and open item consolidation. Orders should not be entered against this account.
Also, when you use OELINHST you get that wonderful field sls_amt which takes care of all the price discounts and rounding and propper sign for credits.
Promotions are run to stimulate future sales. For example a discount is offered for orders of summer products during the winter. When the orders are taken a future ship date is set to sometime in the summer. The problem of course is that the qty is allocated causing backorders on these items for...
On the database properties select options and make sure recovery model is full and the "auto shrink" option is checked. I assume you are backing up the transaction log with the "BACKUP LOG" command.
Dim s1 As String = "Aaa Ha"
Dim r As RegularExpressions.Regex = _
New RegularExpressions.Regex("a", RegularExpressions.RegexOptions.IgnoreCase)
Dim matches As Integer = r.Matches(s1).Count
MessageBox.Show(matches) 'should display 4
Scott,
Thanks for your response. It is scary to think that a company who is in business to provide data access can't produce a reliable state of the art method to access their data engine.
John Cronin
Does anyone have experience with an OLE/DB driver for pervasive. The driver is available from Pervasive as part of the SDK download but not a stand alone download. When I spoke with Pervasive support they recommended not using the OLE/DB driver and to continue using the ODBC driver.
The reason...
When I take that code out I get:
An unhandled exception of type 'System.Web.HttpException' occurred in system.web.dll
Additional information: Could not access 'CDO.Message' object.
Are you just trying to delete some rows from the DB. Then you don't need a dataset to do that. Datasets are used for working with disconnected data. The delete command, and update commands associated with the dataAdapter are used to synch the changes of the data in the dataSet back to the DB.
I had a similar problem when I attempted to send mail using an SMTP server that required autorization. You could give to following code a shot and see if it helps.
With mMail
.From = tbFrom.Text
.To = tbTo.Text
.Subject = tbSubject.Text...
when the combobox is databound you can use the SelectedValue property. Assuming you have Option Explit On and the value as in your example is a string.
MessageBox.Show(CType(ComboBox1.SelectedValue, String))
Dim conn As New SqlConnection
Dim command As New SqlCommand
conn.ConnectionString = "integrated security=SSPI;data " & _
"source=JOHNNB1;initial catalog=Northwind"
command.CommandText = "Select CompanyName from Customers " & _...
you should use the process Class. Has alot of flex. in this example I want to know when the process is closed by the user.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim proc As Process = New Process...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.