How do I get Access 2007 Upsizing Wizard to connect to SQLserver?

[Guest]

My ODBC drivers seem set up correctly - the "test connection" in the ODBC
Data Source Administrator applet from Control Panel works. But when I try to
run the Access 2007 Upsizing Wizard to import my Access DB to my SQL Server,
I get "ODBC--call failed". Any ideas what's wrong?

 

[Guest]

Mike, Sorry I don't have an answer I too have the same issue and the upsizing
tool says "ODBC -- Call failed" whenever I try to connect to an existing SQL
server DB in the upsizing wizard and if I try to create a database it won't
connect to the SQL server and just says "ODBC -- connection to '<server
name>' failed." If you do get an answer can you please post it here so it
can help resolve my issue.

Thanks in Advance

Steve

 

[Guest]

Mike, Sorry I don't have an answer I too have the same issue and the
upsizing
tool says "ODBC -- Call failed" whenever I try to connect to an existing
SQL
server DB in the upsizing wizard and if I try to create a database it
won't
connect to the SQL server and just says "ODBC -- connection to '<server
name>' failed." If you do get an answer can you please post it here so it
can help resolve my issue.

Thanks in Advance

Steve