Tagged Questions
0
votes
2answers
2k views
VB.NET MySQL Connection open for all forms
In the first form I will load Tabels in the secound I want to open the DB Connection.
I wrote a Class which enables me to open and close the connection
Imports System
Imports System.Data
Imports ...
1
vote
1answer
37 views
visual studio 2010 installer
Need some help I have a problem regarding my program using vb10 it was connected to MYSQL Server 2005 i created my final project as an installer when i install it in other computer there was an error. ...
1
vote
1answer
289 views
Visual Basic 2008 - Interaction with database (reading / writing to database tables and fields)
Using Visual Basic 2008 express, I would like to access a database with 2 tables,
one table (useraccounts) which has Users and Password and ID, and the other table which has information (linktable)
...
1
vote
1answer
190 views
“3706 provider not found”
I am working on a project in VB.NET (actually I have migrated the code from VB6) and I am getting the error 3706 provider not found.
Here is the code:
gcnnSpectraHost = New ADODB.Connection
...
1
vote
1answer
900 views
vb.net publish application with a database
i want to have a built in database for my project this is what i did so far, i placed the mdb file inside the project
C:\Users\Jedi Dioh\Documents\Visual Studio 2010\Projects\kuya jake\kuya ...
1
vote
1answer
147 views
Directory pointing to self /creating application with a built-in database
I made a simple program with a database connection:
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
Dim ds As New DataSet 'holds table data
Dim da As ...
1
vote
1answer
499 views
How to close connection created with WebMatrix.Data.Database.Open?
I'm using the Database class from webmatrix in a windows service. (And debugging in a winform causes same error)
The error I receive (after running for a while) is:
Timeout expired. The timeout ...
0
votes
1answer
134 views
unable to import MySql.Data.MySqlClient
I have created a website that uses a MySQL database, but when i put it online, it doesn't work anymore. in my class connection.vb that i use for my connection to my database i get the following ...
0
votes
1answer
48 views
sqlite connection closes automatically after being unactive for few minutes
I have a strange problem with vb.net and sqlite. In my application, if I leave the connection open and dont use my application, for few minutes, it takes long to read or write the database. What could ...
0
votes
1answer
159 views
Odbc Error The specified DSN contains an architecture mismatch?
I have a 64bit Progress OpenEdge 10.2A driver installed. The connection works fine when I set it up in the Data Sources (ODBC) administrator and test it.
When I try to connect to it using VB.NET ...
0
votes
1answer
386 views
Setting the database connection when using a TransactionScope
Does the database connection have to be set inside a TransactionScope?
Or can I set it in the ctor and then have instance methods create up a TransactionScope?
EDIT: e.g.
Public Sub New()
Dim ...
0
votes
0answers
172 views
Checking whether MySQL connection is still alive in VB.NET
Currently, when my computer becomes disconnected from the internet, my program doesn't recognize that it has lost connection with the database. This is to be expected, of course, because VB doesn't ...
0
votes
0answers
59 views
What's the point in adding pooling=true in connectionstring?
This is my current connection string in vb.net
Persist security info=true;Server=******;Character Set=utf8;User ID=admin;Password=*****;Database=******;Max Pool Size=3000;Pooling=true;
I checked ...
