An App That Connects To A Sql Database?
Jul 8, 2011
I have an app that connects to a sql database using the standard connection string.Now i want to do some work on this at home, where i have a vpn connection to work setup.It's quicker to work locally than it is to rdp into work and work from my desktop there.What do i need to append to the connection string to get it to connect to the server at work? i've tried appending the domain in front of the server name but that didn't work. is there something else i should do?
View 2 Replies
ADVERTISEMENT
Mar 12, 2010
I have a little problem. I made a connection to a database. So now i want the mac address of the NIC that connects to the database. Is that possible ?
View 1 Replies
Mar 14, 2012
I'm trying to create a login which connects with a database which i created on db4free.net and i've installed the connector.
View 2 Replies
May 22, 2009
I need to create a program that connects to a database and determines if what the user entered is in the database. Trying to do this in somewhat the same way that a translator might workchecking to find the word, and if found replace it with what is in the row beside it in the database)
Anyone have any idea on how i should go about doing this?
I know its gonna involve looping but as to how i am completely lost
View 4 Replies
Jun 30, 2011
Basically Im going to sell software where once the user buys they register on a page, then their credentials gets added to a database, then once they open my program they login and my program checks if there in the database or not so they can advance.
View 3 Replies
Jul 12, 2010
I have a website with MySQL databases. I'm wanting it to connect and: display a table's data, login using a table with logins, and submit a form to go to be put in the table.
View 2 Replies
Feb 27, 2011
I am trying to make a very simple program that connects to a MySQL database using VB.NET. My program only has one form and one label. I setup my MySQL database to have a table and one field (a VARCHAR)called "Tab1". I manually inserted the value "CLOSED" into the Tab1 field using PHPMyAdmin. I want my program to change the value of the field to OPEN/CLOSED and I also want the label text on my form to change too when it's clicked.
[Code]...
View 3 Replies
Jun 22, 2011
How it's possible to get values (string) from the database when a user connects? i use in this
[Code]...
View 5 Replies
Apr 5, 2010
I have a windows app that has a bindingNavigator connected to BindingSource that connects to an Access database. I am manually adding a record to the underlying database using an OLEDBConnection/command (cloning the current record). The insert into the database works fine, what I am not sure on how to do is force the bindingNavigatgor to refresh and read the new record and refelect it in the record count/next/previous buttons.Jack
View 7 Replies
Mar 12, 2010
i am trying to create a program that connects to a database and shows table fields in listview in windows form i manage to do that but i want now to have a button to take the total of a column in a list box ,lets say from the column "money"?
View 9 Replies
Sep 25, 2009
I am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?
View 7 Replies
Mar 14, 2011
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
View 5 Replies
Nov 30, 2011
I have the following piece of code, which currently connects to a SQL DB using the users windows login, but I would like to change this to use the UserID & Password in the updated ConnectionString which is saved in a config.xml.
vb
<add key="ConnectionString" value="data source=Server;integrated security=SSPI;database=DB1;User Id=develop;Password=develop"/>
vb
Public Sub GetUserDetails()
Dim strSQL As String
strSQL = "SELECT SUBSTRING(SUSER_SNAME() , CHARINDEX('',SUSER_SNAME(),1) + 1 , 20)"
[Code]....
View 2 Replies
Nov 18, 2010
VB2005: So I created an app that connects to an Oracle 9.2.0.1 using the .net oracle adapter. I can issue queries and process the results. This all works fine on my development machine but now that i have distributed the app to my group I find that it bombs on certain workstations, specifically when it comes to connecting to the Oracle db. I've done a little bit of research but havent come up with anything definitive.
So what should I install on my users desktops to make sure that the connection works?
View 7 Replies
Oct 26, 2010
I have build an application in VB.NET (3.5) wich connects to an oracle DB. I works perfectly on my pc. However. When I install the app on a pc without oracle it will not connect to the DB on the server. Do I have to install somekind of driver on the client pc?
View 4 Replies
Jan 29, 2011
i am trying to make a program that connects through a proxy mainly socks proxy but would like to connect through a http proxy also.
View 2 Replies
Aug 5, 2009
I created a vb .net app and basically it connects to the server (my brother's computer at his house) and sends messages. The problem I'm having is, we both have routers. The only way I'v gotten all of this to work, is by both of us connecting ppeo broadband and then our ips work, otherwise the "real ip" is used for all the pcs in my house. How can I connect tcp to him wothout him having to connect broadband. Because to connect broadband he needs to be connected to an ethernet port, so then he cannot be wireless.
View 3 Replies
Jul 3, 2011
I've had a problem which Mike has kindly helped me with here: url..I now ahve a problem when disconnecting then trying to connect again. The app works fine once, but throws the exception again if you try to connect the client a second time.
View 4 Replies
Dec 14, 2009
I'm trying to make an e-mailer that connects to an SMTP server.
Ive looked everywhere and Id prefer if it was explained how to put it into my code.
[code...]
View 4 Replies
Aug 13, 2009
Is it possible for me to make a login that connects to my forums?So 1. User opens login form 2. Enter info 3. Connects to forums 4. User opens browser and is logged in
View 3 Replies
May 30, 2012
Im making image uploader that connects to my ftp and send them in to public_html.This is the
Public Class upload
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim request As System.Net.FtpWebRequest = DirectCast(System.Net.WebRequest.Create("ftp://ftp.my.details.com/public_html/photos/"), System.Net.FtpWebRequest)
[code]....
View 8 Replies
Jul 28, 2009
I am working with two databases stored in SQL server 2005, with VB.Net 2005. Database 1 - is the DevelopmentDB and Database 2 - LiveDB. I have two front-ends one connecting to the DevelopmentDB and the other connecting to the LIVEDB.
Now, I have a problem with the live front end. After publishing, it accepts me to log on with the Live username and password..(it connects to the LiveDB) Note: The two front ends i.e., for Development and Live have different usernames and passwords.
So, I get connected to LiveDB, however, when I open a form built in Datagrids it connects again to the DevelopmentDB.I have checked the connection strings its connecting to the Live. This is not an application or database problem. The reason being I tested it on another PC and when I logged on with my credentials it was fine. I was connected to the live database and all the forms were displaying accurate data. Therefore, my conclusion is that this is not the front end or backend problem.
View 7 Replies
Feb 19, 2009
I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it?
View 4 Replies
Nov 29, 2009
I use Visual Basic.net to create a program that connects to several websites, logins, then post some data. I can't use the httpwebrequest, some java is required on those sites, so i use the webbrowser control.Now I created a form, some fields for input data and a submit button. The coding part is like this:
Code:
sub website1(vars)
'login here
'post some data
[code].....
The problem is that I can't control what happens after submit button is clicked. I need to pause or stop the process at any time. If I exit the program while processing, I can see that even if the window disappear, the program is still running!I tried to use a thread for this, but the subs only get called if I use begininvoke, or invoke on a starter thread.
View 1 Replies
Mar 9, 2009
I have to schedule an exe file as windows service.The exe file should be triggered when user connects to the pariticular net work for ex: company network.User can connect/disconnect to the company n/w "n" number of times to the network in a day. so every time when user connects to the network theservice should run the exe file.
View 1 Replies
Sep 30, 2009
I'm trying to get a VB2008 multi thread application working that connects to a local server program using sockets. Server requests for this particular system can be more quickly handled by a number of connections, so I've written some code to run any number of data request threads that I choose. The problem that I'm having is that the data returned from the server is getting mixed up and is often returned to a different thread/socket than the one that requested it. Other than that, it seems to work okay. If I use just one thread, then the system works as it should. Pls. see incuded code, which is heavily edited to remove all the other fruit salad. Is there any way to set up the sockets so that data returned to the socket/thread that requested it?
Module StaticDeclarations
Public WithEvents g_SD As New SocketDataClass(New MainThread.MTCallback(AddressOf MainThread.MTResultCallbackSub))
Public WithEvents g_MT As New MainThread(New SocketDataClass.SDCallback(AddressOf SocketDataClass.SDThreadResultCallbackSub))
[code]....
View 4 Replies
Apr 4, 2012
i have a form where i wanted to open multiple socket connects to multiple servers. i defined "clientsocket" as a socket array
[Code]...
View 6 Replies
Jan 14, 2011
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
View 1 Replies
May 18, 2009
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
View 1 Replies
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
