Hi,
vb6+mssql2000 i want to disable updates by set cn.mode=adModeRead. inspite
of this, i can do modifications without error... any tip? what should i
check?
Hi,
It could be that provider does not support this mode. What is your
connection string?
Val Mazur
Microsoft MVP
"SRINGER Zoltn" <kecskemetisrac@.remove.it.freemail.hu> wrote in message
news:OIj6BsMoEHA.3876@.TK2MSFTNGP15.phx.gbl...
> Hi,
> vb6+mssql2000 i want to disable updates by set cn.mode=adModeRead.
> inspite
> of this, i can do modifications without error... any tip? what should i
> check?
>
|||i dont remember exactly, but nothing strange:
provider=sqloledb, login=sa..
"Val Mazur" <group51a@.hotmail.com> az albbiakat rta a kvetkezo zenetben
news:uvYHPaRoEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It could be that provider does not support this mode. What is your
> connection string?
> --
> Val Mazur
> Microsoft MVP
>
> "SRINGER Zoltn" <kecskemetisrac@.remove.it.freemail.hu> wrote in message
> news:OIj6BsMoEHA.3876@.TK2MSFTNGP15.phx.gbl...
>
|||Are you sure about connection string? I believe OLEDB for SQL Server
supports it
Val Mazur
Microsoft MVP
"SRINGER Zoltn" <kecskemetisrac@.remove.it.freemail.hu> wrote in message
news:euRGzTZoEHA.644@.tk2msftngp13.phx.gbl...
>i dont remember exactly, but nothing strange:
> provider=sqloledb, login=sa..
>
> "Val Mazur" <group51a@.hotmail.com> az albbiakat rta a kvetkezo
> zenetben
> news:uvYHPaRoEHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||hi Val,
"Val Mazur" <group51a@.hotmail.com> ha scritto nel messaggio
news:%23Pk9yndoEHA.516@.TK2MSFTNGP09.phx.gbl
> Are you sure about connection string? I believe OLEDB for SQL Server
> supports it
>
actually I tried myself with VB6, OLE DB provider, ADO 2.6 and had the same
result indeed..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label updates. Show all posts
Showing posts with label updates. Show all posts
Sunday, March 11, 2012
Thursday, March 8, 2012
Connection to remote sql server db
Hi,
I'm new to SQL and would like to connect to a remote sql server where a
website is hosted and do some updates.
I have a local sqlserver setup here, could you pl guide me
some doc or urls.
I have to backup the db frm the remote sqlserver, my host company told me to
use dts to carry out the back from their server.
Pleaase advice how can I do this
Many Thanks
Shan"shan" <shan@.discussions.microsoft.com> wrote in message
news:670104E2-8986-432A-946C-C2C41931673A@.microsoft.com...
> I'm new to SQL and would like to connect to a remote sql server where a
> website is hosted and do some updates.
> I have a local sqlserver setup here, could you pl guide me
> some doc or urls.
> I have to backup the db frm the remote sqlserver, my host company told me
to
> use dts to carry out the back from their server.
> Pleaase advice how can I do this
The host company could allow a VPN tunnel to the remote server and/or open
the proper firewall ports to/from your computer. You could then use DTS, or
TSQL to issue a BACKUP... or synchronize the updates from your computer to
the hosted version.
Steve
I'm new to SQL and would like to connect to a remote sql server where a
website is hosted and do some updates.
I have a local sqlserver setup here, could you pl guide me
some doc or urls.
I have to backup the db frm the remote sqlserver, my host company told me to
use dts to carry out the back from their server.
Pleaase advice how can I do this
Many Thanks
Shan"shan" <shan@.discussions.microsoft.com> wrote in message
news:670104E2-8986-432A-946C-C2C41931673A@.microsoft.com...
> I'm new to SQL and would like to connect to a remote sql server where a
> website is hosted and do some updates.
> I have a local sqlserver setup here, could you pl guide me
> some doc or urls.
> I have to backup the db frm the remote sqlserver, my host company told me
to
> use dts to carry out the back from their server.
> Pleaase advice how can I do this
The host company could allow a VPN tunnel to the remote server and/or open
the proper firewall ports to/from your computer. You could then use DTS, or
TSQL to issue a BACKUP... or synchronize the updates from your computer to
the hosted version.
Steve
Connection to remote sql server db
Hi,
I'm new to SQL and would like to connect to a remote sql server where a
website is hosted and do some updates.
I have a local sqlserver setup here, could you pl guide me
some doc or urls.
I have to backup the db frm the remote sqlserver, my host company told me to
use dts to carry out the back from their server.
Pleaase advice how can I do this
Many Thanks
Shan
"shan" <shan@.discussions.microsoft.com> wrote in message
news:670104E2-8986-432A-946C-C2C41931673A@.microsoft.com...
> I'm new to SQL and would like to connect to a remote sql server where a
> website is hosted and do some updates.
> I have a local sqlserver setup here, could you pl guide me
> some doc or urls.
> I have to backup the db frm the remote sqlserver, my host company told me
to
> use dts to carry out the back from their server.
> Pleaase advice how can I do this
The host company could allow a VPN tunnel to the remote server and/or open
the proper firewall ports to/from your computer. You could then use DTS, or
TSQL to issue a BACKUP... or synchronize the updates from your computer to
the hosted version.
Steve
I'm new to SQL and would like to connect to a remote sql server where a
website is hosted and do some updates.
I have a local sqlserver setup here, could you pl guide me
some doc or urls.
I have to backup the db frm the remote sqlserver, my host company told me to
use dts to carry out the back from their server.
Pleaase advice how can I do this
Many Thanks
Shan
"shan" <shan@.discussions.microsoft.com> wrote in message
news:670104E2-8986-432A-946C-C2C41931673A@.microsoft.com...
> I'm new to SQL and would like to connect to a remote sql server where a
> website is hosted and do some updates.
> I have a local sqlserver setup here, could you pl guide me
> some doc or urls.
> I have to backup the db frm the remote sqlserver, my host company told me
to
> use dts to carry out the back from their server.
> Pleaase advice how can I do this
The host company could allow a VPN tunnel to the remote server and/or open
the proper firewall ports to/from your computer. You could then use DTS, or
TSQL to issue a BACKUP... or synchronize the updates from your computer to
the hosted version.
Steve
Subscribe to:
Posts (Atom)