How can we use SQL 2000 or latest with Visual FoxPro
Hello Friends
I want use SQL in visual foxprox. how can do it. I ready many website, but all answer not fully cleared. Please send me Solutions.
My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR.
Waiting your reply.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 27, 2008 5:11 AM
UPDATED:
June 28, 2010 4:43 PM
Answer Wiki:
What specific questions do you have? There are tons to pages which show how to connect to SQL Server such as <a href="http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP">this one</a>, <a href="http://www.devarticles.com/c/a/SQL-Server/How-to-Connect-to-a-SQL-Server-from-Visual-FoxPro/">this one</a> and <a href="http://www.rennovationsoftware.com/how-to-connect-to-sql-server-from-visual-foxpro.html">this one</a>.
Fox Pro is a pretty old platform. You might want to look at moving to another development platform such as VB.NET or C#.
To see all answers submitted to the Answer Wiki: View Answer History.
I want upload DBF file on sql server using foxpro .exe and could nt please suggest
Moving foxpro data stored in dbf files can be attempted using SQL Server Intetgration Server as a Data Flow Task using an ODBC connection string. Among the ODBC drivers included are ‘Microsoft FoxPro VFP Driver (*.dbf)’ and ‘Microsoft Visual FoxPro Driver’.
I have not used these but The are listed as available when I go through the dialog to Create New Data Source’ in the Connection Manager pane of the Control Flow tab of the package designer.