I have used a third party component to download a file from my FTP server. One user has advised that their antivirus software (ESET) is blocking it. How can I determine which port it's using so that they can exempt it?
View 2 Repliesi try to do make a view in sql server using this code from access:[code].....how can i convert it to MSSQL?
View 1 RepliesI have been given a task to create a new billing system for my company and I have been trying to get the customers from one Access 2000 database into the SQL Server 2005 table
Public Sub IPCustomers()
Dim rtn As Integer
Dim OLEDBConn1 As New
[Code].....
The problem lies in the strSQL where you see dbo_Libraries.LibDescription.Value and dbo_Libraries.LibID.Value.
Before, I merely put single quotes around the fields from the from the Access Table and it inserted exactly the code itself, dbo_Libraries.LibDescription.Value and dbo_Libraries.LibID.Value , and only 1 record. There are over 300 records in the table.
When I put double quotes around both, separating them out from the string I get the error "Arguments Not Set."
how can i access remote sql server 2005 work on windows 7 ? and in the seem time i donot like turn off firewall .
and how i can make sql server listen to it port 1433
For years now I have been using access as my database. But with the SQL server Express version around I have been wondering if it is not better to use this instead of access. Note: I only develop applications for small businesses and a limited set of users. So what do you guys prefer and recommend?
View 2 RepliesI have MS Access 2007 Databases and VBA modules associated with it.I Now want to upgrade my project so as to use Sql Server 2005 and Vb.net using visual studio.net.Can any one suggest Complete details on the transfer without much hassle or data loss.?
View 3 RepliesI am trying to access a file using the following
CODE:
However I am getting the following error: "Object reference not set to an instance of an object."
I know there are the 'Wizards' to help me, but I need the code to access the Table Manager, the data set and so on, create them in my project and access the tables or stored procedures
View 2 RepliesI have some code that retrieves some data from multiple tables.This works fine.Now I want the data I retrieved to ADD to an excisting table in an Access 2003 DB.
How can I achieve this.I searched this forum and google...without succes :-(
The code I use to retrieve the data from sql server 2005: Dim connection As New SqlConnection(strConnectionStringSQL)
[Code]...
I am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard .
View 1 RepliesI am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesIm having problem with the Serial Port. When i run my program, "Access to the port 'COM1' is denied". What does that mean? Im not sure whats happening because theres no error in my code. Someone suggest me to use 'COM2'. Which is also the same result. I have a microcontroller, programmed and run it. And i need to capture the data onto my vb, which is on a multiline textbox. How to i do that?Just to double check my code?
[code]...
I have a tcp client and tcp server.How do I ping the server from the client, by specifying the ip and port of the server?
View 1 RepliesWe are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 RepliesMay I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
I've been working on a program that monitors ours and our clients server's to make sure they are still on. the ones that are ping able were easy, now I'm trying to monitor servers that are not ping able. what I'm thinking of doing is creating a small client program to put on each one of the none ping able server that sends a packet to our server every 30 seconds over port 80 (not have to worry about firewalls) and once the server program doesn't receive a packet for 2 minutes then it will display/sound a warning. my questions is is this possible, or is there a better way of doing this. right now i just am checking to make sure the server/internet connection is on, later i will look into getting info from event looks, SNMP, etc.
View 4 RepliesI am working on a way to send commands to an Arduino board from a web site. The Arduino board is connected to the computer via a USB port (a COM port).
I have managed to connect and control the board using a VB.NET program. I also wrote a VB.NET class that can instantiate a COM connection and send and receive messages.
My next step is to basically create a program that will act as a proxy between my web server (IIS 7 running on Windows Vista) and the Arduino board. When a user gets to my ASP.NET page, the page will then send a command to the proxy to open the COM connection. When the connection is open and ready then I can send commands to the proxy. In turn, the proxy will send these commands to the board and listen for the responses it receives from the board. The proxy will then pass these messages back to the ASP.NET page.
The main issue I see occurring is that if a second user opens the web page and tries to open the COM port, there will be an error. Will this cause the first connection to fail? I guess I can first check if the port is already in use and give the second user a message. Are there any other potential challenges I am missing or not seeing?
I am new to socket communication. I found a few samples on the web and I managed to make my own host-client communication but i wanted to go a bit further and connect to port 80 of a server and it was just a disaster! First of all I know I can just use the functions that vb has itself but I want to make my own connections ... I have got some reasons I need this one! Do I really have to make them "connect" or just somehow without connecting I get the data? So I'm stack at the point that the connection is made ... it refuses to connect.
View 7 RepliesI have a logon screen that contains several textboxes where user can fill in their logon info (username, pass, server, database, connection port, etc.). I'd like to have the application memorize what they've put in after the first time successfully logon in form of a dropdown box. Let's say the 2nd time when users trying to logon, there is a drop down box of username, server, connection port, etc. available as a dropdown list item. They can select the info and simply enter the password.Is there a way to do that? If so, do you have an example or a reference source I can learn from?
View 5 RepliesI am in need of a way to check the status of a IP and Port. I've been looking around all day and still haven't found the correct thing.
View 8 RepliesI have an application to make a server and clients to read/ send text to it but I want a program I can run from a remote computer that you enter the ip and port and it crashes the server.
View 2 RepliesI'm trying to make a Client that will automatically run a .DLL that I have created and send information over port 80 to my Server program that will take that data and import it into a database for me. Problem is, I don't know where to start as I have never done this before. I want to do this in VB .NET as this is the programming language that I know. What are methods of doing this? Is there sample code out there for something like this? My google searches are failing me.
A better layout of what I'm trying to do:1. Client Runs .DLL, retrieving information from an Excel file.2. Client takes these properties with the data it contains and sends it to a program outside of the local network through port 80, my boss refuses to let me use any other port.3. Server accepts the data and builds its own properties to be imported into my Access Database.4. Repeat over, and over, and over, and over.
I plan for the server application to be a console application, and the client to be a windows form.
I want to find the coordinates of a speeding vehicle by accessing the position of the vehicle through GPS(from a server system). how to access GPS port and retreive the data.
View 4 RepliesI am currently doing a program to control some device via usb port but i don't know how to interface the usb port using vb.net. anybody can help me with this problem as which namespace I should use?
View 10 RepliesI am developing a program that send sms to cellphone using a datacard.I can read the com port from the server if i run the program from the server, but i run the program from the terminal y read the com port of the terminal, but i need to read the port from the server for use datacard. What can i do? My code for read com port.
Function checkPort() As String
Dim intPort, X As Long
Dim strAbierto As String[code].........
How is possible to communicate through USB port in VB.NET 2005?
View 8 RepliesI have following code in VS2008
If Linq.Enumerable.Contains(Of String)(selectedUsersRoles, RoleCheckBox.Text) Then
RoleCheckBox.Checked = True
Else
[code].....
I have am using an XBee ZigBee wireless module to communicate with a project of mine. I currently have it set up to the point where I can open a hyperterminal session to COM 4 (which is the usb com port), and recieve the data that is being sent via the microcontroller on the other side of the wireless link.
I would like to make an app that takes the data and puts it in to a more user-readable format. (Via VB 2005) So far all I have come up with is some problems. It doesn't seem like I can use the built in serial port tool to access a "virtual" com port. From the following link:Quote:
Note You cannot use the Microsoft .NET Framework classes to directly access other types of ports, such as parallel ports or USB ports.[URL]..Do I have to use a "COM port redirector" to make it seem like a real COM port? Or is there some easy way that I am not thinking of?
How do i access a port in Visual Basic?
View 3 RepliesI wanted to know what are the risks of opening up a socket server on a specified port? Right now I have it limited to only accept requests from 1 specific IP to that port and all the other ones get rejected (using the windows firewall), is there a way to implement an authentication or anything else so I can allow it to be accessed from any IP worldwide yet have it secured?
View 1 Replies