I did as you told, but was not able to see the connection.

Below is how I did.

( in form button method)

1-First I connected as below:

lcServer="siteground150.com"
lcPort= 3306
lcDatabase= "mydatase"
lcUser= "user"
lcPassword="password"
lcStringConn="Driver={MySQL ODBC 5.1 Driver};Server=&lcServer;Port=lcPort;Option=16384;Stmt=;Database=&lcDatabase;Uid=&lcUser;Pwd=&lcPassword"

SQLSETPROP(0,"DispLogin",1)


thisform.status.Value = "connecting"
thisform.status.BackColor = RGB(255,242,236)

lnHandle=SQLSTRINGCONNECT(lcStringConn)

IF lnHandle < 1

= MESSAGEBOX("cannot connect " + STR(lnHandle))
RETURN

ENDIF

( connection was sucessful )



2-Then I tried to use the wizard to create the view:


Tools > wizards > all wizards > remote view wizard.

In ODBC datasources I cannot see the connection.

If I switch to connections, the box is empty.

Am I in the right way or doing something wrong.

Moises





>So do I.
>
>You can't bind directly to a SQL table. Use a remote view.
>
>>Thank you. But I mean connecting to a msql and not table.dbf