opening excel application thru vb.net

Hi, I'm having problems opening up excel thru my code. It will write and
saveas an excel file, but the application won't open on the user's computer,
excel seems to be hidden, because it shows up on the task manager. The
problem is, if this user tries to download the data more than once, it gets
stuck because the file already exists, so I want it to overwrite the old
file...but the user can't overwrite when the excel app won't work! Any
suggestions? This is my code below:

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
Dim oDS As New DataSet
Dim oConn As New SqlClient.SqlCo nnection("works tation
id=CTR3_252A;pa cket size=4096;user id=sa;data source=CRI;pers ist security
info=True;initi al catalog=gfdgfd; password=gfdgfd ")
Dim oSqlCmd As New SqlClient.SqlCo mmand("SELECT * from
dbo.MRI_HEATHER STAT_VIEW")
Dim oDA As New SqlClient.SqlDa taAdapter(oSqlC md)

oSqlCmd.Connect ion = oConn

oConn.Open()

oDA.Fill(oDS)
oConn.Close()
Dim oRow As DataRow

For Each oRow In oDS.Tables(0).R ows
Next
Dim oDSLocal As New DataSet
Dim oSqlCmdlocal As New SqlClient.SqlCo mmand("SELECT * from
dbo.MRI_HEATHER STAT_VIEW")
Dim oDAlocal As New SqlClient.SqlDa taAdapter(oSqlC mdlocal)
Dim oConnLocal As New SqlClient.SqlCo nnection("works tation
id=CTR3_252A;pa cket size=4096;user id=sa;data source=CRI;pers ist security
info=True;initi al catalog=gfdgfd; password=gfdgfd ")

Dim xlApp As Excel.Applicati on
Dim xlBook As Excel.Workbook
Dim xlAELBook As Excel.Workbook
Dim xlAELSheet As Excel.Worksheet
Dim xlSheet As Excel.Worksheet
xlApp = CType(CreateObj ect("Excel.Appl ication"), Excel.Applicati on)
xlBook = CType(xlApp.Wor kbooks.Add, Excel.Workbook)
xlSheet = CType(xlBook.Wo rksheets(1), Excel.Worksheet )
xlApp.Visible = True
xlSheet.Visible = True

xlSheet.Applica tion.Visible = True
oSqlCmdlocal.Co nnection = oConnLocal

oConnLocal.Open ()

oDAlocal.Fill(o DSLocal)
Dim oRowLocal As DataRow
Dim x As Integer = 2

'Set header
xlSheet.Cells(1 , 1) = "SUBJECT_ID "
xlSheet.Cells(1 , 2) = "RESERVED"
xlSheet.Cells(1 , 3) = "SLICE1_WHOLEAR M_CSA"
xlSheet.Cells(1 , 4) = "SLICE2_WHOLEAR M_CSA"
xlSheet.Cells(1 , 5) = "SLICE3_WHOLEAR M_CSA"
xlSheet.Cells(1 , 6) = "SLICE4_WHOLEAR M_CSA"
xlSheet.Cells(1 , 7) = "SLICE5_WHOLEAR M_CSA"
xlSheet.Cells(1 , 8) = "SLICE6_WHOLEAR M_CSA"
xlSheet.Cells(1 , 9) = "AVG_WHOLEARM_C SA"
xlSheet.Cells(1 , 10) = "SLICE1_MARROW_ CSA"
xlSheet.Cells(1 , 11) = "SLICE2_MARROW_ CSA"
xlSheet.Cells(1 , 12) = "SLICE3_MARROW_ CSA"
xlSheet.Cells(1 , 13) = "SLICE4_MARROW_ CSA"
xlSheet.Cells(1 , 14) = "SLICE5_MARROW_ CSA"
xlSheet.Cells(1 , 15) = "SLICE6_MARROW_ CSA"
xlSheet.Cells(1 , 16) = "AVG_MARROW_CSA "
xlSheet.Cells(1 , 17) = "SLICE1_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 18) = "SLICE2_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 19) = "SLICE3_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 20) = "SLICE4_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 21) = "SLICE5_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 22) = "SLICE6_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 23) = "AVG_BONE_MARRO W_CSA"
xlSheet.Cells(1 , 24) = "SLICE1_FAT_CSA "
xlSheet.Cells(1 , 25) = "SLICE2_FAT_CSA "
xlSheet.Cells(1 , 26) = "SLICE3_FAT_CSA "
xlSheet.Cells(1 , 27) = "SLICE4_FAT_CSA "
xlSheet.Cells(1 , 28) = "SLICE5_FAT_CSA "
xlSheet.Cells(1 , 29) = "SLICE6_FAT_CSA "
xlSheet.Cells(1 , 30) = "AVG_FAT_CS A"
xlSheet.Cells(1 , 31) = "AVG_WHOLEMUSCL E_CSA"
xlSheet.Cells(1 , 32) = "WHOLEARM_V OL"
xlSheet.Cells(1 , 33) = "MARROW_VOL "
xlSheet.Cells(1 , 34) = "BONE_MARROW_VO L"
xlSheet.Cells(1 , 35) = "FAT_VOL"
xlSheet.Cells(1 , 36) = "WHOLEMUSCLE_VO L"

For Each oRowLocal In oDSLocal.Tables (0).Rows

xlSheet.Cells(x , 1) = oRowLocal("SUBJ ECT_ID")
xlSheet.Cells(x , 2) = oRowLocal("RESE RVED")
xlSheet.Cells(x , 3) = oRowLocal("SLIC E1_WHOLEARM_CSA ")
xlSheet.Cells(x , 4) = oRowLocal("SLIC E2_WHOLEARM_CSA ")
xlSheet.Cells(x , 5) = oRowLocal("SLIC E3_WHOLEARM_CSA ")
xlSheet.Cells(x , 6) = oRowLocal("SLIC E4_WHOLEARM_CSA ")
xlSheet.Cells(x , 7) = oRowLocal("SLIC E5_WHOLEARM_CSA ")
xlSheet.Cells(x , 8) = oRowLocal("SLIC E6_WHOLEARM_CSA ")
xlSheet.Cells(x , 9) = oRowLocal("AVG_ WHOLEARM_CSA")
xlSheet.Cells(x , 10) = oRowLocal("SLIC E1_MARROW_CSA")
xlSheet.Cells(x , 11) = oRowLocal("SLIC E2_MARROW_CSA")
xlSheet.Cells(x , 12) = oRowLocal("SLIC E3_MARROW_CSA")
xlSheet.Cells(x , 13) = oRowLocal("SLIC E4_MARROW_CSA")
xlSheet.Cells(x , 14) = oRowLocal("SLIC E5_MARROW_CSA")
xlSheet.Cells(x , 15) = oRowLocal("SLIC E6_MARROW_CSA")
xlSheet.Cells(x , 16) = oRowLocal("AVG_ MARROW_CSA")
xlSheet.Cells(x , 17) = oRowLocal("SLIC E1_BONE_MARROW_ CSA")
xlSheet.Cells(x , 18) = oRowLocal("SLIC E2_BONE_MARROW_ CSA")
xlSheet.Cells(x , 19) = oRowLocal("SLIC E3_BONE_MARROW_ CSA")
xlSheet.Cells(x , 20) = oRowLocal("SLIC E4_BONE_MARROW_ CSA")
xlSheet.Cells(x , 21) = oRowLocal("SLIC E5_BONE_MARROW_ CSA")
xlSheet.Cells(x , 22) = oRowLocal("SLIC E6_BONE_MARROW_ CSA")
xlSheet.Cells(x , 23) = oRowLocal("AVG_ BONE_MARROW_CSA ")
xlSheet.Cells(x , 24) = oRowLocal("SLIC E1_FAT_CSA")
xlSheet.Cells(x , 25) = oRowLocal("SLIC E2_FAT_CSA")
xlSheet.Cells(x , 26) = oRowLocal("SLIC E3_FAT_CSA")
xlSheet.Cells(x , 27) = oRowLocal("SLIC E4_FAT_CSA")
xlSheet.Cells(x , 28) = oRowLocal("SLIC E5_FAT_CSA")
xlSheet.Cells(x , 29) = oRowLocal("SLIC E6_FAT_CSA")
xlSheet.Cells(x , 30) = oRowLocal("AVG_ FAT_CSA")
xlSheet.Cells(x , 31) = oRowLocal("AVG_ WHOLEMUSCLE_CSA ")
xlSheet.Cells(x , 32) = oRowLocal("WHOL EARM_VOL")
xlSheet.Cells(x , 33) = oRowLocal("MARR OW_VOL")
xlSheet.Cells(x , 34) = oRowLocal("BONE _MARROW_VOL")
xlSheet.Cells(x , 35) = oRowLocal("FAT_ VOL")
xlSheet.Cells(x , 36) = oRowLocal("WHOL EMUSCLE_VOL")

x = x + 1

Next

xlSheet.Name = "Rapidia Dataset"
xlSheet.SaveAs( "C:\MyFile3.xls ")
xlSheet.Applica tion.Quit()
xlSheet = Nothing
oDSLocal = Nothing
oSqlCmdlocal = Nothing
Label3.Visible = True

Jul 21 '05 #1

Subscribe Reply

3126

if anyone could help me, i'd really appreciate it! I've tried all the
suggestions that were similar to my problem, and nothing seems to be working.
I can't figure out why
1) My excel app is hidden even when I try to make it visible
2) When redownloading the data, I'm assuming that it's trying to overwrite
the old data, but giving an "are you sure" message. (My internet explorer
makes a "ching" sound, which I assume is the msg popping up, then it just
sits there and doesn't move fwd, however I can't see any of it because excel
is hidden) I would like to make it so that this msg does not popup, and it
automatically overwrites the old data. thanks!

"ST" wrote:

Hi, I'm having problems opening up excel thru my code. It will write and
saveas an excel file, but the application won't open on the user's computer,
excel seems to be hidden, because it shows up on the task manager. The
problem is, if this user tries to download the data more than once, it gets
stuck because the file already exists, so I want it to overwrite the old
file...but the user can't overwrite when the excel app won't work! Any
suggestions? This is my code below:

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
Dim oDS As New DataSet
Dim oConn As New SqlClient.SqlCo nnection("works tation
id=CTR3_252A;pa cket size=4096;user id=sa;data source=CRI;pers ist security
info=True;initi al catalog=gfdgfd; password=gfdgfd ")
Dim oSqlCmd As New SqlClient.SqlCo mmand("SELECT * from
dbo.MRI_HEATHER STAT_VIEW")
Dim oDA As New SqlClient.SqlDa taAdapter(oSqlC md)

oSqlCmd.Connect ion = oConn

oConn.Open()

oDA.Fill(oDS)
oConn.Close()
Dim oRow As DataRow

For Each oRow In oDS.Tables(0).R ows
Next
Dim oDSLocal As New DataSet
Dim oSqlCmdlocal As New SqlClient.SqlCo mmand("SELECT * from
dbo.MRI_HEATHER STAT_VIEW")
Dim oDAlocal As New SqlClient.SqlDa taAdapter(oSqlC mdlocal)
Dim oConnLocal As New SqlClient.SqlCo nnection("works tation
id=CTR3_252A;pa cket size=4096;user id=sa;data source=CRI;pers ist security
info=True;initi al catalog=gfdgfd; password=gfdgfd ")

Dim xlApp As Excel.Applicati on
Dim xlBook As Excel.Workbook
Dim xlAELBook As Excel.Workbook
Dim xlAELSheet As Excel.Worksheet
Dim xlSheet As Excel.Worksheet
xlApp = CType(CreateObj ect("Excel.Appl ication"), Excel.Applicati on)
xlBook = CType(xlApp.Wor kbooks.Add, Excel.Workbook)
xlSheet = CType(xlBook.Wo rksheets(1), Excel.Worksheet )
xlApp.Visible = True
xlSheet.Visible = True

xlSheet.Applica tion.Visible = True
oSqlCmdlocal.Co nnection = oConnLocal

oConnLocal.Open ()

oDAlocal.Fill(o DSLocal)
Dim oRowLocal As DataRow
Dim x As Integer = 2

'Set header
xlSheet.Cells(1 , 1) = "SUBJECT_ID "
xlSheet.Cells(1 , 2) = "RESERVED"
xlSheet.Cells(1 , 3) = "SLICE1_WHOLEAR M_CSA"
xlSheet.Cells(1 , 4) = "SLICE2_WHOLEAR M_CSA"
xlSheet.Cells(1 , 5) = "SLICE3_WHOLEAR M_CSA"
xlSheet.Cells(1 , 6) = "SLICE4_WHOLEAR M_CSA"
xlSheet.Cells(1 , 7) = "SLICE5_WHOLEAR M_CSA"
xlSheet.Cells(1 , 8) = "SLICE6_WHOLEAR M_CSA"
xlSheet.Cells(1 , 9) = "AVG_WHOLEARM_C SA"
xlSheet.Cells(1 , 10) = "SLICE1_MARROW_ CSA"
xlSheet.Cells(1 , 11) = "SLICE2_MARROW_ CSA"
xlSheet.Cells(1 , 12) = "SLICE3_MARROW_ CSA"
xlSheet.Cells(1 , 13) = "SLICE4_MARROW_ CSA"
xlSheet.Cells(1 , 14) = "SLICE5_MARROW_ CSA"
xlSheet.Cells(1 , 15) = "SLICE6_MARROW_ CSA"
xlSheet.Cells(1 , 16) = "AVG_MARROW_CSA "
xlSheet.Cells(1 , 17) = "SLICE1_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 18) = "SLICE2_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 19) = "SLICE3_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 20) = "SLICE4_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 21) = "SLICE5_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 22) = "SLICE6_BONE_MA RROW_CSA"
xlSheet.Cells(1 , 23) = "AVG_BONE_MARRO W_CSA"
xlSheet.Cells(1 , 24) = "SLICE1_FAT_CSA "
xlSheet.Cells(1 , 25) = "SLICE2_FAT_CSA "
xlSheet.Cells(1 , 26) = "SLICE3_FAT_CSA "
xlSheet.Cells(1 , 27) = "SLICE4_FAT_CSA "
xlSheet.Cells(1 , 28) = "SLICE5_FAT_CSA "
xlSheet.Cells(1 , 29) = "SLICE6_FAT_CSA "
xlSheet.Cells(1 , 30) = "AVG_FAT_CS A"
xlSheet.Cells(1 , 31) = "AVG_WHOLEMUSCL E_CSA"
xlSheet.Cells(1 , 32) = "WHOLEARM_V OL"
xlSheet.Cells(1 , 33) = "MARROW_VOL "
xlSheet.Cells(1 , 34) = "BONE_MARROW_VO L"
xlSheet.Cells(1 , 35) = "FAT_VOL"
xlSheet.Cells(1 , 36) = "WHOLEMUSCLE_VO L"

For Each oRowLocal In oDSLocal.Tables (0).Rows

xlSheet.Cells(x , 1) = oRowLocal("SUBJ ECT_ID")
xlSheet.Cells(x , 2) = oRowLocal("RESE RVED")
xlSheet.Cells(x , 3) = oRowLocal("SLIC E1_WHOLEARM_CSA ")
xlSheet.Cells(x , 4) = oRowLocal("SLIC E2_WHOLEARM_CSA ")
xlSheet.Cells(x , 5) = oRowLocal("SLIC E3_WHOLEARM_CSA ")
xlSheet.Cells(x , 6) = oRowLocal("SLIC E4_WHOLEARM_CSA ")
xlSheet.Cells(x , 7) = oRowLocal("SLIC E5_WHOLEARM_CSA ")
xlSheet.Cells(x , 8) = oRowLocal("SLIC E6_WHOLEARM_CSA ")
xlSheet.Cells(x , 9) = oRowLocal("AVG_ WHOLEARM_CSA")
xlSheet.Cells(x , 10) = oRowLocal("SLIC E1_MARROW_CSA")
xlSheet.Cells(x , 11) = oRowLocal("SLIC E2_MARROW_CSA")
xlSheet.Cells(x , 12) = oRowLocal("SLIC E3_MARROW_CSA")
xlSheet.Cells(x , 13) = oRowLocal("SLIC E4_MARROW_CSA")
xlSheet.Cells(x , 14) = oRowLocal("SLIC E5_MARROW_CSA")
xlSheet.Cells(x , 15) = oRowLocal("SLIC E6_MARROW_CSA")
xlSheet.Cells(x , 16) = oRowLocal("AVG_ MARROW_CSA")
xlSheet.Cells(x , 17) = oRowLocal("SLIC E1_BONE_MARROW_ CSA")
xlSheet.Cells(x , 18) = oRowLocal("SLIC E2_BONE_MARROW_ CSA")
xlSheet.Cells(x , 19) = oRowLocal("SLIC E3_BONE_MARROW_ CSA")
xlSheet.Cells(x , 20) = oRowLocal("SLIC E4_BONE_MARROW_ CSA")
xlSheet.Cells(x , 21) = oRowLocal("SLIC E5_BONE_MARROW_ CSA")
xlSheet.Cells(x , 22) = oRowLocal("SLIC E6_BONE_MARROW_ CSA")
xlSheet.Cells(x , 23) = oRowLocal("AVG_ BONE_MARROW_CSA ")
xlSheet.Cells(x , 24) = oRowLocal("SLIC E1_FAT_CSA")
xlSheet.Cells(x , 25) = oRowLocal("SLIC E2_FAT_CSA")
xlSheet.Cells(x , 26) = oRowLocal("SLIC E3_FAT_CSA")
xlSheet.Cells(x , 27) = oRowLocal("SLIC E4_FAT_CSA")
xlSheet.Cells(x , 28) = oRowLocal("SLIC E5_FAT_CSA")
xlSheet.Cells(x , 29) = oRowLocal("SLIC E6_FAT_CSA")
xlSheet.Cells(x , 30) = oRowLocal("AVG_ FAT_CSA")
xlSheet.Cells(x , 31) = oRowLocal("AVG_ WHOLEMUSCLE_CSA ")
xlSheet.Cells(x , 32) = oRowLocal("WHOL EARM_VOL")
xlSheet.Cells(x , 33) = oRowLocal("MARR OW_VOL")
xlSheet.Cells(x , 34) = oRowLocal("BONE _MARROW_VOL")
xlSheet.Cells(x , 35) = oRowLocal("FAT_ VOL")
xlSheet.Cells(x , 36) = oRowLocal("WHOL EMUSCLE_VOL")

x = x + 1

Next

xlSheet.Name = "Rapidia Dataset"
xlSheet.SaveAs( "C:\MyFile3.xls ")
xlSheet.Applica tion.Quit()
xlSheet = Nothing
oDSLocal = Nothing
oSqlCmdlocal = Nothing
Label3.Visible = True

Jul 21 '05 #2

Similar topics

3010

Export datagrids to Excel

by: | last post by:

I have a web page written in asp.net that has multiple datagrids on it that would need to be exported to Excel. Each of the datagrids would be a subset of what the datagrid above it was. Thus far, I've had no luck in finding anything to work reliably. Some of the files I've saved (using a radio button click event), will open fine in Excel, others give me an "Unable to open file" message. Any help appreciated.

ASP.NET

4434

generating MS-Excel report through ASP.Net without installing MS-E

by: hari krishna | last post by:

hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in asp.net. The Xl sheet should not be opened in the browser. All the information from dataset(datatable,datarows) should be sent to XL and the file name should be given dynamically through program and the xl file should be saved dynamically through...

ASP.NET

2549

Creating Excel Spreadsheet without opening Excel application

by: Ken Hall | last post by:

Is it possible to create an Excel spreadsheet using VB.NET without opening the Excel application or having to have the Excel application on the operating computer? KH

Visual Basic .NET

2822

Excel in VB.NET - looks the same as the old days?

by: Anthony | last post by:

To me, creating Excel 2003 spreadsheets programmatically via VB.NET hasn't really changed since the days of VB6. That is, I'd do something similar to this Code: Dim ExcelApp As Excel.Application Dim ExcelWB As Excel.Workbook

Visual Basic .NET

362

opening excel application thru vb.net

by: ST | last post by:

.NET Framework

10352

Opening a space delimited textfile in Excel using VB.net

by: Jacob.Bruxer | last post by:

Hi everyone, I'm having trouble opening space delimited textfiles in Excel from Visual Basic.net. I'm able to control, open and modify Excel files from Visual Basic, so my Excel reference seems to be working ok. I just don't know what I'm doing when I try to open a space delimited file and want to put the data into columns. I tried recording a macro in VBA and going from there, but then I got stuff saying "Name 'xlDelimited' is not...

Visual Basic .NET

2050

Excel.Application

by: Gorgo | last post by:

Hello I'm sorry if this is not the right group to post this post, but unfortunetly this one is one of the best i know. I'm doing and asp.net application with need to create excel file thru DCOM Excel.application object. For that I created special user and make it as a default user on which Excel.Application is created (I did this thru dcomcnf). Also I give full control to my application folder in inetpub.

ASP.NET

3123

question about opening SQL results in Excel from ASP.NET via XML

by: Mad Scientist Jr | last post by:

>From an asp.net web page I want the user to open the results of a SQL query in Excel, as automatically as possible (ie not having to loop through columns, rows, in code). For this, dataset.writexml works great (got the code from http://forums.devx.com/archive/index.php/t-57273.html ) The only question I have is, when Excel opens up, it isn't the view I would prefer. It opens as a read-only workbook, I would prefer as an

Visual Basic .NET

5185

Opening Excel from Access

by: Phil Stanton | last post by:

I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub Storage_Click() On Error GoTo Err_Storage_Click

Microsoft Access / VBA

9563

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10144

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9997

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9822

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8821

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5270

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5405

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3522

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2793

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General