OLAP based reports not rendering

I hope someone with a bit of knowledge about Analysis Services and Reporting
Services can give me some help here, please.
A client has the following setup:
One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services sp
2 and IIS 5.
One Windows 2003 server running Analysis Services sp 3.
--
1 role has been created in AS, with full access to everything. This is an AD
group, and we've tried adding all sorts of AD users to this group, to give
them access to the cube. We haven't tried adding "Everyone" and given it
full access.
--
When developing reports, we can access the OLAP cube with the usual NT login
of the developer. The report report renders perfectly on the dev box.
In Report Manager, reports based on SQL Server queries works perfectly.
Reports based on OLAP will work when run on the server running Reporing
Services, but NO OTHER computer. So when we access the Reporing Services
server with Remote Desktop, the OLAP report will render. From any other
computer, all in the same domain, it won't work.
The error message we get is basically "Cannot create a connection to data
source '<our datasource>'". But the "explanation" varies depending on what
user we try to use in our connection settings. The most common was "Database
'<our database>' could not be found." The other one was "Unknown error
E_(bunch of characters)".
So... any suggestions? I've found posts from other people who seem to have
had the same problem as ours, but no solution. We haven't figured out where
the problem is. Is it the credentials sent from Internet Explorer? Is it the
identity used in the connection string? Is it a new bug in SP 2? Reporting
Services has just been installed, and SP2 was installed immedeately. We
don't know if it would have worked without SP2, and I guess we won't find
out.
All help is really appreciated on this one!
Yours,
Kaisa M. Lindahloh yes please - we are having the same problems and noone seems to be able
to help !!!!
Please can someone help ?
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
>I hope someone with a bit of knowledge about Analysis Services and
>Reporting Services can give me some help here, please.
> A client has the following setup:
> One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> sp 2 and IIS 5.
> One Windows 2003 server running Analysis Services sp 3.
> --
> 1 role has been created in AS, with full access to everything. This is an
> AD group, and we've tried adding all sorts of AD users to this group, to
> give them access to the cube. We haven't tried adding "Everyone" and given
> it full access.
> --
> When developing reports, we can access the OLAP cube with the usual NT
> login of the developer. The report report renders perfectly on the dev
> box.
> In Report Manager, reports based on SQL Server queries works perfectly.
> Reports based on OLAP will work when run on the server running Reporing
> Services, but NO OTHER computer. So when we access the Reporing Services
> server with Remote Desktop, the OLAP report will render. From any other
> computer, all in the same domain, it won't work.
> The error message we get is basically "Cannot create a connection to data
> source '<our datasource>'". But the "explanation" varies depending on what
> user we try to use in our connection settings. The most common was
> "Database '<our database>' could not be found." The other one was "Unknown
> error E_(bunch of characters)".
> So... any suggestions? I've found posts from other people who seem to have
> had the same problem as ours, but no solution. We haven't figured out
> where the problem is. Is it the credentials sent from Internet Explorer?
> Is it the identity used in the connection string? Is it a new bug in SP 2?
> Reporting Services has just been installed, and SP2 was installed
> immedeately. We don't know if it would have worked without SP2, and I
> guess we won't find out.
> All help is really appreciated on this one!
> Yours,
> Kaisa M. Lindahl
>|||Provider=MSOLAP.2;Client Cache Size=25;Data
Source=myOLAPServer;SSPI=Kerberos;Initial Catalog=myOLAPDB;Auto Synch
Period=20000
Look into setting up Kerberos/trust betweent he servers and check the
connection string above "Kerberos"
--
Gary Foster
"Kathy" wrote:
> oh yes please - we are having the same problems and noone seems to be able
> to help !!!!
> Please can someone help ?
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> >I hope someone with a bit of knowledge about Analysis Services and
> >Reporting Services can give me some help here, please.
> >
> > A client has the following setup:
> >
> > One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> > sp 2 and IIS 5.
> >
> > One Windows 2003 server running Analysis Services sp 3.
> > --
> > 1 role has been created in AS, with full access to everything. This is an
> > AD group, and we've tried adding all sorts of AD users to this group, to
> > give them access to the cube. We haven't tried adding "Everyone" and given
> > it full access.
> > --
> >
> > When developing reports, we can access the OLAP cube with the usual NT
> > login of the developer. The report report renders perfectly on the dev
> > box.
> > In Report Manager, reports based on SQL Server queries works perfectly.
> > Reports based on OLAP will work when run on the server running Reporing
> > Services, but NO OTHER computer. So when we access the Reporing Services
> > server with Remote Desktop, the OLAP report will render. From any other
> > computer, all in the same domain, it won't work.
> >
> > The error message we get is basically "Cannot create a connection to data
> > source '<our datasource>'". But the "explanation" varies depending on what
> > user we try to use in our connection settings. The most common was
> > "Database '<our database>' could not be found." The other one was "Unknown
> > error E_(bunch of characters)".
> >
> > So... any suggestions? I've found posts from other people who seem to have
> > had the same problem as ours, but no solution. We haven't figured out
> > where the problem is. Is it the credentials sent from Internet Explorer?
> > Is it the identity used in the connection string? Is it a new bug in SP 2?
> > Reporting Services has just been installed, and SP2 was installed
> > immedeately. We don't know if it would have worked without SP2, and I
> > guess we won't find out.
> >
> > All help is really appreciated on this one!
> >
> > Yours,
> >
> > Kaisa M. Lindahl
> >
>
>|||For our reports that use Analysis Services we had to do the following.
First, we ended up was using a single domain account hard-coded in the
data-link properties for the datasource. This account must have at least a
read-only role on the AS box in Analysis Manager. We were not allowed to use
Kerberos delegation as out SA team thought it was a security reisk on AD2k.
We may go this route once they have upgraded to AD2k3 as that release is
supposed to have the ability to provide scope limited Kerberos delegation.
Anyway, from here, it seemed like it would work. Our users are given access
or not based on their domain accounts being in a group ReportingServices on
the Report Server machine. What we found though was this still did not work.
Finally we found that after every deploy, we always have to go to the
web-based report manager, find the datasource that points to AS and check the
box "Use as Windows credentials when connecting to the data source" and then
retype the password and apply. After this our reports worked fine. Be aware
that this check box gets unchecked each time you deploy. I have not found
any other workaround. If you do, please let me know.
Hope this helps.
"garyf@.someone.com" wrote:
> Provider=MSOLAP.2;Client Cache Size=25;Data
> Source=myOLAPServer;SSPI=Kerberos;Initial Catalog=myOLAPDB;Auto Synch
> Period=20000
> Look into setting up Kerberos/trust betweent he servers and check the
> connection string above "Kerberos"
> --
> Gary Foster
>
> "Kathy" wrote:
> > oh yes please - we are having the same problems and noone seems to be able
> > to help !!!!
> > Please can someone help ?
> >
> >
> > "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> > news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> > >I hope someone with a bit of knowledge about Analysis Services and
> > >Reporting Services can give me some help here, please.
> > >
> > > A client has the following setup:
> > >
> > > One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> > > sp 2 and IIS 5.
> > >
> > > One Windows 2003 server running Analysis Services sp 3.
> > > --
> > > 1 role has been created in AS, with full access to everything. This is an
> > > AD group, and we've tried adding all sorts of AD users to this group, to
> > > give them access to the cube. We haven't tried adding "Everyone" and given
> > > it full access.
> > > --
> > >
> > > When developing reports, we can access the OLAP cube with the usual NT
> > > login of the developer. The report report renders perfectly on the dev
> > > box.
> > > In Report Manager, reports based on SQL Server queries works perfectly.
> > > Reports based on OLAP will work when run on the server running Reporing
> > > Services, but NO OTHER computer. So when we access the Reporing Services
> > > server with Remote Desktop, the OLAP report will render. From any other
> > > computer, all in the same domain, it won't work.
> > >
> > > The error message we get is basically "Cannot create a connection to data
> > > source '<our datasource>'". But the "explanation" varies depending on what
> > > user we try to use in our connection settings. The most common was
> > > "Database '<our database>' could not be found." The other one was "Unknown
> > > error E_(bunch of characters)".
> > >
> > > So... any suggestions? I've found posts from other people who seem to have
> > > had the same problem as ours, but no solution. We haven't figured out
> > > where the problem is. Is it the credentials sent from Internet Explorer?
> > > Is it the identity used in the connection string? Is it a new bug in SP 2?
> > > Reporting Services has just been installed, and SP2 was installed
> > > immedeately. We don't know if it would have worked without SP2, and I
> > > guess we won't find out.
> > >
> > > All help is really appreciated on this one!
> > >
> > > Yours,
> > >
> > > Kaisa M. Lindahl
> > >
> >
> >
> >sql

okay, how does THIS work?

I'm relatively new to Crystal Reports, and have a bunch of reports that are run from a proprietary application. Since the proprietary software people charge a mint for modifications to the reports, and it takes them months to do so, we purchased a copy of CR, and I've been doing modifications to the reports. Now, each report has a data source behind it, generally calling a SQL Server stored procedure. Problem is, the data source is not one we have here (not server name, user, or anything) so I can't log in to it. The stored procedures that are being called are named the same as those in our database, but I just renamed the procedure from one report on our SQL Server(thus the one the report is calling no longer exists on our server), and the report still runs fine! The data in the reports matches our database, but obviously, the stored procedures are coming from somewhere else. So my question is, where the H are the stored procedures being called by this report?Changing the name of the stored procedure wont affect the actual data source because it is only the alias displayed to the user. You can anything here.

To change the actual data source you need to change it from 'Set Location'

OK button is not working on file upload page

Hi everybody,
I hope than somebody can help me to fix my reporting services server.
I can upload reports on my reportin services server i dont know why but when
i press the OK button nothings happend everything is working bit i need to to
ulpload to new reports but i can't...
maybe if smebody know some diagnostic tool than can help to fix the problem
will be great.
plase, help....
Thanks.This happened to me once. But with the Apply button in the parameters section
of the report manager. This indicates the installation of reporting services
is corrupted and I had to reinstall it on the server.
Maybe that's not the problem for you, but it solved my problem.
"Edman" wrote:
> Hi everybody,
> I hope than somebody can help me to fix my reporting services server.
> I can upload reports on my reportin services server i dont know why but when
> i press the OK button nothings happend everything is working bit i need to to
> ulpload to new reports but i can't...
> maybe if smebody know some diagnostic tool than can help to fix the problem
> will be great.
> plase, help....
> Thanks.

Offsite Printing

Anyone have any suggestions on how I can go about getting Reporting Services
Reports(about 2000 pages) printed by a 3rd party printshop? PDF export etcmy co in the past has output the rpt to a PDF file, put the pdf on a cd, then
taken it to Kinkos to have them print out the file. This has worked will even
when travelling around the country.
hth!
"Davin" wrote:
> Anyone have any suggestions on how I can go about getting Reporting Services
> Reports(about 2000 pages) printed by a 3rd party printshop? PDF export etcsql

Offline Report Generation

Hi,

I have a requirement of generating very long reports (1-2hrs approx). Obviously the user would not like to wait for the report to come up to view.

Can I generate reports offline using SSRS 2005? If yes, then how can i submit the report for generation and re-direct the user to any other page, where he/she can see the status of the report (or continue to work on other pages).
If yes, then can I run an exe in the background to check the status of the report at regular intervals and notify the user once the report is completed? I checked the status of the report in the ExecutionLog table should be 'rsSuccessful', indicating the successful generation of the report.

If yes, then where (path) the reports generated offline are stored?

Thanks in advance.One option would be to schedule the reports and then deliver them to an email address or fileshare.
Another option would be to use the snapshot feature.
From BOL:

Report history is a collection of report snapshots. You can maintain report history by adding and deleting snapshots, or by modifying properties that affect report history storage. You can create report history manually or on a schedule.

