>>>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
Integer in SQL :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.