msg: Specified method is not supported

msg: Specified method is not supported

Postby m4him » Mon 18 Apr 2005 15:34

Using library 4.70.4
When I run the below query to my Windows xp machine running mysql 5.0.0-alpha-nt it works fine
When I run it on Linux 5.0.3-beta-standard it fails with the message
msg: specified method is not supported

This query works fine using Navicat 2004 which I believe uses a previous mysql library
Code: Select all
select tt.ndcCode,
   DATE_FORMAT(tt.VisitDate,'%Y%m%d')as searchDate,
   DATE_FORMAT(tt.VisitDate,'%Y%m')as YearMonth,
  sum(Qty)  as Used,
pharmacy.pharmacyinventory.stockItem,
pharmacy.pharmacyinventory.reorderLevel,
pharmacy.pharmacyinventory.ExpireFlag,
pharmacy.pharmacyinventory.ndcCode,
pharmacy.pharmacyinventory.Unit,
pharmacy.pharmacyinventory.TradeName,
pharmacy.pharmacyinventory.GenericName,
pharmacy.pharmacyinventory.Strength,
pharmacy.pharmacyinventory.Package,
pharmacy.pharmacyinventory.DoseForm,
pharmacy.pharmacyinventory.Route,
pharmacy.pharmacyinventory.Category,
pharmacy.pharmacyinventory.MasterCategory,
pharmacy.pharmacyinventory.multum_category_id,
pharmacy.pharmacyinventory.currentInventory
  from
(
SELECT
  diagnosis.VisitDate,
  diagnosis.Qty,
  diagnosis.ndcCode,
  diagnosis.confirmed
FROM
  diagnosis
WHERE
  (diagnosis.confirmed = 'Y' AND diagnosis.ndcCode != '0' AND DATE_FORMAT(visitDate,'%Y%m%d')   >= :parmStartDate AND   DATE_FORMAT(visitDate,'%Y%m%d') <= :parmEndDate)
) as tt
INNER JOIN pharmacy.pharmacyinventory ON (tt.ndcCode = pharmacy.pharmacyinventory.ndcCode)
group by tt.ndcCode
m4him
 
Posts: 4
Joined: Fri 15 Apr 2005 18:57

Postby Serious » Tue 19 Apr 2005 08:48

MySQLDirect .NET v2.80 does not provide full compatibility with MySQL Server v5.0.3. We are working to support its new protocol. Please look forward for the next build (we are planning to release it in a month).
Serious
 


Return to dotConnect for MySQL