Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP & MySql
Message
From
24/10/2007 10:37:36
 
 
To
23/10/2007 22:32:15
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01262774
Message ID:
01263097
Views:
17
>Following is my Line of Code but it returns negitave value.
>
>cDatabaseName = 'Solistor'
>cUsername = 'Ahsan'
>cPassword = ''
>
>mHandle = SQLStringConnect("Driver={mySQL};" +;
> "Server=db1.database.com;" +;
> "Port=3306;" +;
> "Option=131072;" +;
> "Stmt=;" +;
> "Database="+cDatabaseName+";" +;
> "Uid="+cUsername+";" +;
> "Pwd="+cPassword)
>Please guide.


Ahsan

I don't know. I don't use MySQL. The command looks OK from examples. You have to make sure that the ports used are valid. Can you get to it from other means? If you can, use those same connection and credentials in VFP.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform