Re: Connecting to database and see any data

Article View: borland.public.delphi.database.dotnet

Article #88

Back to borland.public.delphi.database.dotnet Previous Next

#88

From: Bob Swart
Date: Thu, 26 Jan 2006 06:56

22 lines
1768 bytes

Hi Matjaz,

> I install odbc drivers for MySQL. Then i add to the WebForm
> SqlConnection and sucesfully connect to the MySQL. 

SqlConnection only connects to SQL Server. You either need the
OdbcConnection (not installed by default) or the BdpConnection.

> But i cann't see any property of DataSet where to choose source, in my
> case SqlDataAdapter.

It's the BdpDataAdapter that has the DataSet property. You are using the
ADO.NET version SqlDataAdapter (which works with SQL Server, not mySQL).

You need to take a BdpConnection, BdpDataAdapter, etc.

Groetjes,
          Bob Swart

-- 
Bob Swart Training & Consultancy (eBob42.com) Borland Technology Partner
Weblog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml

Technical Details

Message-ID: <43D87287.5B636678@chello.nl>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!news-peer0-test!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <43d75027$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,6955dc25955ba7e6
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
Message-ID: <43D87287.5B636678@chello.nl>
Date: Thu, 26 Jan 2006 07:56:07 +0100
From: Bob Swart <b.swart@chello.nl>
Organization: Bob Swart Training & Consultancy
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.delphi.database.dotnet
Subject: Re: Connecting to database and see any data
References: <43d75027$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.187.74.5
X-Trace: newsgroups.borland.com 1138258407 212.187.74.5 (25 Jan 2006 22:53:27 -0700)
Lines: 22
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!news-peer0-test!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message