Oracle ODBC Connection Monitoring?
Apr 8, 2011
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).
View 3 Replies
ADVERTISEMENT
May 1, 2009
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]....
View 3 Replies
Jul 9, 2011
I use Microsoft ODBC For Oracle, and process a distributed transaction with ransactionScope, but, the code throws a error: ERROR [HYC00][ORACLE][ODBC]option not implement, my code is in vb.net.ere is my code:
sub Main()
dim strConn1 as string = "Driver={Microsoft ODBC for Oracle};Server=server1;UID=user1;PWD=pwd1;"
[code].....
View 2 Replies
Nov 21, 2010
I do need to connect oracle database via odbc in my vs 2005 project. I have no idea how to connect, kindly give me connection string codes and prerequisites.
View 7 Replies
Oct 21, 2010
I'm converting some RDO code to ODBC Provider code in .NET.The problem is parameter names were not specified in the orignal code, but param values were retrieved by parameter name after the command was executed.Is there anyway to have parameter names populated by the provider once the command is executed so calling code can access params by name.Let me show you an example of the declaration of param and accessing of it.
[Code]...
You can now see how this "used to work in RDO/VB". For some reason it would accept this and know what the param names were after execution. I imagine it had to do another round trip to the db to get this info.
Is there anyway to mimic this behaviour in .NET for ODBC Provider (using Oracle)? Or am I stuck manually specifying the param names in the code (I understand this is the better option, but wondering what the alternative is to match the original code as closely as possible).
View 1 Replies
Nov 9, 2009
i want to ask what is the difference between oledb connection and odbc connection. I have a case, my office used ncomputing then i have to developed an application using sqlserver 2000 and vb.net 2005, i used oledb connection. When i try to implement it in ncomputing, why user must has admin access level and dbo level in sql server, it seems trouble when all users are admin. But there's a rumor that when using odbc connection, we dont need to give admin access level for users.es.
View 1 Replies
Jan 5, 2012
i have 2003 access database. why i cannnot connect to my database using the code below?
red
Public BioCon As New Odbc.OdbcConnection
Public GAdp As Odbc.OdbcDataAdapter
red
Public Function Execute(ByVal Qry As String, ByVal Con As Odbc.OdbcConnection) As Boolean
[Code]...
View 22 Replies
Jan 14, 2011
I'm trying to connect to a database and keep the connection open for any amount of user activity/queries within the database. Currently I have a connection that opens and closes for any query (save, update, etc...) which requires the logon process to the back-end every time the user saves etc... Is there a way to simply connect and leave the connection open so there won't be a lag time when running the query due to the logon process? This is what I'm using:
Private sConStrFormat As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security Info=True;User ID={0};Password={1};Default Database=bcpm_ddbo;Session Mode=ANSI;"
[Code].....
View 2 Replies
Sep 8, 2009
I am trying to coonect to Oracle 10g database through ASP using ODBC connection. The connection string used is con.Open "DRIVER={Microsoft ODBC for Oracle};SERVER=xxxx;UID=xxxxx;PWD=xxxxx".
This works when I tried creating a macro and also using a vbs script. When run through classic ASP it gives error on the connection.open line.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'. [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-12154 /TestSC/a.asp, line 23
The connection is opened when using Ora oledb con.Open "Provider=OraOLEDB.ORACLE;Data Source=xxxx;User Id=xxxx;Password=xxxx". I am using IIS 6.0 and Oracle 10g.
View 2 Replies
Sep 8, 2011
I need to update a database table from a dataset and only have access to the database through an odbc connection. Is there anyway to make this work or do I need to go a different direction to do this ?
View 1 Replies
May 14, 2011
I'm trying to insert values from my asp.net application into my MySQL database.
On the register page people can fill in Name and Pass and press submit.
Public Function InsertMember(ByVal objMember As Member) As Boolean
[Code]...
View 2 Replies
Oct 23, 2009
with odbc connection in vb.net example i have add button on my database and i want that what ive added will be added on the database with odbc connection.i know how in oledb but im really confuse with odbc
View 2 Replies
Oct 6, 2009
I have an excel with 10 sheets, each sheet has a connection stored in it because i am using the ms query to read data from access database. when I code the below, both line are accepted by vb.net (with new or without)
Dim wb1 As Excel.Workbook
Dim wb2 As New Excel.Workbook
Now when I code
Dim wb_cnn1 As Excel.ODBCConnection ' Works Fine
Dim wb_cnn2 As new Excel.ODBCConnection ' Error 'New' cannot be used on an interface.
Q1: Why I cannot create New Excel.ODBCConnection? I have this
Dim xlsApp As New Excel.Application
Dim wb_cnn As Excel.ODBCConnection
Dim wb As Excel.Workbook
[code]....
Maybe because it is read only. I want that because the ms query is hardcoding the path of the access db even if i choose DSN so, if I change the location of the access file the query in the excel will not work, Q2: How I can change the connection in the Excel sheet?
View 2 Replies
Aug 10, 2009
I'm trying to create an ODBC in the registry using VB.NET. I had found some code on the internet(link below) to do perform this function in VB6, but have been unable to find a way in VB.NET.
[URL]
View 4 Replies
Dec 12, 2011
I tried to make my ODBC Connection within the class. here's my class code
Public Class Library
Public Function Seek(ByVal Connection As Odbc.OdbcConnection, ByVal TableName As String, ByVal Field As String, ByVal Index As Long)
[Code]....
Here's my error: Unable to cast object of type 'System.Int32' to type 'System.Data.DataSet'. I am using VBdotNet2005
View 2 Replies
Jun 12, 2009
I m making my semester project on hotel room reservation i want to get all records from ms acess in data grid.
View 5 Replies
Jul 10, 2009
this is code where i want to insert ConnectionString=<%$ConnectionString =""%>[code]....
I can not connect MySql (SQL YOG) at all to this control, this is prob from .net control and not MySqlMark the thread as answered
View 2 Replies
Sep 24, 2007
I'm using Visual Studio 2005 Pro. I have an ODBC (not OLEdb) Connection to a spreadsheet. Works fine except the first row is missing. How do I stop this behavior? I can see that for OLEdb there is a way to suppress this behavior using the HDR=No parameter in the connection string. When I try that for the ODBC connection, No change. Row Still Eaten. I also went to the HKLMSoftwareMicrosoftJet4.0EnginesExcel registry key and changed the FirstRowHasNames value to 00. No change. Row Still Eaten.
View 6 Replies
Dec 9, 2009
When connecting to a Sybase ASE database via ODBC using the code below, I'll occasionally get a '[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed' error. this be caused by my code? I read here that I should be using the 'With' statement instead, but I don't understand how that would affect this.
[Code]...
View 1 Replies
Sep 9, 2009
I need code for opening DB connection using an ODBC data source. then I need to get some data from there to a data set.
View 7 Replies
Sep 23, 2011
I'm trying to connect to Transoft U/SQL license using an odbc connection and and odbcDataAdapter. I am using a function to return a dataset into the mainModule.
HTML
dsOMD = getOMDinfo(psSerialNbr)
dtOMD = dsOMD.Tables(0)
The Function code that is being used is as follows:
HTML
Function getOMDinfo(ByVal strSerialNumber As String) As System.Data.DataSet
Dim myconnection1 = New OdbcConnection("DSN=omd.udd;uid=;")
Dim strSQL As String = String.Empty
[code]...
I am getting the following error:
Message: "ERROR [42000] [Transoft][TSODBC][usqlsd]Name expected ([)"
Source: "TSODBCW.DLL"
If I change the code to use a datareader it I can loop through the data but a data reader is not recommended to pass through the layers and so I'm wanting to create a dataset/data table process. Anyone have any ideas why the dataset/dataTable code is not working properly?
View 6 Replies
Mar 30, 2011
I use ODBC connection for my application (controlpanel -> administrativetools -> odbc -> DSN) to sql server 2008, and windows authentication
it works perfect on windows xp,but now I run it on windows7 and sql server 2008 with sql server authentication.when I make the DSN and query the connection its ok and I got this message (TESTS COMPLETED SUCCESSFULLY!)but when I run the application I got this error (ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.) I think a little more and I found that Maybe my password doesn't save for my user, when I make that DSN?
View 4 Replies
Oct 25, 2010
I have a program that connects to an ODBC tables (3 of them) and I use select .... Left join etc Where ... etc. The issue I have is the connection takes about 20 to 25 seconds to complete. I'd like to create some status message so the user knows the system is not actually hung. Using Visual Studio 2010 Ultimate, VB.NET, ADO 2.7.
View 1 Replies
Mar 27, 2012
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]
View 3 Replies
Aug 22, 2011
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.
[Code]...
View 4 Replies
Jan 26, 2011
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?
View 2 Replies
Sep 8, 2010
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 Replies
Apr 27, 2011
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
[code]....
View 1 Replies
Aug 13, 2011
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.
View 1 Replies
Jan 19, 2011
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!
View 18 Replies
