Wednesday, March 28, 2012
replacing Access db with SQL Server db
We are currently using a couple Access 2002 databases
that were recently converted from Access 97. The
databases are located on a Windows 2000 server and
accessed from Windows XP Pro workstations. One of our
databases has a loader program that looks in a particular
directory for some .txt files, then uploads them into an
Access table. Since upgrading, a message says that it's
an unrecognized database format. The loader was built to
work with Access 97 and is not working with 2002. The
programmer that created the loader program does not have
the latest versions so he can't help me. Can someone
give me any ideas on how to go about correcting this.
The other option would be to move the database into SQL
Server and use Access as front end, but I would still
need a 'loader' program and would not know how to create
it.
Does anyone have ideas, suggestions? If further
information is needed, I'd be happy to supply it.
Thanks in advance for your expertise.
D.If the loader is itself an Access db, find a consultant that will upgrade it
for you...sounds easier than doing a SQLServer conversion. If you go to SQL
Server, you can likely dump the loader and use SQL's built in DTS utility to
load the txt files
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:a67601c406cd$ee46b490$a501280a@.phx.gbl...
> Hi,
> We are currently using a couple Access 2002 databases
> that were recently converted from Access 97. The
> databases are located on a Windows 2000 server and
> accessed from Windows XP Pro workstations. One of our
> databases has a loader program that looks in a particular
> directory for some .txt files, then uploads them into an
> Access table. Since upgrading, a message says that it's
> an unrecognized database format. The loader was built to
> work with Access 97 and is not working with 2002. The
> programmer that created the loader program does not have
> the latest versions so he can't help me. Can someone
> give me any ideas on how to go about correcting this.
> The other option would be to move the database into SQL
> Server and use Access as front end, but I would still
> need a 'loader' program and would not know how to create
> it.
> Does anyone have ideas, suggestions? If further
> information is needed, I'd be happy to supply it.
> Thanks in advance for your expertise.
> D.
Replacing a Server
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.
Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.
|||Hi,
Look into the KB article:-
http://support.microsoft.com/default...b;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.
Replacing a Server
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.|||Hi,
Look into the KB article:-
http://support.microsoft.com/defaul...kb;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.
Replacing a Server
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.|||Hi,
Look into the KB article:-
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.
Monday, March 26, 2012
replacement for report manager
I am evaluating how far i can go in implementing repoting features of SRS in
my program.
I want to be able to write a Windows form (in C#) that has a grid/list
containing all the reports that I have made. The list may have been
previously enterd into the database along with other information needed to
run the particular report.
I want to be able to select in the grid/list(e.g. using a check box) which
reports to run, and what format to render each individual report, as well as
other parameters.
Is the Report Manager that extensible? Is it possible to create this sort of
replacement for Report Manager from C#?
I am using VS2005 and SRS 2005.
Thanks in advance!It is absolutely possible... I have written a report for a customer which
searches the reporting services met data database and returns a list of
reports which match the search criteria the customer wants.. It creates a
report which displays the report name, directory and description... Each
report name is a hot link to run the report... This was done in a report!~
Using a programming language you can do anything you wish... There is a
ReportViewer control ( Search for ReportViewer in Books on line.) that you
can use..
There are sample programs in the SQL directory /90 subdirectory which will
help get you started...
Reporting Services is also just a DotNet Web service, with an entire API
which can you call from your program as well.. It is the same API that MS
uses in the Report Manager..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"PacMan" wrote:
> Hi!
> I am evaluating how far i can go in implementing repoting features of SRS in
> my program.
> I want to be able to write a Windows form (in C#) that has a grid/list
> containing all the reports that I have made. The list may have been
> previously enterd into the database along with other information needed to
> run the particular report.
> I want to be able to select in the grid/list(e.g. using a check box) which
> reports to run, and what format to render each individual report, as well as
> other parameters.
> Is the Report Manager that extensible? Is it possible to create this sort of
> replacement for Report Manager from C#?
> I am using VS2005 and SRS 2005.
> Thanks in advance!
Wednesday, March 21, 2012
Replace Cluster Disks
Hello,
I have a two node SQL 2000 cluster running on windows 2003 enterprise server. We need to replace the SAN disks. Can we not disable SQL service & Cluster service, copy the contents from existing disks to target disks, swap the drive letter & start the services?
What is the best practice to do this? Appreciate your help.
Thanks
Rajan
It was not that straight forward. Cluster does not use drive letters for the volume....it uses the disk signatures.
I had to use clusterrecovery.exe utility from resource kit. It is a great tool.
Regards
Rajan
This technique will work just fine. I've used it many times.
In the cluster administrator stop the SQL Server and the SQL Agent.
Attach the new luns to the servers, and make them cluster resources.
Copy ALL the files and folders from the old drive to the new drive.
Switch out the drive letters so that everything looks eactly like before (just with the new drives).
Update the cluster resources lables for the drives so that they match the correct new drive letters.
Change the dependencies on the SQL Server cluster resource so that it now depends on the correct drive letters.
Startup the SQL Server and SQL Agent services in the cluster administrator.
All should be working well after that.
Replace Cluster Disks
Hello,
I have a two node SQL 2000 cluster running on windows 2003 enterprise server. We need to replace the SAN disks. Can we not disable SQL service & Cluster service, copy the contents from existing disks to target disks, swap the drive letter & start the services?
What is the best practice to do this? Appreciate your help.
Thanks
Rajan
It was not that straight forward. Cluster does not use drive letters for the volume....it uses the disk signatures.
I had to use clusterrecovery.exe utility from resource kit. It is a great tool.
Regards
Rajan
This technique will work just fine. I've used it many times.
In the cluster administrator stop the SQL Server and the SQL Agent.
Attach the new luns to the servers, and make them cluster resources.
Copy ALL the files and folders from the old drive to the new drive.
Switch out the drive letters so that everything looks eactly like before (just with the new drives).
Update the cluster resources lables for the drives so that they match the correct new drive letters.
Change the dependencies on the SQL Server cluster resource so that it now depends on the correct drive letters.
Startup the SQL Server and SQL Agent services in the cluster administrator.
All should be working well after that.
Wednesday, March 7, 2012
Repair a Sql Server
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?
Repair a Sql Server
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?
firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases
|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?
Repair a Sql Server
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?
Saturday, February 25, 2012
Reorganize data and index pages
SQL 2000 on Windows 2000. If I go into all tasks, maintenance plan, it
gives me an option to reorganize data and index pages. When I check on
it, it populates the line "change free space per page percentage to" and
puts in 10 in there. Is this the default for free space? Is it the
data pages that will have 10% free space or just the index pages? Are
data and index on the same pages?
Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***Hi
If you profile the maintainance plan is seems that choosing causes a call to
DBCC DBREINDEX which is documented in books online. The 10% free space value
is reversed to be a 90% fillfactor as described by:
fillfactor
Is the percentage of space on each index page to be used for storing data
when the index is created. fillfactor replaces the original fillfactor as
the new default for the index and for any other nonclustered indexes rebuilt
because a clustered index is rebuilt. When fillfactor is 0, DBCC DBREINDEX
uses the original fillfactor specified when the index was created.
If you look at the Table and Index Architecture section of books online you
will see how clustered and non-clustered indexes are composed.
or at:
http://msdn.microsoft.com/library/d...ar_da2_8sit.asp
http://msdn.microsoft.com/library/d...ar_da2_1tbn.asp
http://msdn.microsoft.com/library/d...ar_da2_75mb.asp
You may want to get "Inside SQL Server 2000" by Kalen Delany ISBN
0-7356-0998-5 which talks about this sort of thing in detail.
John
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:rF97e.5$Nk2.347@.news.uswest.net...
> Hello all,
> SQL 2000 on Windows 2000. If I go into all tasks, maintenance plan, it
> gives me an option to reorganize data and index pages. When I check on
> it, it populates the line "change free space per page percentage to" and
> puts in 10 in there. Is this the default for free space? Is it the
> data pages that will have 10% free space or just the index pages? Are
> data and index on the same pages?
> Thanks,
> Raziq.
>
> *** Sent via Developersdex http://www.developersdex.com ***
Monday, February 20, 2012
Rendering Reports to Web Application Interactive Features
available to internet users).
(Windows Authentication now but can be change to Form authentication)
To let outside users to view the report through internet, I create a asp.net
page to render the report: [Product Line Sales]
You can see here:
http://207.14.208.161/UnicareReport/frmImage.aspx
There is a linked report [Employee Sales Summary]: when click the [Employee
Name], ie [Jang, Stephen] in the above report, it should go to the linked
report: [Employee Sales Summary].
The problem is:
(1) How to also render the linked report in asp.net pages to allow internet
users click the [Employee Name] in the above report to go to the linked
report?
(2) The real problem is: How to pass the parameter value in the report
[Product Line Sales] (ie, enp id=20, etc) in the asp.net page to go to the
linked report [Employee Sales Summary].
(it's easy to do in the report designer in VS 2003: jump to URL or Report:
but the linked report in the report server [Unicube] is not availablre to
internet users).I found the solution:
http://207.14.208.161/UnicareReport/frmImage.aspx
You can click the Employee Name such as [Caro, Fernando],[Ito, Shu] to view
the linked report.
My solution is:
(1) First render the first report [Product Line Sales] on the web use render
method:
(You can see the code on RS BOOK ONLINE: ReportingService.Render Method
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_6x0z.asp )
For my example, the report rendered on The ASP.Net page frmImage.aspx
(2) Change the [jumpe to report] to [Jump to URL] in report [Product Line
Sales]
then deploy the report on Report Server:
For my example, the [jump to URL] Code is:
="http://207.14.208.161/UnicareReport/ESS.aspx?EmpID="&Fields!EmployeeID.Value
&""
(You need to change it to your web site domain/directory setting)
(3)Render the linked report [Product Line Sales] on the web use render
method
You have to render the 2 linked report [Employee Sales Summary] on webpage:
My ASP.net page is ESS.aspx:
Note:
To pass the parameter you can use request.querystring method, for example,
' Prepare report parameter.
Dim parameters(2) As ParameterValue
Dim EMPIDV As String
EMPIDV = Request.QueryString("EmpID")
parameters(0) = New ParameterValue
parameters(0).Name = "EmpID"
parameters(0).Value = EMPIDV
parameters(1) = New ParameterValue
parameters(1).Name = "ReportMonth"
parameters(1).Value = "6" ' June
parameters(2) = New ParameterValue
parameters(2).Name = "ReportYear"
parameters(2).Value = "2004"
"John Chen" <jchen@.uneriercarecorp.com> wrote in message
news:ewjry75tEHA.2072@.tk2msftngp13.phx.gbl...
>I installed RS on a Windows 2003 Server: [Unicube] (inside our network, not
>available to internet users).
> (Windows Authentication now but can be change to Form authentication)
> To let outside users to view the report through internet, I create a
> asp.net page to render the report: [Product Line Sales]
> You can see here:
> http://207.14.208.161/UnicareReport/frmImage.aspx
> There is a linked report [Employee Sales Summary]: when click the
> [Employee Name], ie [Jang, Stephen] in the above report, it should go to
> the linked report: [Employee Sales Summary].
> The problem is:
> (1) How to also render the linked report in asp.net pages to allow
> internet users click the [Employee Name] in the above report to go to the
> linked report?
> (2) The real problem is: How to pass the parameter value in the report
> [Product Line Sales] (ie, enp id=20, etc) in the asp.net page to go to the
> linked report [Employee Sales Summary].
> (it's easy to do in the report designer in VS 2003: jump to URL or Report:
> but the linked report in the report server [Unicube] is not availablre to
> internet users).
>
>|||Correct:
(3)Render the linked report [Employee Sales Summary] on another webpage:
My ASP.net page is ESS.aspx:
Note:
To pass the parameter you can use request.querystring method, for example,
' Prepare report parameter.
Dim parameters(2) As ParameterValue
Dim EMPIDV As String
EMPIDV = Request.QueryString("EmpID")
parameters(0) = New ParameterValue
parameters(0).Name = "EmpID"
parameters(0).Value = EMPIDV
parameters(1) = New ParameterValue
parameters(1).Name = "ReportMonth"
parameters(1).Value = "6" ' June
parameters(2) = New ParameterValue
parameters(2).Name = "ReportYear"
parameters(2).Value = "2004"
"John Chen" <jchen@.uneriercarecorp.com> wrote in message
news:eJWU8JEuEHA.348@.tk2msftngp13.phx.gbl...
>I found the solution:
> http://207.14.208.161/UnicareReport/frmImage.aspx
> You can click the Employee Name such as [Caro, Fernando],[Ito, Shu] to
> view the linked report.
> My solution is:
> (1) First render the first report [Product Line Sales] on the web use
> render method:
> (You can see the code on RS BOOK ONLINE: ReportingService.Render Method
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_6x0z.asp )
> For my example, the report rendered on The ASP.Net page frmImage.aspx
> (2) Change the [jumpe to report] to [Jump to URL] in report [Product Line
> Sales]
> then deploy the report on Report Server:
> For my example, the [jump to URL] Code is:
> ="http://207.14.208.161/UnicareReport/ESS.aspx?EmpID="&Fields!EmployeeID.Value
> &""
> (You need to change it to your web site domain/directory setting)
> (3)Render the linked report [Product Line Sales] on the web use render
> method
> You have to render the 2 linked report [Employee Sales Summary] on
> webpage:
> My ASP.net page is ESS.aspx:
> Note:
> To pass the parameter you can use request.querystring method, for example,
> ' Prepare report parameter.
> Dim parameters(2) As ParameterValue
> Dim EMPIDV As String
> EMPIDV = Request.QueryString("EmpID")
> parameters(0) = New ParameterValue
> parameters(0).Name = "EmpID"
> parameters(0).Value = EMPIDV
> parameters(1) = New ParameterValue
> parameters(1).Name = "ReportMonth"
> parameters(1).Value = "6" ' June
> parameters(2) = New ParameterValue
> parameters(2).Name = "ReportYear"
> parameters(2).Value = "2004"
>
> "John Chen" <jchen@.uneriercarecorp.com> wrote in message
> news:ewjry75tEHA.2072@.tk2msftngp13.phx.gbl...
>>I installed RS on a Windows 2003 Server: [Unicube] (inside our network,
>>not available to internet users).
>> (Windows Authentication now but can be change to Form authentication)
>> To let outside users to view the report through internet, I create a
>> asp.net page to render the report: [Product Line Sales]
>> You can see here:
>> http://207.14.208.161/UnicareReport/frmImage.aspx
>> There is a linked report [Employee Sales Summary]: when click the
>> [Employee Name], ie [Jang, Stephen] in the above report, it should go to
>> the linked report: [Employee Sales Summary].
>> The problem is:
>> (1) How to also render the linked report in asp.net pages to allow
>> internet users click the [Employee Name] in the above report to go to the
>> linked report?
>> (2) The real problem is: How to pass the parameter value in the report
>> [Product Line Sales] (ie, enp id=20, etc) in the asp.net page to go to
>> the linked report [Employee Sales Summary].
>> (it's easy to do in the report designer in VS 2003: jump to URL or
>> Report: but the linked report in the report server [Unicube] is not
>> availablre to internet users).
>>
>>
>