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