samfromchicago
MIS
I have created a query for Sybase database using MS Query. One of the criteria is set as parameter (meaning everytime I run the query, it would ask for user input for that field). It works perfect in MS Query but the problem comes when I try to use the query in MS Excel. In Excel, using Get External Data option, I run my original Database query. At that time it give me the following error message:
"[INTERSOLV][ODBC SQL Server driver]Inconsistent descriptor information."
If I take out the parameter (user input option) from MS Query and give static information, the results come in MS Excel without any problem. This leads me to believe that Excel is not sending information to MS Query proper way. Any help in this regard is highly appreciated.
"[INTERSOLV][ODBC SQL Server driver]Inconsistent descriptor information."
If I take out the parameter (user input option) from MS Query and give static information, the results come in MS Excel without any problem. This leads me to believe that Excel is not sending information to MS Query proper way. Any help in this regard is highly appreciated.