Hello All!

I've just migrated by databases to SQL 2005, it works quite well, but now I
have problems with AS.
I couldn't manage to migrate AS2000 DB to AS2005. First question:
- Does AS2005 support ODBC data source? I want to connect to MySQL database,
via MyODBC and I cannot find it?!
- Do I really need to use Microsoft Visual Studio to create OLAP cube? I
cannot seem to alter anything when connected directly to Analysis Services.
For example, I can create new database,
but when I right-click on the Data sources, the only option I see is
'Refresh'.
Any ideas?

Thank you and kind regards,
Dejan

No and yes. Sorry :-)


Dejan Markic wrote:

In article <kSgIf.78$oj5.35032 (AT) news (DOT) siol.net>, dejan (AT) akton (DOT) is says...
This might be because you are in the wrong tool. You need to use the
Business Intelligence Development Studio (BIDS) to migrate from an AS2k
server to AS2k5. (you need to connect to a running AS2k server - you
can't backup/restore from AS2k to AS2k5)

AS2k5 uses .Net providers and OLEDB providers. I does not have native
support for ODBC. AS2k used to have the OLEDB provider for ODBC, but I
could not find that on my AS2k5 machine. You might want to try the .Net
provider for MySQL
(http://dev.mysql.com/downloads/connector/net/1.0.html)

No you don't BIDS comes with SQL Server 2005 and that is all you need
(it is in fact based on the Visual Studio IDE, but you don't need to buy
a separate license of VS.NET)

The Refresh option only appears in SQL Server Management Studio. If you
use BIDS instead, you will get the option to create new datasources.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

Hello!

I've installed the MySQL .NET, but I cannot choose it for DataSource in
SBID. Do I need to do anything else, besides the install of MySQL .NET?
I'm really not familiar with this .NET stuff ... help, please

Kind regards,
Dejan

<Darren Gosbell> wrote