To create report history, your role assignment must include the "Manage report history" task. To view report history, your role assignment must include the "View reports" task. Report history is available to all users who have access to the report. You cannot selectively enable or disable report history for a subset of users.

Snapshots in report history are identified by the date and time they were created. The date and time is based on when the query executed.

Offline Capabilities

Hello All,

I have developed a solution where the user can generate pivot based reports using excel with Analysis Services in the background.

Now the requirement is that the user should also be able to go offline.

I want to understand how can this be done. Given the fact that the data in the cube is of financial nature so we need to have very secure solution.

(I read about local cubes, but how will I secure them? today the customer is generating excel sheets and protects it with windows DRM.... the problem with that solution is that we have too much data to put in excel).

Securing local cubes:

http://sqljunkies.com/WebLog/mosha/archive/2006/03/08/local_cube_password.aspx
|||

Passwords don't provide a good security solution because they can be shared, they are known to the person.

Let's say an employee who had the excel sheet is leaving the company, he takes it along to his new employer and uses it there because he has the password.

Is it possible to DRM (digital rights management) protect a local cube. So that everytime someone opens a cube it makes contact to the DRM server to decide what can be done and read/write to the cube?

As I said that our security requrirement is very critical because the cube contains a lot of financial data.

regards,

Abhishek.

|||There is no DRM integration with local cube files.

Office Web Components Security Settings...?

I have a number of reports for which it would be useful to allow users to make use of the office web Components to allow them to maniplulate the data and then export it to excel..

But as soon as i click the Excel symbol to dump out the pivot table to excel i get the error message;

"Safety settings on this computer prohibit accessing a data source on another domian."

Now i have been into Internet Explorers Tools >> Options >> security and enabled the 'Access Data sources across domains' on my computer (in both the internet and intranet zones) but it still pops up.. and wont let me export to excel

Any ideas.. anyone..?

worked it out.. as well as allowing the "Access data across domains" option in IE you also have to add the website to the 'Trusted Sites'.

Odd Sum() problem

Hi everyone, first time posting here.

I am having an odd problem with Crystal Reports XI. I have a small database table in Oracle, only has 8 records in it. I want to do a grand total for each column in the database (adding up all 8 records).

But when I use the Sum(fieldname) command, I get a number that is way off. The other commands like Maximum(fieldname) return the value I expect. But Sum is way off.

I am using the columns in a different part of the report, and the report is broken down into sections that match the different records of this database. What I need is a grand total for each column for the whole report.

I even tried a running total, and it returns the same number that is more than twice what it should be. There has to be something I am missing.

Thanks for the help. I am pretty new to .net and programming so I might have used the wrong terms for something.Is the detail section hidden or supressed? If so, have you checked to see if you are selecting distinct records? When you run te report what is the record count in the lower right corner of the screen? It should only be 8.

Odd drill though date problem

Hi, i'm quite new to Reporting Services and am having some problems with a drill through I've sert up.

I have about 10 reports that link to each other passing all the required peramiters to limit the data shown, this includes 2 dates.

When accessing the first report I put a uk date in (dd/mm/yyyy) but RS decides to change it to a us date (mm/dd/yyyy) which the second report doesnt like as It's expecting a uk date.

I cannot pass the first report a us date as it doent like it.
If i pass it a iso date (yyyy-mm-dd) RS converts it into a uk date and passes that into the report.

I dont beleve I should have to manually format the date for the linkthoughs, but cant find a way around this.
I've tryed the reports on 2 diffrent RS 2000 servers with the same results.
Thanks

Dan

Hi Dan,

In the properties of report all the components can be listed on the top select Report in it and then in Language select English(United Kingdom). This should change the default format to dd/mm/yyyy

Hope this Helps.

|||It is better practice to set Language to "=User!Language".

This picks up the locale from IE.

You can still override formatting on individual items.

Read more:
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

