Error with Parameter Query with ODBC to Remedy, a BMC Software com

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a parameter query using ODBC to Remedy in Microsoft
Query.
The ODBC connection is "AR System ODBC Sata Source".

In the query, in the "Criteria Field", if I use a string and click on
"Return Data to Microsoft Office Excel" everything is fine and the result is
inserted in the Excel sheet ( and is refreshable etc. )

If I use parameter in the Criteria Field like [Enter your Name:] and run it
inside Microsoft Query, then all is good and I get a pop-up form with the
question "Enter your Name:".

Problem occurs when I click on "Return Data to Microsoft Office Excel" - I
get a popup from Excel saying "Driver] Parameter missing" and the query is
lost and not executed and the result is not sent to excel.

Where should I be looking ? Google pulled up the same problem from others
but no solution.

Thanks in advance. - Sumitro.
 
Hi S.C.,
If I use parameter in the Criteria Field like [Enter your Name:] and run it
inside Microsoft Query, then all is good and I get a pop-up form with the
question "Enter your Name:".

Problem occurs when I click on "Return Data to Microsoft Office Excel" - I
get a popup from Excel saying "Driver] Parameter missing" and the query is
lost and not executed and the result is not sent to excel.
Click to expand...

Could you post the SQL statement you have (from MSQuery)? perhaps it needs some
delimiters?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
SELECT "TCR:ServerTableData"."Server Name", "TCR:ServerTableData"."DC
Location", "TCR:ServerTableData"."Type of Server",
"TCR:ServerTableData"."Server Model"
FROM "TCR:ServerTableData" "TCR:ServerTableData"
WHERE ("TCR:ServerTableData"."Capacity ID"=?) AND
("TCR:ServerTableData"."Design Type"='Decommission')
ORDER BY "TCR:ServerTableData"."Design Type", "TCR:ServerTableData"."DC
Location"


--
Work smarter, not harder.


Jan Karel Pieterse said:
Hi S.C.,
If I use parameter in the Criteria Field like [Enter your Name:] and run it
inside Microsoft Query, then all is good and I get a pop-up form with the
question "Enter your Name:".

Problem occurs when I click on "Return Data to Microsoft Office Excel" - I
get a popup from Excel saying "Driver] Parameter missing" and the query is
lost and not executed and the result is not sent to excel.
Click to expand...

Could you post the SQL statement you have (from MSQuery)? perhaps it needs some
delimiters?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
Click to expand...
 
Hi S.C.,
SELECT "TCR:ServerTableData"."Server Name", "TCR:ServerTableData"."DC
Location", "TCR:ServerTableData"."Type of Server",
"TCR:ServerTableData"."Server Model"
FROM "TCR:ServerTableData" "TCR:ServerTableData"
WHERE ("TCR:ServerTableData"."Capacity ID"=?) AND
("TCR:ServerTableData"."Design Type"='Decommission')
ORDER BY "TCR:ServerTableData"."Design Type", "TCR:ServerTableData"."DC
Location"
Click to expand...

I think all "..." should be replaced with [...]

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Back
Top