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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
developerdude said:
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
Click to expand...
 
Back
Top