Newbee MSSQL How to?

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by sam Fri, 08 Sep 2006 06:11

#360

Author: sam
Date: Fri, 08 Sep 2006 06:11

9 lines
951 bytes

What is the best way to connect to mssql server?

Is there any full functioning example ?

Or should one use a 3rd party component?

TIA

Sam

Re: Newbee MSSQL How to?

#361

Author: Mark Guerrieri
Date: Fri, 08 Sep 2006 15:07

9 lines
1344 bytes

> What is the best way to connect to mssql server?

Drop a TADOConnection and a TADOQuery on a form.  Set the 
TADOConnection.ConnectionString to a vaid connection string for your 
database. Set the TADOQuery.Connection property to the TADOConnection. Set 
the TADOQuery.SQL property to the SQL you want to execute.  Call 
TADOQuery.Open().

Mark

Re: Newbee MSSQL How to?

#362

Author: Sam
Date: Sun, 10 Sep 2006 01:07

18 lines
1377 bytes

Thank you Mark
Worked a treat



"Mark Guerrieri" <mguerrieri@no_spam_verizon.net> wrote in message
news:450186d4@newsgroups.borland.com...
> > What is the best way to connect to mssql server?
>
> Drop a TADOConnection and a TADOQuery on a form.  Set the
> TADOConnection.ConnectionString to a vaid connection string for your
> database. Set the TADOQuery.Connection property to the TADOConnection. Set
> the TADOQuery.SQL property to the SQL you want to execute.  Call
> TADOQuery.Open().
>
> Mark
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads