Hi everyone>

I am in the process of taking our existing FoxPro 6.0 database and "upsizing" it to SQL Server. So far, I haven't been able to get past the second screen of the upsizing wizard.

The first step is to select your FoxPro database, which I did

The next step is to select an ODBC data source, which I did.

After I click next, A SQL server login form pops up and prompts me for a user name and password. I haven't been able to get past this.

I was wondering if anyone reading this has had any experience upsizing FoxPro to SQL Server, using the wizard, and could point me in the right direction.

Note: I have on my local computer the SQL Server Utilities, but not an actual SQL Server database. That may be a huge problem. The actual SQL Server DBase I am trying to upsize to is on a remote server, hundreds of miles away!


I am just not clear on the exact steps I need to take to upsize. I apologize for this being so vague. I just don't know what specifics I can give. I am getting stuck on the second page of the wizard, where it prompts me for a user ID and a Password.

When I click "help", it says this SQL server login form only pops up when the user (me!) calls the ODBC driver w/o specifying enough information for the driver to connect to the SQL Server.

I don't know what it is talking about!

Any thoughts would be very helpful


Thank you in advance

Jason