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?
I 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]
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand() cmd.Connection = My.Settings.Item("csStaffHoursWorked") cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "spSaveDeltekImport"
I 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.
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.
I 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
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'
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.
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 :
I got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
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?
I understand the possibilities for encrypting a connection string in .net v4. I have a win forms application that will be used by multiple people on different machines. I understand that I need to protect the connection string at time of the app being first run on the target machine. However I am concerned that for a period of time my connection string will be unencrypted. I am looking for advice in how to deploy my app with the connection string already encrypted or encrypted during installation. encrypting the connection string in a secure way?
I'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
I am trying to connect DSN from my VB 2008 project. When i try using myoledb.connectionstring="DSN=myDNSname" I get the following error message An OLEDB provider was not specified in the connectionstring.
I'm using the Oracle command dbms_output.get_line to retrieve output from a stored procedure. Once my code runs the command, I'm retrieving the results through a buffer string, 32000 bytes long.Inevitably, this string will have Oracle line breaks (chr(10) and chr(13)) in it that I'd like to replace with Environment.NewLine so I can display the output in a standard Winforms textbox.Here is the code I've been using - I don't recall exactly where I got the Oracle command right now, but if I find it, I'll add the link.
Dim cmdGetOutput As New OracleCommand("declare " & _ " l_line varchar2(255); " & _ " l_done number; " & _
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
Why doesn't an exception get thrown when this function is called when there is no ConnectionString set for the Connection? I just spent 15 minutes debugging and staring at it and finally figured out it needed the connection string. Shouldn't an exception get thrown?
Friend Function GetValues(ByVal TableName As String, ByVal FieldName As String) As DataTable Dim cn As New SqlConnection Dim cmd As New SqlCommand[code].....
After using the following code, no errors are shown, but my database is not updated once i have made a change using my management system application.
Dim constring As String = Application.StartupPath.ToString() + "mydatabaseName.mdf" Public c As String = "Data Source=.SQLEXPRESS;AttachDbFilename=" + constring + ";Integrated Security=True;User Instance=True" Sub openConnection() conn.ConnectionString = c conn.Open() End Sub
I using SQL Server 2008 R2 to connect with HTML page. I trying to connect HTML page with login to SQL Database. I have try called the Source but didnt work.
I am developing a software which will connect to a SQL SERVER situated at Head Quarters over a VPN connection.But for times when VPN is disconnected I want my applications at the branches to connect to a local Sql Server installed at a local server.Now all the applications at each of the local machines have their connectionstring stored in their App.config file.When the VPN is disconnected we have to change each of the connection strings on all the applications in each machine. Is there a way to do it automatically switch the connection string depending on whether the Server is reachable or not, and to store the connectionstring at centralised location.
