is connection pooling something that can be used after moving tables from
mdb file to sql server 2000 and just relinking the tables via ODBC in the
front end file? Or is this something that must be setup in code?Connection pooling is on by default. It's typically used if you make and
break connections with the same connection string parameters. A web server
is a primary candidate for it's use.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sqlsql
Showing posts with label moving. Show all posts
Showing posts with label moving. Show all posts
Thursday, March 22, 2012
connection pooling
is connection pooling something that can be used after moving tables from
mdb file to sql server 2000 and just relinking the tables via ODBC in the
front end file? Or is this something that must be setup in code?
Connection pooling is on by default. It's typically used if you make and
break connections with the same connection string parameters. A web server
is a primary candidate for it's use.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
mdb file to sql server 2000 and just relinking the tables via ODBC in the
front end file? Or is this something that must be setup in code?
Connection pooling is on by default. It's typically used if you make and
break connections with the same connection string parameters. A web server
is a primary candidate for it's use.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Connection other database tables
We are finally moving off of Access to SQL Server 2000. In Access we can
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How do I attach tables from another SQL database to the current?
Thank you
Gwen Powell
Torrance Unified School District
Check SQL Server Books Online under the topic Linked
Servers.
-Sue
On Thu, 5 Aug 2004 13:38:39 -0700, "Gwen Powell"
<gpowell@.tusd.k12.ca.us> wrote:
>We are finally moving off of Access to SQL Server 2000. In Access we can
>attach all sorts of tables from different sources. In our SQL database, I
>need to attach tables from other SQL databases as well as other odbc
>sources. Then I will create views in order to utilize the data together.
>How do I attach tables from another SQL database to the current?
>Thank you
>Gwen Powell
>Torrance Unified School District
>
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How do I attach tables from another SQL database to the current?
Thank you
Gwen Powell
Torrance Unified School District
Check SQL Server Books Online under the topic Linked
Servers.
-Sue
On Thu, 5 Aug 2004 13:38:39 -0700, "Gwen Powell"
<gpowell@.tusd.k12.ca.us> wrote:
>We are finally moving off of Access to SQL Server 2000. In Access we can
>attach all sorts of tables from different sources. In our SQL database, I
>need to attach tables from other SQL databases as well as other odbc
>sources. Then I will create views in order to utilize the data together.
>How do I attach tables from another SQL database to the current?
>Thank you
>Gwen Powell
>Torrance Unified School District
>
Tuesday, March 20, 2012
Connection other database tables
We are finally moving off of Access to SQL Server 2000. In Access we can
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How do I attach tables from another SQL database to the current?
Thank you
Gwen Powell
Torrance Unified School DistrictCheck SQL Server Books Online under the topic Linked
Servers.
-Sue
On Thu, 5 Aug 2004 13:38:39 -0700, "Gwen Powell"
<gpowell@.tusd.k12.ca.us> wrote:
>We are finally moving off of Access to SQL Server 2000. In Access we can
>attach all sorts of tables from different sources. In our SQL database, I
>need to attach tables from other SQL databases as well as other odbc
>sources. Then I will create views in order to utilize the data together.
>How do I attach tables from another SQL database to the current?
>Thank you
>Gwen Powell
>Torrance Unified School District
>
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How do I attach tables from another SQL database to the current?
Thank you
Gwen Powell
Torrance Unified School DistrictCheck SQL Server Books Online under the topic Linked
Servers.
-Sue
On Thu, 5 Aug 2004 13:38:39 -0700, "Gwen Powell"
<gpowell@.tusd.k12.ca.us> wrote:
>We are finally moving off of Access to SQL Server 2000. In Access we can
>attach all sorts of tables from different sources. In our SQL database, I
>need to attach tables from other SQL databases as well as other odbc
>sources. Then I will create views in order to utilize the data together.
>How do I attach tables from another SQL database to the current?
>Thank you
>Gwen Powell
>Torrance Unified School District
>
Subscribe to:
Posts (Atom)