dts and bit fields

sql2k sp2
If I dts data from a table to a .txt file all of the data
in the bit field gets turned into a "true" or "false"
value. Is there a way to turn this setting off?
TIA, ChrisDid not test, but
turn the column to allow null, then when dts, do not load the column.
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:014401c3c995$94930900$a501280a@.phx.gbl...
> sql2k sp2
> If I dts data from a table to a .txt file all of the data
> in the bit field gets turned into a "true" or "false"
> value. Is there a way to turn this setting off?
> TIA, Chris|||DTS a query or view rather than the base table.
In the query or view, use CONVERT or CAST to cast the bit column to integer
(or what you want).
James Hokes
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:014401c3c995$94930900$a501280a@.phx.gbl...
> sql2k sp2
> If I dts data from a table to a .txt file all of the data
> in the bit field gets turned into a "true" or "false"
> value. Is there a way to turn this setting off?
> TIA, Chris

DTCPing works, but distributed transaction cannot be started

Hi!
I'm getting an error when trying to start simple distributed
transaction.
Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
DTCPing works in both directions, but there is one strange thing in log
on cluster server:
Cluster Environment detected
03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
(Mask:255.255.255.248) (38)
MSDTC Virtual Name:DTC1, IP:
When used internal an IP address, there is no such message.
Here is a full log of DTC ping on a cluster:
Platform:Windows 2003
cluster environment detected:
Windows 2003,sp1 environment is detected:
Reading MSDTC settings from cluster registry:
NetworkDtcAccess :true
NetworkDtcAccessAdmin :true
NetworkDtcAccessClients :true
NetworkDtcAccessTransactions:true
NetworkDtcAccessTip :false
XaTransactions :true
TurnOffRpcSecurity :true
NetworkDtcAccessOutbound :true
NetworkDtcAccessInbound :true
FallbackToUnsecureRPCIfNecessary:false
AllowOnlySecureRpcCalls :false
AccountName :NT AUTHORITY\NetworkService
IP Configure Information
Host Name . . . . . . . . . : HOSTA1
DNS Servers . . . . . . . . : 192.168.0.8
192.168.0.7
207.x.x.250
63.x.x.5
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no
Ethernet adapter {BBA542FC-1328-4246-A31B-16379406424B}:
Description . . . . . . . . : BASP Virtual Adapter
Physical Address. . . . . . : 00-10-18-14-4C-4E
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 192.168.0.103
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.101
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.100
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.105
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.107
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.8
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
Ethernet adapter {52ED9D48-488E-4265-AC55-3CE5BBFDBF23}:
Description . . . . . . . . : Broadcom NetXtreme Gigabit
Ethernet
Physical Address. . . . . . : 00-14-22-73-F9-C9
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 207.x.x.253
Subnet Mask . . . . . . . . : 255.255.255.248
IP Address. . . . . . . . . : 207.x.x.251
Subnet Mask . . . . . . . . : 255.255.255.248
IP Address. . . . . . . . . : 207.x.x.250
Subnet Mask . . . . . . . . : 255.255.255.248
Default Gateway . . . . . . : 207.x.x.249
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
193.x.x.147 HOSTB1
Cluster Environment detected
03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
(Mask:255.255.255.248) (38)
MSDTC Virtual Name:DTC1, IP:
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for
++++++++++++++++++++++++++++++++++++++++++++++
Firewall Port Settings:
Port:5000-5200
RPC server is ready
03-06, 06:52:51.078-->RPC server: received following information:
Network Name: HOSTA1
Source Port: 5069
Partner LOG: HOSTB15232.log
Partner CID: CA74E8B7-5274-40DF-97F0-CCF7B89895A9
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
03-06, 06:52:51.296-->Trying to Reverse Bind to HOSTB1...
Test Guid:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
Name Resolution:
HOSTB1-->193.x.x.147-->HOSTB1
Reverse Binding success: -->HOSTB1
++++++++++++Reverse Bind Test ENDED++++++++++
03-06, 06:52:52.296-->Called POKE from Partner:HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
++++++++++++Validating Remote Computer Name++++++++++++
03-06, 06:52:55.140-->Start DTC connection test
Name Resolution:
HOSTB1-->193.x.x.147-->HOSTB1
03-06, 06:52:55.156-->Start RPC test (-->HOSTB1)
RPC test is successful
Partner's CID:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to HOSTB1
03-06, 06:52:55.296--> Initiating DTC Binding Test...
Test Guid:66C8FDED-CEC3-4C56-A4F6-F6EA236DAD5F
Received reverse bind call from HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
Binding success: -->HOSTB1
++++++++++++DTC Binding Test END+++++++++++++
Anyone can help me?
|||See if this helps.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://support.microsoft.com/kb/555017/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<maqdev@.gmail.com> wrote in message
news:1141651435.453798.152890@.u72g2000cwu.googlegr oups.com...
> Hi!
> I'm getting an error when trying to start simple distributed
> transaction.
> Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K
> ----
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
> ----
> DTCPing works in both directions, but there is one strange thing in log
> on cluster server:
> ----
> Cluster Environment detected
> 03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
> (Mask:255.255.255.248) (38)
> MSDTC Virtual Name:DTC1, IP:
> ----
> When used internal an IP address, there is no such message.
> Here is a full log of DTC ping on a cluster:
> ----
> Platform:Windows 2003
> cluster environment detected:
> Windows 2003,sp1 environment is detected:
> Reading MSDTC settings from cluster registry:
> NetworkDtcAccess :true
> NetworkDtcAccessAdmin :true
> NetworkDtcAccessClients :true
> NetworkDtcAccessTransactions:true
> NetworkDtcAccessTip :false
> XaTransactions :true
> TurnOffRpcSecurity :true
> NetworkDtcAccessOutbound :true
> NetworkDtcAccessInbound :true
> FallbackToUnsecureRPCIfNecessary:false
> AllowOnlySecureRpcCalls :false
> AccountName :NT AUTHORITY\NetworkService
> IP Configure Information
> Host Name . . . . . . . . . : HOSTA1
> DNS Servers . . . . . . . . : 192.168.0.8
> 192.168.0.7
> 207.x.x.250
> 63.x.x.5
> Node Type . . . . . . . . . :
> NetBIOS Scope ID. . . . . . :
> IP Routing Enabled. . . . . : no
> WINS Proxy Enabled. . . . . : no
> NetBIOS Resolution Uses DNS : no
>
> Ethernet adapter {BBA542FC-1328-4246-A31B-16379406424B}:
> Description . . . . . . . . : BASP Virtual Adapter
> Physical Address. . . . . . : 00-10-18-14-4C-4E
> DHCP Enabled. . . . . . . . : no
> IP Address. . . . . . . . . : 192.168.0.103
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.101
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.100
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.105
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.107
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.8
> Subnet Mask . . . . . . . . : 255.255.255.0
> Default Gateway . . . . . . :
> DHCP Server . . . . . . . . : 255.255.255.255
> Primary WINS Server . . . . : 0.0.0.0
> Secondary WINS Server . . . : 0.0.0.0
> Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
> Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
> Ethernet adapter {52ED9D48-488E-4265-AC55-3CE5BBFDBF23}:
> Description . . . . . . . . : Broadcom NetXtreme Gigabit
> Ethernet
> Physical Address. . . . . . : 00-14-22-73-F9-C9
> DHCP Enabled. . . . . . . . : no
> IP Address. . . . . . . . . : 207.x.x.253
> Subnet Mask . . . . . . . . : 255.255.255.248
> IP Address. . . . . . . . . : 207.x.x.251
> Subnet Mask . . . . . . . . : 255.255.255.248
> IP Address. . . . . . . . . : 207.x.x.250
> Subnet Mask . . . . . . . . : 255.255.255.248
> Default Gateway . . . . . . : 207.x.x.249
> DHCP Server . . . . . . . . : 255.255.255.255
> Primary WINS Server . . . . : 0.0.0.0
> Secondary WINS Server . . . : 0.0.0.0
> Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
> Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
>
> ++++++++++++lmhosts.sam++++++++++++
>
> ++++++++++++hosts ++++++++++++
> 127.0.0.1 localhost
> 193.x.x.147 HOSTB1
>
> Cluster Environment detected
> 03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
> (Mask:255.255.255.248) (38)
> MSDTC Virtual Name:DTC1, IP:
> ++++++++++++++++++++++++++++++++++++++++++++++
> DTCping 1.9 Report for
> ++++++++++++++++++++++++++++++++++++++++++++++
> Firewall Port Settings:
> Port:5000-5200
> RPC server is ready
> 03-06, 06:52:51.078-->RPC server: received following information:
> Network Name: HOSTA1
> Source Port: 5069
> Partner LOG: HOSTB15232.log
> Partner CID: CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> ++++++++++++Start Reverse Bind Test+++++++++++++
> Received Bind call from HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> 03-06, 06:52:51.296-->Trying to Reverse Bind to HOSTB1...
> Test Guid:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> Name Resolution:
> HOSTB1-->193.x.x.147-->HOSTB1
> Reverse Binding success: -->HOSTB1
> ++++++++++++Reverse Bind Test ENDED++++++++++
> 03-06, 06:52:52.296-->Called POKE from Partner:HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> ++++++++++++Validating Remote Computer Name++++++++++++
> 03-06, 06:52:55.140-->Start DTC connection test
> Name Resolution:
> HOSTB1-->193.x.x.147-->HOSTB1
> 03-06, 06:52:55.156-->Start RPC test (-->HOSTB1)
> RPC test is successful
> Partner's CID:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> ++++++++++++RPC test completed+++++++++++++++
> ++++++++++++Start DTC Binding Test +++++++++++++
> Trying Bind to HOSTB1
> 03-06, 06:52:55.296--> Initiating DTC Binding Test...
> Test Guid:66C8FDED-CEC3-4C56-A4F6-F6EA236DAD5F
> Received reverse bind call from HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> Binding success: -->HOSTB1
> ++++++++++++DTC Binding Test END+++++++++++++
>

