>ok I installed the developer version of sqlserver 2008R2
>
>now in vfp i ran the upsizing wizard but it asks for a connection or odic data source how do I create this?

Probably the easiest way for starters is to create an User DSN ODBC connection in the Data Sources tool in the Administrative Tools menu from your start menu (assuming XP - what are you using?). You'll need to add a new User DSN using SQL Server Native Client driver (that will be in the list of driver choices). You can name the DSN whatever you want (you'll use that as the connection name in the upsizing wizard).

You then need to specify the SQL server - you can use the computer name or IP address of whichever machine has the SQL Server installed on it.

You can then have it use Windows Authentication (you will be authenticated by your windows login account) or you can use a SQL Server username and password. When you installed SQL Server, if you specified Mixed Mode authentication you will have specified a password for the administrative (sa is the name) account. You can specify the instead of windows authentication. Either should work.

When you click next, it should test the connection and either tell you you've failed or let you specify a default database (master is all you'll have for the moment).

Once you have that done, you've got a connection you can use in the upsizing wizard.


>
>
>Peter
>
>
>
>>If you get in a bind with any of this, ask here or feel free to send me an EMail and I'll try to help. There is a learning curve, but once you get the hang of it you'll never go back (All my VFP apps for the last 10+ years use SQL Server as the database).
>>
>>