One client machine gets a connection error

Which talks about Named Pipes.
We're not using Named Pipes, we're using TCP/IP.
All of the four other machines work...why not this one.
Note. It's a machine that has been reformatted and programs reinstalled.
But my program does nothing special other than connect to a SQL Server
through a WAN.
I'm obviously missing something.
Kyle!Compare the client netlib configuration between the machines (cliconfg.exe).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:ujMzvwWnHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Which talks about Named Pipes.
> We're not using Named Pipes, we're using TCP/IP.
> All of the four other machines work...why not this one.
> Note. It's a machine that has been reformatted and programs reinstalled.
> But my program does nothing special other than connect to a SQL Server through a WAN.
> I'm obviously missing something.
>
> Kyle!
>|||Since reformatted and reinstalled, how about windows internet firewall is on
(enabled by default when you applied windows xp SP2)? Or another firewall
product perhaps? Can you connect if you explicitly put in the ip address of
the machine in QA/SSMS?
--
TheSQLGuru
President
Indicium Resources, Inc.
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:ujMzvwWnHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Which talks about Named Pipes.
> We're not using Named Pipes, we're using TCP/IP.
> All of the four other machines work...why not this one.
> Note. It's a machine that has been reformatted and programs reinstalled.
> But my program does nothing special other than connect to a SQL Server
> through a WAN.
> I'm obviously missing something.
>
> Kyle!
>sql

One client machine gets a connection error

Which talks about Named Pipes.
We're not using Named Pipes, we're using TCP/IP.
All of the four other machines work...why not this one.
Note. It's a machine that has been reformatted and programs reinstalled.
But my program does nothing special other than connect to a SQL Server
through a WAN.
I'm obviously missing something.
Kyle!
Compare the client netlib configuration between the machines (cliconfg.exe).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:ujMzvwWnHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Which talks about Named Pipes.
> We're not using Named Pipes, we're using TCP/IP.
> All of the four other machines work...why not this one.
> Note. It's a machine that has been reformatted and programs reinstalled.
> But my program does nothing special other than connect to a SQL Server through a WAN.
> I'm obviously missing something.
>
> Kyle!
>
|||Since reformatted and reinstalled, how about windows internet firewall is on
(enabled by default when you applied windows xp SP2)? Or another firewall
product perhaps? Can you connect if you explicitly put in the ip address of
the machine in QA/SSMS?
TheSQLGuru
President
Indicium Resources, Inc.
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:ujMzvwWnHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Which talks about Named Pipes.
> We're not using Named Pipes, we're using TCP/IP.
> All of the four other machines work...why not this one.
> Note. It's a machine that has been reformatted and programs reinstalled.
> But my program does nothing special other than connect to a SQL Server
> through a WAN.
> I'm obviously missing something.
>
> Kyle!
>

One client machine gets a connection error

Which talks about Named Pipes.
We're not using Named Pipes, we're using TCP/IP.
All of the four other machines work...why not this one.
Note. It's a machine that has been reformatted and programs reinstalled.
But my program does nothing special other than connect to a SQL Server
through a WAN.
I'm obviously missing something.
Kyle!Compare the client netlib configuration between the machines (cliconfg.exe).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:ujMzvwWnHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Which talks about Named Pipes.
> We're not using Named Pipes, we're using TCP/IP.
> All of the four other machines work...why not this one.
> Note. It's a machine that has been reformatted and programs reinstalled.
> But my program does nothing special other than connect to a SQL Server thr
ough a WAN.
> I'm obviously missing something.
>
> Kyle!
>|||Since reformatted and reinstalled, how about windows internet firewall is on
(enabled by default when you applied Windows XP SP2)? Or another firewall
product perhaps? Can you connect if you explicitly put in the ip address of
the machine in QA/SSMS?
TheSQLGuru
President
Indicium Resources, Inc.
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:ujMzvwWnHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Which talks about Named Pipes.
> We're not using Named Pipes, we're using TCP/IP.
> All of the four other machines work...why not this one.
> Note. It's a machine that has been reformatted and programs reinstalled.
> But my program does nothing special other than connect to a SQL Server
> through a WAN.
> I'm obviously missing something.
>
> Kyle!
>

On demand backups

Have a client that needs to do an "on demand" back up of a database. How
can this be done ?
The database in question is used by the accounting department and the
application uses the SA login to access the database.
Any insight would be greatful.
TIAThis is a multi-part message in MIME format.
--=_NextPart_000_0013_01C361A3.29261130
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Ok... after looking at the SQL server, it appears that the accounting =app is using a Login ID, that in turn is the dbo for the accounting =database, so I have given that ID the Backup DB permission on the =server. Now what can I do to place a short cut on the desktops so that =the database is backed up when click (thus on demand). Is there a =script file that I need to write or a command line to be entered ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:us9V7HcYDHA.656@.tk2msftngp13.phx.gbl...
An app with the sa password is like a 3-yr old with a .357 magnum. =Your accounting app should not have sysadmin rights. You can grant =BACKUP DATABASE to any login and that's all you would need for that.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"_M_" <here@.gone.com> wrote in message =news:#KbMuEcYDHA.2464@.TK2MSFTNGP09.phx.gbl...
Have a client that needs to do an "on demand" back up of a database. =How
can this be done ?
The database in question is used by the accounting department and the
application uses the SA login to access the database.
Any insight would be greatful.
TIA
--=_NextPart_000_0013_01C361A3.29261130
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Ok... after looking at the SQL server, =it appears that the accounting app is using a Login ID, that in turn is =the dbo for the accounting database, so I have given that ID the Backup DB =permission on the server. Now what can I do to place a short cut on the =desktops so that the database is backed up when click (thus on demand). Is =there a script file that I need to write or a command line to be entered ?
"Tom Moreau" = wrote in message news:us9V7HcYDHA.656@.t=k2msftngp13.phx.gbl...
An app with the sa password is like =a 3-yr old with a .357 magnum. Your accounting app should not have sysadmin = rights. You can grant BACKUP DATABASE to any login and that's =all you would need for that.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"_M_" =wrote in message news:#KbMuEcYDHA.2464=@.TK2MSFTNGP09.phx.gbl...Have a client that needs to do an "on demand" back up of a database. Howcan this be done ?The database in question is used by =the accounting department and theapplication uses the SA login to =access the database.Any insight would be greatful.TIA