DSN-less connection to SQL Server with sql 7 and sql 2k

Hi,
I have commercial asp webspace hosting an application that connects to
an SQL machine on my local network. THe machine has both SQL 7 and SQL
2k running on it. Webspace and SQL are both running on Win2k.
The connection string I am using is as follows:
Application("Application_ConnectionString") = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=aaa.bbb.ccc.ddd,1433;" & _
"Initial Catalog=DBName;" & _
"User ID=xxx;" & _
"Password=yyy;"
It works fine when pointing to a database in the sql 7 instance. But
what I want to achieve is to connect to a database in the sql 2k
instance. Running locally, I can achieve this by substituting
aaa.bbb.ccc.ddd\servername_sql2k. But I cannot get it to connect to
the sql 2k instance from the commercial webspace. I get the following
message in this case:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBMSSOCN]General network error. Check your network documentation.
SO, my question is, how do you address a database in the sql 2k
instance via a dsn-less connection? Do you have to set SQL 7 and SQL
2k to listen on different ports? I have tried this but have not met
with success.
Any help gratefully received...
Thanks in advanceCan you make a connection from a DSN from the commercial webspace using
aaa.bbb.ccc.ddd\servername_sql2k as the server name?
Also can you connect via Query Analyzer form the commercial webspace using
that servername?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi Rand
Thanks for your reply. Restricted access to the commercial web space
means that I DSN cannot be established, hence the DSN less connection.
For that reason I cannot try your suggestion of connecting Query
Analyser from that server. However, I have ascertained that both
instances of SQL Server can be reached from an external server by
connecting from a server where where I do have SQL and OS level
access.
rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<A1F7CV6gEHA.480@.cpms
ftngxa06.phx.gbl>...
> Can you make a connection from a DSN from the commercial webspace using
> aaa.bbb.ccc.ddd\servername_sql2k as the server name?
> Also can you connect via Query Analyzer form the commercial webspace using
> that servername?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.

