MS Access "Upsizing" Tools in SQL Server

Dave,
I have tried the method that you described to import an Access database and
I keep getting the same error:
Could not set up data flow connections. The conection type OLEDB specified
for connection manager (then I see what looks like a registry entry) is not
recognized as a valid connection manager type.
I have also tried creating a new Integrated Services Project and run the
import from there. I get the same error. When I try to upsize in Access I
get a report that says that the tables were not converted.
Any suggestions?
"Dave Patrick" wrote:

> Good to hear. You're welcome.
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Alex Maghen" wrote:
> | Thanks. Yeah, I get it jow.
> |
> | Alex
>
>
Looks like this should sort it.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=255347&SiteID=1
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Rob" wrote:
> Dave,
> I have tried the method that you described to import an Access database
> and
> I keep getting the same error:
> Could not set up data flow connections. The conection type OLEDB
> specified
> for connection manager (then I see what looks like a registry entry) is
> not
> recognized as a valid connection manager type.
> I have also tried creating a new Integrated Services Project and run the
> import from there. I get the same error. When I try to upsize in Access
> I
> get a report that says that the tables were not converted.
> Any suggestions?

Moving SQL 2005 Express dbs using SQL Server Management Express Studio?

Is it possible to move a SQL 2005 Express database using the SQL Server
Management Express 2005 Studio tools? I am trying to move the default
databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
and would like to know if I can do this with the SME 2005 tools, rather than
using the command line method in KB224071.
Also, is there a list of what the default databases are for MOSS 2007, so I
can make sure that I move all the databases?
Thanks,
Rob G.
Hi Robert
"Robert Gordon" wrote:

> Is it possible to move a SQL 2005 Express database using the SQL Server
> Management Express 2005 Studio tools? I am trying to move the default
> databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
> and would like to know if I can do this with the SME 2005 tools, rather than
> using the command line method in KB224071.
> Also, is there a list of what the default databases are for MOSS 2007, so I
> can make sure that I move all the databases?
> Thanks,
> Rob G.
>
I am not sure about SQL Express Manager, but you can always use sp_detach_db
and sp_attach_db from a command prompt and SQLCMD see
http://support.microsoft.com/kb/224071/
John

Moving SQL 2005 Express dbs using SQL Server Management Express Studio?

Is it possible to move a SQL 2005 Express database using the SQL Server
Management Express 2005 Studio tools? I am trying to move the default
databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
and would like to know if I can do this with the SME 2005 tools, rather than
using the command line method in KB224071.
Also, is there a list of what the default databases are for MOSS 2007, so I
can make sure that I move all the databases?
Thanks,
Rob G.Hi Robert
"Robert Gordon" wrote:
> Is it possible to move a SQL 2005 Express database using the SQL Server
> Management Express 2005 Studio tools? I am trying to move the default
> databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
> and would like to know if I can do this with the SME 2005 tools, rather than
> using the command line method in KB224071.
> Also, is there a list of what the default databases are for MOSS 2007, so I
> can make sure that I move all the databases?
> Thanks,
> Rob G.
>
I am not sure about SQL Express Manager, but you can always use sp_detach_db
and sp_attach_db from a command prompt and SQLCMD see
http://support.microsoft.com/kb/224071/
John