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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
SQL 2005 Databases
 Login/Join
 
Platinum Member
posted
We are using the SQL2000 adapte to access SQL2000 databases. We are thinking of upgrading to SQL2005.

I just tested connecting to our SQL2005 test database with the WF SQL200 adapter and it worked. I was surprised. I didn't think it would work.

Is anyone else doing this? Have you encountered any problems?

Here is the code I used.

SQL SQLMSS COMMIT

ENGINE SQLMSS SET DEFAULT_CONNECTION CCR2005


SQL SQLMSS
SELECT * FROM LOG;

TABLE FILE SQLOUT
PRINT *
END


(Production: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
(Test: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
 
Posts: 105 | Location: Boston | Registered: April 23, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
We are using the same adapter for both the sql2000 and sql2005 databases
But I'm not sure if this in fact should be two different adapters.

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
<JJI>
posted
Lenny,

We are using both SQL 2000 and SQL 2005 with the same SQL 2000 adapter without any problem.

Like Frank already mentionned it's not sure that you should use 2 different adapters or not. For me this works with one and the same.

I realy wonder what the difference realy is between the two. Anyone an idea?
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
We found that the 2000 adapter couldn't access MS SQL Server 2005, but when we upgraded to the 2005 adapter, it could access both 2000 and 2005.

This is on the Linux reporting server, where the native MS SQL adapter is implemented via JDBC. We had to get 2005 JDBC drivers. This may be one reason for the different implementations.

Regards,

Dan Kenny
University of Nebraska at Omaha
Prod: WF 7.1.6 BID/MRE/DataMigrator Test: WF 7.6.1 BID/MRE/DataMigrator
 
Posts: 63 | Registered: March 07, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
It would be interesting to know why you would need the SQL2005 adapter if the SQL2000 adapter works for both SQL2000 and SQL2005.

Maybe someone from IBI could respond to this question?

Lenny


(Production: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
(Test: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
 
Posts: 105 | Location: Boston | Registered: April 23, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I did not hear anymore on this so I opened up a case with IBI.

The case number is 31072004

I wanted IBI to confirm or deny that the SQL2000 adapter is SUPPORTED when connecting to a SQL2005 database.

This is what I got back on my case.

" ok, I will create a symptom problem for this.
But please be aware that this configuration is functional but it is not officially supported.
This is due to the fact that if there are issues that arise that need to be add ressed by programming we will not be able to address the 2005 adapter for MS SQL 2000 as it will most likely break things from the 2005 adapter going against the MS SQL 2005 server."


I guess it comes down to buyer beware.


(Production: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
(Test: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
 
Posts: 105 | Location: Boston | Registered: April 23, 2003Reply With QuoteReport This Post
Master
posted Hide Post
you *could* try using ODBC instead.

We ended up going that route after having nothing but trouble connecting to a DB2/400 database, and performance seems fine.

We do however, get a "well, we can't help you with connectivity issues using that method, so we recommend using the provided adapter" on more than one occasion when contacting tech support.

Use the adapter if you can, if you get trouble use ODBC.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Reply With QuoteReport This Post
Member
posted Hide Post
If you are using both SQL 2000 and SQL 2005 Servers, I would recommend using the SQL 2005 client. This is typically how you would install a new instance.


WebFOCUS 53, 71, 76 - All Platforms
 
Posts: 15 | Location: Information Builders - Chicago | Registered: May 08, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


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