This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 Repliesi am doing school software projects in windows application. now i want to install. this project to my client place. i can able to convert my application in to EXE using setup project. The problem for me is the database. i am using sqlserver 2005. i don't how to install my database and table into the client computer. is there any way to copy the database. if anyone have any idea about how to install my database i have create for that application into client computer.
View 1 RepliesClient/Server Application in vb.net 2010 i have created but it was just basic one. I need to show send data from client to sever and sever to client and and more functionality. (like showing price ot item or anything
View 2 Repliesim decide to develop Vb .net Application With Sql server Express 2008 ,but microsoft says they limit 4 GB Sze for per DB! So im developing my app for Single user Desktop pc , so what i do when the DB reached to the Maximum size? when the db size reached to maximum size , is it Good thing to create new DB and allow my vb.net application to work with both DB s ?
View 4 RepliesI am building a database application using MYSQL as the backend. The MYSQL instance will be installed remotely on a share host. I have access to SSL certificates. I'm obviously not looking for any code but, conceptually, how do I go about securing the connection using SSL between my application and the remote MYSQL database?
View 2 RepliesCase : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
I've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script etc.
View 1 RepliesWe would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
View 2 RepliesI'm creating an application that uses SQLite (using the SQLite.Net adapter) as its database engine. Since some of the data stored in the database is sensitive I've encrypted the database using the SQLite.NET built-in encryption, and then to open the database I've to do something like this:
vbnet
SQLiteconnection.ConnectionString = "Data Source=" & DataBaseLocation & ";" 'Set the connection string
[code].....
am [writing reading] from a plain text file usernames and passwords, but its an bad way of securing data, is there any other way to do this, most probably by using IV's, encryption decryption algorithms.
View 2 RepliesIs there a relatively simple way that my VB.NET application can be notified of the fact that a new value has been written to a table in SQL Server Express 2008? Polling is not an option since I'd need to do that every 10 seconds nonstop.
View 1 RepliesWe are developing an application in VB.NET 2008. We break the application into smaller multiple dlls so that we can easily update the program at the customer end.We want to know that is their any way to stop the other person to use my dll in their application?i.e we want to lock the dlls such a way that the dlls will be used by us only and not anybody in their application.Also we want to block viewing of dlls code using any code reflector
View 4 Replieshow to create a client/server... But I couldn't... I don't want anything fancy. Just want the client to send the server 4 numbers, depending on the user's choice; after that, the server would turn off the pc, restart it, etc. It all depends on the number received. Is there a rather "simple" way to do it? If it's not to much trouble you could use Atheist's example. (Btw I don't understand the code and, yes, I've checked on [URL])
View 9 RepliesI would like to create a server program that accesses an "ms access" database. I will also need a client program that connects to the server. The reason for this is that the server is a mediator for several clients. Since I am using access, I plan on maybe having 20 or 30 clients connect to the server only. The client will have access to a virtual market. So when a person buys or sells something on the market, the server mediates the transaction and etc. At the same time, the access database saves each clients data as well as the overall market data.
View 1 RepliesI need some pointers on which .NET technology to use for a project I'm working on. I'm building a "dashboard" digital signage WPF program that will display various things on a large monitor mounted high up in the ceiling of my office.What I need to be able to do is control certain aspects of this program from my desktop. For example, there will be a TV window in the application with signal being provided by a TV tuner on the mini-computer connected to the monitor in the ceiling. What I want to be able to do is make a remote control to be able to change the channel etc. I'm confused at what technology to use. I've read about remoting, WCF, and simple TCPclient classes but I'm confused at which one would be better. I'm thinking it may be better to use WCF because what I think I need to do is make a function that will change the channel and accept channel numbers, etc from the remote control program. Am I on the right path?
View 5 RepliesI'm developing a project.
I wanted to connect client software to sql server 2008 database and server for now is Windows 7.
I created an account Named Test with pass=1 on the windows 7 (server) and it's admin account
My Connection string on the client is this:
server=ip of server;database=dbName;uid=Test;pwd=1;
1-Is it neccessary to install sql server on the client?
2-When I want to connect it says: Login failed for the user Test.
how can I restore sqlserver database from VB.net or C# Application?
View 2 RepliesI've basically made a basic tcp server/client application. The thing is that I'm behind a router and so will be the other people that use my clients. I've had to use port-forwarding or the software "rinetd"to run quite a few applications online.
Let me explain: I'm on a lan network that connects to the internet. Whenever I want to host a server - for instance a basic ftp or http server. If I give my external IP to anyone, they won't be able to access my server. Even if I portforward, it doesnt work. I have to use rinetd here. For other applications, portforwarding works. I'm not sure how these things work at all.
Anyway, my issue now is that I have created this server/client application. I'm having serious doubts that if I run the server, I'll have to either a) portforward or use rinetd to get people to connect to my server. IF I need to portforward, that's fine. However, using rinetd would really suck... My 2nd concern is as follows: IF the person running the client is in a similar situation as me (i.e he's on a lan that has a router which connects to the net), will he have to portforward or use rinetd as well? If he portforwards that's fine. But I don't think I could get people to use rinetd.... Also, if there are more than 1 person on a lan trying to connect to my server, there is a big problem when they try to portforward: they will only be able to allocate one of their internal ip to that port, and the others won't be able to connect, right? How does this work? I mean, I use many softwares like msn/skype/(some games)/firefox that do not need portforwarding/rinetd. Yet they work. My housemates(other people on the lan) use the same softwares, and it works fine. There's no clash/probs watsoever How come these run fine?
Anyway, back to my issues. Given I have no knowledge about how the above work, I was wondering whether there was a way to host a vb .net server application on an external website (external to my house) so that I might *avoid* the above mentioned problems, and to what extent that would be a sound solution.
Ive been working recently on a chat. Ive been using FTP to comunicate through both forms but it need to constantly download the new data and make the application freeze. Even with a Backgroundworker. So my question is : is there a way to keep a constant connection between the form and the host? And not LAN ,I mean that doesnt need to be on the same router.
View 1 RepliesI have a simple TCP Client/Server application that ties two pcs on a lan together. This has worked great for many job sites but the most recent has an IT manager that will not allow me to set a static ip address on the server pc.Basically, I was wondering if there was a nifty way to have the client find the server.
View 25 RepliesHow to "download a file from sever to client".
View 3 RepliesIm using the code from [URL] as a starter, most of the code is the same. the chat system works fine but on the client a added a disconnect button "clientSocket.Close()" and as soon as i click that i get errors, on the client, this is the code...
Private Sub getMessage()
For infiniteCounter = 1 To 2
[CODE]...
And this line...
serverStream.Read(inStream, 0, buffSize)
gives me "Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."
Now im talking the server, after the client clicks disconnect or closes by task manager, looses connection, etc the server crashes and gives me.
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesHow to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?
View 6 RepliesIm planning to create a Remote Desktop Application and I'm having problem with viewing other computers monitor or screen.
Im not asking for the code on how to do it. and one more thing is it safe to use winsock in creating a client/server application?
i'm newbie in this programming..i need some references or a starting guide to build an sql server and vb.net application.
View 3 RepliesI am creating small application (desktop search engine) which uses sql server as back end. Sql server is used to store huge data using indexing (for quick search). Is it necessary that client should have sql server on his machine to run the application? I don't want to install sql server on client's machine, because my application is just a small utility.Is there any other way so that I can store huge data using indexing?
View 2 RepliesI have wrote an Application for a organisation and they had let the app run in their lan using Samba, it worked perfect. Now they want to work over the internet.The Problem is that I have written this app with Sqlite, that means its currently working so:They have a exe and the sqlite dll and the sqlite database on their samba server and they connected a network drive on their windows pc to run it. So that means every pc is writing over samba to the sqlite database.
I tried it over the internet, but like i thought sqlite is a local database and its very slow, even if the ping is under 50ms. I could create a tcp server, that handles all and writes all to the sqlite database, but I have already written around 20.000 code lines for the project, so that would be not the best option for the lazy me. I have used only one sqlite class in my client for querieng, so I thought that it could work without much work, if i would replace the sqlite database adapter with the mysql database adapter, since sqlite has nearly the same syntax then mysql.
Hey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
I seem to have a major problem. when I add a typed dataset to my project and go back to my sql server and click on the databse I use it doesn't open. the tables and stuff just vanish. using the wizard, it creates this connectionstring:
<add name="Schenectady.My.MySettings.SISQL2ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataSISQL3.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
It connects fine. but after I try opening it in sql server i get an error. It doesnt let me restore or anything. i tried restarting my pc incase the db was locked but it is still gone. now my app cant connect. Just for clarity, is user instance supposed to be set to true. and what is the purpose of it. also when the wizard asks to make a copy of the file that will be copied accross each time I run my project I select No.