L
Lou Arnold
I can't seem to create an ADP Project database on MSDE using MS
Access. I get no error messages, but no database is created. Why??
I've tried the SQL Server group but they can't solve it.
Please don't suggest alternative tools for creating a database I've
tried that and it works. The objective now is to use MS Access.
Symptoms:
We attempt to create a new database from MS Access on one computer, in
MSDE on the other computer. The SQL Server Database Wizard executes
normally, produces no error message, but at its final database
creation, its progress bar appears for only a split second and its bar
is empty. Looking in the MSDE directory confirms that no database has
been created.
Yet I am able to log on and create a database using Osql.exe, as well
as MSDE Plus a 3rd party alternative to MS Enterprise Manager. What
could be different between MS Access and this 3rd party tool??
Some details:
1) This is a single Win2K computer with MSDE2000A, MS Access SP3,
and MDAC 2.8.
2) File and Printer Sharing and Client for MS networks are
enabled.
3) MSDE is set for Windows Authentication only, but there is no
domain controller. This is an objective of the test-bed.
4) Named pipes have been disabled. Tests with named pipes enabled
did not change the symptoms or result.
5) All work was done under the standard Windows Administrator
account.
6) As this a named instance of MSDE, the client and server
network components have been set up to use port 1433.
7) There is no firewall on the computer.
8) I can connect to the Master db (a SQL Server default) and
create tables in there, but I cannot create a new database.
9) Using osql -E I was able to log onto the SQL Server in
Windows Authentication mode from the Windows Admin account. I was also
able to create a database once logged in. I could not log on using the
SA account and password.
10) The utility MSDE Plus is an alternative to MS Enterprise
Manager. With it I was able to create a database while logged on as
the Windows Administrator.
Lou Arnold
Ottawa, Canada.
Access. I get no error messages, but no database is created. Why??
I've tried the SQL Server group but they can't solve it.
Please don't suggest alternative tools for creating a database I've
tried that and it works. The objective now is to use MS Access.
Symptoms:
We attempt to create a new database from MS Access on one computer, in
MSDE on the other computer. The SQL Server Database Wizard executes
normally, produces no error message, but at its final database
creation, its progress bar appears for only a split second and its bar
is empty. Looking in the MSDE directory confirms that no database has
been created.
Yet I am able to log on and create a database using Osql.exe, as well
as MSDE Plus a 3rd party alternative to MS Enterprise Manager. What
could be different between MS Access and this 3rd party tool??
Some details:
1) This is a single Win2K computer with MSDE2000A, MS Access SP3,
and MDAC 2.8.
2) File and Printer Sharing and Client for MS networks are
enabled.
3) MSDE is set for Windows Authentication only, but there is no
domain controller. This is an objective of the test-bed.
4) Named pipes have been disabled. Tests with named pipes enabled
did not change the symptoms or result.
5) All work was done under the standard Windows Administrator
account.
6) As this a named instance of MSDE, the client and server
network components have been set up to use port 1433.
7) There is no firewall on the computer.
8) I can connect to the Master db (a SQL Server default) and
create tables in there, but I cannot create a new database.
9) Using osql -E I was able to log onto the SQL Server in
Windows Authentication mode from the Windows Admin account. I was also
able to create a database once logged in. I could not log on using the
SA account and password.
10) The utility MSDE Plus is an alternative to MS Enterprise
Manager. With it I was able to create a database while logged on as
the Windows Administrator.
Lou Arnold
Ottawa, Canada.