How To Invoke the OLE DB Data Link Properties Dialog Box in Visual Basic Code

David Parker [Visio MVP]

I have used the following article
http://support.microsoft.com/kb/286189/EN-US/
in my vb.net code, but now realise thatthis is intended for pre-.net

So, what is the equivalent in vb.net?

Nov 21 '05 #1

Subscribe Post Reply

2577

stand__sure

"David Parker [Visio MVP]" <da****@bvisual.net> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...

I have used the following article
http://support.microsoft.com/kb/286189/EN-US/
in my vb.net code, but now realise thatthis is intended for pre-.net

So, what is the equivalent in vb.net?

you no longer do it this way. you use ADO.NET -- look at the System.Data
namespace (and avoid using OLE DB directly unless absolutely necessary)

Nov 21 '05 #2

Carlos J. Quintero [.NET MVP]

If you really want to show the OLEDB Data Link Properties dialog, then the
code is the same, but .NET provides a new technology ADO.NET which uses .NET
Data Providers, not OLEDB Providers, and currently there is no way in .NET
to show a dialog to select a .NET Provider, select the data source, etc.

--

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

"David Parker [Visio MVP]" <da****@bvisual.net> escribió en el mensaje
news:%2******************@TK2MSFTNGP15.phx.gbl...

I have used the following article
http://support.microsoft.com/kb/286189/EN-US/
in my vb.net code, but now realise thatthis is intended for pre-.net

So, what is the equivalent in vb.net?

Nov 21 '05 #3

David Parker [Visio MVP]

Thanx Carlos.
I have spent hours lookng for something that does not exist, but is good to
know that I didn't miss the obvious

"Carlos J. Quintero [.NET MVP]" <ca*****@NOSPAMsogecable.com> wrote in
message news:%2****************@TK2MSFTNGP10.phx.gbl...

If you really want to show the OLEDB Data Link Properties dialog, then the
code is the same, but .NET provides a new technology ADO.NET which uses
.NET Data Providers, not OLEDB Providers, and currently there is no way in
.NET to show a dialog to select a .NET Provider, select the data source,
etc.

--

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

"David Parker [Visio MVP]" <da****@bvisual.net> escribió en el mensaje
news:%2******************@TK2MSFTNGP15.phx.gbl...
I have used the following article
http://support.microsoft.com/kb/286189/EN-US/
in my vb.net code, but now realise thatthis is intended for pre-.net

So, what is the equivalent in vb.net?

Nov 21 '05 #4

Similar topics

"Long binary data" in Access db

by: Jerry | last post by:

I have an off-the-shelf app that uses an Access database as its backend. One of the tables contains a field with an "OLE Object" datatype. I'm writing some reports against this database, and I...

Microsoft Access / VBA

Invoke Error

by: Boni | last post by:

Dear all, I am trying to dynamically create the instance (withActivator.CreateInstance) of cManop class This class uses as reference Dep4Man class. But somehow at the invokation time I get a...

C# / C Sharp

Cannot access Excel sheet data from Visual Basic.Net

by: Omar | last post by:

Hi Developers, I am trying to access an Excel data file through a VB.Net application. I have the following code: =================================== VB.Net Code =================== Dim...

Visual Basic .NET

Whidbey: Add New data source does not work.

by: rogsonl | last post by:

My computer was moved last week, and the company changed the network groups we work on. As a result, one of the main benefits from Whidbey (database connectivity) no longer works. Situation: 1....

Visual Basic .NET

How does one connect to local excel file using data wizard is it possible vb.net

by: | last post by:

Greets, How does one connect to a local excel file using data wizard is it possible? I'm trying to connect to an excel file and populate a dataset and combo box with the data from excel TIA

Visual Basic .NET

Frustrated Beginner ! Browse Dialog Box

by: William Foster | last post by:

Good evening all, Microsoft is really starting to annoy me as a new user. I am trying to convert my code from VBA (A very user friendly laguage with generally good help files) to Visual Studio...

Visual Basic .NET

Real time link to data element

by: Leslie Coover | last post by:

http://finance.yahoo.com/ offers a wide range of financial data. Would anyone have (or know where I can get) a sample of code that

Javascript

how to connect opr link frontapge to vb 6.0?

by: czi02 | last post by:

Hi there;;; How to link with frontapge to vb 6.0?? Does anyone how to link the frotnpage to visual basic??? Wha properties shall im gonna going to choose and waht is its code??? For example...

Visual Basic 4 / 5 / 6

How Open Database to search for a table using vba to display its data properties.

by: sunnyluthra1 | last post by:

Hi Everyone, I am working on a piece of code, that displays the properties(Name, Datatype, size & Description) of the table in the database. Now I want to further Enhance the code. I Have created...

Microsoft Access / VBA

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing