 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Phenix Smith
Guest
|
 Posted: Sun Oct 10, 2004 2:34 am Post subject: SQL Server 2005 Express / TADO |
 |
|
We currently have a Delphi 7 application that uses the BDE and wish to move
off the BDE completely to SQLExpress. I have been reading that we will need
to use the SQL Native Client , does this mean that we will need to load .Net
2.0 Frameworks on each client machine. I know we will need to load the
framework for the server.
I was informed that we cannot use TAdoTable or TAdoQuery if we wish to
bypass the BDE because they use the BDE. ???
Thanks for any information.
|
|
| Back to top |
|
 |
Jeff Overcash (TeamB)
Guest
|
| Posted: Sun Oct 10, 2004 3:33 am Post subject: Re: SQL Server 2005 Express / TADO |
|
|
Phenix Smith wrote:
| Quote: |
I was informed that we cannot use TAdoTable or TAdoQuery if we wish to
bypass the BDE because they use the BDE. ???
|
No they don't.
| Quote: | Thanks for any information.
|
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
A human being should be able to change a diaper, plan an invasion, butcher
a hog, conn a ship, design a building, write a sonnet, balance accounts, build
a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act
alone, solve equations, analyze a new problem, pitch manure, program a computer,
cook a tasty meal, fight efficiently, die gallantly. Specialization is for
insects. (RAH)
|
|
| Back to top |
|
|
Carlos Fandango
Guest
|
| Posted: Mon Oct 11, 2004 4:14 am Post subject: Re: SQL Server 2005 Express / TADO |
|
|
SQL Native Client Stands for just that, Native ie non managed data access.
This blog post explains more;
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
In theory all you need to do to get this to work is change the connection
string from pointing at sqloledb to sqlncli.
-Euan
"Phenix Smith" <lante (AT) sc (DOT) rr.com> wrote
| Quote: | We currently have a Delphi 7 application that uses the BDE and wish to
move off the BDE completely to SQLExpress. I have been reading that we
will need to use the SQL Native Client , does this mean that we will need
to load .Net 2.0 Frameworks on each client machine. I know we will need
to load the framework for the server.
I was informed that we cannot use TAdoTable or TAdoQuery if we wish to
bypass the BDE because they use the BDE. ???
Thanks for any information.
|
|
|
| Back to top |
|
|
Anton Santa
Guest
|
| Posted: Tue Oct 12, 2004 6:56 am Post subject: Re: SQL Server 2005 Express / TADO |
|
|
Hi,
consider SDAC from Corelab when wenting away from BDE. I had very goog
experience with these components.
best regards
Anton Santa
"Phenix Smith" <lante (AT) sc (DOT) rr.com> ha scritto nel messaggio
news:41689f9f (AT) newsgroups (DOT) borland.com...
| Quote: | We currently have a Delphi 7 application that uses the BDE and wish to
move off the BDE completely to SQLExpress. I have been reading that we
will need to use the SQL Native Client , does this mean that we will need
to load .Net 2.0 Frameworks on each client machine. I know we will need
to load the framework for the server.
I was informed that we cannot use TAdoTable or TAdoQuery if we wish to
bypass the BDE because they use the BDE. ???
Thanks for any information.
|
|
|
| Back to top |
|
|
Viatcheslav V. Vassiliev
Guest
|
| Posted: Tue Oct 12, 2004 10:34 am Post subject: Re: SQL Server 2005 Express / TADO |
|
|
You can use both ADO and ODBC with SQL native client. There is no need for
..Net 2 framework, but if you want to setup SQL Express on the same computer
as your program (common scenario for SQL Express), you will need .Net 2.
Some new features of SQL Express may also require .Net 2.
For ADO/OLEDB you need to use new provider - SQLNCLI, i.e. connection string
will be, for example:
Provider=SQLNCLI;Data Source=.SQLEXPRESS;Integrated Security=SSPI;Initial
catalog=DbName
for local installation. ODBC needs similar changes.
You may also use OLEDB Direct (http://www.oledbdirect.com) with SQL Express
2005 for fastest performance.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Phenix Smith" <lante (AT) sc (DOT) rr.com> сообщил/сообщила в новостях следующее:
news:41689f9f (AT) newsgroups (DOT) borland.com...
| Quote: | We currently have a Delphi 7 application that uses the BDE and wish to
move
off the BDE completely to SQLExpress. I have been reading that we will
need
to use the SQL Native Client , does this mean that we will need to load
..Net
2.0 Frameworks on each client machine. I know we will need to load the
framework for the server.
I was informed that we cannot use TAdoTable or TAdoQuery if we wish to
bypass the BDE because they use the BDE. ???
Thanks for any information.
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
