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 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 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 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?
How is the Bluetooth connection by Visual Basic Dot Net readers and text sent by the Bluetooth
View 2 RepliesI 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]....
I have create a simple app in vb.net that receive data from a bluetooth device ( data are simple strings like "90123.9mm"). Is there a way to check if the device has closed the connection ?
[Code]...
I need to be able to click a link from a vb6 program and call a number via a connected mobile phone.(Assumption: the mobile phone is already connected to the PC via bluetooth on com3)
View 1 Repliesis 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 RepliesIs there anyway, in a program, to detect if a program is being run from inside a remote desktop session or if the program is being run normal in .NET 2.0? What I'm trying to do is, I create a timeclock application which will clock a person in and out and keep track. But this particular person, I suspect, is remoting into their computer at work, from home, and clocking in and out.
View 5 RepliesI made a desktop application and I Have a server on the internet and I need to make a connection between them
Can some one advise me about this problem?
I built a window's app in VB. The app is made to be used worldwide. The app works fine when it is installed on a computer using the same network than the local machine hosting the sql database. The problem actually, is that, when the app is installed on a computer using a diferent network, the connection fails.
[Code]...
I have a desktop computer with a cable connection on the back that allows me to watch TV on the computer using Windows Media Center. I had the idea of writing a program that would access this feed and send it to another computer (laptop) via my network. That way I would be able to watch TV from anywhere that my network spans. I have no idea if this is possible or how I would even do it,
So I have three questions.
1: Is it possible?
2: How would I go about access the feed?
3: How would I send it over the network?
My original thought was doing it in Flash, but I'm not very good at Flash so I wanted to do it in VB.Net.
is it possible to establish if a url exists?
The reason is I want to establish if the server is active or not.
We have a Windows Forms VB.NET application running on Windows Server 2008. Users access this app using Remote desktop.The app displays information in Excel, but Excel opens on the server.Is there a way for the .NET app to launch Excel on the users local desktop?
View 1 RepliesSome of u already know I'm making a 'virtual desktop'- thing.Only one problem. When switching to a new desktop it starts a new instance of my app in that desktop (works) and on the form load event it says process.start("explorer.exe") <- here is the problem. It only shows a window not the actually bar.Also this may be important it shows the window, but when I navigate to explorer.exe 'C:Windowsexplorer.exe' and open it there. The explorer bar does show up.
View 14 RepliesOur 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 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...]