Click here to Skip to main content
15,900,254 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
MatrixCoder3-Jan-07 8:40
MatrixCoder3-Jan-07 8:40 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
oogyboogyme3-Jan-07 8:51
oogyboogyme3-Jan-07 8:51 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
Tim Carmichael3-Jan-07 10:17
Tim Carmichael3-Jan-07 10:17 
GeneralRe: VB6 to VB.NET printing using Printer Language Pin
oogyboogyme4-Jan-07 13:00
oogyboogyme4-Jan-07 13:00 
GeneralRe: VB6 to VB.NET printing using Printer Language Pin
Tim Carmichael5-Jan-07 2:41
Tim Carmichael5-Jan-07 2:41 
QuestionEngineering problem-please advise Pin
neobavesten3-Jan-07 6:10
neobavesten3-Jan-07 6:10 
GeneralRe: Engineering problem-please advise Pin
nagendra rao s.v.3-Jan-07 20:07
nagendra rao s.v.3-Jan-07 20:07 
QuestionMySql connection Pin
jds12073-Jan-07 5:59
jds12073-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
AnswerRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 6:34
mveDave Kreskowiak3-Jan-07 6:34 
AnswerRe: MySql connection Pin
jds12073-Jan-07 7:17
jds12073-Jan-07 7:17 
GeneralRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 7:22
mveDave Kreskowiak3-Jan-07 7:22 
GeneralRe: MySql connection Pin
jds12073-Jan-07 7:29
jds12073-Jan-07 7:29 
GeneralRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 11:37
mveDave Kreskowiak3-Jan-07 11:37 
QuestionVB 6.0 IDE Project Explorer form icon Pin
A long way from home3-Jan-07 5:16
A long way from home3-Jan-07 5:16 
QuestionProblem Pin
amaneet3-Jan-07 1:25
amaneet3-Jan-07 1:25 
AnswerRe: Problem Pin
Dave Kreskowiak3-Jan-07 2:16
mveDave Kreskowiak3-Jan-07 2:16 
AnswerRe: Problem Pin
Martin.Smith3-Jan-07 3:57
Martin.Smith3-Jan-07 3:57 
AnswerRe: Problem Pin
Kevin McFarlane3-Jan-07 5:48
Kevin McFarlane3-Jan-07 5:48 
QuestionReading XML Pin
vivek_cs3-Jan-07 0:57
vivek_cs3-Jan-07 0:57 
AnswerRe: Reading XML Pin
Martin.Smith3-Jan-07 2:27
Martin.Smith3-Jan-07 2:27 
GeneralRe: Reading XML Pin
vivek_cs3-Jan-07 19:47
vivek_cs3-Jan-07 19:47 
GeneralRe: Reading XML Pin
Martin.Smith3-Jan-07 21:29
Martin.Smith3-Jan-07 21:29 
QuestionError Message Pin
morteza573-Jan-07 0:05
morteza573-Jan-07 0:05 
AnswerRe: Error Message Pin
Christian Graus3-Jan-07 0:19
protectorChristian Graus3-Jan-07 0:19 
GeneralRe: Error Message Pin
morteza573-Jan-07 0:34
morteza573-Jan-07 0:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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