Accessing a .dbf file in SQL Server 2000

I am new to SQL Server 2000, and anxious to get started. I'm beginning with a project that will use a file saved in the .dbf(dBase) format.

I looked in the Books on Line under 'OLEDB Provider' and didn't find any help about dbf files. I did use the 'OLEDB Provider for Jet' example to create a linked server that accessed an Excel spreadsheet.

Can someone give me some pointers in accessing my dbf file in SQL Server 2000?

Thanks for any help.

Randyyou can create an odbc datasource and then set up a linked server with the 'ole db for odbc' driver. See in books online for more info.

Access help.

I am a beginning programmar using Access. I need help defining creating a query that shows the number of items from a particular field as there are many of the same items. As well as create seperate listings for each item as they are also located under different location keys. Can anyone help???

This question sounds pretty basic and I feel really dumb for asking.Look at the following 2 functions: count(*) and group by

col has values 1,3,6,1,2,1,1,3

e.g. - select col, count(*) from table group by col

would return:

col count(*)
1 4
2 1
3 2
6 1|||does the same rule apply when you are trying to sort 2 columns by count.

ex.

col 1 - High School 1, high school 2 high school 3
col 2- IIe, IIe, iMac, II, HP HP, IIe, IIe, iMac, II, HP HP
col 3 - count

I am trying to create a count list for: high school 1, 2 and 3.

Jeremy

Originally posted by rnealejr
Look at the following 2 functions: count(*) and group by

col has values 1,3,6,1,2,1,1,3

e.g. - select col, count(*) from table group by col

would return:

col count(*)
1 4
2 1
3 2
6 1

Access denied to global.asax

I have been fighting this for several days now and it is REALLY beginning to
irritate the crap out of me. Configuration is as follows:
Win2k3 server SP1
SPS 2003 SP1
SQL server is remote
Using the Network Service account to run the Report Server service
Using windows integrated for DB access
Impersonate = true in the web.config file
Reporting Services has been successfully initialized per the documentation
Paths for Reports and Report Server have been excluded in SharePoint
I can access http://<servername>/ReportServer just fine.
When I try and access http://<servername>/reports I am prompted for a
username and password and although I am a member of the local administrators
group I still can't access the Reports page. The username/password box comes
up three times and then redirects to that oh so glorious error message we all
know and hate.
I have tried granting my account, machine\aspnet, iusr_machinename
permissions to global.asax and still get the error message each and every
time.
It should not be this difficult to get an application to work. Any help is
appreciated more than you can possibly imagine.
TIA!!!!!!!
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the boxes
for the desired access.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\global.asax" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, Boolean
bFromProxy) +888
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize) +44
System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean
detectEncodingFromByteOrderMarks, Int32 bufferSize) +79
System.Web.UI.Util.ReaderFromFile(String filename, HttpContext context,
String configPath) +443
System.Web.UI.TemplateParser.ParseFile(String filename, String
virtualPath) +62
System.Web.UI.TemplateParser.Parse() +200
System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() +74
System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean
fCreateIfNotFound) +219
System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() +125
System.Web.UI.TemplateParser.GetParserCacheItem() +98
System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String
inputFile, HttpContext context, ApplicationFileParser& parser) +171
System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
+43
System.Web.HttpApplicationFactory.Init(HttpContext context) +485
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +170
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414> When I try and access http://<servername>/reports I am prompted for a
> username and password and although I am a member of the local
> administrators
> group I still can't access the Reports page. The username/password box
> comes
> up three times and then redirects to that oh so glorious error message we
> all
> know and hate.
> I have tried granting my account, machine\aspnet, iusr_machinename
> permissions to global.asax and still get the error message each and every
> time.
Try the NETWORK SERVICE account. Another thing that crosses my mind is
https. Did you set any certificates on IIS? If yes, try
https://<servername>/reports.
Christoph|||Christoph,
Not using SSL as yet. I just want to get this working on my dev server so I
know how to get it working on my production box.
NETWORK SERVICE has full control permissions on global.asax.
Thx for the help!
"Christoph Wienands" wrote:
> > When I try and access http://<servername>/reports I am prompted for a
> > username and password and although I am a member of the local
> > administrators
> > group I still can't access the Reports page. The username/password box
> > comes
> > up three times and then redirects to that oh so glorious error message we
> > all
> > know and hate.
> >
> > I have tried granting my account, machine\aspnet, iusr_machinename
> > permissions to global.asax and still get the error message each and every
> > time.
> Try the NETWORK SERVICE account. Another thing that crosses my mind is
> https. Did you set any certificates on IIS? If yes, try
> https://<servername>/reports.
> Christoph
>
>