SQL Server Connection problem

Hi,
Let me ask the short version first?
What is wrong with SQL 2008 express SP1/SP2 installation if local client app cannot connect to it until you install management studio express and suddenly everything is working?

Now Let me introduce the background:
I have got a deployment task of vb.net application originally developed in VB.net 2.0 and uses some 3rd party components developed in c++ and vb6. In project there are lots of SQLDMO usage and last owner solved SQL 2008 compatibility issue by using SQL 2005 backward compatibility package. So far this application working fine on Windows7 32bit environment.
Requirement was deploy it to 64 bit windows7.
I successfully created a installable package for 64 bit windows7 by replacing SQL server 2008 32 bit version with 64 bit version and SQL 2005 Backward compatibility pack also replaced with 64 bit version. In my project configuration I configured the application is X86 because otherwise I cannot use some 3rd party library originally in use. This set up working fine on my development environment.
But after I packaged and installed them to clean windows7 application can create the database but cannot create tables until I install management studio 2008 express on that environment. After that bingo!  everything works fine.

I do not want to add management studio as requirement of my application, there is no use of it but my application not working without it.

Can someone provide me some idea how can I debug/fix this problem? Or what might be going wrong? I have spent lots of time already and tried this with different setup.

I hope I provided enough detail but I can give you more detail if you ask.

Thanks in advance.
AikeremuAsked:
Who is Participating?
 
AikeremuAuthor Commented:
Thank you for everybody's comment, I found out yesterday the reason was adodb.dll was used in my application but it is not installed on my testing environment. Seems that dll comes with VS2005 that's why it works on my development environment and it seems also installed with management studio and that is the reason why my application works if management studio installed on my testing environment also.
I found that redistributing the file \program files\common files\merge modules\vs_piaredist.exe together with my application solves the problem.
0
 
lcohanDatabase AnalystCommented:
<<What is wrong with SQL 2008 express SP1/SP2 installation if local client app cannot connect to it until you install management studio express and suddenly everything is working?>>

This means that your " local client app" connects through some method/driver that is not installed with SQL Express SP1/SP2 but is part of Management tools suite - SSMSE

Microsoft SQL Server 2008 Management Studio Express (SSMSE) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

http://www.microsoft.com/download/en/details.aspx?id=7593
0
 
AikeremuAuthor Commented:
Hi, thanks for the comment but if so how can my local client app work with SQL 2008 express SP1 on 32 bit windows7 without problem? also in my development environment on 64 bit machine I have not installed management studio and when I debug it works well.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
AikeremuAuthor Commented:
It would be great if I can find what else I need to install in addition to SQL 2008 express and SQL 2005 backward compatibility package in order to make it work. I have suspected that it was msxml 6.0 because it is one of prerequisitives management studio. I tried to installed it but did not work.
0
 
lcohanDatabase AnalystCommented:
"how can my local client app work with SQL 2008 express SP1 on 32 bit windows7 without problem?"

That means in my opinion the "connectivity" component comes with Windows 7 32 but maybe not there  with 64 bit until you install SQL SSMSE tools.
0
 
AikeremuAuthor Commented:
closing this question since I found out the answer myself, lcohan's comment was helpful but did not answer my question fully
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.