Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mercator 6.7 and Sybase 12.5 StoPro

Status
Not open for further replies.

MarkX1

Programmer
Mar 17, 2005
7
0
0
BE
I'am a Mercator 6.7 newbie and struggling with the following problem :

I'am trying to read the result of a Sybase 12.5.1 stored procedure (only 1 row with 1 column and no input params) in an input card "varRunID" (defined as integer) while using the following GET > COMMAND -line (not a .mdq file)

-DBTYPE SYBASE -SOURCE MyServer\\MyDB -STMT exec dbo.MyStoPro -USER xxxxx -PASSWORD xxxxxx -TRACE mapTraceSQL.log

When I try to compile the map, I receive the following error :
M1012 ERROR :
Could not retrieve query information
varRunID

Sybase open client is installed, access to the db is ok
When using the DID, connection can be made and the StoPro is seen...

What am I doing wrong ?
 
Found the problem... Had to generate a tree through the DID and not simply declare an item...

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top