I'm running the following code and I get no error and the stored proc doesn't run. I've tried with different syntax on the stored proc (exec <stored> <parm>) and that didn't work either. I'm connecting via Sybase ODBC. I've also tried with command type text and got the same results (no error and the proc doesn't run).
I am moving a vb.net application from Oracle Lite to Sybase SQL anywhere. I have made several code changes but have a specific error that is driving me mad. All of this is in Visual Studio 2005. When I compile the code it gives me the following error "Reference required to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' containing the base class 'System.Data.Common.DbCommand'. Add one to your project".
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
I was trying to establish a database connection to MS Access but this error keep occurring.
The 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the local machine. I have forcefully set my cpu to x86 but still no lock below is the code how I open it.
Imports System Imports System.Data Imports System.Data.OleDb
for example, if i want to create a program that that takes the result of the calculator ( i mean the default calc of the windows ), or the result of any program, and keep these results in my created vb program, or to manipulte these results, is it possible?
I dusted off VB.net, and now im trying to connect to a local FoxPro DB. Problem is, its not working. Ive been at this for about an hour or so, trying many misc things, but without any luck. [Code]. 'C:aaaCF21000.DBF' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Suggestions? That path is 100% valid, I can copy/paste that and open up the Database without error. I also tried other code I found on the web, some of them I cant even get them to run.
I had an application wich connects to an oracle DB (built in VB 2008). Now..I am using VB 2010 and the oracle client is obsolete. Therefore I want to change my application to connect to an oracle DB the right way.
I want to create an application which generates random questions. So, initially, I have a form where I choose some options. They're all "Yes" or "No". According to my answers, I want my application to generate 10 random questions which are written in a Excel file.
It's like:
Option 1: Yes (Generate 3 questions / Excel file: Questions 1 to 6) Option 2: No (Generate 2 questions / Excel file: Questions 7 to 14)
how to connect vb.net 2010 to ms access database to get the data and display it in vb.net application that I am doing right now. My project is that I am doing dictionary application with vb.net so every time i put new word in search box, I want the vb.net to get the definition from ms access and display it in the application.
I have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the database using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment. This is further confused by office 2007 and VB 2010 both of which didnt exsist the first time i did this.Connect 2010 to an access database?
I have created a db in sql server 2008. I am now trying to connect to it from vb 2010 express project. When I try to add the data source, I get the error "You don't have permission to open this file". I have change the Auto Close option to True on the db.
After further testing I found if I opened BV as Administator I was able to add the db.
I am creating a app to analyze databases for duplicate data for multiple projects. For example, I might have 10 different access databases to analyze individually and I would like to choose them from a dialog control if possible. After the connection is made I will then proceed to run the query from the button click event and spit out the resulting data into a separate winform.
I'm using the latest version of the MYSQL DotNet Connector (currently 6.3.7) and I am unable to connect to my database at all with it. It keeps giving me an error. I can connect the the database using SQLyog with the exact same information but not with this.
This is the error:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Here is the code I'm using:
Dim conn As New MySql.Data.MySqlClient.MySqlConnection("" _ & "server=mydomain;" _ & "user=myusername;" _
I have a few different databases and I need to connect to a specific database according the value of the label (whatever). This is the connectionstring:
I want to connect to a mdb file but i have never did that before. i don't know where to start. heard something about ado.net and some other things.
the file is a 2003 access file if i am not mistaken. and it is shared on network. so multiple users (not too many, max 50) will use it at same time. what is the best connection to use? i have to mention that i don't want to use data controls. i want to use sql commands to fetch data and manipulate data on the form controls myself. i know there are various connection ways like strings and adapters. not sure which one is better.
I have an app, that is going to connect to a remote MYSQL DB.I've look around online, and didnt find any good resources. I've seen some where you have to download an odbc driver etc
I try to use my data source and setup a new connection, but i see it wont let me.Is this another features they left out of 2010 express edtions?I just want to setup a connection to sql server with vb.net express 2010?
i need to check if a port is open, apparently i can't ping ports so i need to use sockets, and it seems that there is no option for timeout on the connecting... how can i put a timeout on connect?
I'm a PHP coder normally, but I've been asked to make a small vb app. I've created my sql db (MSSQL) and have got all the data in it. However, I have no idea about how to connect or perform queries.
Here's my
Private Sub Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]..........
1) Am I connecting properly? I created a new database using the dataset option and it has no username or password.
2) I'm trying to list the results, which will be clickable to open a new form with the full details. How would I do that?
Eg: In PHP, I'd loop through the resources using fetch_assoc, and create a link with the id and it's name as the firstname and surname.
I am trying to make a new data connection to an Access DB using the Server Explorer. The connection test OK then when I click on the OK button to finish I get the following error message.
Unable to add data connection. Index was outside the bounds of the array.
I am using VS2010 and the 4.0 .Net Framework. I have found several posts on this but done have worked out.
I have a desktop WinForms app that I would like to be able to connect to my Sql Server database that I have through my GoDaddy webhost. Problem is not all ISP's forward the 1433 port (like mine) so I can't connect directly to the DB from any of my home computers without buying the expensive dedicated IP address package, which has me thinking since my website can connect directly to the DB I was wondering if it might be possible for me to make a dll that would have all of the database interaction through subs and functions and all my WinForms app would have to do is connect to that dll through http or something, anyone know if I could do something along those lines?
I've got the following code that just does a WMI connect to a remote machine - I haven't setup any code to query anything yet but when I step through the code I don't get any errors. I get to the last debug.print statement and when I step over it the program exists. Almost like I've called a End. No errors or anything - it just exists. How come it doesn't take me back to the form? IF I comment out " scope.Connect()" then it ends the sub and returns to the form.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim displayString As String = "" Dim pcTag As String = "server"