Board index » cppbuilder » BCB 6 and SQL Server connectivity

BCB 6 and SQL Server connectivity


2005-03-08 07:25:20 AM
cppbuilder87
I have a new project that is huge and I need to get it done very fast!
So I was thinking of using BCB6, but I need to know if BCB6 and SQL Server
work well together?
And if so, what type of connectivity is available, ie. ADO, OLEDB, ODBC,
DBLibrary, etc..?
Thanks
 
 

Re:BCB 6 and SQL Server connectivity

"Relaxin" < XXXX@XXXXX.COM >wrote in message news:<422ce301$ XXXX@XXXXX.COM >...
Quote
I have a new project that is huge and I need to get it done very fast!

So I was thinking of using BCB6, but I need to know if BCB6 and SQL Server
work well together?

And if so, what type of connectivity is available, ie. ADO, OLEDB, ODBC,
DBLibrary, etc..?


Thanks
Hi,
BCB6 ans SQL Server 2000 work very well together.
We used ADO connectivity in heavy industrials applications.
 

Re:BCB 6 and SQL Server connectivity

I would use the ado tab. Seems to offer best performance etc. Otherwise out
of the box you have BDE (ug) ODBC (slowing down). If you want to use
dbexpress you will (i beleive) pay for a 3rd party driver for MSSQL.
Hope this helps.
"Relaxin" < XXXX@XXXXX.COM >wrote in message
Quote
I have a new project that is huge and I need to get it done very fast!

So I was thinking of using BCB6, but I need to know if BCB6 and SQL Server
work well together?

And if so, what type of connectivity is available, ie. ADO, OLEDB, ODBC,
DBLibrary, etc..?


Thanks

 

{smallsort}

Re:BCB 6 and SQL Server connectivity

Relaxin wrote:
Quote
I have a new project that is huge and I need to get it done very
fast!

So I was thinking of using BCB6, but I need to know if BCB6 and
SQL Server work well together?

And if so, what type of connectivity is available, ie. ADO,
OLEDB, ODBC, DBLibrary, etc..?
The BDE support in BCB6 is limited to 6.5 and earlier, IIRC.
Microsoft pulled back the TDS specs, so don't expect to use BDE &
SQLLinks for current SQL Server versions.
I've done very well with ADO. The components are an early version
of ADO, but if all you're really after is TQuery/TStoredProc type
commands, they work and they're reasonably fast. ADO is,
essentially, OleDB.
There are third party libraries out there to try to squeeze every
last cycle you can, but I haven't found the performance to be worth
the cost.
-Brion
 

Re:BCB 6 and SQL Server connectivity

Brion L. Webster wrote:
Quote
Microsoft pulled back the TDS specs, so don't expect to use BDE &
SQLLinks for current SQL Server versions.
Pulled back? What do you mean? They've never released them publicly, or
to Borland.
--
John Kaster blogs.borland.com/johnk
Features and bugs: qc.borland.com
Get source: cc.borland.com
If it's not here, it's not happening: ec.borland.com
 

Re:BCB 6 and SQL Server connectivity

John Kaster (Borland) wrote:
Quote
Brion L. Webster wrote:

>Microsoft pulled back the TDS specs, so don't expect to use BDE
>& SQLLinks for current SQL Server versions.

Pulled back? What do you mean? They've never released them
publicly, or to Borland.
Even worse.
All I recall for sure was MS said "don't use TDS, use ADO" for SQL
Server.
Sorry for the misinformation.
-Brion
 

Re:BCB 6 and SQL Server connectivity

Brion L. Webster wrote:
Quote
Sorry for the misinformation.
No worries. Just was confused by the sentence.
--
John Kaster blogs.borland.com/johnk
Features and bugs: qc.borland.com
Get source: cc.borland.com
If it's not here, it's not happening: ec.borland.com
 

Re:BCB 6 and SQL Server connectivity

John Kaster (Borland) wrote:
Quote
Brion L. Webster wrote:

>Sorry for the misinformation.

No worries. Just was confused by the sentence.
Might be I should wait longer to post after getting out of the
hospital - but cruising the newsgroups is easier than some other
things I could be catching up on, and I can't seem to make myself
shut up <g>.
-Brion
 

Re:BCB 6 and SQL Server connectivity

Brion L. Webster wrote:
Quote
Might be I should wait longer to post after getting out of the
hospital
I hope it wasn't anything serious, and glad you've recovered enough to
be back on the newsgroups. Perhaps a full recovery would mean you
WOULDN'T be back on the newsgroups ;)
--
John Kaster blogs.borland.com/johnk
Features and bugs: qc.borland.com
Get source: cc.borland.com
If it's not here, it's not happening: ec.borland.com
 

Re:BCB 6 and SQL Server connectivity

John Kaster (Borland) wrote:
Quote
Brion L. Webster wrote:

>Might be I should wait longer to post after getting out of the
>hospital

I hope it wasn't anything serious, and glad you've recovered
enough to be back on the newsgroups. Perhaps a full recovery
would mean you WOULDN'T be back on the newsgroups ;)
A week stay, courtesy of meningitis, with every single test coming
back negative. They don't know what caused it. The energy level
is not coming back as fast as I'd like, and I get sporadic
headaches even now. Last night I was waking up from the pain about
every three minutes from 01:00 on. Still not as bad as the trigger
headache, though.
-Brion
 

Re:BCB 6 and SQL Server connectivity

Brion L. Webster wrote:
Quote

A week stay, courtesy of meningitis, with every single test coming
back negative. They don't know what caused it. The energy level
is not coming back as fast as I'd like, and I get sporadic
headaches even now. Last night I was waking up from the pain about
every three minutes from 01:00 on. Still not as bad as the trigger
headache, though.

-Brion
Brion,
I'm not sure what you're talking about in relation to the trigger
headache, but let me add a minor item (or not so minor) here.
I darn near died in November due to severe complications from surgery --
what should have been a 90 minute outpatient operation ended up with me
spending 5 days in the hospital, on a respirator. However, because of
the results, even knowing what happened, I'd do it again.
Here's what I'm talking about -- make sure you're getting sufficient air
through your nose, especially when sleeping. I'm not joking, I'm dead
serious.
I've suffered from major migraines for decades. Averaging one every
week or so, some so major they were incapacitating. I haven't had a
single one since the surgery. What did they do? It turns out that I
couldn't breath properly through my nose. So, especially when sleeping,
I wasn't getting enough air. The went in and removed bone and fixed a
deviated sceptum, and for the first time in my life I can actually
breathe normally. Except that up until now I thought I WAS breathing
normally (after all, it was 'normal' for me).
If you've having some kind of major headache and can't trace the cause,
I would strongly suggest you visit an ENT guy, and see if you have some
kind of sinus blockage.
David Erbas-White
 

Re:BCB 6 and SQL Server connectivity

David Erbas-White wrote:
Quote
I'm not sure what you're talking about in relation to the trigger
headache, but let me add a minor item (or not so minor) here.
I've suffered chronic headaches since a playground accident in
second grade. They're very close to migraines in symptoms, but the
doctor I tried tracking it down with, oh, about 1992, said they're
actually tension headaches. Counseling and stress management were
his recommendations.
I've been thinking about trying again, since it's been over a
decade. Vicodin works wonders when I get these kind of headaches,
but of course that's a controlled substance, and I don't want to
get {*word*60}ed. I do notice they get worse when I'm under stress,
but I'm just not a self-analysis kind of person.
I don't snore (when I'm on my side, and my wife doesn't let me
sleep on my back long <g>), I've never had anyone catch me in sleep
apnea, so I don't think that's my issue.
I'm thinking today (last night's?) headache is just one of my
normal recurring headaches, just worse than normal. Monday the
28th I experienced the worst headache of my life, which developed
into numbness, tingling, something suspiciously like Bell's palsy,
and aphasia. Turned out to be meningitis. I copied an email
below.
-Brion
Some of you might have wondered where I was last week. The short
answer? In the hospital, recovering from viral meningitis. I've
been assured I'm not contagious, and unfortunately none of the
tests indicated what caused anything. For those who are
interested, I wrote about what happened below. If I was supposed
to get something done for you, please give me a few days to get
back on track (and if I still haven't taken care of it, please
remind me!).
Thanks,
-Brion
Monday (Feb 28th), I was running an errand for my mother in law
after work, when I got a splitting headache. The headache went
away pretty quickly, then my right leg started tingling. By the
time I left the store, my midsection was tingling. As I was
driving to her house, I developed blind spots. When I got to her
house, my neck was tingling, and she wanted to call an ambulance.
I wanted to go to the urgent care at Northwest Med Center. Lori
arrived, decided to take me to the hospital, but first she went and
got our son. She brought him back to my mother-in-law's. I was
fairly incoherent - I couldn't make complete sentences (I could put
words in there, but not words that made sense). So Lori called the
ambulance.
They took me off to Saint Agnes. Turns out I had viral meningitis.
In a way, it was the best way I could get into the hospital. While
they were ruling out bacterial meningitis (very contagious), I was
in isolation, in a room by myself. When I was freed from
isolation, they didn't have another bed to put in the room. So
until Thursday afternoon, I had the room to myself. The specialist
said I could go home at 4:00 on Thursday, but the doctor who had to
co-sign didn't show up until nine o'clock that evening.
Apparently, everything from Advil to West Nile Virus can trigger a
meningitis attack. However, every single test they did or sent out
for came back negative. I had both a CAT scan and an MRI, ump{*word*249}
{*word*76} tests, a nuclear "thingy" at Valley Children's, and the
County did the West Nile test. We still don't have a reason why it
happened.
I'm on track to make a full recovery. My back is sore where I had
a spinal tap (lumbar puncture). Thankfully I don't remember
getting it, Lori says I was cursing at the doctors. One of my
three IV sites is sore, I probably pulled it loose while I was
hooked up and injured myself. I still tire ridiculously easily,
but the doctor says that's to be expected for a few more days yet.
Now every weird feeling and headache makes me nervous, and Lori's
pestering me asking if I'm OK all the time. Hopefully it'll all be
over by this weekend.
-Brion
 

Re:BCB 6 and SQL Server connectivity

Brion L. Webster wrote:
I wish you the best in your recovery. I know how debilitating headaches
like that can be.
David Erbas-White
 

Re:BCB 6 and SQL Server connectivity

Brion L. Webster wrote:
Quote
headaches even now. Last night I was waking up from the pain about
every three minutes from 01:00 on. Still not as bad as the trigger
headache, though.
Best wishes on a speedy and complete recovery.
--
John Kaster blogs.borland.com/johnk
Features and bugs: qc.borland.com
Get source: cc.borland.com
If it's not here, it's not happening: ec.borland.com