We help IT Professionals succeed at work.
Get Started

SQL Express

Larry Rungren
on
348 Views
Last Modified: 2012-08-13
I have an application that was designed using Access, but I needed to migrate the data to SQL 2005, and in this instance Express version.  There are a number of hierarchical structure that need to be dealt with and CTE's seem to be the best option. After a truly exhausting experience finding a way to move the tables to express. I need to modify the database connection string to attach to the sql database in VB6.

I have visited about 25-30 web search sites to get the syntax correct and so far no luck.
The database location by default is ridiculously deep in the tree.

1.  How do I change the location of the database structures?

2. I need to create using vb6 deployment wizard the ability to install the vb app and the databases and the redisributable version of express.

I would like to build the final structure on my desktop and have the install duplicate for my client.

Can anyone outline the process,  and most importantly can anyone give me a connection string that works.  For
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE