Problem - Visual Basic Discussion Boards

jds12073-Jan-07 5:59

3-Jan-07 5:59

I don't know why it is so difficult for me to connect to the MySQL database. But I have made a little progress. Data is being inserted to the db but the column names are being inserted instead of the values. Also after the program run for a while I will get the following error:
Can't connect to MySql Server(10048).

Here is some code to go by:
Dim myConnString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=192.168.1.27;" & _
"DATABASE=;" & _
"USER=;" & _
"PASSWORD=;" & _
"OPTION=3;"
Dim MyConnection As New Odbc.OdbcConnection(myConnString)
MyConnection.Open()
Dim MyCommand As New Odbc.OdbcCommand
MyCommand.Connection = MyConnection

MyCommand.CommandText = "INSERT INTO ls_orderitems (OrderItemID, OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES('OrderItemID', 'OrderDate', 'OrderCustomer', 'OrderAcctNum', 'OrderType', 'OrderSoNum', 'OrderItemPartNum', 'OrderItemPartDesc', 'OrderItemQty', 'OrderItemQtyRec', 'OrderItemQtyDtRec', 'OrderItemBO', 'OrderItemBODt','OrderItemCanceled', 'OrderItemCanceledDt', 'OrderItemNotes', 'OrderItemPONum', 'OrderItemRetailPrice', 'OrderItemSalePrice', 'Status', 'InsertDate')"

MyCommand.ExecuteNonQuery()
MyConnection.Close()

jds1207

jds1207

Re: MySql connection

Dave Kreskowiak3-Jan-07 6:34

Dave Kreskowiak

3-Jan-07 6:34

jds1207 wrote:
MyCommand.CommandText = "INSERT INTO ls_orderitems (OrderItemID, OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES('OrderItemID', 'OrderDate', 'OrderCustomer', 'OrderAcctNum', 'OrderType', 'OrderSoNum', 'OrderItemPartNum', 'OrderItemPartDesc', 'OrderItemQty', 'OrderItemQtyRec', 'OrderItemQtyDtRec', 'OrderItemBO', 'OrderItemBODt','OrderItemCanceled', 'OrderItemCanceledDt', 'OrderItemNotes', 'OrderItemPONum', 'OrderItemRetailPrice', 'OrderItemSalePrice', 'Status', 'InsertDate')"

jds1207 wrote:
Data is being inserted to the db but the column names are being inserted instead of the values.

