General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only