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

[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.

 

[Jan Karel Pieterse]

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.

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

 

[Guest]

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.

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.

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

 

[Jan Karel Pieterse]

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"

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