scroll down to #93|||Hi, I've tryed setting the report manguage to 'Default', English(United kingdom), =User!Language none worked .
I even decided that the date format isnt really important and set the second level report language to English United states, but the report still wanted a uk date!

ag: There is no #93, I assume you mean #33

cheers
|||There is a 93, but you have to scroll down - they have not updated the contents at the top.

I think it might be case sensitive.

In the "language" box in report properies, click on 'expression'.

Then use the boxes at the bottom of the editor to select 'user ! lang...'

Think it is in constants or globals, whatever. Double click it to select.

If it still is not working with user!language, it means your IE settings are not set to UK

Can someone else post how to change IE regional settings, I can't be arsed.|||Hi, I've used = User!Language via the expression editor with no luck.
I've written = User!Language to a text box which prints en-GB so IE must be set to english (uk).

I've found no 93, IE doent show anything above no 38, Firefox however does.

|||You haven't overridden the settings in Start - control panel - regional.. - reg. options.

have you?

I remember a box once having short date as UK and long date as US.

I am using FF, well spotted.

Also check IE - options - general - languages...

and check the lang pref order.

The textbox doesn't have an overriding format ?|||No will be right, will check again in the morning.
I had another guy try the report with the same problem.
I've tryed creating 2 new reports one links to the second, this still has the same problem.

I'm really baffled with this.
|||

Are you having the problem in the Visual Studio IDE, or in the report server when you have deployed the report? I find that in the IDE it ignores UK date formatting...but when deployed to the report server it works fine.

Regards

Jof

|||

The ide requires the date to be passed as a us date so doesnt have this porblem.

The deployed rpeorts however expect the dates to be passed as uk.

dan

ODBC Select Data Source in Crystal reports - continuously prompts

I've created an ODBC entry for crystal reports. When I go to refresh and
run a report, it always prompts me with a select data source and SQL server
is at the bottom of the list under dBase, Excel and MS Access Database. If
I select it, the report runs. How do I have it automatically choose that
source so I don't have to select it each time?
Thank you.You should ask this question in a Crystal support newsgroup or site.
This one is for SQL Server, so your pickings will be slim.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
<advice1one@.hotmail.com> wrote:

quote:

---

>I've created an ODBC entry for crystal reports. When I go to refresh and
>run a report, it always prompts me with a select data source and SQL server
>is at the bottom of the list under dBase, Excel and MS Access Database. If
>I select it, the report runs. How do I have it automatically choose that
>source so I don't have to select it each time?
>Thank you.
>

---

|||Thank you, I figured it out, I needed to change the ODBC connector to named
pipes.
"Mary Chipman" <mchip@.nomail.please> wrote in message
news:do51vv0gshsu7e2g9mr6bl0i9sinf4bq4t@.
4ax.com...

quote:

---

> You should ask this question in a Crystal support newsgroup or site.
> This one is for SQL Server, so your pickings will be slim.
> -- Mary
> MCW Technologies
> http://www.mcwtech.com
> On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
> <advice1one@.hotmail.com> wrote:
>
server[QUOTE]
If[QUOTE]
>

---

ODBC Issue

Am I missing somthing obvious here. I create an ODBC System dataSource
programatically and I can see it in the registry.
However Crystal Reports or ODBC Admin fail to list it. Is there some other
area this info is held?
Chris
If you're sure the key is correct then it should show up.
You may want to check your MDAC installation. You can use
component checker to check MDAC - it's available at:
http://msdn.microsoft.com/data/mdac/...s/default.aspx
-Sue
On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Am I missing somthing obvious here. I create an ODBC System dataSource
>programatically and I can see it in the registry.
>However Crystal Reports or ODBC Admin fail to list it. Is there some other
>area this info is held?
>Chris
>
|||Sue
I am unsure why MDAC would be an issue here. Is this something you have
seen?
I am 100% sure the key is ok. If I use regedit all the settings under ODBC
key are there and correct
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.4ax.com...
> If you're sure the key is correct then it should show up.
> You may want to check your MDAC installation. You can use
> component checker to check MDAC - it's available at:
> http://msdn.microsoft.com/data/mdac/...s/default.aspx
> -Sue
> On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
|||Some of the MDAC files are for the ODBC Data Source
Administrator applet.
-Sue
On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>I am unsure why MDAC would be an issue here. Is this something you have
>seen?
>I am 100% sure the key is ok. If I use regedit all the settings under ODBC
>key are there and correct
>Chris
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.4ax.com.. .
>
|||Ok Will look into this
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.4ax.com...
> Some of the MDAC files are for the ODBC Data Source
> Administrator applet.
> -Sue
> On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
|||Sue
The checker showed all was ok with the installation. So back to square one
Chris
"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Ok Will look into this
> Thanks
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.4ax.com...
>
|||Post the code you are using. The only way I can reproduce it
if I miss something in code in creating the DSNs.
-Sue
On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>The checker showed all was ok with the installation. So back to square one
>Chris
>"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
>news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
>
|||Sue
I am not using VB but in a 4GL so the code may not be useful. However you
said that the only way you can reproduce it is if you miss something in
code.
However if there is something I am missing the VB code (I assume thats what
you are using) that you are using may be illustrative to me where I am going
wrong.
If not is there a list of what needs to be done as I believe I am doing all
that is required to the registry
Chris Spencer
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:v25081t0fmbt88752luib8u7cc3hr3j49u@.4ax.com...
> Post the code you are using. The only way I can reproduce it
> if I miss something in code in creating the DSNs.
> -Sue
> On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>

ODBC Issue

Am I missing somthing obvious here. I create an ODBC System dataSource
programatically and I can see it in the registry.
However Crystal Reports or ODBC Admin fail to list it. Is there some other
area this info is held?
ChrisIf you're sure the key is correct then it should show up.
You may want to check your MDAC installation. You can use
component checker to check MDAC - it's available at:
http://msdn.microsoft.com/data/mdac...ds/default.aspx
-Sue
On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Am I missing somthing obvious here. I create an ODBC System dataSource
>programatically and I can see it in the registry.
>However Crystal Reports or ODBC Admin fail to list it. Is there some other
>area this info is held?
>Chris
>|||Sue
I am unsure why MDAC would be an issue here. Is this something you have
seen?
I am 100% sure the key is ok. If I use regedit all the settings under ODBC
key are there and correct
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.
4ax.com...
> If you're sure the key is correct then it should show up.
> You may want to check your MDAC installation. You can use
> component checker to check MDAC - it's available at:
> http://msdn.microsoft.com/data/mdac...ds/default.aspx
> -Sue
> On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
>|||Some of the MDAC files are for the ODBC Data Source
Administrator applet.
-Sue
On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>I am unsure why MDAC would be an issue here. Is this something you have
>seen?
>I am 100% sure the key is ok. If I use regedit all the settings under ODBC
>key are there and correct
>Chris
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.
4ax.com...
>|||Ok Will look into this
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.
4ax.com...
> Some of the MDAC files are for the ODBC Data Source
> Administrator applet.
> -Sue
> On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
>|||Sue
The checker showed all was ok with the installation. So back to square one
Chris
"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Ok Will look into this
> Thanks
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.
4ax.com...
>|||Post the code you are using. The only way I can reproduce it
if I miss something in code in creating the DSNs.
-Sue
On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>The checker showed all was ok with the installation. So back to square one
>Chris
>"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
>news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
>|||Sue
I am not using VB but in a 4GL so the code may not be useful. However you
said that the only way you can reproduce it is if you miss something in
code.
However if there is something I am missing the VB code (I assume thats what
you are using) that you are using may be illustrative to me where I am going
wrong.
If not is there a list of what needs to be done as I believe I am doing all
that is required to the registry
Chris Spencer
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:v25081t0fmbt88752luib8u7cc3hr3j49u@.
4ax.com...
> Post the code you are using. The only way I can reproduce it
> if I miss something in code in creating the DSNs.
> -Sue
> On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
>