I am developing a program to manage inventory and accounts. different clients need different databases like oracle/sqlserver/mysql etc. i want to make my solution work with all these database servers by only changing one string value . i want to declare like :
[Code]...
I can connect to VPN and I can access Sql Server using RDP. Now, I want to access the Sql Server programmatically.
I connected to the VPN and then have the following connection string set up[code]...
how to establish a connection in vb.net using sqlserver
View 3 RepliesI am currently playing around with VB.Net using Visual Studio 2010 (.Net 4.0) and I need your help to create a collection class (let's call it 'cl_MyCollection') with a constructor that accepts two arguments:An SqlDataReader object Some means of pointing to a custom class I have created.I have five database tables in SQL 2000 and five VB.Net custom classes.Each custom class contains a variable for each field of the table the class represents.For example:"tbl_User" has 2 fields "User_ID" and "User_Name" and tbl_Family" has 3 fields "Family_ID", "Family_Name" and "Family_ Location". [code] Fixed typo, the select case now points to the second argument ('selectedClass') as originally intended.
View 2 RepliesI need more then 1 (MS-SQL) connection string/configuration, depending on the current running configuration (Development, Production, offline etc.)How could I declare these connection strings in advance (Proj.Settings) and tell the application which one to use without the need to compile the program.Using a command-line argument is an option but still unconvenient.I know .NET/ASP has an 'outside' non-comipied config file used by the application which you can modify.
View 3 RepliesI have put my tns connection into the .ora file and am now able to conenct to it using SQL plus and can ping it :tnsping myConn.I've also added the connection to the ODBC Manager and connecting successfully when tetsing conneciton through the ODBC tool.now i'm having an issue making a connection to it using vb.net..[code]
View 3 RepliesI am seeing a strange intermittent connection failure. My application works just fine and then starts throwing connection failure exceptions. A reset of IIS is required before the app will start working again.I've been able to trace a few of the failures back to an unexpected restart of the oracle cluster but not all of them. Has anyone else seen this problem? I've searched the web but haven't found anything.
Client - Win2003 server, IIS running ASP.net 2.0.50727, code is VB.NET, ODBC connection via Oracle Client 10.2.0.1.0 Server - Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production on a Linux cluster.
[Code]...
i am trying to connect to it via VB.net 2010. I have been trying the following:
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim dr As OleDbDataReader
[Code]....
And i get the error on the Catch ee As Exception line: ORA-12560: TNS:protocol adapter error
I also have a tnsnames.ora file on my computer but i am unsure if i need to use that when connecting (or really, how too in the first place)? Is it needed for the code above?
I am trying to use a DNS-Less connection to the DB. Not sure if that is what it is doing in this or not?
Anyone know where I might be able to find code examples for connecting to an existing Oracle DB? I need to connect to my company's oracle db so I can write strings to it, verify strings, and read from it. I've found bits and pieces of code here and there, but nothing for all of it. I am a novice programmer and I am trying to add a db connection to an existing project for our plant to access the data. Our IT dept. is helping me with the db end.
View 2 RepliesI have a vb.net program that is failing, but giving no errors. I've just discovered that the code I am using is deprecated. But what is the replacment? (That seems like something useful for MSDN to list, but I'm sure not seeing it.)
Private Sub SetConnectionToDB(ByRef oCMD As OracleCommand)
Dim connectionString As String
connectionString = My.Settings.ImportDataConnectionString
[code]....
In my program I got multiple spots where I open a Connection to an Oracle database, read some lines via a stored procedure which returns me a cursor, put them in an IDataReader, close the connection and go on.
Now everything works fine till the point of closing the connection. I've watched the connections opened to the database via TOAD for Oracle and I figured out, that the database seems to keep an connection opened after I said m_Connection.Close and m_Connection.Dispose.
I use Oracle.DataAccess and get an error after a short time, that there are to many connections. I debuged my session and made sure, that vb performs the close() command and it does it, but the database not.
I've been viewing the tutorial at [URL]...08-088541.html but I'm still having issues creating my connection to our Oracle database. Here's my code, which uses the same connection string as one of my VB6 programs (no password required for database--Oracle picks up windows name) :
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Create connection object
Dim OraDB As String = "Data Source=databaseneme;Persist Security Info=False"
Dim conn As New OracleConnection(OraDB)
conn.ConnectionString = OraDB
conn.Open()
Me.Show()
End Sub
I've been using .NET for all of 10 mins so the error may be painfully obvious!
I'm trying to develop a simple app with vb.net in VS 2010 that could monitor the ODBC connections via DSN made on the macnhine running this app.My scenario is an application (non Vb) running on a workstation that connects to an MS Access database on a network share.
The application (non Vb) connects using a link (ODBC connection via Oracle 10G) to the tables on the Oracle side.My VB.net Application should monitor the machine running the main application for ODBC connections drops and alert me via email for example.My question is where in the framework can I find something to instantiate or reference in order to check ODBC connections states constantly as well as network disconnection issues as well so I can log and /or alert when possible for network problems and ODBC connection problems for all the applications that might run on the host (machine running my vb app).
I'm connecting succesfully to an Oracle 10g DB with an the Microsoft ODBC for Oracle driver.Regular queries without parameters work fine, but parameterized queries act as if the parameters aren't getting passed in.ex.
--this works fine
Select * from tbl1 where column1 = 'test'
--this doesn't
select * from tbl1 where column1 = ?
--odbc string parameter 'test'
Here's what my connection string looks like:
"Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
[code]....
I'm starting using a project for smart device in windows CE 5. I'm using visual basic of v. studio 2008.I need to create a dynamic connection between a PDA (codebar lector) and an server with ORACLE 9i. The PDA connected via WIFI. But in my vb project I don't find OLEDB or ODBC elements.
View 2 RepliesI am trying to open an Oracle database connection in vb.net 2008 in order to issue a Select statement and the populate a listbox with it.
My code is as follows:
Dim orclstr As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=10.0.0.77;" & _
"User ID=myuser;" & _
[code]....
Obviously, I am doing something wrong, but I can't figure out what.
I have the below mentioned code in a seperate class file for establishing connection and carry out DB transactions. I have an issue where multiple connections being opened which sometime exceed the connection pool. When I stepped through the code I found that there are codes which call ConnectDB() in a loop without calling DisconnectDB(). But I expected that the condition OraConn.State = ConnectionState.Closed should handle the situation. Somehow the condition is always satisfied hence openning another set of connection. Can you suggest where am I going wrong and also what best practice can be adopted here?
[Code]...
The connection is again opened in function updData(). While I understand that it has to be closed correctly but keeping tab on every developer is not possible. Hence I want to control it directly from the connection class by using the same connection but the condition If OraConn.State = ConnectionState.
UPDATE I have put the code in UpdateDB under a Using block and removed call to ConnectDB and DisconnectDB from function like InsertData(...). It seems that the issue has been resolved. But I would like to know in case of exception will the connection remain open? and also OraConn is a public variable defined outside Using block so will it be disposed of by the GC?
[Code]...
Anyone knows how to export to .csv programmatically? Im using visual studio 2008 and MySQL 5.0 Database
View 6 RepliesI am working in visual studio with a datagridview that is bound to a mysql database via the .net mysql connector. In my vb app I have some text fields that provide the necessary fields for building the connection string which I have defined as:
[Code]...
It will apparently allow me to enable/disable my network connection programatically.I'm not sure how I should call it?I've tried several things such as:Network.SetConnectionState("Network Connections", "Local Area Connection 2", "1", "0", True)[code]
View 3 RepliesI want to create a dataset.xsd in vs2005, and I am using access database, so I cant know where my client save the application. Hence I used application.startuppath() to get the application folder and appended "Datadb.msd" to the application.startuppath() so i got the target location for the access databse in client machine. Now to create crystal reports I need the dataset.xsd but while creating a new dataset.xsd it was asking the path for the access database, how to programmatically specify the connection string in dataset.xsd so that i can create a connection string. and use that dataset for creating crystal reports.
View 2 RepliesI have few crystal 10 reports with default to a server & database during crystal design time (server=SRV1, DB=Pub1). And, i calling these report from VB. net application with a config.ini define my server & DB . Recently,i hv clone the same reports but extract from different server & Database name (Server=Srv2,DB=Pub2, the tables & fields are still same ) i have created a config.ini which contain my server, database, uid & pwd. And, when i execute these cloned report , they still point back to the origin server which was server=SRV1, DB=Pub1.
My coding :-
Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
[Code].....
I'm making a winforms app in vb.net that connects to a mysql database on my webserver to read and write data, this all works fine.But i have to allow the users ip to remote connect to the database.Is it possible to give everyone access to the database? The user account will not have all rights an the data isn't very important if it got lost.The user account and connection details are hard coded.
View 3 RepliesHow to connect using MySQL connection?
View 1 RepliesPrivate Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim MyConnection As New OdbcConnection("Driver={MySQL ODBC 5.1
[code]....
I was wondering is it possible to use C#/++ and php to connect to a mysql database? I ask because seems my host doesnt have remote access setup for me to access my database.
View 1 RepliesI'm being able to connect to mysql database in localhost. But not able to connect in my server?
View 1 RepliesI'm trying to connect to a database but it doesn't work...
Code:
Dim conn As MysqlConnection
conn = New Mysqlconnection()
conn.ConnectionString = "server=http://www.*****.net/phpMyAdmin; user id=*****; password=****; database=login"
[Code]...
I created a mysql database and I want to connect to it through VB.Net 2008 using MySQL Connector Net. For this I made 3 forms, 1 form - login form, 2 - as ADMIN, 3 - from USER, the database each user has a role defined by regimes (admin / user). The problem is the following - after entering the username and password will not open one of the forms 2 or 3 but the application closes without any error.The code is:
vb.net
Imports MySql.Data.MySqlClient Public Class Form1 Const AppName = "MySql" Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[code].....
so ive drank goats blood, sacrificed a virgin to the gods and more and im still not any closer to connection to a DB in vb.net (something that takes about 2-3 lines on code in a sensible language)....
Imports System
Imports System.Data
Imports MySql.Data.MySqlClient
[code].....