Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (FOC1406) SQL OPEN CURSOR ERROR
Go
New
Search
Notify
Tools
Reply
  
(FOC1406) SQL OPEN CURSOR ERROR
 Login/Join
 
Member
posted
I am getting following error message for quite a few of my procedure in webfocus.They run fine in the developer studio but when i try to schedule them using Report caster, i get the below listed error message.Does any one know what's causing it.

: Microsoft OLE DB Provider for SQL Server: [08001] [DBNETLIB][ConnectionO
pen (Connect()).]SQL Server does not exist or access denied.
L (FOC1406) SQL OPEN CURSOR ERROR.


WebFocus 7.1.6, Windows/SQL Server 2003,

Expected Output Formats: Excel, Word, HTML.
 
Posts: 2 | Registered: June 17, 2008Reply With QuoteReport This Post
<JG>
posted
1. In Dev Studio do you have the MSSQL server configured on localhost
and are you creating and testing the jobs on localhost?

2. Is the MSSQL server configured on the reportcaster WebFocus server?

3. Are you using explicit,password passthrough or trusted connection to MSSQl?

MSSQL trusted (which is most likely) has an issue if the caster job userid and password
are not valid Domain id's but are dedictaed run time id's.

The id must either be a valid domain id or it must be an MSSQL specific id and authentication
in MSSQL must be set to allow both.
 
Reply With QuoteReport This Post
Member
posted Hide Post
1. In Dev Studio do you have the MSSQL server configured on localhost
and are you creating and testing the jobs on localhost?
I am not sure but i believe it is a locast host. This was already setup by my precessdor.

2. Is the MSSQL server configured on the reportcaster WebFocus server?

Yes.

3. Are you using explicit,password passthrough or trusted connection to MSSQl?

I am using Explicit connection to MSSQL.


WebFocus 7.1.6, Windows/SQL Server 2003,

Expected Output Formats: Excel, Word, HTML.
 
Posts: 2 | Registered: June 17, 2008Reply With QuoteReport This Post
<JG>
posted
OK,

You need to go to the WebFocus server console used by the Report Caster server not your localhost.

Goto adapters and test the conection to the problem MSSSQL instance.

If that fails your adapter is configured incorrectly.

userid / password and server all need to be checked
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (FOC1406) SQL OPEN CURSOR ERROR

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.