I have being trying without success to create a program that can establish a SSH connection with [URL] on a changeable post with a set username and password. The program when done will configure IE proxy settings and establish a SSH connection to [URL] to allow the user to browse the internet without restrictions.
View 1 RepliesI'm developing a device app in VB.net that will access a SQL Server database. I need to establish a connection when the app is launched, and keep the connection open until the app is closed. I've done the following:In the Master Module:
Public CNN
As SqlConnection
In the Main menu form load:
CNN =
New SqlConnection(sqlConnString)
CNN.Open()
Then when I want to read from the database:
Dim sqlDR
As SqlDataReader
SQL = "SELECT Name FROM Table"
[code]....
When I run the same code without the global CNN, but rather dim the connection inside the Select function, all works well.
This will happen at random, and I can always just catch the error and re-establish connection to the server, but I am confused as to why. When doing lots of inserting into the sql server, I only establish one connection that is public, instead of many little connections. I had my doubts on a public sql connection, but it's been running great, and I've seen no problems until this morning. Again, this random moment I hit an error that stated, sql connection state is broken. Is it bad practice to just accept this error, and when it happens, re-establish the connection?
View 7 RepliesI'm using Visual Studio 2005 and SQL Server 2000 for my vb.net desktop application..I'm having a SQL Server exception saying that "connection can't be established to the server.hen connecting to SQL Server 2005 this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. Also showing
View 2 Repliesi have 2003 access database. why i cannnot connect to my database using the code below?
red
Public BioCon As New Odbc.OdbcConnection
Public GAdp As Odbc.OdbcDataAdapter
red
Public Function Execute(ByVal Qry As String, ByVal Con As Odbc.OdbcConnection) As Boolean
[Code]...
I just can't seem to establish a connection between my two P2P applications over the internet(LAN works perfectly fine).
I have tried the following.
- Disabling Firewall
- Changing Port
The only way I can establish a connection is if I'm connecting to the same computer using the universal IP or the local. Does anyone have a fix for this? Oh and here is the error that I receive when trying to connect over the internet:
System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 255.255.255.255:8787
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at P2P_Client.Form1.Msgtxt_KeyDown(Object sender, KeyEventArgs e) in C:\Users\Administrator\Documents\Visual Studio 2008\VB Projects\P2P-Client\P2P-Client\Form1.vb:line 32
i use vb 2008 office 2007 , it's a powerpoint add-in application. I need to use a window form as a bluetooth interface.the working procedure is like that when i click the Enum button, it will help me to search for available bluetooth devices.but now i have an error, it shows "WCL ERROR: Specified transfer is not available"
[Code]...
I'm designing a web service in ASP.NET and VS2008, and am using typed datasets for retrieving table data. These work well and establish their own connections through their associated TableAdapter objects. Edit: I'm using VB, BTW!I am now attempting to run a custom SQL string using a DataAdapter and a Command object, however I need to reference a Connection object in order for the Command to work. What is the best way to handle this?hould I:a) Create a global connection object using Global.asax, retrieving the connection string from web.config? (I've been trying that one already, with not much success)b) Create a class-level connection object using the InitialiseComponent method, also retrieving the ConnectionString from web.config?c) Retrieve a Connection from one of the TableAdapters that I've already created in my typed DataSets?d) Something else I haven't thought of yet?
View 2 RepliesI want to know how to connect sql server 2005 to vb.net windows application
1)is there any connection string ?
2)if so i am using windows authendication in sql server 2005 management studio so am not entering any user id and
password to enter in sql server
3)so what should be the userid and password for the connection string can any one send me a sample code that i can refar
I want to start a new project on PC and Mobile Phone. But i'm still have so many question about the communication between PC and Mobile.
My project List:
1) My idea is establish a connection between PC and Mobile through IP address in first, but my question is 'How to do it' ? izit same like PC to PC by using Winsock open a port to access? i'm using VB.Net 2005 for PC and Net60 for mobile.
2)My mobile phone Nokia 6220 Symbian OS is support GPRS/3G. Since the GPRS/3G can connect to the internet, izit means mobile itself have a IP address and service provider in order to surf the web? So, can i connect my mobile phone to PC through this gateway?
I have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click
result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text
End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
What is the correct way to accomplish this?
EDIT
Using MySQL 5.1
I am unable to load the dat into the data Grid. Here is where I keep getting stuck.
dgvOleDb1 = table.Select
dgvOleDb1.DataSource = DataGridViewEditMode.EditProgrammatically
dgvOleDb1.DataSource = ds.Tables(0)
I am confused; I am using VB2010, IBM.iSeries.DB2 on an as400 V5R4. I am trying to establish an OLEDB connection, and return the values from the selected table to a DataGridView. I had one of the admin's make me file named GARBAGE, in the Rprtaccess catalog. In the past, I have been able to connect via access and an ODBC connection. My project is too big for access, and the SQL middleware we have is clunky and not user friendly. This is a program that will generate the SQL statements, specifically the WHERE: clause and populate the datagrid with the selected criteria. In essence I am making a user friendly striped down program, that has variables that are manipulated by the end user, and the rest, referenced tables and libraries are coded.
Imports System.Data.OleDb
Imports System.Exception
Public Class Form11
[code]....
is there a way to create a program that has a SSH Connection to a VPS?
View 2 RepliesCan we use serial port object to create usb connection? How can we use Visual Basic to create USB connection
View 9 RepliesI need to write a program that uses constants to establish the base pay, the quota, and the commission rate. The Pay menu item calculates and displays the commission and the total pay for that person. However, if there is no commission, do not display the commission amount (do not display a zero-commission amount).
Write a function procedure to calculate the commission. The function must compare sales to the quota. when the sales are equal to or greater than the quota, calculate the commission by multiplying sales by the commission rate. Format the dollar amounts to two decimal places; do not display a dollar sign.
The summary menu item displays a message box that holds total sales, total commission, and total pay for all salesperson. Display the number with two decimal places and dollar signs.
the Clear menu item clears the name, sales, and pay for the current employee and then resets the focus.
The Color and Font menu items should change the color and font of the information displayed in the total pay text box. Use a message box to display the program name and your name as programmer for the about option on the Help menu.
[code...]
So the issue is when I push calculate and summary, the total sales comes up, but not the total commission or total pay. Also, the color only changes to blue and that is it. I am not sure how to get the color or the font menu choices to be able to be choosen by the user. Is that possibile?
[code...]
is it possible to create application for my mobile phone Sony Ericsson to remote control my program using Bluetooth connection which have simple functions?I have came across one program that is able to do that which is floAt's Mobile Agent. It can control from media player, powerpoint slides and even mouse cursor movement.
View 10 RepliesAfter running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
I Want to develop a software like Yed.i just don know where to start.how we can create a workspace where i can drag and drop icons and create connection etc etc.
View 6 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 RepliesI want the program to display the text "Waiting for connection..." while the program is actually waiting for a connection. However, when I run the program, the form doesn't even appear because the TCPListener is waiting. What can I do to have the program appear and show the text while it's waiting for a connection?
Imports System.Net.Sockets
Imports System.IO
Public Class frmMain
Dim client As TcpClient
[code].....
is it possible to establish if a url exists?
The reason is I want to establish if the server is active or not.
Our core server is calling out to a soap web service over https on a number of different servers to confirm that a transaction has completed.The code is dotnet 3.5 (vb) and works for the various callback services we have set up until we just moved a new one into production and it is refusing to communicate, giving the following error:Unhandled Exception: System.ServiceModel.Security.SecurityNegotiationException:Could not establish secure channel for SSL/TLS with authority -> System.Net.WebException: The request washe case here.
View 3 RepliesI am new to ssl. I am trying to Post some data to OWA using httpwebrequest class using following code.
Dim post As Stream
post = web1.GetRequestStream
post.Write(data, 0, data.Length)
post.Close()
But when I try to get request stream to submit data using above code.(JUST PART OF CODE).i get following error. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
here is my code
[Code]...
my problem is how can i pass the SSL certificate cause im using https in my request,
i am trying to Post some data to OWA using httpwebrequest class.
Dim post As Stream
post = web1.GetRequestStream
post.Write(data, 0, data.Length)
post.Close()
but when i try to get request stream to submit data using above code.(JUST PART OF CODE).i get following error.The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
how to create an application in vb 2010 platform to serial communication port for Mifare module with using command sets defined by the firmware.
View 3 RepliesI'm using datediff to establish difference between two dates using datetimepicker.i.m nnot getting the right results. a one day difference returns a 0, a two day difference returns a 1 etc. the code I am using is posted below.
days = DateDiff(DateInterval.Day, dtpStart.Value(), dtpEnd.Value())
I want to create a class in vb.net that make the connection to database.Also I need the way to use this class inside forms. I need a code example of both the class and the form call
View 1 RepliesI wrote a small application in witch I create a connection to a database. I'm new to this, so I followed the steps in MSDN help. I first created a link to the database with the "Datasource" of the Visual Studio environement. Then, in the code, I create instances of the dataset in the datasource and use a tableAdapter to register my changes in the database.
Now I want to allow the user of the application to specify the path of the DB file he wants to use. How can I do so? Do I still can use the datasource in the VS environment? I don't know where to start.
How to Create a sql connection String in vb.net 2010? my DataBase Is Sql Express 2008
Name of Allah, Most Gracious, Most Merciful and He created the human