Re: Connecting to database and see any data

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

Article #89

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

#89

From: Matjaz Cof
Date: Sat, 28 Jan 2006 16:14

34 lines
2131 bytes

Hi!
So I add odbc conection and connected to the database. But 
odbcDataAdapter doesn't have an dataset property.
If I use bdpConection I can't connect. I always get MySQL provider 
initialization failes.
I want to use odbcConnection because I must connect to the pervasive. So 
how to fill data with odbcDataAdapter?
Thanks

Bob Swart wrote:
> 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
>

Technical Details

Message-ID: <43db97ab@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <43d75027$1@newsgroups.borland.com> <43D87287.5B636678@chello.nl>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,6955dc25955ba7e6
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sat, 28 Jan 2006 17:14:43 +0100
From: Matjaz Cof <fora@fora.cc>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, 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> <43D87287.5B636678@chello.nl>
In-Reply-To: <43D87287.5B636678@chello.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 193.77.58.111
Message-ID: <43db97ab@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1138464683 193.77.58.111 (28 Jan 2006 08:11:23 -0700)
Lines: 34
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message