Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: Novice Guy
  Where is Novice Guy?
 Bacolod
 Philippines
 Novice Guy
 Tags
Subject: RE: Client/SERver Programming
Thread ID: 228360 Message ID: 228575 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, May 20, 2009 2:28:10 AM         
   


Take time to read, analyze, and explore this link...

http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect

lcServer="localhost" && Server Name
lcDatabase="test" && Database Name
lcUser = "root"
lcPassword = "root"
lcStringConn="Driver={MySQL ODBC 3.51 Driver};Port=3306"+;
             ";Server="+lcServer+;
             ";Database="+lcDatabase+;
             ";Uid="+lcUser+;
             ";Pwd="+lcPassWord
*** Don't prompt for login
SQLSETPROP(0,"DispLogin",3)
lnHandle=SQLSTRINGCONNECT(lcStringConn)
IF lnHandle  > 0
   ? SQLTABLES(lnHandle,"TABLES")
   browse last nocaptions
   SQLDISCONNECT(lnHandle)
ELSE
   =AERROR(laError)
   MESSAGEBOX("Error at Connecting"+CHR(13)+;
              "Description:"+laError[2])
ENDIF


for connection strings..

http://www.connectionstrings.com/

Best Regards,

CriZ (,")

"Happiness is real when shared."

ENTIRE THREAD

Client/SERver Programming Posted by Novice Guy @ 5/18/2009 2:07:31 PM
RE: Client/SERver Programming Posted by Ammar Hadi @ 5/18/2009 2:49:09 PM
RE: Client/SERver Programming Posted by Novice Guy @ 5/19/2009 5:18:30 PM
RE: Client/SERver Programming Posted by Christian Tabligan @ 5/20/2009 2:28:10 AM
RE: Client/SERver Programming Posted by Novice Guy @ 5/20/2009 2:57:45 AM
RE: Client/SERver Programming Posted by Christian Tabligan @ 5/20/2009 4:05:49 AM
RE: Client/SERver Programming Posted by Novice Guy @ 5/20/2009 4:05:24 PM
RE: Client/SERver Programming Posted by Christian Tabligan @ 5/21/2009 6:05:06 AM
RE: Client/SERver Programming Posted by Novice Guy @ 5/21/2009 5:02:14 PM
RE: Client/SERver Programming Posted by Christian Tabligan @ 5/22/2009 1:43:37 AM
RE: Client/SERver Programming Posted by Tom Saddul @ 5/23/2009 5:54:28 AM
RE: Client/SERver Programming Posted by Novice Guy @ 5/26/2009 2:45:32 AM