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: 228582 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, May 20, 2009 4:05:49 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...

It's just an example. :-U

The example above is for mySQL. My mistake. I used SQL Server 2008. :-)

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