>>can someone give some steps as to access sql server 2008 developer (64 bit) from vfp9.2 (32 bit)
>>
>>also can someone give me a translation table from vfp datatypes to sql date types
>>vfp iterger = sql ??
>>vfp char = sql??
>>
>>etc
>>
>>hnaks
>>
>>
>>Peter
>
>It depends what you want to use:
>ODBC or ADO.
>
>With ODBC you can use SQLCONNECT()/SQLSTRINGCONNECT() to connect to SQL Server.
>ADO you could use only CAs.
>
>VFP char-> SQL Char/varchar/nvarchar
>VFP int-> SQL tinyint/smallint/integer

how about the primary key which I vfp is integer