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


Well thank you very much. This would help me much an idea. Anyway, what SQL server installer did you use as back-end?

Regarding your source particularly:
lcStringConn="Driver={MySQL ODBC 3.51 Driver};Port=3306"+;
> ";Server="+lcServer+;
> ";Database="+lcDatabase+;
> ";Uid="+lcUser+;
> ";Pwd="+lcPassWord

I'm conscious on where did you get driver=(MySQL ODBC 3.51 Driver} and Port=3306 ? I wondering? Please, let me know...

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