I am trying to do a simple query of selecting an ID number from one table and matching it with the ID number in the other table, however the catch is the two tables are stored on two different sql databases.[code]...
View 5 RepliesI want to connect to a database Ive created using Microsoft Access 2007. Im using Visual Basic 2005. I also want to be able to perform basic tasks such as searching.
View 1 RepliesI am trying to Connect my VB.net Window Application to IBM_DB2 Database.I have used the same method to connect to previous other databases such as SQL Server, Oracle. But getting an error in DB2.
Dim cn As New OdbcConnection("dsn=Sample;uid=db2admin;pwd=password") 'Sample is DSN
cn.Open()
Dim da As New OdbcDataAdapter("Select * from Employee", cn)[code]......
Basically, we have three databases to grab data from. One is a SQL Server database, one is an Access database (which is particularly annoying to connect to because we have to map a network drive and such), and the final one will be an Oracle database when IT finally gives us rights.I'm thinking about creating a helper function that makes querying any one of these databases as easy as possible. I want to create a two-dimensional array
Dim myEasyResultArray(10,10) as String
myEasyResultArray = DatabaseHelper("Access", "SELECT * FROM Employee")
Is this a good design decision? Also, how can I have the array be the right size? Can I just do this?
Dim myEasyResultArray = DatabaseHelper("Access", "SELECT * FROM Employee")
Should this be a module or a class? I don't really need to share variables?
I have used two database (1) party (2)partydup.[code]In both tables i have common field ("code"). I tried to retrieve the value of "description" field from partydup table when the "code" field in both the tables are same. I run the below coding but it is showing the error as "No data exists for the row/column". But i have a record which contains the code field value as 123 in both the tables. Still it is showing the error. Please let me know what is the mistake i have done.[code]
View 8 RepliesI am rewriting a program I originally did in MS Access. In this program I pull a table from the company's AS400 iSystems, it is filtered by data that I have in an Access Table. In Access, I first link both tables to the source and then just create a Query as if both tables were local. Now that I am using .Net, the second table is in SQL Server 2008.
SELECT LPROD
FROM ITEMS
WHERE EXISTS(
[code].....
I want to create 1000 MySQL database on a hosting server & add 1 single user in all of them with all privileges enabled,Now I know how to create a database from MySQL query, But what I can not find is "how to add a user in the database",For example: create database 1a;This will create the database, but with the creation of the database I also want to add a user in that database from the same MySQL query, or another query to run with it, but I want both operation to run at the same time.
View 1 RepliesI am looking for the proper code format to rename a table of an SQL file within VB.net.[code]...
View 7 RepliesI developed a program using Vb.Net that is data based enabled, it has a field for serial number etc. its working fine but the serial number failed to update when a record is deleted, its always keeps tracks of its formal numbering, even when the program is restarted, unless reinstalled.How do i also backup the data stored in such program.
View 6 Repliesive been asked to write a program to deal with supply chains (tracking commodities, personnel, etc). I want to create a program that will allow multiple office to run the same software and update their local databases as well as a central database.how to best send the data/ recieve it, and store it so that all offices can see, edit, and store the data both locally, and over the internet.
View 13 RepliesI have a basic question about using a database with Visual Basic.I'm using a OleDb connection. I have dragged and dropped editboxes from the DataDource view. This automatically places the table navigation- bar on the form. When I run it this works fine.However I want to be able to search within the table, with an SQL statement.How can I connect the results from the SQL query to the navigation bar,such that the editboxes automatically take the values of the record without having to assign every textbox manually?
View 1 RepliesI'm fairly new to VB.NET and I'm looking to create a module that will contain all general SQL functionality like connect, disconnect and execute a sql query etc. I think I'm almost there but the code keeps bombing in one place. Can anyone see what is wrong with the following code?
[Code]...
i connect the Datagridview by using command connection not coding. now i have "table3tableadabter", "table3bindingsource" and "database3dataset" below the form ? the search string " "Select * from tabel3 Where test2 like '" & Me.TextBox1.Text & "%';"" how i can do serch and the result will be shown in datagridview.
View 4 RepliesI know connection of MS Access and VB. I don't know connection of SQL with VB.
View 2 RepliesI have oracle database
and i want to connect to DB from vb.net
how step to perform them
I am in progress learning on how to make link between VB 2008 to Microstation v7(2D drawing software) or
any program might be. What is the best way for me to start, for doing this kind of development?
it is a lot of thing for me to take in to account before go far?
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed...
someone gave me a link to changing the database connection using an instance. When I tried to type what the instance of my SQL server 2008 I must have put the wrong information into the database connection instance.
What is the database connection instance called for SQL server 2008?
i'm trying to build a program where I could preview the songs, and then copy it to my mp3 player. Is there anyway that I could connect the mp3 player with my vb.net program? So far what I have done is just a normal mp3 player using the windows media player in vb.net 2008 express edition.
View 1 RepliesTo start, I should probably mention that I have almost NO knowledge on coding, MySQL, or anything in that category. I have watched some simple Visual Basic tutorials and I am attempting to make a software in Visual Basic 2010.What I need to do is connect all of the users of the software. For example, in the software there will be a label. When somebody using the software enters something into the label using a text box, I want it to show up for all users using the software. I am going to take a guess and assume that a MySQL database will need to be connected?
View 1 RepliesGiving out a complete tutorial on the step by step way a connecting to a database using VB?
View 2 RepliesI try to connect my programe with MySql on my computer but it could not execute. The error like attached image file.[code]...
View 6 RepliesI'm trying to connect to a SQL server from VB. The SQL server is across the network uses my windows login for authentication.[code]...
View 5 RepliesHow can i connect two VB.net applications together so that they can send each other informations ???
View 3 Repliesi want my program to connect to a radio.with IP:Port as in its being streamed with shoutcast.So [URL] << i want that radio on my program (its my radio, that link is not for advertisement perpouses)
View 3 Repliesi want to learn this kind of program.. and this are my problems:
1. i dont know how to connect my vb.net program to sql server?? can you help me.
2. how can i call my fingerprint scanner to my vb.net program.
3. how can i input the time eveytime the employee's touch the scanner ( log-=in and log out)
I have a vb.net program that uses mysql as its database. And it works when the computer has wampservr installed. But the program gets an unhandled exception error when the computer where its running does not have a wampserver. The only thing that is installed in it is the mysql connector net. How do I make it work. I just want the two programs to access the same mysql database. I already opened port 20 by configuring firewall. Both in TCP and UDP. What do I do? Do I have to tweak the codes?
View 1 RepliesI am using this connection string to connect to my database and still it won't connect[code]....
View 3 Repliesevery time i try to establish a data connection between vb 2010 and sql 2005 i get the following error message QuoteA network-related or instance specific error occurred while establishing a connection to SQL server.the server was not found or was not accessible .verify that the instance name is correct and that SQL server is configured to allow remote connection .(Provider:SQL network interface,error:26
View 6 RepliesI have a windows application written in VB.net. After finishing it I'll setup the program in more than one pc. I want to connect the program in all PCs to one database in another PC using Microsoft Access, and I also want to limit the level of access of the users to the database in my program.
View 2 RepliesI make my Program to Connect via Network to Database..[code]
View 5 Replies