CODEWITHSUNDEEP
c#asp.netmysqlsql
G Gr
G Gr

Reputation: 6080

mysql sntax error using sqldatasource in asp.net

Hi I keep getting this error using a sqldatasource in asp.net, I can connect and see mysql schema and it lists everything fine but every query I test is returned with an error even the manualy inputted ones.

enter image description here

Upvotes: 0

Views: 386

Answers (1)

Shekhar_Pro
Shekhar_Pro

Reputation: 18430

Visual Studio IDE doesn't supports schemas yet, so you would need to manually Pre-pend Table's Schema name in the Query.

Upvotes: 1

Related Questions