Jet - > sql2k reports
[Originally posted by chris b]
I've changed my reports over from a 'jet' provider to 'sql server' and my reports SEEM to be functioning normally.
HOWEVER, when I define the sqlserver and database
any report (datareports in VB) that uses the grouping tab in the dataenvironment command properties can't get rowset(s)
My code is:
Unload DataEnvironment1 '<------ I USE THIS TO REFRESH ALL THE REPORTS AT ONCE
DataEnvironment1.Connection1.ConnectionString = "Provider=sqloledb;Data Source=" & Dataentry.ServerName & ";Initial Catalog=" & Dataentry.DatabaseName & ";User id=sa;Password="
If I don't use the second line, the reports work fine, it can't be the code variables, otherwise all the reports would fail.
What is going wrong??? is there another way to specify the sqlserver & database on the fly?
PS: is it possible in 'SQL Server 2K/MSDE 2K' to have 2 users concurrently connect to the server under the same username?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL