sbs2008

Question

I've VB 2005 application compiled in 32 bit and using SQL 2005 express edition. Can I migrate the 32bit VB .net application to a 64bit SBS 2008 server and SQL express 2008

---

Feizal

Answer 1

Hi Feizal,

Welcome to the MSDN forum.

In general, a 32bit application can be run in 64bit. But your issue is more complex.

>>Can I migrate the 32bit VB .net application to a 64bit SBS 2008 server and SQL express 2008

I just wondering what things you need to use in the SBS2008 server, the .exe file OR the Code?

If the .exe files of the Application, the answer is NO.

If you want the exe can be run successfully, you need to use the SQL server 2005 as database. At the same time, open the database remote access and edit your code to suitable for remote access of database.

If you mean refer to the code, the answer is Yes.

I have no idea about what version of VS in your SBS, but you can use the original logic and code to solve your issue but you need to load the data from  SQL Server 2005 to 2008.

Hope this helps.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Feizal,

We haven’t heard from you for several days. I’d like to mark my reply as answer firstly. If you have any additional questions, you also can unmark the replay and post your question here. 

Sorry for any inconvenience and have a nice day.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 3

In fact my source files will remain on windows xp.

I'm thinking about 2 options for deployment

1.  Client-server installation .The application would be installed on windows xp or windows 7 and my server would be SBS 2008 (domain installation) and SQL express 2008

2. The server SBS2008 would not be a domain. The application would be installed on the server 2008 using RDP (terminal services) and connecting to SQL express 2008. I wonder whether specific settings must be used for the compilation.

Do you think both options would work?

Thanks

---

Feizal

Answer 4

Hi Feizal,

I'd like to explain my suggestion clearly.

The application whether can be run in server side depends on what the connection string you used in the application.

As you mentioned, the database file is in XP PC. If you want your application can be used in SBS2008, you need edit the connect sting suitable for remote access. In this way, the database file can be accessed by the code.

Hope this clearly. 

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us