DSN-less connection to SQL Server with sql 7 and sql 2k

Hi,
I have commercial asp webspace hosting an application that connects to
an SQL machine on my local network. THe machine has both SQL 7 and SQL
2k running on it. Webspace and SQL are both running on Win2k.
The connection string I am using is as follows:
Application("Application_ConnectionString") = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=aaa.bbb.ccc.ddd,1433;" & _
"Initial Catalog=DBName;" & _
"User ID=xxx;" & _
"Password=yyy;"
It works fine when pointing to a database in the sql 7 instance. But
what I want to achieve is to connect to a database in the sql 2k
instance. Running locally, I can achieve this by substituting
aaa.bbb.ccc.ddd\servername_sql2k. But I cannot get it to connect to
the sql 2k instance from the commercial webspace. I get the following
message in this case:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBMSSOCN]General network error. Check your network documentation.
SO, my question is, how do you address a database in the sql 2k
instance via a dsn-less connection? Do you have to set SQL 7 and SQL
2k to listen on different ports? I have tried this but have not met
with success.
Any help gratefully received...
Thanks in advance
Can you make a connection from a DSN from the commercial webspace using
aaa.bbb.ccc.ddd\servername_sql2k as the server name?
Also can you connect via Query Analyzer form the commercial webspace using
that servername?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Hi Rand
Thanks for your reply. Restricted access to the commercial web space
means that I DSN cannot be established, hence the DSN less connection.
For that reason I cannot try your suggestion of connecting Query
Analyser from that server. However, I have ascertained that both
instances of SQL Server can be reached from an external server by
connecting from a server where where I do have SQL and OS level
access.
rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<A1F7CV6gEHA.480@.cpmsftngxa06.phx.gbl>...
> Can you make a connection from a DSN from the commercial webspace using
> aaa.bbb.ccc.ddd\servername_sql2k as the server name?
> Also can you connect via Query Analyzer form the commercial webspace using
> that servername?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.