Changing How Application Connects To A DB
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
ADVERTISEMENT
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
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
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
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
May 21, 2011
In my windows application, the first form is login form. When the user double clicks my application, the applications icon flashes in the taskbar though the cursor is in the username textbox. The user then again should use the mouse to turn the focus to the login form. But however while i am working with the source code its working just fine
View 7 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
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
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
Feb 23, 2011
I work with VB.NET 2005 and I want to set the application EXE name according to a certain condition. For example:
I have a variable its name Version
If Version = 1 EXE name will be CarsApp
Else If Version = 2 EXE name will be BuildingApp
and so on.
View 8 Replies
Oct 21, 2009
I am trying to load a icon from a path and set it as program icon any idea how to do that .
View 1 Replies
Oct 11, 2009
find out to change the location of a button.Can't find out how to use the Button.Location.Y property.
View 4 Replies
Apr 23, 2011
I want to ask is there is any way to convert the VB.net application to ASP.net without changing the code..
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 11, 2011
I am running into an issue with changing properties of controls on a VB.net project that I am working on. The portion of code that I am having trouble with is re-enabling a couple of buttons and a ComboBox after a Threaded operation completes. The point of it is to disable the buttons after clicking the main "run process" type of button (called cmdCrawlSearch) so that the process can run on a new thread while the form is updated with the status. I was able to learn about Thread Safe calls using delegates in order to update the Text property of the TextBox (txtOutput) on the form, and thought that enabling buttons would be just as easy, but when I am trying, I am either getting an "Object reference not set to an instance of an object" exception, or an "Exception has been thrown by the target of an invocation" exception (from the current version of code) with the InnerException being the Object reference exception. I am posting the portions of code related to the issue, then below it is the InnerException name and stack trace. Perhaps I am not using the Delegates correctly (since I still do not fully understand what can and can't be done using a Delegate.) Or there is a better way to do this.
[code]...
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
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
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
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
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
Oct 14, 2009
I have created an application which uses an sql server connection as its datasource. The problem I'm having is that the application needs to work on computer that has no network connection. How Can i change the datasource so that on runtime it can work off a machine that is not connected to a network? The datasource from the sql connection only contains one table with no data. It only needs to be updated with a target folder that can be changed to any location on any computer already written in the code.
The connection string suddenly stands as: Dim MyConnectionString As String = "Data Source=MY-PC;Initial Catalog=ImageLocs;User Id=test;Password=test;Pooling=False"
View 5 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
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
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
Feb 18, 2009
Is there some way of programtically changing the culture for a multi form application on startup so that the application will interpret date formats correctly. For example if the aplication runs on a machine with a en-US culture it would be able to take a date from a database in the MM/dd/yyyy format and convert it to a date object and when the same application runs on a en-GB machine it can take that same MM/dd/yyyy date and convert it into a date object without getting a date format exception.
View 4 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
