Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql server - vfp how?
Message
 
To
11/04/2012 09:28:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01541027
Message ID:
01541039
Views:
66
>>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform