 |  |  |  |  |  |  |  |
conencting to SQL database via VB.net
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
Hi I'm a final year university student and i'm running into a bit of trouble with my final year project (It's very important)
My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database.
I really don't know where to start so I was wondering if anyone could give me a link or a reference of code as to how to connect to the database. My sql itself is pretty good so the commands themselves shouldn't be too difficult but it's the actual conncetion that is the problem as I have no idea where to begin.
Oh and could you please offer clear instructions as I don't want to simply cut and paste code into my work I'd rather have an understanding of how I've done what I've done.
Thanks in advance for any help.
My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database.
I really don't know where to start so I was wondering if anyone could give me a link or a reference of code as to how to connect to the database. My sql itself is pretty good so the commands themselves shouldn't be too difficult but it's the actual conncetion that is the problem as I have no idea where to begin.
Oh and could you please offer clear instructions as I don't want to simply cut and paste code into my work I'd rather have an understanding of how I've done what I've done.
Thanks in advance for any help.
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation: 
Solved Threads: 256
To manage management tasks you can use SMO namespace
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation:
Solved Threads: 256
That's just for SQL Server not Oracle you can go to Oracle forum http://www.daniweb.com/forums/forum129.html to ask there
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
hmm...you want to connect with sqlserver or oracle???
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
sorry i wish to connect to an oracle database as I am actually modifying oracle users not the actual databases involved within it.
I am using the .net framework for oracle to access it and have the connectiong strings etc etc
but for some reason I can't declare the connection and things like I would with OLE DB. can anyone help?
I am using the .net framework for oracle to access it and have the connectiong strings etc etc
but for some reason I can't declare the connection and things like I would with OLE DB. can anyone help?
I hope this helps:
The Microsoft provider ships with the .NET Framework 1.1. All types are contained in the System.Data.OracleClient namespace. The Microsoft provider requires Oracle client version 8.1.7 or above.
ODP.NET is freely available from the Oracle Technology Network (OTN) at http://www.oracle.com/technology/sof...net/index.html. The types are contained in two namespaces—Oracle.DataAccess.Client (data access classes and enumerations) and Oracle.DataAccess.Types (classes and structures for Oracle data types). Both namespaces are in the assembly Oracle.DataAccess.dll located in the oracle\ora92\bin directory. ODP.NET requires Oracle client version 9.2 or later.
Regards
Sunil Punjabi
<snipped URL>
The Microsoft provider ships with the .NET Framework 1.1. All types are contained in the System.Data.OracleClient namespace. The Microsoft provider requires Oracle client version 8.1.7 or above.
ODP.NET is freely available from the Oracle Technology Network (OTN) at http://www.oracle.com/technology/sof...net/index.html. The types are contained in two namespaces—Oracle.DataAccess.Client (data access classes and enumerations) and Oracle.DataAccess.Types (classes and structures for Oracle data types). Both namespaces are in the assembly Oracle.DataAccess.dll located in the oracle\ora92\bin directory. ODP.NET requires Oracle client version 9.2 or later.
Regards
Sunil Punjabi
<snipped URL>
Last edited by Ancient Dragon; May 18th, 2008 at 6:54 am. Reason: snipped url
|
Other Threads in the VB.NET Forum
- Previous Thread: Tray Icon Transparency
- Next Thread: watch certain files within certain folder
| Thread Tools | Search this Thread |
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for VB.NET
.net .net2008 2005 2008 access account application array arrays basic beginner browser button buttons center checkbox client code convert cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic eclipse excel fade filter forms ftp generatetags gridview html images inline input insert intel internet lib listview mobile monitor net objects open panel passingparameters pdf picturebox port position print printing problem read remove save searchvb.net select serial settings shutdown soap sorting sqlserver survey table temperature textbox timer timespan transparency trim update user validation vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winforms wpf wrapingcode year