---

--=_NextPart_000_0013_01C361A3.29261130--|||This is a multi-part message in MIME format.
--=_NextPart_000_0338_01C361A5.7026B970
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You can create a little .CMD file that has the following:
osql -SMyServer -E -Q"backup database MyDB to disk =3D 'C:\MyDB.bak'"
or
osql -SMyServer -UMyLogin -PMyPassword -Q"backup database MyDB to disk ==3D 'C:\MyDB.bak'"
Ideally, use Windows authentication as shown in the first example, so =that no one can see the password. Alternatively, you can write the =second one as:
osql -SMyServer -UMyLogin -Q"backup database MyDB to disk =3D ='C:\MyDB.bak'"
It will then prompt the user for the password.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"_M_" <here@.gone.com> wrote in message =news:O7KcoScYDHA.888@.TK2MSFTNGP10.phx.gbl...
Ok... after looking at the SQL server, it appears that the accounting =app is using a Login ID, that in turn is the dbo for the accounting =database, so I have given that ID the Backup DB permission on the =server. Now what can I do to place a short cut on the desktops so that =the database is backed up when click (thus on demand). Is there a =script file that I need to write or a command line to be entered ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:us9V7HcYDHA.656@.tk2msftngp13.phx.gbl...
An app with the sa password is like a 3-yr old with a .357 magnum. =Your accounting app should not have sysadmin rights. You can grant =BACKUP DATABASE to any login and that's all you would need for that.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"_M_" <here@.gone.com> wrote in message =news:#KbMuEcYDHA.2464@.TK2MSFTNGP09.phx.gbl...
Have a client that needs to do an "on demand" back up of a database. =How
can this be done ?
The database in question is used by the accounting department and the
application uses the SA login to access the database.
Any insight would be greatful.
TIA
--=_NextPart_000_0338_01C361A5.7026B970
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

You can create a little .CMD file that =has the following:
osql -SMyServer -E -Q"backup =database MyDB to disk =3D 'C:\MyDB.bak'"
or
osql -SMyServer -UMyLogin -PMyPassword -Q"backup database MyDB to disk =3D ='C:\MyDB.bak'"
Ideally, use Windows authentication as shown in the first example, =so that no one can see the password. Alternatively, you can write the =second one as:
osql -SMyServer =-UMyLogin -Q"backup database MyDB to disk =3D 'C:\MyDB.bak'"
It will then prompt the user for the =password.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"_M_" =wrote in message news:O7KcoScYDHA.888@.T=K2MSFTNGP10.phx.gbl...
Ok... after looking at the SQL server, =it appears that the accounting app is using a Login ID, that in turn is =the dbo for the accounting database, so I have given that ID the Backup DB =permission on the server. Now what can I do to place a short cut on the =desktops so that the database is backed up when click (thus on demand). Is =there a script file that I need to write or a command line to be entered ?
"Tom Moreau" = wrote in message news:us9V7HcYDHA.656@.t=k2msftngp13.phx.gbl...
An app with the sa password is like =a 3-yr old with a .357 magnum. Your accounting app should not have sysadmin = rights. You can grant BACKUP DATABASE to any login and that's =all you would need for that.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"_M_" =wrote in message news:#KbMuEcYDHA.2464=@.TK2MSFTNGP09.phx.gbl...Have a client that needs to do an "on demand" back up of a database. Howcan this be done ?The database in question is used by =the accounting department and theapplication uses the SA login to =access the database.Any insight would be greatful.TIA

---

