Universal Data Exporter ASP Support Product Page
ADODB.Recordset error '800a0bb9' on Excel export
Asked 14 Mar 2012 19:26:52
1
has this question
14 Mar 2012 19:26:52 Paolo Cognetti posted:
hello folk Sorry for my poor english
![](/images/forum/smilies/icon_smile_wink.png)
I've this problem with UDE
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/inc/marketing/ScriptLibrary/dmxDataExporter.asp, line 918
I cannot send you an access to the page, it is on a very protected server and the application works in intranet If it is useful I can send you the source page
Thanks Paolo
Replies
Replied 15 Mar 2012 07:19:24
15 Mar 2012 07:19:24 Vulcho Vulev replied:
Hello Paolo.
Did you applied some filters to your recordset ?
Regards: Vulcho.
Did you applied some filters to your recordset ?
Regards: Vulcho.
Replied 15 Mar 2012 07:28:04
15 Mar 2012 07:28:04 Paolo Cognetti replied:
Hello Vulcho
This is my RS
---------------
<%
Dim RSProve
Dim RSProve_cmd
Dim RSProve_numRows
Set RSProve_cmd = Server.CreateObject ("ADODB.Command"![](/images/forum/smilies/icon_smile_wink.png)
RSProve_cmd.ActiveConnection = MM_HondaProveMoto_STRING
RSProve_cmd.CommandText = "SELECT * FROM prove_modelli WHERE codice_conc LIKE ? AND modello_prova LIKE ? AND cognome LIKE ? AND provincia LIKE ? AND anno LIKE ?"
RSProve_cmd.Prepared = true
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param1", 200, 1, 255, RSProve__MMParamDealerCode) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param2", 200, 1, 255, RSProve__MMParamModello) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param3", 200, 1, 255, RSProve__MMParamCognome) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param4", 200, 1, 255, RSProve__MMParamProvincia) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param5", 200, 1, 255, RSProve__MMParamAnno) ' adVarChar
Set RSProve = RSProve_cmd.Execute
RSProve_numRows = 0
%>
Thanks Paolo
This is my RS
---------------
<%
Dim RSProve
Dim RSProve_cmd
Dim RSProve_numRows
Set RSProve_cmd = Server.CreateObject ("ADODB.Command"
![](/images/forum/smilies/icon_smile_wink.png)
RSProve_cmd.ActiveConnection = MM_HondaProveMoto_STRING
RSProve_cmd.CommandText = "SELECT * FROM prove_modelli WHERE codice_conc LIKE ? AND modello_prova LIKE ? AND cognome LIKE ? AND provincia LIKE ? AND anno LIKE ?"
RSProve_cmd.Prepared = true
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param1", 200, 1, 255, RSProve__MMParamDealerCode) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param2", 200, 1, 255, RSProve__MMParamModello) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param3", 200, 1, 255, RSProve__MMParamCognome) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param4", 200, 1, 255, RSProve__MMParamProvincia) ' adVarChar
RSProve_cmd.Parameters.Append RSProve_cmd.CreateParameter("param5", 200, 1, 255, RSProve__MMParamAnno) ' adVarChar
Set RSProve = RSProve_cmd.Execute
RSProve_numRows = 0
%>
Thanks Paolo
Replied 15 Mar 2012 07:38:33
15 Mar 2012 07:38:33 Paolo Cognetti replied:
I use "LIKE" because in the "param" there's the SQL char "%" force search part of string
Replied 15 Mar 2012 08:13:38
15 Mar 2012 08:13:38 Miroslav Zografski replied:
Hello Paolo,
Please, provide more information on the way you set up the UDE - Are you setting it up as a Server Behavipr or as Behavior?
Can you provide a sample data of what you are trying to export? And in what format you are trying to export -xls, pdf, csv?
Also provide the file to my e-mail:
Regards,
M. Zografski.
Please, provide more information on the way you set up the UDE - Are you setting it up as a Server Behavipr or as Behavior?
Can you provide a sample data of what you are trying to export? And in what format you are trying to export -xls, pdf, csv?
Also provide the file to my e-mail:
Regards,
M. Zografski.
Replied 15 Mar 2012 11:51:24
15 Mar 2012 11:51:24 Paolo Cognetti replied:
OK miro i've send the info and the example files
Paolo
Paolo
Replied 15 Mar 2012 13:09:30
15 Mar 2012 13:09:30 Miroslav Zografski replied:
Hello Paolo,
thanks, will check on them.
Regards.
thanks, will check on them.
Regards.
Replied 22 Mar 2012 16:59:07
22 Mar 2012 16:59:07 Paolo Cognetti replied:
hello Miro
do you have some news for me?
Thanks
Paolo
do you have some news for me?
Thanks
Paolo
Replied 19 Apr 2012 12:07:11
19 Apr 2012 12:07:11 Paolo Cognetti replied:
Why this problem is "answered", were is the solution?
Thanks
Thanks