473,770 Members | 1,994 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

oracle db connection with VB 2005 express BETA 2

Hello, I want make a database connection to an Oracle db (8i) with
Visual Basic 2005 express BETA 2. I already installed Oracle Data
Provider for .NET
(http://www.oracle.com/technology/tec...net/index.html) And
..NET Managed Provider for Oracle
(http://www.microsoft.com/downloads/d...d=4F55D429-17D...)
I still can't configure the oracle connection. The "add new data
source" button does not mention a ODBC or Oracle datasource. Or isn't
there any oracle connection possible in the vb'05 express version? (and
should I use visual studio 2003?)

Thanks in advance.

Nov 21 '05 #1
1 4374
Hi,

With both .NET providers the basic connect string is:

"DataSource=MyS erver;User ID=scott;Passwo rd=tiger"

Each provider has other specific attributes. You can use the ADO.NET
Connection String Assistant of my add-in (below). Even the demo version will
allow you to see the connect string attributes.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

"henk" <ri*******@hotm ail.com> escribió en el mensaje
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .
Hello, I want make a database connection to an Oracle db (8i) with
Visual Basic 2005 express BETA 2. I already installed Oracle Data
Provider for .NET
(http://www.oracle.com/technology/tec...net/index.html) And
.NET Managed Provider for Oracle
(http://www.microsoft.com/downloads/d...d=4F55D429-17D...)
I still can't configure the oracle connection. The "add new data
source" button does not mention a ODBC or Oracle datasource. Or isn't
there any oracle connection possible in the vb'05 express version? (and
should I use visual studio 2003?)

Thanks in advance.

Nov 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

48
3734
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL SERVER 2000 after playing around with SQL Server 2005...
28
3406
by: prunoki | last post by:
Hello, I am an SQL server newbie. Our company has a massive application written in PL/SQL. I need to port parts of it to SQL Server. - Which SQL server version should I choose, to have a reasonable chance of porting? - Could you recommend any best practices, tools? I use Toad for SQL development on Oracle, I am looking for something similar for SQL
3
1331
by: Mike P | last post by:
I've been using Visual Studio 2005 Beta 1 for the last few weeks, and I now want to try using SQL Server 2005 Beta with it. I've been to the Microsoft URL http://lab.msdn.microsoft.com/express/sql/ which allows you to download a product called SQL Server Express (April CTP). It also specifies that you must uninstall all Express software and the .NET framework 2.0 from your machine before downloading. Does this mean uninstalling the VS...
10
1981
by: Bonj | last post by:
Hi I installed .NET 2005 express edition, and am about to unnistall it again because it can't seem to be able to even insert a resource file into a project. Can anyone tell me is this right? Should it be able to? I know it's express edition, and therefore limited functionality, but surely resources are quite fundamental? Also, once it's downloaded, is there any way of getting access to the fully downloaded file incase you want to...
1
2962
by: Bob | last post by:
Trying to use VBisual web developer express 2005 beta 2. Dragged an accessdatasource to the blank web page. Started to configure. Entered location of an access database. On next page, clicked on Query builder. Got error with "Microsoft Visual Studio" in the title - I am using VWD express 2005 beta 2 although I also have Visual Studio 2003 installed. the text of the error is: Retrieving the com class factory for component w/ clsid...
6
2559
by: Brian Henry | last post by:
Visual Basic 2005 Express: http://download.microsoft.com/download/f/c/7/fc7debaf-4513-4300-9e6a-8fe27be88cd1/vbsetup.exe Visual C# 2005 Express: http://download.microsoft.com/download/2/d/2/2d221839-eaf9-4d91-899e-95a9af12202e/vcssetup.exe Visual C++ 2005 Express: http://download.microsoft.com/download/3/f/3/3f3e65c3-9f57-40ee-a95b-57d49e560883/vcsetup.exe Visual J# 2005 Express:
2
1575
by: vbmark | last post by:
I get the following message box: Visual Basic 2005 Express Edition Beta 2- ENU Setup =================================================== Setup has detected that previous versions of the following product(s) are currently installed. Uninstall these applications before continuing with Setup. For more information, see the readme.htm file. This file can be
8
14376
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
3
3186
by: pine | last post by:
hi! i just joined this group today after a colleague told me about it. anyway, i'm new to SQL and haven't tried installing any version of it. I do have vb 6.0 though on my pc. My problem is that I can't install SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the installer from the Microsoft site as well as the dotnetfix which is supposed to install the .net framework 2.0. whenever i try to install SQL server EE, it is...
0
9618
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10259
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10101
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9906
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7456
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2849
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.