December 15, 2007 at 11:13 pm
Hello everyone.. first post..
I start with a Vista Ultimate laptop running in x64 mode.
Add to that VS2005 in x64, and the load SQL 2005 (x64).
I did select SSIS, SSRS, and all of the goodies.
Nothing showed an error during installation.
SQL Server Configuration manager shows SSIS and the other services running.
The problem is, is that I don't see Business Intelligence Projects in either the SQL 2005 menu or as a VS 2005 project type. But yet they are "running"
I love these tool and want to learn more about them. Please help me get to where I can see them.
December 18, 2007 at 12:03 pm
VS2005 both the one that comes with SQL Server developer edition and I am assuming professional you installed are both 32bit applications. Yes you can use the pro to do some 64bits development I don't think Business intelligence is included. You can find the 32bits and 64bits components of SQL Server in the BOL. Hope this helps.
Kind regards,
Gift Peddie
December 18, 2007 at 12:16 pm
No, I loaded everything as X64 mode. Vista, VS2005, SQL2005
December 18, 2007 at 12:26 pm
I am trying to tell you loading VS2005 in 64bits mode will not give you a lot of development tools including Business Intelligence because those tools are in 32bits so also is Asp.net it can use 64bits dll but IIS must run in 32bits mode. What you can do is develop in 32bits and compile with AnyCPU option which means you can deploy the code in 64bits.
Kind regards,
Gift Peddie
December 18, 2007 at 12:37 pm
I was affraid of this.. Junk a copy of Vista Unlimate and go back to good ole reliable XP Pro..
Do you or anyone know if VS2008/SQL2008 intend to make these tools 64 bit?
December 19, 2007 at 10:59 am
I don't think so because Microsoft says the reason VS2008 is 32bits is their customers plugins about 1000 plus are all in 32bits. The good news is most database development tools let you develop in 32bits and deploy in 64bits. There are known issues but if you have the full VS2005 version check you build configuration you should have AnyCPU and X64, use AnyCPU and your code will run without issue. Hope this helps.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply