I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQLServer Error: 17
[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.
Does anyone know how I should proceed Any help would be appreciated.
Thanks
Error messages upsizing from MSAccess database to SQLServer
Valent Lei
Matthias R
http://support.microsoft.com/ scid=kb;en-us;303257&spid=2509&sid=49
HTH
Shinya Watanabe
swimmer
Which version of SQL Server are you using
Does the following help
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
deenaMay3
I did all the steps and I got the following error message:
ODBC - call failed.
I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.
Do you have any recommendations.
Thanks
Mark