Anyone having successs using this with MySql? I keep getting the error:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near '?, ?, ?, ?, ?)'
at line 1
I run the outputted SQL string in mySql client and it works fine.
Anyone having successs using this with MySql? I keep getting the error:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near '?, ?, ?, ?, ?)'
at line 1
I run the outputted SQL string in mySql client and it works fine.
sql from debug:
INSERT INTO person (oid, CreatedDate, ModifiedDate, create_date,
person_name) VALUES (?, ?, ?, ?, ?)
@p1: 000000110001
@p2: 6/6/2004 8:25:15 PM
@p3: NULL
@p4: 6/6/2004 8:25:15 PM
@p5: testPlayer
Hi Eric,
I've fixed it now. The ByteFX provider wants parameter names in the MSSQL style (ie @param) instead of using the ? placeholder.
CVS has been updated now, or you can change the code in CMySqlDatabase.vb as follows:
Public Overrides Function getParamHolder(ByVal i As Integer) As String
Return "@p" & CStr(i)
End Function
- Richard.