Search results for query: *

Thank you I could finally get the DSN connection to successfully connect to the remote MySQL server using the hostname, username and password.. it succeeded. But, in VFP, creating a remote view requires the connection to connect to a database. when I use the database name in the DSN...

Hi Mike No, I just started to create the Data Source Name (DSN. during the DSN configuration, I filled the server name,database name, username and password. It should be that easy, but when you test the connection using a push button on that same configuration form, it fails with the message...

Hi all I am trying to connect to a remote Mysql Database using MyODBC , but it seems to fail to connect, any body has suggestions or better experience in connecting to web based MySQL Databases. Thank you Bob

You can create a LOCAL VIEW of the table and set the ODER to RECNO() Decending, then use the view as the source for your list, easy and permanent without the (SET ORDER) confusion. Bob

yes Mike thank you for the AERROR idea , it helped to expose the error which was a connection busy error. the solution was that I had to set the fetch size to -1 for all the other views. it's okay for this case because those views contain limited number of records. I don't know why I didn't use...

Hi mike as I mentioned before, the problem appears on the client's computers and not on the development PC. my client is in a remote location and I have to test this on their location and I am waiting for them to arrange for this visit. I couldn't get somebody there to do the test for me...

Thank you mike. the FetchAsNeeded property is .F. and it is stated clearly in the SQL statement when I (VIEW SQL) of the remote view on the view designer. to make sure of this i issued the requery statements as follows: MESSAGEBOX(REQUERY("ITDLIST"))...

Hi I have a parameterized remote view on which I use the REQUERY() function. it works fine and retrieves the records normally but when I run the system on the client's computer it does not fetch any records.same data set, same version of vfp, SQL and everything. I checked the return value of...