I need help getting a connection to a database from within the windows 7 environment. The code currently works for windows XP flawlessly.However in Windows 7 i get an error about a resource not being registered on the local computer.
View 12 RepliesI have a .net window application created and I wanted to see if it's at all possible to place various file dependencies off the web server. e.g. is it possible to have the connection to the database be off a web server?
I also would like to see if it's possible to place one of the .dlls off the web and have code that points to it to load.
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
[Code]...
I want to store Usernames/Passwords in a Database/Data Connection...eg. A login.
View 4 RepliesI have a small databse program. Form1 uses the Private Sub OpenToolstripmenu to Openfiledialog box and creates a connection and adapters. I need a second form that will access the same connections and adpaters what is the best /correct way to do this? Also other sub functions on form1
View 8 RepliesI was wondering, if there is a way to block incoming connections from specific ip adress that tries to connect to computer
I assume that it cant be via windows host files
I need to change the connection string of all tableadapters at runtime, can anyone tell me for the best way to do it?I have a conection string in my settings, that i can't change at runtime (application scope), i could go to dataset.designer and change the value to a new variable but i don't think this is a good method.
View 3 RepliesI just can't run any of Data sample codes that come embedded with VS2008. I'm trying running CreateDB example but I can't make it work.How can I configure Data Connections? [code]
View 12 RepliesI'm wondering if its possible to log who is connecting remotely to my local hard drive and also log what they do if possible?A lot of people access my hard drive and im curious to what they do while there.
View 1 RepliesHow would i write all the TCP connections as an array then when i click on one connected client, it chooses the same value from that array?
View 2 RepliesI'm writing a program that notifies the user when process X.exe starts eceives a new TCP connection.
Is the only way to issue a full 'netstat' and then select the entries relating to that specific application or is there a better way?
I have written tons of websites with PHP and MySQL, now I want to combine a website with a program on the computer.I have searched google, but I cannot find a good tutorial on how to use MySQL on a server with Visual Basic.NET I need to connect to my MySQL database, read data, and write data.
View 6 RepliesI have a need for an application with a SQL database back-end. The application will run on a laptop and will therefore be used both on and off the network. I can write the app and I can link it to SQL over the network. I also know how to dynamically change the connection string so I can handle online/offline data source connections. Where the data can be stored on the local client? I'd like the data to be held in the central SQL DB and to automatically copy to the laptop upon connection to the network. The client data source is read-only and will not upload back to SQL. I've seen XML mentioned but that looks overly complex.
View 2 RepliesI have been developing an async socket connection server and client program. I have been testing it, and noticed that if I connect to the server from my client and then disconnect. Upon reconnecting I am on a different port(local IP still). This is fine, however when I go to send a message, and the server trys to update all the clients, it eventually hits clients that do not exist anymore. I get the SocketException 10054, and upon connecting/disconnecting enough, it no longer works at all. My question is how do I clear out these no longer useful sockets from the server? I am doing currentsocket.Shutdown(SocketShutDown.Both); and then a currentsocket.Close(); after that. When a user disconnects.
[Code]...
For example, is this an acceptable way of checking that fields are not empty before submitting data to a datatable/database? Right now, Im simply checking with an If statement, and I'm starting to think that this is not the correct way to do it.
I'm also trying to learn more about unit testing, so if you have any tips or tricks, please feel free to share.
[Code]...
I wrote the programme with vs2008 and access 2007,i built its setup.when i execute my setup on winxp ,its true,but when i execute it on win 7 ,when i want to save my data i have an error.
View 1 RepliesI am trying to get valid data entered in a Windows Form.I simply used bunch of IF and ElseIF statements to set the conditions.
1. Because the field can only accept letters, I need to filter out characters. Eg: !@#$, stuff like that.
2. I need to apply a loop so that the user is prompted to re-enter the data or to have the error message repeat. Right now the error message display once and that's it.I understand the Do Until Loop but my book shows example only on numbers.
Public Class validDataForm
Private Sub validDataForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[code]....
I'm using Visual Basic Express 2008 in Windows 7(64-Bit). I've added a datasource to my project and dragged a table from Data Sources onto my form. It automatically created a DataViewGrid and placed this statement in my form load event:
Me.BillsTableAdapter.Fill(Me.DoBills_2009DataSet.Bills)
The DataGridView shows all the correct fields/columns. The .DataSource property for the DataGridView is set to the automatically created BillsBindingSource. When I preview the BillsTableAdapter, the data appears. But data does not appear when I run the app. The datagridview is empty. When I build the app and run the executable, I get a Microsoft .NET Framework error message that says: "Unhandled exception has occurred in your application. If you click continue, the application will ignore this error and attempt to continue. If you click Quit, the applicaiton will close immediately. The 'Microsoft .ACE.OELDB.12.0' provider is not registered on the local machine." If I click "Continue" I get my form with an empty DataGridView. What am I missing to get the data to display in the grid at run time? Oh, and I've also tried using the DataGridView in C# and I get the same problem.
I am trying to read excel data (Excel 2007 SP1, on Windows XP SP3) with visual basic .net 2008 (VB 9.0 SP1). I have tried several attempts and whatever I do I am getting the following error message: System.Runtime.InteropServices.COMException was unhandled ErrorCode=-2147319784 Message="Altes Format oder ungültige Typbibliothek. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" Source="Microsoft.Office.Interop.Excel" Message="Altes Format oder ungültige Typbibliothek." Translated: Old format or unknown type libraryI have added the reference "Microsoft Excel 12.0 Object Library" to my project. I am assuming that I might have to add a different or an additional reference, but I do not have any clue which one to use. List of things I have already done:- Searched other forums- Altered the language settings- Tried it on an other Computer (Win XP SP3, Excel 2007, Visual Basic 2008 Express)- Ran the diagnostics tool in Excel - Updated all updates etc...- Reinstalled Visual BasicI really do not have any clue why it should not work?
Imports excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim xlsApp As excel.Application
[code]....
I have an excel file that I would like to load into my form and display there.
View 1 RepliesIt is possible to create windows service using windows form control in vb.net. give me the url or links. The windows forms control such as, Timer control, list-box, notify-icon control etc.
View 1 Replieswill an program built on windows 7 using vs 2008 or 2005 have the compatibility with windows xp or vista
View 5 RepliesI'm populating a listview with a list of databases on a selected SQL instance, then retrieving a value from each database (It's internal product version, column doesn't always exist) I'm calling the below function to populate the second column of the listview:
[Code]...
I'm trying to understand how to handle db connections in a multi-theaded windows program.It I have this simple class:
public class MyClass
private myConn as new sqlconnection
private MyThreadPool(5) as Thread
[code]....
I searched araound and having some difficulties in implementing one scenario with SQL Server 2000 and sybase.I have two SQL servers on different locations naming ServerA (MSSQL Server) and ServerB (Sybase server).I have a table called SALARY.Whenever I insert one record to customer SALARY in ServerA, I also will insert it into ServerB.If should any of them failed, both of them should be rolled back.I am using Asp .Net with VB for the programming.I do not have the right to change / add table in Server B. The only thing allowed in Server B is insert/delete/update record.I looked around and find a method to use TransactionScope but I am not quite sure it is the right way to do.url...
View 1 RepliesI am developing an Application that uses TCP To listen for connections, and then when a message is sent to the server and then it alerts the IP that is running the server. (Lets say the server is on a iPhone, and some how the iPhone gets a text message, which alerts a tcp server running in the background via a .jar, it would send the owner of the iPhone a message on the computer telling it it has a text. This is just an example though, but I think it gets the general idea across. I've been trying to do this, and I can connect to a TCP Server (using 127.0.0.1:8888 for testing purposes, will move to a solid IP and Port later). I can start the server (its still buggy and under development) but i don't know how to connect to the server via an application, and when a certain message is received to alert the IP Running the server.
My Server Code is:
Dim serverSocket As New TcpListener(8888)
Dim clientSocket As TcpClient
Dim infiniteCounter As Integer
Dim counter As Integer
serverSocket.Start()
[Code] .....
Now I know that to connect you'd do something like
Code:
Dim clientSocket As New System.Net.Sockets.TcpClient()
Dim serverStream As NetworkStream
clientSocket.Connect("127.0.0.1", 8888)
serverStream = clientSocket.GetStream()
And I know I would have to use some sort of Byte() method to send/receive messages, but I am at a loss on how to set it all up.
how to hide exe into taskmanager in windows 7 using vb.net windows application?
I want exe is hide into task-manager in windows 7 & windows vista machine using vb.net(windows application)
I need to download a bunch of pages from a web server, ie. spidering. I know that servers are typically configured to only allow a couple of concurrent connections from a given IP, but that would already halve the total time to run the script instead of downloading one page at a time.
View 4 Repliesi've been previously using Visual Studios built in wizards for manipulating data access to and from an MSAccess Database, however just recently i coded my own classes and connections to the database, ive been able to select, update and delete records effectively however my problem comes with inserting records.
I have a 3 tiered table database:Tbl_PO, Tbl_Parts, Tbl_Shipments each po has multiple parts, each part has multiple shipments.when i insert a record into the tbl_PO, i need to retrieve the ID used on that insertion.
I am using two SQL connections in my Program. I declare them like this:
Public SQLcon As New SqlConnection("server=(local);database=master;Trusted_Connection=True;")
[code].....