Stack Exchange
log in

Jåcob

 Discussion between Pimp Juice IT and …

Jåcob
Mar 29, 2019 03:34
@TroubleMakerChatBroom Had already tied this approach before posting the question. This did not solve the issue.
Jåcob
Mar 28, 2019 16:23
Will certainly update if it is redressed.
Jåcob
Mar 28, 2019 16:19
Much appreciated for the effort and time.
Jåcob
Mar 28, 2019 16:16
I will check with the admin
Jåcob
Mar 28, 2019 16:11
Yes, does disconnect and then I have to manually connect again
Jåcob
Mar 28, 2019 16:05
Is it something to do with VPN client? Excuse my ignorance about this subject matter.
Jåcob
Mar 28, 2019 16:00
D:\>route DELETE 0.0.0.0 MASK 0.0.0.0 192.168.100.1
OK!

D:\>route print
===========================================================================
Interface List
21...10 62 e5 e3 8c 58 ......Realtek Gaming GBE Family Controller
11...76 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #3
15...74 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #4
23...00 09 0f fe 00 01 ......Fortinet Virtual Ethernet Adapter (NDIS 6.30)
14...74 40 bb 49 9b 93 ......Realtek RTL8822BE 802.11ac PCIe Adapter
Jåcob
Mar 28, 2019 16:00
Outputs
Jåcob
Mar 28, 2019 15:55
user image
Jåcob
Mar 28, 2019 15:55
Before the changing the option, see the below image. Does this cause any issue as it is checked for automatic?
Jåcob
Mar 28, 2019 15:50
Automatic Metric option should be that of the VPN client or Wifi? Ethernet is disconnected
Jåcob
Mar 28, 2019 15:48
my personal laptop
Jåcob
Mar 28, 2019 15:44
Type of VPN is SSTP
Jåcob
Mar 28, 2019 15:42
I am using Fortieclient VPN client and connected to my company network by providing username and password
Jåcob
Mar 28, 2019 15:41
user image
Jåcob
Mar 28, 2019 15:36
Upon execution of route DELETE and route ADD, the VPN does disconnect.
Jåcob
Mar 28, 2019 15:34
D:\>route DELETE 0.0.0.0 MASK 0.0.0.0 192.168.100.1
OK!

D:\>route print
===========================================================================
Interface List
21...10 62 e5 e3 8c 58 ......Realtek Gaming GBE Family Controller
11...76 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #3
15...74 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #4
23...00 09 0f fe 00 01 ......Fortinet Virtual Ethernet Adapter (NDIS 6.30)
14...74 40 bb 49 9b 93 ......Realtek RTL8822BE 802.11ac PCIe Adapter
Jåcob
Mar 28, 2019 15:34
Output
Jåcob
Mar 28, 2019 15:31
Let me try
Jåcob
Mar 28, 2019 15:28
===========================================================================
Interface List
21...10 62 e5 e3 8c 58 ......Realtek Gaming GBE Family Controller
11...76 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #3
15...74 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #4
23...00 09 0f fe 00 01 ......Fortinet Virtual Ethernet Adapter (NDIS 6.30)
14...74 40 bb 49 9b 93 ......Realtek RTL8822BE 802.11ac PCIe Adapter
25...........................TEST
6...74 40 bb 49 9b 94 ......Bluetooth Device (Personal Area Network)
Jåcob
Mar 28, 2019 15:28
D:\>route DELETE 0.0.0.0 MASK 0.0.0.0 192.168.100.1
OK!

D:\>route ADD 0.0.0.0 MASK 0.0.0.0 192.168.100.1 METRIC 10
OK!
Jåcob
Mar 28, 2019 15:24
route print
===========================================================================
Interface List
21...10 62 e5 e3 8c 58 ......Realtek Gaming GBE Family Controller
11...76 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #3
15...74 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #4
23...00 09 0f fe 00 01 ......Fortinet Virtual Ethernet Adapter (NDIS 6.30)
14...74 40 bb 49 9b 93 ......Realtek RTL8822BE 802.11ac PCIe Adapter
25...........................TEST
6...74 40 bb 49 9b 94 ......Bluetooth Device (Personal Area Network)
Jåcob
Mar 28, 2019 15:24
D:\>route DELETE 0.0.0.0 MASK 0.0.0.0 192.168.100.1
OK!

D:\>route ADD 0.0.0.0 MASK 0.0.0.0 192.168.100.1
OK!
Jåcob
Mar 28, 2019 15:22
while connected to the VPN?
Jåcob
Mar 28, 2019 15:18
Sure, by all means take your time
Jåcob
Mar 28, 2019 15:17
===========================================================================
Interface List
21...10 62 e5 e3 8c 58 ......Realtek Gaming GBE Family Controller
11...76 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #3
15...74 40 bb 49 9b 93 ......Microsoft Wi-Fi Direct Virtual Adapter #4
23...00 09 0f fe 00 01 ......Fortinet Virtual Ethernet Adapter (NDIS 6.30)
14...74 40 bb 49 9b 93 ......Realtek RTL8822BE 802.11ac PCIe Adapter
25...........................TEST
6...74 40 bb 49 9b 94 ......Bluetooth Device (Personal Area Network)
Jåcob
Mar 28, 2019 15:15
You mean when connected to VPN?
Jåcob
Mar 28, 2019 15:15
I do understand
Jåcob
Mar 28, 2019 15:14
Hello
 

 Discussion on question by user75ponic…

Imported from a comment discussion on dba.stackexchange.com/qu...
user75ponic
Aug 29, 2017 10:13
It is a start of a prototype @AndriyM
user75ponic
Aug 29, 2017 10:13
@ypercube Query is valid. So it is best practice to have two lookup table for question_type and question_category even though it contains only lookup information? For my unserstanding, why and what is the reasoning for this? Thanks
user75ponic
Aug 29, 2017 10:13
@AndriyM question_codes is only a lookup table so still do I need to have multiple tables like one for question_type and another for question_category?
user75ponic
Aug 29, 2017 10:13
@AndriyM yes multiple foreign key to question_codes to get the code_id and code_desc.
user75ponic
Aug 29, 2017 10:13
@ypercube I have updated my question with table description and sample records. Thanks
user75ponic
Aug 29, 2017 10:13
@ypercube Yes both tables are linked, e.g. question_type corresponding code_id will be stored in questionnaire table. Same the case with question_category.
user75ponic
Aug 29, 2017 10:13
@RuudvandeBeeten So no need to have a new table for product_type?