but I'm too much newbie for the lan setup.. :-(
from my "SQL server" VM, I can ping the NB... from the NB I can ping the VM..
but nslookup don't work..
but I'm too much newbie for the lan setup.. :-(
from my "SQL server" VM, I can ping the NB... from the NB I can ping the VM..
but nslookup don't work..
Google this:
how to setup reverse dns in windows
or look here and be sure to add entries your client machines.
https://technet.microsoft.com/en-us/.../cc958812.aspx
Last edited by barrymavin; 2018-03-27 at 19:33.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
Hi Barry,
Ok, I try... but I'm not working with domain..
I've a standalone NB linked to a commercial internet Router..
And I don't understand why I need to do this setup if I use IP address on ODBC settings.. :-(
Ok, finally.. nslookup work. I've found a bad setup on the Lan settings.
this is from my machine:
this from LianjaServer (a VM)
this, the explain command:
Code:******************************************************************************** Explaining execution plan for command: select cod_art,des_art from articoli_alldata -------------------------------------------------------------------------------- SET EXCLUSIVE ON SET NETWORKSHARE OFF SET SMARTQUERY OFF SET STRCOMPARE ON (Case insensitive string comparisons with padding) SET DCACHE ON (Table page cache) SET DCACHEBLOCKSIZE TO 8192 (Size of table cache pages) SET DCACHESIZE TO 10 (Number of table pages to cache) SET ICACHE TO 50 (Index node cache) SET SQLCACHE ON (SQL Query cache) SET SQLCACHESIZE TO 65536 (Size of SQL Query cache extents) SET SQLBUFFERSIZE TO 1024 (Number of SQL write cache buffers) Total I/O read operations was 0 Total I/O read size was 8.0895MB Total I/O write size was 7.7695MB Total SEEK operations performed was 0 Total SEEK operations failed was 0 Total locks performed 0 Total rlocks performed was 0 Total unlocks performed was 0 (0 active) Total I/O read cache hits was 0 Total I/O read cache misses was 0 Total I/O index reads was 0 Total I/O index cache hits was 0 Total I/O index cache misses was 0 9057 records selected in 29.420 seconds
You don’t need to understand just believe me. It’s a TCP/IP requirement for performant connections.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
Still incorrectly configured.
Yesterday you said you fetched 2-3000 records but you are fetching 9000 into a tree grid across the network. That’s not what it’s supposed to be used for. You need to rethink your design and perhaps assign the autosuggestion SQL SELECT with a WHERE condition after the first character is typed.
I sent you links on how to setup DNS entries. Did you do that or just ignore my advice?
Also your domain names look very strange.
Read up about FQDN and add these to your hosts file on the server.
https://technet.microsoft.com/en-us/.../cc959322.aspx
Sounds like you have a convoluted network configuration which is the source of your problems.
Last edited by barrymavin; 2018-03-28 at 05:31.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
haha..
Ok, but 29 seconds.. it's too much... or not?
In this way, also Autosuggestion need to work with the full table.. and when I take focus to the formfield.. it take 29 seconds to read the data from the server..
Please go back and read my replies. We are going round in circles.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
You are reading the whole table into the equivalent of a combo box. Bad design.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
Bookmarks