Did you happen to look at what's in the VALUES clause?? It's inserting the Column names because that exactly what your telling it to do! VALUES ('OrderItemID', 'OrderDate', ... You've told it to insert these strings into the database. You have to build the SQL statement to insert the data you have stored in variables somewhere, preferrably using a parameterized query.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: MySql connection

jds12073-Jan-07 7:17

jds1207

3-Jan-07 7:17

What about the error message? Do you have any ideas?

Re: MySql connection

Dave Kreskowiak3-Jan-07 7:22

Dave Kreskowiak

3-Jan-07 7:22

You didn't supply a database name in your connection string. You left the DATABASE option blank. You have supply the name of the database you want the connection to work with.

Dim myConnString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
   "SERVER=192.168.1.27;" & _
   "DATABASE=????????????;" & _
   "USER=;" & _
   "PASSWORD=;" & _
   "OPTION=3;"

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: MySql connection

jds12073-Jan-07 7:29

jds1207

3-Jan-07 7:29

The database name is in the original code. I just did not post the names.

Re: MySql connection

Dave Kreskowiak3-Jan-07 11:37

Dave Kreskowiak

3-Jan-07 11:37

It could the IP is wrong, the MySQL server isn't running, the user ID and/or password is wrong, ...

Dave Kreskowiak
Microsoft MVP - Visual Basic

VB 6.0 IDE Project Explorer form icon

A long way from home3-Jan-07 5:16

A long way from home

3-Jan-07 5:16

In the Project Explorer window in VB 6.0, some of the icons for my forms are partially greyed out. The blank page part and the read-only lock part are okay, but the window with the aqua strip is greyed out. Does anyone know what this means? Thanks.

Confused | :confused:

A long way from home

Problem

amaneet3-Jan-07 1:25

amaneet

3-Jan-07 1:25

Sir/madam,
I am facing problem in the following line which is bold.I want to know the meaning of this line.It is associated with the following function.

<browsable(true), defaultvalue(false)=""> Public Property [ReadOnly]() As Boolean
Get
Return _ReadOnly
End Get
Set(ByVal Value As Boolean)
_ReadOnly = Value
End Set
end sub

Thanks and Regards
Pankaj

Re: Problem

Dave Kreskowiak3-Jan-07 2:16

Dave Kreskowiak

3-Jan-07 2:16

Which line? There isn't a line that's bold...

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Problem

Martin.Smith3-Jan-07 3:57

Martin.Smith

3-Jan-07 3:57

As already mentioned there is no line in bold, but looking at the code you have supplied there seems to be an end sub that is in error/not required.

My guess at this point in time is to delete the end sub at the bottom of your ReadOnly property.

Regards,

Martin

Re: Problem

Kevin McFarlane3-Jan-07 5:48

Kevin McFarlane

3-Jan-07 5:48

The end sub should be End Property.

Kevin

Reading XML

vivek_cs3-Jan-07 0:57

vivek_cs

3-Jan-07 0:57

How to read xml from a string object.

Reading XML from XML file is fine.

but how to read XML from a string, at that time there was error

Re: Reading XML

Martin.Smith3-Jan-07 2:27

Martin.Smith

3-Jan-07 2:27

Its hard to give an example without knowing what the XML data is, that said, below is an example that will create an x-path navigator for XML data taken from a string variable:

Dim sReader As New IO.StringReader(My_XML_Text_string)
Dim xDoc As New Xml.XPath.XPathDocument(sReader)
Dim xNav As Xml.XPath.XPathNavigator = xDoc.CreateNavigator()

The variable My_XML_Text_string contains your XML data....

At this point you can navigate through the XML nodes and attributes using the xNav instance

Regards,

Martin

Re: Reading XML

vivek_cs3-Jan-07 19:47

vivek_cs

3-Jan-07 19:47

Way is fine but Error I am receiving is same,
Same in case of XmlDocument.

Error "Root Element is missing"

Re: Reading XML

Martin.Smith3-Jan-07 21:29

Martin.Smith

3-Jan-07 21:29

It would seem there is a problem with your XML data and not your programming. The Root Node from your XML data is missing -- what is your XML data??

Martin

Error Message

morteza573-Jan-07 0:05

morteza57

3-Jan-07 0:05

hi, i have a windows application. in load event of my form i retrieve data from " Microsoft Access" database.
when i build or run form,i see several Error MessageBox with this content : "object reference not set to an instance of an object ".
after that i submit these,Program Runs Successfully!!
what is my problem?
thanks

Re: Error Message

Christian Graus3-Jan-07 0:19

Christian Graus

3-Jan-07 0:19

Your main problem appears to be that you can't decide what account to post with, or what language you're using. Or did a different user just happen to post the exact same question in the C# forum ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Error Message

morteza573-Jan-07 0:34

morteza57

3-Jan-07 0:34

Dear Christian Graus
I am programmer with both C# and VB
It happened many times ,i Asked my problem in both C# and VB forums and i accept my answer in only one of theme.
Thanks

Re: Error Message

Dave Kreskowiak3-Jan-07 2:14

Dave Kreskowiak

3-Jan-07 2:14

That message means you tried to set a property or call a method on a class that wasn't instantiated. The most common cause is that you assumed you'd get back an object from some kind of query, but instead, you got back Nothing and tried to use it or make some modification to it.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Error Message

morteza573-Jan-07 3:39

morteza57

3-Jan-07 3:39

Thank you MR Dave Kreskowiak

Building projects from a batch file

dlarkin772-Jan-07 23:48

dlarkin77

2-Jan-07 23:48

Hi,

I have created 2 simple projects, one executable and one dll. The exe has a reference to the dll.

When I try to compile the dll (TEST TWO.vbproj) from a batch file the exe (TEST ONE.vbproj) is compiled also. Why does this happen? I thought I would have to issue another command to build the exe.

The batch file I use looks like

<br />
FOR /F "tokens=2* delims=	 " %%A IN ('REG QUERY "HKEY_LOCAL_MACHINE\Software\Microsoft\VisualStudio\8.0" /v InstallDir') DO SET InstallDir=%%B<br />
<br />
set mycommand="%InstallDir%devenv" /build Release /out "C:\BuildErrors.log" ".\TEST TWO\TEST TWO.vbproj"<br />
echo %mycommand%<br />
<br />
@call %mycommand%<br />
<br />
pause<br />

If anyone can suggest a nicer way of finding out the Visual Studio installation path I'd be very grateful.

Thanks very much,

dlarkin77

Re: Building projects from a batch file

Colin Angus Mackay3-Jan-07 0:42

Colin Angus Mackay

3-Jan-07 0:42

Have you considered using MSBUILD instead of using the Visual Studio environment? As I understand it, visual studio just uses MSBUILD underneath the covers anyway.

It can be accessed from the following path:
%windir%\Microsoft.NET\Framework\v2.0.50727

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Building Windows Froms project using NAnt

dlarkin774-Jan-07 23:48

dlarkin77

4-Jan-07 23:48

Thanks for that info Colin. I started looking at MSBuild but I got totally sidetracked with NAnt.

I've been playing around with it and it looks pretty good. But whenever I try to build a Windows Forms application the XP Visual Styles are being lost. Can anyone tell me what I need to do to keep the xp styles?

The build file I use is below:

<code>
<?xml version="1.0" encoding="Windows-1252" ?>

<project name="TESTER" default="run" xmlns="http://nant.sf.net/release/0.85/nant.xsd">
<property name="basename" value="TESTER"/>
<property name="debug" value="true"/>
<property name="build.dir" value="bin"/>

<namespaceimports id="tester.imports">
<import namespace="Microsoft.VisualBasic" />
<import namespace="System" />
<import namespace="System.Collections" />
<import namespace="System.Data" />
<import namespace="System.Diagnostics" />
<import namespace="System.Drawing" />
<import namespace="System.Windows.Forms" />
</namespaceimports>

<target name="build">
<mkdir dir="${build.dir}"/>
<vbc target="winexe" output="${build.dir}/${basename}.exe" debug="${debug}"
main="TESTER.frmMain"
optioncompare="text"
optionexplicit="true"
optionstrict="true"
rootnamespace="TESTER"
removeintchecks="true">
<imports refid="tester.imports" />
<sources>
<include name="*.vb" />
</sources>
<references>
<include name="System.dll" />
<include name="System.Data.dll" />
<include name="System.Drawing.dll" />
<include name="System.Windows.Forms.dll" />
<include name="System.Xml.dll" />
</references>
</vbc>
</target>

<target name="run" depends="build">
<exec program="${basename}.exe" basedir="${build.dir}" />
</target>
</project>
</code>

Thanks very much,

dlarkin77

Updating DataSets

MatthysDT2-Jan-07 23:28

MatthysDT

2-Jan-07 23:28

What is the simplest way to update or add data with a DataSet?

My Dataset contains various tables with relations, I want a way to update my datasource according to all the changes that has taken place on my dataset (changes made by means of data-bound controls).

As far as I now System.Data.DataSet.AcceptChanges() does this, updating both the DataTables' and the DataRows' data to the datasource.

My problem is that when I add a control (eg. TextBox) to my form and setup it's DataBinding, it doesn't seem to communicate with the DataSet, so when I type something in that field and execute AcceptChanges() it doesn't update my datasource.

The control's databinding is setup to a BindingSource which has my dataSet as Source.

What does work is to do a BindingSource.EndEdit() for a specific DataTable and then a TableAdapter.Update() but this seems to update the datasource as well and totally bypasses the "global update" functionality I hope to obtain by using the Dataset.AcceptChanges() method.

you can't forget something you never knew...

"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann

virtual execution system

kiranknair2-Jan-07 22:59

kiranknair

2-Jan-07 22:59

note on virtual execution system

thank you

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.