--=_NextPart_000_0338_01C361A5.7026B970--|||Dbo does not have to have backup database permission. A dbo can do anything
to the database that he/she owns..
Here is something short I did
1. create this proc ( you need to adjust the db name)
create proc dbo.bu as
declare @.fname varchar(128)
select @.fname = 'c:\' +
db_name() + '_DB_' + convert(varchar(100), getdate(),112)
+ datename(hh,getdate()) + datename(mi,getdate())
--select @.fname
backup database northwind to disk = @.fname
create a dos batch job like this
OSQL -Ulogin -Ppassword -Q"exec dbname.dbo.bu"
when the job is run the backup occurs...
Then put a shortcut to the job on their desktop
I would create a new login for the database which has ONLY backup
permissions, since the login and password are easily found...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and its
community of SQL Server professionals.
www.sqlpass.org
"_M_" <here@.gone.com> wrote in message
news:#KbMuEcYDHA.2464@.TK2MSFTNGP09.phx.gbl...
> Have a client that needs to do an "on demand" back up of a database. How
> can this be done ?
> The database in question is used by the accounting department and the
> application uses the SA login to access the database.
> Any insight would be greatful.
> TIA
>|||I like both yours and Tom's responses... Can yours be modified to use
Windows Authentication or can Tom's be modified to save each backup in the
time-date file name like yours ?
I'm sort of new to this SQL server stuff but I have had a semester of DB in
college...
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OVu5IfcYDHA.2524@.TK2MSFTNGP09.phx.gbl...
> Dbo does not have to have backup database permission. A dbo can do
anything
> to the database that he/she owns..
> Here is something short I did
> 1. create this proc ( you need to adjust the db name)
> create proc dbo.bu as
> declare @.fname varchar(128)
> select @.fname = 'c:\' +
> db_name() + '_DB_' + convert(varchar(100), getdate(),112)
> + datename(hh,getdate()) + datename(mi,getdate())
> --select @.fname
> backup database northwind to disk = @.fname
> create a dos batch job like this
> OSQL -Ulogin -Ppassword -Q"exec dbname.dbo.bu"
> when the job is run the backup occurs...
> Then put a shortcut to the job on their desktop
> I would create a new login for the database which has ONLY backup
> permissions, since the login and password are easily found...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and its
> community of SQL Server professionals.
> www.sqlpass.org
>
> "_M_" <here@.gone.com> wrote in message
> news:#KbMuEcYDHA.2464@.TK2MSFTNGP09.phx.gbl...
> > Have a client that needs to do an "on demand" back up of a database.
How
> > can this be done ?
> >
> > The database in question is used by the accounting department and the
> > application uses the SA login to access the database.
> >
> > Any insight would be greatful.
> >
> > TIA
> >
> >
>|||This is a multi-part message in MIME format.
--=_NextPart_000_03C3_01C361AA.859BF130
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Tom's can be modified. ;-) Just have it execute the proc instead of =the raw BACKUP:
osql -SMyServer -E -Q"exec MyBackupProc"
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"_M_" <here@.gone.com> wrote in message =news:uofpKqcYDHA.2448@.TK2MSFTNGP09.phx.gbl...
I like both yours and Tom's responses... Can yours be modified to use
Windows Authentication or can Tom's be modified to save each backup in =the
time-date file name like yours ?
I'm sort of new to this SQL server stuff but I have had a semester of DB =in
college...
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OVu5IfcYDHA.2524@.TK2MSFTNGP09.phx.gbl...
> Dbo does not have to have backup database permission. A dbo can do
anything
> to the database that he/she owns..
> Here is something short I did
> 1. create this proc ( you need to adjust the db name)
> create proc dbo.bu as
> declare @.fname varchar(128)
> select @.fname =3D 'c:\' +
> db_name() + '_DB_' + convert(varchar(100), getdate(),112)
> + datename(hh,getdate()) + datename(mi,getdate())
> --select @.fname
> backup database northwind to disk =3D @.fname
> create a dos batch job like this
> OSQL -Ulogin -Ppassword -Q"exec dbname.dbo.bu"
> when the job is run the backup occurs...
> Then put a shortcut to the job on their desktop
> I would create a new login for the database which has ONLY backup
> permissions, since the login and password are easily found...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and its
> community of SQL Server professionals.
> www.sqlpass.org
>
> "_M_" <here@.gone.com> wrote in message
> news:#KbMuEcYDHA.2464@.TK2MSFTNGP09.phx.gbl...
> > Have a client that needs to do an "on demand" back up of a database.
How
> > can this be done ?
> >
> > The database in question is used by the accounting department and =the
> > application uses the SA login to access the database.
> >
> > Any insight would be greatful.
> >
> > TIA
> >
> >
>
--=_NextPart_000_03C3_01C361AA.859BF130
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Tom's can be modified. ;-) =Just have it execute the proc instead of the raw BACKUP:
osql -SMyServer -E -Q"exec MyBackupProc"
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"_M_" =wrote in message news:uofpKqcYDHA.2448=@.TK2MSFTNGP09.phx.gbl...I like both yours and Tom's responses... Can yours be modified to useWindows Authentication or can Tom's be modified to save each =backup in thetime-date file name like yours ?I'm sort of new to this =SQL server stuff but I have had a semester of DB =incollege..."Wayne Snyder" wrote in messagenews:OVu5IfcYDHA.2524=@.TK2MSFTNGP09.phx.gbl...> Dbo does not have to have backup database permission. A dbo can doanything> to the database that he/she =owns..>> Here is something short I did> 1. create this proc ( you need to =adjust the db name)> create proc dbo.bu as> declare @.fname =varchar(128)> select @.fname =3D 'c:\' +> db_name() + '_DB_' + =convert(varchar(100), getdate(),112)> + datename(hh,getdate()) + datename(mi,getdate())> --select @.fname> backup database =northwind to disk =3D @.fname>> create a dos batch job like =this> OSQL -Ulogin -Ppassword -Q"exec dbname.dbo.bu">> when the job =is run the backup occurs...>> Then put a shortcut to the job on =their desktop>> I would create a new login for the database =which has ONLY backup> permissions, since the login and password are easily =found...>>> --> Wayne Snyder, MCDBA, SQL =Server MVP> Computer Education Services Corporation (CESC), Charlotte, NC>http://www.computeredservices.com">www.computeredservices.com=> (Please respond only to the newsgroups.)>> I support the Professional Association of SQL Server (PASS) and its> community =of SQL Server professionals.>>&g=">http://www.sqlpass.org">www.sqlpass.org>>&g=t; "_M_" wrote in message> news:#KbMuEcYDHA.2464=@.TK2MSFTNGP09.phx.gbl...> > Have a client that needs to do an "on demand" back up of a database.How> > can this be done ?> >> => The database in question is used by the accounting department and =the> > application uses the SA login to access the database.> =>> > Any insight would be greatful.> >> > TIA> >> >>>

---

