Run for your life

Visual Basic - Non ODBC

Set db = New Connection
db.CursorLocation = adUseClient
db.Open “PROVIDER=MSDataShape;Data PROVIDER=” & _
“Microsoft.Jet.OLEDB.4.0;Data Source=” _
& App.Path & “\fpdata.mdb;Jet OLEDB:” & _
“Database Password=”;”

Visual Foxpro - ODBC

STORE SQLCONNECT(’exdata’, ‘admin’,”) TO gnConnHandle
IF gnConnHandle <= 0
= MESSAGEBOX(’Cannot make connection’, 16, ‘SQL Connect Error’)

*!* execute
SQLEXEC(gnConnHandle,”SELECT * FROM USER”,”USER”)
ENDIF

Visual Foxpro - Non ODBC

gnConnHandle =  SQLSTRINGCONNECT(”driver=mysql odbc 3.51 driver;server=localhost;uid=root;pwd=;database=myData”)

Related posts:

1. Connection strings for Access with visual foxpro
2. Visual foxpro: Terminate active windows application
3. How to : Visual Foxpro | OO Calc
4. Export DBF to Excel
5. Load Form Login VFP

This entry was posted on Saturday, September 13th, 2008 at 9:01 am and is filed under Programming.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.