odbc - Visual Basic .NET

I would like to connect to a third part database. I know the datasourcename
and even know the location of the dll that can serve the database, .

what is the best way for an vb.net ( 2005 express wit .net2) application to
access that odbc DB.

Oct 14 '06 #1

Subscribe Reply

1112

Spam Catcher

"GS" <gs**********************@msnews.Nomail.comwrote in
news:#A**************@TK2MSFTNGP02.phx.gbl:

I would like to connect to a third part database. I know the
datasourcename and even know the location of the dll that can serve
the database, .

what is the best way for an vb.net ( 2005 express wit .net2)
application to access that odbc DB.

Does the database support ODBC?

If it does - use the .NET ODBC provider (System.Data.ODBC).

Oct 14 '06 #2

rowe_newsgroups

I know you said you already knew your DSN, but this sight might help
others who browse this thread:

www.connectionstrings.com

Thanks,

Seth Rowe
Spam Catcher wrote:

"GS" <gs**********************@msnews.Nomail.comwrote in
news:#A**************@TK2MSFTNGP02.phx.gbl:

I would like to connect to a third part database. I know the
datasourcename and even know the location of the dll that can serve
the database, .

what is the best way for an vb.net ( 2005 express wit .net2)
application to access that odbc DB.

Does the database support ODBC?

If it does - use the .NET ODBC provider (System.Data.ODBC).

Oct 14 '06 #3

thank you all very much
"GS" <gs**********************@msnews.Nomail.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

I would like to connect to a third part database. I know the

datasourcename

and even know the location of the dll that can serve the database, .

what is the best way for an vb.net ( 2005 express wit .net2) application

access that odbc DB.

Oct 14 '06 #4

Cor Ligthert [MVP]

GS,

Try to avoid ODBC it is in my opinion from the previous century, therefore
use the link as Seth (rowe) gave you and use if possible a special provider
and otherwise OleDb, I write this because I am less hesitating.

http://www.connectionstrings.com/

Cor
"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...

>I would like to connect to a third part database. I know the datasourcename
and even know the location of the dll that can serve the database, .

what is the best way for an vb.net ( 2005 express wit .net2) application
to
access that odbc DB.

Oct 14 '06 #5

Thank you, Cor.

I guess that I will use OleDbDataAdapter, OleDbConnnection...along with
binding navigator etc. In a quick glance on the built-in help, it does
support procedure call- that is great.

It is also rich in functionalities and features; so rich it is a tad
overwhelming.

I guess I just have to search some more.

I have just learned enough on the sql express side for updating simple small
table with navigator ....

Any hint on linking multiple datagridview for related tables
(master-details...) with user specified criteria?

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:ut**************@TK2MSFTNGP02.phx.gbl...

GS,

Try to avoid ODBC it is in my opinion from the previous century, therefore
use the link as Seth (rowe) gave you and use if possible a special

provider

and otherwise OleDb, I write this because I am less hesitating.

http://www.connectionstrings.com/

Cor
"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...
I would like to connect to a third part database. I know the

datasourcename

and even know the location of the dll that can serve the database, .

what is the best way for an vb.net ( 2005 express wit .net2) application
to
access that odbc DB.

Oct 14 '06 #6

Cor Ligthert [MVP]

Just do it, it is easy,

:-)

Cor

"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...

Thank you, Cor.

I guess that I will use OleDbDataAdapter, OleDbConnnection...along with
binding navigator etc. In a quick glance on the built-in help, it does
support procedure call- that is great.

It is also rich in functionalities and features; so rich it is a tad
overwhelming.

I guess I just have to search some more.

I have just learned enough on the sql express side for updating simple
small
table with navigator ....

Any hint on linking multiple datagridview for related tables
(master-details...) with user specified criteria?

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:ut**************@TK2MSFTNGP02.phx.gbl...
>GS,

Try to avoid ODBC it is in my opinion from the previous century,
therefore
use the link as Seth (rowe) gave you and use if possible a special
provider
>and otherwise OleDb, I write this because I am less hesitating.

http://www.connectionstrings.com/

Cor
"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...
>I would like to connect to a third part database. I know the

datasourcename

and even know the location of the dll that can serve the database, .

what is the best way for an vb.net ( 2005 express wit .net2)
application
to
access that odbc DB.

Oct 14 '06 #7

Similar topics

2228

py2exe, mx.ODBC

by: Marco Aschwanden | last post by:

Hi - Win2000 - Python 2.3.3 - py2exe 0.5.0 - eGenix Comercial & Base Package I am developing an app using mxODBC. On the home page they say http://www.egenix.com/files/python/mxODBC.html#Hints

Python

3734

annoying delay during refresh of aspx web page with ODBC Access query on IIS Windows 2003

by: Wolfgang Kaml | last post by:

Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET...

ASP / Active Server Pages

6750

Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000

by: Andreas Lauffer | last post by:

I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:

Microsoft SQL Server

5636

DataDirect Server Wire vs. MS ODBC

by: Andreas Lauffer | last post by:

Can anyone tell me advantages / disadvantages of DataDirect Server Wire ODBC-driver? Any experiences? What about redistribution? Andreas Lauffer, easySoft. GmbH, Germany

Microsoft Access / VBA

12008

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr

by: bazzer | last post by:

hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in '/CinemaBookingSystem' Application. -------------------------------------------------------------------------------- ERROR General error Unable to open registry...

ASP.NET

7270

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

General

7128

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7543

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

5704

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5103

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

4759

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3242

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

817

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

473

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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

General