--=_NextPart_000_03C3_01C361AA.859BF130--|||Tried to create the procedure as listed by Wayne... I get an error message
(Invalid syntax at or around backup"
I did do a cut and paste as well as completely re-typing it myself. The
server is SQL 2000 if that matters...
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OVu5IfcYDHA.2524@.TK2MSFTNGP09.phx.gbl...
> Dbo does not have to have backup database permission. A dbo can do
anything
> to the database that he/she owns..
> Here is something short I did
> 1. create this proc ( you need to adjust the db name)
> create proc dbo.bu as
> declare @.fname varchar(128)
> select @.fname = 'c:\' +
> db_name() + '_DB_' + convert(varchar(100), getdate(),112)
> + datename(hh,getdate()) + datename(mi,getdate())
> --select @.fname
> backup database northwind to disk = @.fname
> create a dos batch job like this
> OSQL -Ulogin -Ppassword -Q"exec dbname.dbo.bu"
> when the job is run the backup occurs...
> Then put a shortcut to the job on their desktop
> I would create a new login for the database which has ONLY backup
> permissions, since the login and password are easily found...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and its
> community of SQL Server professionals.
> www.sqlpass.org
>
> "_M_" <here@.gone.com> wrote in message
> news:#KbMuEcYDHA.2464@.TK2MSFTNGP09.phx.gbl...
> > Have a client that needs to do an "on demand" back up of a database.
How
> > can this be done ?
> >
> > The database in question is used by the accounting department and the
> > application uses the SA login to access the database.
> >
> > Any insight would be greatful.
> >
> > TIA
> >
> >
>sql

Olympic Games Support in Torino 2006

We are utilizing a .net front end Client side application to access a remote
SQL database. We will be using this method for transactions locally to issue
apparel to Athletes as well as other information about our team. The
question I have is our proposed setup is to have a 2MB line using a VPN
connection back to our home site and conduct live application entry, we will
then have a local client facing server in Italy for disaster recovery
performing stored procedures to trigger replication for a backup copy. We
proposed this topology as other members need real time access to the data at
multiple locations. Are main concerns are survivability of the database and
potential latency issues over a leased line. Anyone have any thoughts?
I wouldn't use stored procedures for that but setup replication.
In case the link fails you have disconnected systems that can operate
independent from eachother and when the connection comes back up replication
will occur.
There are several replication topologies and methods possible.
This will depend on the amount of data you want to replicate as well.
Thinking of snapshot replication or transactional replication
Probably transactional with immediate updating subscribers might be the
option.
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Paul Walker" <Paul Walker@.discussions.microsoft.com> wrote in message
news:5488F052-E627-415C-AD93-545D726BA28F@.microsoft.com...
> We are utilizing a .net front end Client side application to access a
> remote
> SQL database. We will be using this method for transactions locally to
> issue
> apparel to Athletes as well as other information about our team. The
> question I have is our proposed setup is to have a 2MB line using a VPN
> connection back to our home site and conduct live application entry, we
> will
> then have a local client facing server in Italy for disaster recovery
> performing stored procedures to trigger replication for a backup copy. We
> proposed this topology as other members need real time access to the data
> at
> multiple locations. Are main concerns are survivability of the database
> and
> potential latency issues over a leased line. Anyone have any thoughts?

OLEDB vs ODBC

I am new SQL Server 2005. The native client supports both OLEDB and ODBC
connections. Which one should I prefer and why? Thanks.
I would say it depends on the particular application. We use JD Edwards
which runs on SQL server and it has always been configured for ODBC
connections. Because of a couple of other apps we have in house which call
for an OLEDB connection and the performance was great we migrated from ODBC
to OLEDB on JD Edwards and the performance was severely degraded so we
switched back to ODBC on this particular app.
Hope this helps.
Robby
"mason" <masonliu@.msn.com> wrote in message
news:O81z$qzNGHA.208@.tk2msftngp13.phx.gbl...
>I am new SQL Server 2005. The native client supports both OLEDB and ODBC
>connections. Which one should I prefer and why? Thanks.

OLEDB for DB2 how to ...

Hello,
I've installed the Host Integration server client SP1 on my development
machine running SQL server. I'm tryiyng to create a udl file to connect to
the DB server but I allways get an error about wrong parameters ... can
anyone help me out?
The idea is to be able to run a dts task against the DB2 thx!OK the connection test worksm
now I struggling with the meaning and significance of collection and schema
options ...
Tips are welcome
"John Koswalski" <john.koswalski@.shell.nl> wrote in message
news:umv9fhe2DHA.2856@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Hello,
> I've installed the Host Integration server client SP1 on my development
> machine running SQL server. I'm tryiyng to create a udl file to connect

---

to

quote:

---

> the DB server but I allways get an error about wrong parameters ... can
> anyone help me out?
> The idea is to be able to run a dts task against the DB2 thx!
>

---

OLEDB consumer and for xml SELECT

Hi,
I have a select statement which retrieve data in xml format (FOR XML
AUTO option). When I run this statement from a client using an OLEDB
consumer template for the table, I get the data BUT it does not look
right... Here is a sample:
suppose I run the following statement:
SELECT StateID,
RTRIM(StateCode) AS StateCode,
RTRIM(StateName) as StateName,
RTRIM(Country) as Country
FROM State
FOR XML AUTO
This sql will generate the following result if run from SQL Query Analyzer:
..........................................
<State StateID="1" StateCode="AL" StateName="Alabama" Country="USA"/>
<State StateID="2" StateCode="AK" StateName="Alaska" Country="USA"/>
<State StateID="3" StateCode="AZ" StateName="Arizona" Country="USA"/>
........... etc.
When I run the same query from a client using an OLEDB consumer template, I
get a string with a lot of nulls, the xml format is no longer there, there
are some unprintable chars, etc. The odd thing is that the data is there! It
just is not in the right format!?
Does anyone know what is going on?
Thanks,
George.Did you use the CommandStream interface? This looks like the binary format
that is being returned if you use the rowset interface. Using the
CommandStream interface will be giving you the stream in parseable XML.
Best regards
Michael
"George Tihenea" <tihenea@.comcast.net> wrote in message
news:uNWVeiwCFHA.2568@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a select statement which retrieve data in xml format (FOR XML
> AUTO option). When I run this statement from a client using an OLEDB
> consumer template for the table, I get the data BUT it does not look
> right... Here is a sample:
> suppose I run the following statement:
> SELECT StateID,
> RTRIM(StateCode) AS StateCode,
> RTRIM(StateName) as StateName,
> RTRIM(Country) as Country
> FROM State
> FOR XML AUTO
> This sql will generate the following result if run from SQL Query
> Analyzer:
> ..........................................
> <State StateID="1" StateCode="AL" StateName="Alabama" Country="USA"/>
> <State StateID="2" StateCode="AK" StateName="Alaska" Country="USA"/>
> <State StateID="3" StateCode="AZ" StateName="Arizona" Country="USA"/>
> ........... etc.
> When I run the same query from a client using an OLEDB consumer template,
> I get a string with a lot of nulls, the xml format is no longer there,
> there are some unprintable chars, etc. The odd thing is that the data is
> there! It just is not in the right format!?
> Does anyone know what is going on?
> Thanks,
> George.
>|||Michael,
Thanks. No I did not use ICommandStream. The database access is done
using a stored procedure, and the OLEDB client code is generated by the
wizard. That creates a class ready to run the stored procedure and return
the result set.
George.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:%23ULojEUDFHA.3368@.TK2MSFTNGP10.phx.gbl...
> Did you use the CommandStream interface? This looks like the binary format
> that is being returned if you use the rowset interface. Using the
> CommandStream interface will be giving you the stream in parseable XML.
> Best regards
> Michael
> "George Tihenea" <tihenea@.comcast.net> wrote in message
> news:uNWVeiwCFHA.2568@.TK2MSFTNGP10.phx.gbl...
>|||I assume that this is the problem. If the stored proc generates a FOR XML
result, your OLEDB code has to use the command stream and not the normal way
of retrieving a relational rowset. FOR XML results are generating an XML
stream and not a rowset after all...
The Books Online should have some sample code snippets.
Best regards
Michael
"George Tihenea" <tihenea@.comcast.net> wrote in message
news:%23pMpqvWDFHA.2620@.tk2msftngp13.phx.gbl...
> Michael,
> Thanks. No I did not use ICommandStream. The database access is done
> using a stored procedure, and the OLEDB client code is generated by the
> wizard. That creates a class ready to run the stored procedure and return
> the result set.
> George.
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:%23ULojEUDFHA.3368@.TK2MSFTNGP10.phx.gbl...
>|||Michael,
Thanks. Here is an answer I got in oledb forum:
.........................................................
...................
Yes, there is something happening in OLE DB. Query Analyzer uses ODBC,
so there is no problem.
You would see the problem if you did:
SELECT * FROM OPENQUERY(LOOPBACK, 'SELECT * FROM tbl FOR XML AUTO')
And LOOPBACK is a linked server set up with SQLOLEDB.
In SQL 2005, there is a new command-line tool SQLCMD which is implemented
with SQL Native Client (SQLOLEDB for SQL 2005). And sure enough, if you
issue a FOR XML query, all you get is a bunch of hex digits. I've submitted
a bug report for that. I wonder how they will fix it...
.........................................................
.........................................................
.........
George.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:OVjWxBoDFHA.3368@.TK2MSFTNGP10.phx.gbl...
>I assume that this is the problem. If the stored proc generates a FOR XML
>result, your OLEDB code has to use the command stream and not the normal
>way of retrieving a relational rowset. FOR XML results are generating an
>XML stream and not a rowset after all...
> The Books Online should have some sample code snippets.
> Best regards
> Michael
> "George Tihenea" <tihenea@.comcast.net> wrote in message
> news:%23pMpqvWDFHA.2620@.tk2msftngp13.phx.gbl...
>|||Correct. But please note that the OPENQUERY always requests a rowset and not
a CommandStream.
If you code against OLEDB yourself, you can use the ICommandStream and get
the XML back as a nice XML character stream. Were you able to try that?
Best regards
Michael
"George Tihenea" <tihenea@.comcast.net> wrote in message
news:eIEqR5tDFHA.1040@.TK2MSFTNGP09.phx.gbl...
> Michael,
> Thanks. Here is an answer I got in oledb forum:
> ........................................................
....................
> Yes, there is something happening in OLE DB. Query Analyzer uses ODBC,
> so there is no problem.
> You would see the problem if you did:
> SELECT * FROM OPENQUERY(LOOPBACK, 'SELECT * FROM tbl FOR XML AUTO')
> And LOOPBACK is a linked server set up with SQLOLEDB.
> In SQL 2005, there is a new command-line tool SQLCMD which is implemented
> with SQL Native Client (SQLOLEDB for SQL 2005). And sure enough, if you
> issue a FOR XML query, all you get is a bunch of hex digits. I've
> submitted
> a bug report for that. I wonder how they will fix it...
> ........................................................
.........................................................
..........
> George.
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:OVjWxBoDFHA.3368@.TK2MSFTNGP10.phx.gbl...
>|||Michael,
Thanks. I am using the class created by the OLEDB wizard to add the
consumer template. That has an ICommandStream and I can read the data but it
is the same. Do you have a sample somewhere showing how to use
ICommandStream with a class generated by the wizard?
George.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:ea$6uuyDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Correct. But please note that the OPENQUERY always requests a rowset and
> not a CommandStream.
> If you code against OLEDB yourself, you can use the ICommandStream and get
> the XML back as a nice XML character stream. Were you able to try that?
> Best regards
> Michael
> "George Tihenea" <tihenea@.comcast.net> wrote in message
> news:eIEqR5tDFHA.1040@.TK2MSFTNGP09.phx.gbl...
>

OLEDB consumer and for xml SELECT

Hi,
I have a select statement which retrieve data in xml format (FOR XML
AUTO option). When I run this statement from a client using an OLEDB
consumer template for the table, I get the data BUT it does not look
right... Here is a sample:
suppose I run the following statement:
SELECT StateID,
RTRIM(StateCode) AS StateCode,
RTRIM(StateName) as StateName,
RTRIM(Country) as Country
FROM State
FOR XML AUTO
This sql will generate the following result if run from SQL Query Analyzer:
...................................... ......
<State StateID="1" StateCode="AL" StateName="Alabama" Country="USA"/>
<State StateID="2" StateCode="AK" StateName="Alaska" Country="USA"/>
<State StateID="3" StateCode="AZ" StateName="Arizona" Country="USA"/>
............ etc.
When I run the same query from a client using an OLEDB consumer template, I
get a string with a lot of nulls, the xml format is no longer there, there
are some unprintable chars, etc. The odd thing is that the data is there! It
just is not in the right format!?
Does anyone know what is going on?
Thanks,
George.
Did you use the CommandStream interface? This looks like the binary format
that is being returned if you use the rowset interface. Using the
CommandStream interface will be giving you the stream in parseable XML.
Best regards
Michael
"George Tihenea" <tihenea@.comcast.net> wrote in message
news:uNWVeiwCFHA.2568@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a select statement which retrieve data in xml format (FOR XML
> AUTO option). When I run this statement from a client using an OLEDB
> consumer template for the table, I get the data BUT it does not look
> right... Here is a sample:
> suppose I run the following statement:
> SELECT StateID,
> RTRIM(StateCode) AS StateCode,
> RTRIM(StateName) as StateName,
> RTRIM(Country) as Country
> FROM State
> FOR XML AUTO
> This sql will generate the following result if run from SQL Query
> Analyzer:
> ...................................... .....
> <State StateID="1" StateCode="AL" StateName="Alabama" Country="USA"/>
> <State StateID="2" StateCode="AK" StateName="Alaska" Country="USA"/>
> <State StateID="3" StateCode="AZ" StateName="Arizona" Country="USA"/>
> ........... etc.
> When I run the same query from a client using an OLEDB consumer template,
> I get a string with a lot of nulls, the xml format is no longer there,
> there are some unprintable chars, etc. The odd thing is that the data is
> there! It just is not in the right format!?
> Does anyone know what is going on?
> Thanks,
> George.
>
|||Michael,
Thanks. No I did not use ICommandStream. The database access is done
using a stored procedure, and the OLEDB client code is generated by the
wizard. That creates a class ready to run the stored procedure and return
the result set.
George.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:%23ULojEUDFHA.3368@.TK2MSFTNGP10.phx.gbl...
> Did you use the CommandStream interface? This looks like the binary format
> that is being returned if you use the rowset interface. Using the
> CommandStream interface will be giving you the stream in parseable XML.
> Best regards
> Michael
> "George Tihenea" <tihenea@.comcast.net> wrote in message
> news:uNWVeiwCFHA.2568@.TK2MSFTNGP10.phx.gbl...
>
|||I assume that this is the problem. If the stored proc generates a FOR XML
result, your OLEDB code has to use the command stream and not the normal way
of retrieving a relational rowset. FOR XML results are generating an XML
stream and not a rowset after all...
The Books Online should have some sample code snippets.
Best regards
Michael
"George Tihenea" <tihenea@.comcast.net> wrote in message
news:%23pMpqvWDFHA.2620@.tk2msftngp13.phx.gbl...
> Michael,
> Thanks. No I did not use ICommandStream. The database access is done
> using a stored procedure, and the OLEDB client code is generated by the
> wizard. That creates a class ready to run the stored procedure and return
> the result set.
> George.
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:%23ULojEUDFHA.3368@.TK2MSFTNGP10.phx.gbl...
>
|||Michael,
Thanks. Here is an answer I got in oledb forum:
...................................... ...................................... ..
Yes, there is something happening in OLE DB. Query Analyzer uses ODBC,
so there is no problem.
You would see the problem if you did:
SELECT * FROM OPENQUERY(LOOPBACK, 'SELECT * FROM tbl FOR XML AUTO')
And LOOPBACK is a linked server set up with SQLOLEDB.
In SQL 2005, there is a new command-line tool SQLCMD which is implemented
with SQL Native Client (SQLOLEDB for SQL 2005). And sure enough, if you
issue a FOR XML query, all you get is a bunch of hex digits. I've submitted
a bug report for that. I wonder how they will fix it...
...................................... ...................................... ...................................... ............
George.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:OVjWxBoDFHA.3368@.TK2MSFTNGP10.phx.gbl...
>I assume that this is the problem. If the stored proc generates a FOR XML
>result, your OLEDB code has to use the command stream and not the normal
>way of retrieving a relational rowset. FOR XML results are generating an
>XML stream and not a rowset after all...
> The Books Online should have some sample code snippets.
> Best regards
> Michael
> "George Tihenea" <tihenea@.comcast.net> wrote in message
> news:%23pMpqvWDFHA.2620@.tk2msftngp13.phx.gbl...
>
|||Correct. But please note that the OPENQUERY always requests a rowset and not
a CommandStream.
If you code against OLEDB yourself, you can use the ICommandStream and get
the XML back as a nice XML character stream. Were you able to try that?
Best regards
Michael
"George Tihenea" <tihenea@.comcast.net> wrote in message
news:eIEqR5tDFHA.1040@.TK2MSFTNGP09.phx.gbl...
> Michael,
> Thanks. Here is an answer I got in oledb forum:
> ...................................... ...................................... .
> Yes, there is something happening in OLE DB. Query Analyzer uses ODBC,
> so there is no problem.
> You would see the problem if you did:
> SELECT * FROM OPENQUERY(LOOPBACK, 'SELECT * FROM tbl FOR XML AUTO')
> And LOOPBACK is a linked server set up with SQLOLEDB.
> In SQL 2005, there is a new command-line tool SQLCMD which is implemented
> with SQL Native Client (SQLOLEDB for SQL 2005). And sure enough, if you
> issue a FOR XML query, all you get is a bunch of hex digits. I've
> submitted
> a bug report for that. I wonder how they will fix it...
> ...................................... ...................................... ...................................... ...........
> George.
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:OVjWxBoDFHA.3368@.TK2MSFTNGP10.phx.gbl...
>
|||Michael,
Thanks. I am using the class created by the OLEDB wizard to add the
consumer template. That has an ICommandStream and I can read the data but it
is the same. Do you have a sample somewhere showing how to use
ICommandStream with a class generated by the wizard?
George.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:ea$6uuyDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Correct. But please note that the OPENQUERY always requests a rowset and
> not a CommandStream.
> If you code against OLEDB yourself, you can use the ICommandStream and get
> the XML back as a nice XML character stream. Were you able to try that?
> Best regards
> Michael
> "George Tihenea" <tihenea@.comcast.net> wrote in message
> news:eIEqR5tDFHA.1040@.TK2MSFTNGP09.phx.gbl...
>

OLE DB Services and SQL Native Client

Is the option OLE DB Services = -4 still valid in the connection string with
the SQL Native Client ?Hello Michael,
The connection string in the SQL Native Client did not contain the OLE DB
Services option.
If you want to disable the resource pooling, please set the Pooling
property to false in the connection string.
SqlConnection.ConnectionString Property
http://msdn2.microsoft.com/en-us/li...t.sqlconnection
connectionstring(VS.80).aspx
This article described all the propertied you could use in the
ConnectionString.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I'm NOT using SqlConnection.
I'm using ADO (NOT ADO.NET) with Provider=SQLNCLI
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:S5EFMreZHHA.2372@.TK2MSFTNGHUB02.phx.gbl...
> Hello Michael,
> The connection string in the SQL Native Client did not contain the OLE DB
> Services option.
> If you want to disable the resource pooling, please set the Pooling
> property to false in the connection string.
> SqlConnection.ConnectionString Property
> [url]http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection[/ur
l]
> connectionstring(VS.80).aspx
> This article described all the propertied you could use in the
> ConnectionString.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Michael,
Thanks for the update.
Since the SQL Native Client works different with ADO, I am doult that ADO
did not fully compatitable with SQL Native Client. I will consult the
internal team to confirm whether we could use the Pooling setting in the
connnection string for ADO.
My suggestion is that you may considaring migrate your application from ADO
to ADO.NET if you do not have other concern. Please let me know whether you
have any concern about the ADO.NET. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||The application is HUGE and was developed using ADO which is why we can not
migrate.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:nwGUjviZHHA.3800@.TK2MSFTNGHUB02.phx.gbl...
> Hello Michael,
> Thanks for the update.
> Since the SQL Native Client works different with ADO, I am doult that ADO
> did not fully compatitable with SQL Native Client. I will consult the
> internal team to confirm whether we could use the Pooling setting in the
> connnection string for ADO.
> My suggestion is that you may considaring migrate your application from
> ADO
> to ADO.NET if you do not have other concern. Please let me know whether
> you
> have any concern about the ADO.NET. Thank you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Michael,
I did not get the reply from the internal right now.
Once I get the response, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Michael,
According to the response from internal team, OLE DB SERVICES works for any
OLE DB Provider because it operates at the OLE DB service layer that is
used to instantiate a provider instance. i.e. it's not a provider-specific
setting. So you could still use the OLE DB SERVICES = -4 in ADO string.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ah why do you keep polling like this? It just adds noise to the newsgroup.
We know you're there and want to help.
Thanks
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:kqiT3vGbHHA.3820@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello William,
I just want to check the status of the issue. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

OLE DB Services and SQL Native Client

Is the option OLE DB Services = -4 still valid in the connection string with
the SQL Native Client ?
Hi Michael,
I notice that you have posted the same question in
microsoft.public.sqlserver.clients newsgroup, to which I have already
responded. Please check my answer there, and if you need any further
assistance on this particular issue please reply to me in that thread so I
can follow up with you. In the future, please don't cross-post the same
question in multiple newsgroups. This will help our engineers work on your
question more efficiently. Your understanding and cooperation is
appreciated.
For your convenience, I have included my reply as follows:
Hello Michael,
The connection string in the SQL Native Client did not contain the OLE DB
Services option.
If you want to disable the resource pooling, please set the Pooling
property to false in the connection string.
SqlConnection.ConnectionString Property
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection
connectionstring(VS.80).aspx
This article described all the propertied you could use in the
ConnectionString.
Sincerely,
Wei Lu
Microsoft Online Community Support

Thank you and have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

OLE DB Services and SQL Native Client

Is the option OLE DB Services = -4 still valid in the connection string with
the SQL Native Client ?
Hello Michael,
The connection string in the SQL Native Client did not contain the OLE DB
Services option.
If you want to disable the resource pooling, please set the Pooling
property to false in the connection string.
SqlConnection.ConnectionString Property
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection
connectionstring(VS.80).aspx
This article described all the propertied you could use in the
ConnectionString.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
I'm NOT using SqlConnection.
I'm using ADO (NOT ADO.NET) with Provider=SQLNCLI
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:S5EFMreZHHA.2372@.TK2MSFTNGHUB02.phx.gbl...
> Hello Michael,
> The connection string in the SQL Native Client did not contain the OLE DB
> Services option.
> If you want to disable the resource pooling, please set the Pooling
> property to false in the connection string.
> SqlConnection.ConnectionString Property
> http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection
> connectionstring(VS.80).aspx
> This article described all the propertied you could use in the
> ConnectionString.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello Michael,
Thanks for the update.
Since the SQL Native Client works different with ADO, I am doult that ADO
did not fully compatitable with SQL Native Client. I will consult the
internal team to confirm whether we could use the Pooling setting in the
connnection string for ADO.
My suggestion is that you may considaring migrate your application from ADO
to ADO.NET if you do not have other concern. Please let me know whether you
have any concern about the ADO.NET. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||The application is HUGE and was developed using ADO which is why we can not
migrate.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:nwGUjviZHHA.3800@.TK2MSFTNGHUB02.phx.gbl...
> Hello Michael,
> Thanks for the update.
> Since the SQL Native Client works different with ADO, I am doult that ADO
> did not fully compatitable with SQL Native Client. I will consult the
> internal team to confirm whether we could use the Pooling setting in the
> connnection string for ADO.
> My suggestion is that you may considaring migrate your application from
> ADO
> to ADO.NET if you do not have other concern. Please let me know whether
> you
> have any concern about the ADO.NET. Thank you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello Michael,
I did not get the reply from the internal right now.
Once I get the response, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hello Michael,
According to the response from internal team, OLE DB SERVICES works for any
OLE DB Provider because it operates at the OLE DB service layer that is
used to instantiate a provider instance. i.e. it's not a provider-specific
setting. So you could still use the OLE DB SERVICES = -4 in ADO string.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Ah why do you keep polling like this? It just adds noise to the newsgroup.
We know you're there and want to help.
Thanks
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:kqiT3vGbHHA.3820@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello William,
I just want to check the status of the issue. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

OLE DB Provider

How do you set up an OLE DB Provider on a client machine.
Is there a similar setup procedure as ODBC?
Thanks,
StephIf you have MDAC installed on your client PC, you will have all major OLE DB
providers. MDAC gets installed along with some applications. You can also
get it from Microsoft site at: http://www.microsoft.com/data
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"steph" <stephaniebeling@.hotmail.com> wrote in message
news:393a01c3559d$91c59f60$a001280a@.phx.gbl...
How do you set up an OLE DB Provider on a client machine.
Is there a similar setup procedure as ODBC?
Thanks,
Steph

OLE DB or ODBC collation information

Good morning.
We are building a SQL Server client in C++ and out client needs to be
able to dynamically discover collation information about result set
columns and existing table columns. We'd like to be able to map that
collation back to an LCID in Win32. Does anyone know the proper
properties or interfaces to use to obtain this information?
ThanksYou can use a system store procedure:
exec [<database>]..sp_tablecollations '[<schema>].[<tablename>]'
Michael
"Chris Stolte" <cstolte@.graphics.stanford.edu> wrote in message
news:98086226.0410220714.20ad4ed2@.posting.google.com...
> Good morning.
> We are building a SQL Server client in C++ and out client needs to be
> able to dynamically discover collation information about result set
> columns and existing table columns. We'd like to be able to map that
> collation back to an LCID in Win32. Does anyone know the proper
> properties or interfaces to use to obtain this information?
> Thanks|||And to map a collation to an LCID:
SELECT COLLATIONPROPERTY ('<collation_name>', 'LCID')
To do this in one query instead of submitting the above for each of the
columns returned by sp_tablecollations:
USE pubs
GO
SELECT COLUMN_NAME, DATA_TYPE, COLLATION_NAME,
COLLATIONPROPERTY (COLLATION_NAME, 'LCID') AS LCID
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'pubs' AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME =
'authors'
Bart
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Michael Thomas \(Microsoft\)" <mithomas@.online.microsoft.com>
| References: <98086226.0410220714.20ad4ed2@.posting.google.com>
| Subject: Re: OLE DB or ODBC collation information
| Date: Fri, 22 Oct 2004 09:21:33 -0700
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.181
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
| Message-ID: <eMH94MFuEHA.1372@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: tide138.microsoft.com 131.107.71.95
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.odbc:42809
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| You can use a system store procedure:
|
| exec [<database>]..sp_tablecollations '[<schema>].[<tablename>
]'
|
|
|
| Michael
|
|
| "Chris Stolte" <cstolte@.graphics.stanford.edu> wrote in message
| news:98086226.0410220714.20ad4ed2@.posting.google.com...
| > Good morning.
| >
| > We are building a SQL Server client in C++ and out client needs to be
| > able to dynamically discover collation information about result set
| > columns and existing table columns. We'd like to be able to map that
| > collation back to an LCID in Win32. Does anyone know the proper
| > properties or interfaces to use to obtain this information?
| >
| > Thanks
|
|
|

OLE DB or ODBC collation information

Good morning.
We are building a SQL Server client in C++ and out client needs to be
able to dynamically discover collation information about result set
columns and existing table columns. We'd like to be able to map that
collation back to an LCID in Win32. Does anyone know the proper
properties or interfaces to use to obtain this information?
Thanks
You can use a system store procedure:
exec [<database>]..sp_tablecollations '[<schema>].[<tablename>]'
Michael
"Chris Stolte" <cstolte@.graphics.stanford.edu> wrote in message
news:98086226.0410220714.20ad4ed2@.posting.google.c om...
> Good morning.
> We are building a SQL Server client in C++ and out client needs to be
> able to dynamically discover collation information about result set
> columns and existing table columns. We'd like to be able to map that
> collation back to an LCID in Win32. Does anyone know the proper
> properties or interfaces to use to obtain this information?
> Thanks
|||And to map a collation to an LCID:
SELECT COLLATIONPROPERTY ('<collation_name>', 'LCID')
To do this in one query instead of submitting the above for each of the
columns returned by sp_tablecollations:
USE pubs
GO
SELECT COLUMN_NAME, DATA_TYPE, COLLATION_NAME,
COLLATIONPROPERTY (COLLATION_NAME, 'LCID') AS LCID
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'pubs' AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME =
'authors'
Bart
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Michael Thomas \(Microsoft\)" <mithomas@.online.microsoft.com>
| References: <98086226.0410220714.20ad4ed2@.posting.google.com >
| Subject: Re: OLE DB or ODBC collation information
| Date: Fri, 22 Oct 2004 09:21:33 -0700
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.181
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
| Message-ID: <eMH94MFuEHA.1372@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: tide138.microsoft.com 131.107.71.95
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP14
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.odbc:42809
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| You can use a system store procedure:
|
| exec [<database>]..sp_tablecollations '[<schema>].[<tablename>]'
|
|
|
| Michael
|
|
| "Chris Stolte" <cstolte@.graphics.stanford.edu> wrote in message
| news:98086226.0410220714.20ad4ed2@.posting.google.c om...
| > Good morning.
| >
| > We are building a SQL Server client in C++ and out client needs to be
| > able to dynamically discover collation information about result set
| > columns and existing table columns. We'd like to be able to map that
| > collation back to an LCID in Win32. Does anyone know the proper
| > properties or interfaces to use to obtain this information?
| >
| > Thanks
|
|
|

OLE DB Connectivity

Do users need to be setup with the Client Connectivity
only for an application that uses OLE DB to access MS SQL
Standard Edition?
Thanks,
AnjelinaNo, Users you need to have the MDAC installed.
If you send your queries DSN-less in your Apps, they even don´t have
maintain a connection info and their computers (like DSNs)
HTH, Jens Süßmeyer.
"anjelina" <ajturner@.canada.com> schrieb im Newsbeitrag
news:023d01c37b5c$0de07f50$a001280a@.phx.gbl...
> Do users need to be setup with the Client Connectivity
> only for an application that uses OLE DB to access MS SQL
> Standard Edition?
> Thanks,
> Anjelina|||Sorry, my english sounded like this from a drunk, so
the corrected version (just for my ego :)
--
No, you only have the MDAC to be installed on the clients.
If you send your queries in your Apps DSN-less, you
even don´t have to maintain a connection info on the
clients (like DSNs)
--
"anjelina" <ajtuener@.canada.com> schrieb im Newsbeitrag
news:068701c37b67$61096740$a101280a@.phx.gbl...
Thanks a million!!!
Anjelina
>--Original Message--
>No, Users you need to have the MDAC installed.
>If you send your queries DSN-less in your Apps, they
even don´t have
>maintain a connection info and their computers (like
DSNs)
>HTH, Jens Süßmeyer.
>"anjelina" <ajturner@.canada.com> schrieb im Newsbeitrag
>news:023d01c37b5c$0de07f50$a001280a@.phx.gbl...
>> Do users need to be setup with the Client Connectivity
>> only for an application that uses OLE DB to access MS
SQL
>> Standard Edition?
>> Thanks,
>> Anjelina
>
>.
>