Report Designer crashes when accessing Access DB via ODBC

Hi:
I am trying to build a report off of a stand alone MS Access 2000 database. I can create the Data Source using the "Driver do Microsoft Access" driver, version 4.00.6019.00.
When I go to create the query to create the Dataset, I right click to add a table, I can see the table list and check the table I want to use. It is at this point the Visual Studio crashes, closes and send off the error report to Microsoft.
What's up? Why is this happening? I can write reports to my heart's content using an IBM ODBC driver against our DB2 database on an AS/400. One would think that writing reports using all MS products this should go very smooth.
Thanks in advance.
Bruce.Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
work with Access?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> Hi:
> I am trying to build a report off of a stand alone MS Access 2000
database. I can create the Data Source using the "Driver do Microsoft
Access" driver, version 4.00.6019.00.
> When I go to create the query to create the Dataset, I right click to add
a table, I can see the table list and check the table I want to use. It is
at this point the Visual Studio crashes, closes and send off the error
report to Microsoft.
> What's up? Why is this happening? I can write reports to my heart's
content using an IBM ODBC driver against our DB2 database on an AS/400. One
would think that writing reports using all MS products this should go very
smooth.
> Thanks in advance.
> Bruce.|||Hi Robert:
Thanks. That did the trick.
I had been using the ODBC connection that caused VS to crash for the last year with Crystal Reports with no issues. Curious...
Thanks again.
Bruce.
"Robert Bruckner [MSFT]" wrote:
> Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
> work with Access?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
> in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> > Hi:
> >
> > I am trying to build a report off of a stand alone MS Access 2000
> database. I can create the Data Source using the "Driver do Microsoft
> Access" driver, version 4.00.6019.00.
> >
> > When I go to create the query to create the Dataset, I right click to add
> a table, I can see the table list and check the table I want to use. It is
> at this point the Visual Studio crashes, closes and send off the error
> report to Microsoft.
> >
> > What's up? Why is this happening? I can write reports to my heart's
> content using an IBM ODBC driver against our DB2 database on an AS/400. One
> would think that writing reports using all MS products this should go very
> smooth.
> >
> > Thanks in advance.
> >
> > Bruce.
>
>

Report Builder 401 Errors since SP1

I have been accessing SSRS and Report Builder on a SQL 2005 from the
Internet successfully for some time now but today I am receiving 401 errors
when I try to launch Report Builder. The details show a 401 error
"Unauthorized". This all worked fine until I installed SQL 2005 SP1.
Has anybody run into this before or any suggestions. I can still run saved
reports just fine, it is only the launch of Report Builder that fails.
Thanks, MikeWe got this from Report Manager after we installed Microsoft Windows
Server 2003 Service Pack 1 (SP1).
http://support.microsoft.com/Default.aspx?kbid=896861 solved our
problem.
Neil
Mike Morisoli wrote:
> I have been accessing SSRS and Report Builder on a SQL 2005 from the
> Internet successfully for some time now but today I am receiving 401 errors
> when I try to launch Report Builder. The details show a 401 error
> "Unauthorized". This all worked fine until I installed SQL 2005 SP1.
>
>
> Has anybody run into this before or any suggestions. I can still run saved
> reports just fine, it is only the launch of Report Builder that fails.
>
>
> Thanks, Mike

report authentication: windows prompt removal

Hello,

I'm writing a small program to access reports on a remote server. When simply accessing the server, using the reportviewer, I get a windows prompt for login. I would like to avoid this by passing the account information.

How should I do this? (Maybe through network credentials)

Could someone send me some example code?

Thank you.

Jos

i'm not sure but i think you mean that you want to acces it through internet explorer?

if that's the case , demanding the credentials depends on the zone your page is in

see internet explorer>extra>internet options>security

by default internet explorer demands credentials for public sites and uses integrated login for intranet, that i wouldn't change

the clue is that any address with a dot . (be it in an ip or dns notation, eg 10.2.54.56 or webserver.domain.local) is regarded by default as a public address

so either you add the adress in the intranet zone or you change the adress in wins notation style ( eg //webserver/reports)

|||

Well I want to access the reports through a small asp.net program. You may see the source code in http://www.odetocode.com/Articles/95.aspx

When I access my reportserver (http://sqlreport244_9.mysite4now.com/reportserver) I get prompted for a windows login.

What I would like to do is to set the credentials on the code of the asp.net program to avoid being shown the prompt. This program will be used by several users and don't want them to have to insert the password each time they access the reports.

Thanks