Can't pass first screen on SQL wizard to create new msde2000A DB

Hi,
I installed on my Windows2000 server (with SP4) MSDE2000 release A. The
problem is whenever I create a new MS Access Database project, the SQL Server
Database wizard shows up. The first screen asks for information like the name
of the server(SERVER01), the userID (sa) and the password. After I provide
all those information, whenever I click on the Next button, I have the
message box saying:
"Overflow" without any other explanation. I am using MS Office Premium. What
is curious is I create Ms Access .mdb file to import object from the master
DB and I am successfull using the same SA and password that I provided to the
setup program during the installation phase.
Does anybody have any idea why I have the "overflow" message?
hi Firedrich,
Zadi Friedrich wrote:
> Hi,
> I installed on my Windows2000 server (with SP4) MSDE2000 release A.
> The problem is whenever I create a new MS Access Database project,
> the SQL Server Database wizard shows up. The first screen asks for
> information like the name of the server(SERVER01), the userID (sa)
> and the password. After I provide all those information, whenever I
> click on the Next button, I have the message box saying:
> "Overflow" without any other explanation. I am using MS Office
> Premium. What is curious is I create Ms Access .mdb file to import
> object from the master DB and I am successfull using the same SA and
> password that I provided to the setup program during the installation
> phase.
> Does anybody have any idea why I have the "overflow" message?
please have a look at
http://support.microsoft.com/default...b;en-us;272384
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Can't import Access tables..?

Hi all,
When I use the import Wizard in SQL-2005 I get the following message:
TITLE: SQL Server Import and Export Wizard
--
Error 0xc002f210: Preparation SQL Task: Executing the query "" failed
with the following error:
"Retrieving the COM class factory for component with CLSID
{7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following
error: 80040154.".
Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
--
BUTTONS:
OK
--
..it's just plain tables.
What can be wrong?
Kent J.I had this with Access tables once and decided to use Microsofts
"Access to SQL Migration tool", not sure if that was the exact name
but... its available for download.. its really cool and fast...
don't even bother trouble shooting this to get the wizard to work; I
spent a long time until I gave in to using the tool.
Erik

Can't import Access tables..?

Hi all,
When I use the import Wizard in SQL-2005 I get the following message:
TITLE: SQL Server Import and Export Wizard
Error 0xc002f210: Preparation SQL Task: Executing the query "" failed
with the following error:
"Retrieving the COM class factory for component with CLSID
{7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following
error: 80040154.".
Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
BUTTONS:
OK
...it's just plain tables.
What can be wrong?
Kent J.
I had this with Access tables once and decided to use Microsofts
"Access to SQL Migration tool", not sure if that was the exact name
but... its available for download.. its really cool and fast...
don't even bother trouble shooting this to get the wizard to work; I
spent a long time until I gave in to using the tool.
Erik