dbTalk Databases Forums  

Process the database

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Process the database in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
George Hester
 
Posts: n/a

Default Process the database - 11-11-2004 , 11:53 PM






Using Microsoft SQL 7 SP4 OLAP Analysis Services SP3.

After I add a New Database... in OLAP Manager and then navigate to Library |
Data Sources and try to add a Data Source I get to New Data Source... |
Microsoft OLE DB Provider for ODBC Drivers | Next | Dropdown | Use
datasource name my New Database is not listed as available and typing it in
does not fix the issue. What have I done wrong and can this be fixed?

Windows 2000 Professional SP4 ODBC 3.520.9030.0 MDAC 2.71 9030.0:
Lab06_N(dagbuild) Internet Explorer 5.01 SP4 Microsoft Office 2000 SP1

Thanks.
--
George Hester
_________________________________



Reply With Quote
  #2  
Old   
Jon Jahren
 
Posts: n/a

Default Re: Process the database - 11-12-2004 , 04:52 AM






George,
Are you sure you have a ODBC DSN configured? Try using the OLEDB Provider
for SQL Server instead if you want to connect directly to a SQL Server
database.

Jon Jahren

"George Hester" <hesterloli (AT) hotmail (DOT) com> wrote

Quote:
Using Microsoft SQL 7 SP4 OLAP Analysis Services SP3.

After I add a New Database... in OLAP Manager and then navigate to Library

Data Sources and try to add a Data Source I get to New Data Source... |
Microsoft OLE DB Provider for ODBC Drivers | Next | Dropdown | Use
datasource name my New Database is not listed as available and typing it
in
does not fix the issue. What have I done wrong and can this be fixed?

Windows 2000 Professional SP4 ODBC 3.520.9030.0 MDAC 2.71 9030.0:
Lab06_N(dagbuild) Internet Explorer 5.01 SP4 Microsoft Office 2000 SP1

Thanks.
--
George Hester
_________________________________





Reply With Quote
  #3  
Old   
George Hester
 
Posts: n/a

Default Re: Process the database - 11-13-2004 , 06:04 PM



NO DSN was not congured. Got to do that after I make the new database?
Jeeze looking again I see that. Sorry.

--
George Hester
_________________________________
"Jon Jahren" <jon.jahren.fightspam (AT) sqlkompetanse (DOT) no> wrote

Quote:
George,
Are you sure you have a ODBC DSN configured? Try using the OLEDB Provider
for SQL Server instead if you want to connect directly to a SQL Server
database.

Jon Jahren

"George Hester" <hesterloli (AT) hotmail (DOT) com> wrote in message
news:uehvtvHyEHA.2572 (AT) tk2msftngp13 (DOT) pgbl...
Using Microsoft SQL 7 SP4 OLAP Analysis Services SP3.

After I add a New Database... in OLAP Manager and then navigate to
Library
|
Data Sources and try to add a Data Source I get to New Data Source... |
Microsoft OLE DB Provider for ODBC Drivers | Next | Dropdown | Use
datasource name my New Database is not listed as available and typing it
in
does not fix the issue. What have I done wrong and can this be fixed?

Windows 2000 Professional SP4 ODBC 3.520.9030.0 MDAC 2.71 9030.0:
Lab06_N(dagbuild) Internet Explorer 5.01 SP4 Microsoft Office 2000 SP1

Thanks.
--
George Hester
_________________________________







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.