VB & Database, MTS VB and clsutered SQL server 7.0

MTS VB and clsutered SQL server 7.0

Author	Message
jc #1 / 4	MTS VB and clsutered SQL server 7.0 I have written a VB data access with MTS enabled to SQL 7.0 and it works fine. However, when this component was used to connect to a cluster SQL 7.0, it produces the MSDTC transaction error. In a normal SQL server, the MSDTC and SQL server are using the same IP address. In a cluster SQL server, the MSDTC and the SQL cluster has different IP. In a VB string, Private Const scCONNECT_SHAPE = "Provider=MSDataShape;DSN=Duwamish_Phase3.5" , the DSN only provides the SQL address and not the MSDTC address, any idea how how we can use MTS with SQL cluster? jc
Fri, 20 Sep 2002 03:00:00 GMT

Michael D. Lon #2 / 4	MTS VB and clsutered SQL server 7.0 Are you certain that you followed the installation guidelines for SQL Server on an MSCS cluster? I know the MTS configuration requires a specific installation sequence, else you have the type of problem that you are observing. Mike Quote: > I have written a VB data access with MTS enabled to SQL 7.0 and it works > fine. However, when this component was used to connect to a cluster SQL > 7.0, it produces the MSDTC transaction error. In a normal SQL server, > the MSDTC and SQL server are using the same IP address. In a cluster SQL > server, the MSDTC and the SQL cluster has different IP. In a VB string, > Private Const scCONNECT_SHAPE = > "Provider=MSDataShape;DSN=Duwamish_Phase3.5" , the DSN only provides the > SQL address and not the MSDTC address, any idea how how we can use MTS > with SQL cluster? > jc
Fri, 20 Sep 2002 03:00:00 GMT

jc fan #3 / 4	MTS VB and clsutered SQL server 7.0 Hi Mike, I believe I have followed the guidelines of installing the cluster SQL server as explained in "Windows NT Cluster Server GuideBook" by David Libertone. I have the membership server that works with standard SQL server and now I have an error "0x80072014L" in the Win32 error codes for ADSI, which has an explanation of LDAP_OBJECT_CLASS_VIOLATION ERROR_DS_OBJ_CLASS_VIOLATION. Have you ever tried out using object.setcomplete and object.setabort with clsuter SQL server? Any advice would be helpful. Thanks * Sent from Devdex.com http://www.devdex.com The Web Developers Index * The world's largest index site for Microsoft web technologies.
Fri, 27 Sep 2002 03:00:00 GMT

Michael D. Lon #4 / 4	MTS VB and clsutered SQL server 7.0 No, I haven't run SQL Server in this configuration. When I ran MTS on MSCS I was using Oracle on Solaris as a backend. Looking back to your original post I note that you reference 2 addresses - one for SQL Server and the other for DTC. This should not be the case, as both should be using the external address of the cluster. If either is using an address that is assigned to an adapter in either physical machine, then the configuration is incorrect. As to the book/paper you reference I am not familiar with it. I would reference the material supplied by Microsoft, and pay special attention to the most recent MSKB articles. How to Install SQL Server 7.0 EE on MSCS: Step by Step Instructions http://support.microsoft.com/support/SQL/Content/70Papers/70clstr.asp... G&SA=ALLKB&FR=0 INF: Installation Order: Cluster Server Support for SQL or MSMQ http://support.microsoft.com/support/kb/articles/Q192/7/08.ASP?LNG=EN... LKB&FR=0 INF: Order of Installation for SQL Server 7.0 Clustering Setup http://support.microsoft.com/support/kb/articles/Q219/2/64.ASP?LNG=EN... LKB&FR=0 My experience with MSCS is that it is rather unforgiving with regard to installation and configuration. I ended up reinstalling the cluster and paying close attention to detail. Mike Hi Mike, I believe I have followed the guidelines of installing the cluster SQL server as explained in "Windows NT Cluster Server GuideBook" by David Libertone. I have the membership server that works with standard SQL server and now I have an error "0x80072014L" in the Win32 error codes for ADSI, which has an explanation of LDAP_OBJECT_CLASS_VIOLATION ERROR_DS_OBJ_CLASS_VIOLATION. Have you ever tried out using object.setcomplete and object.setabort with clsuter SQL server? Any advice would be helpful. Thanks * Sent from Devdex.com http://www.devdex.com The Web Developers Index * The world's largest index site for Microsoft web technologies.
Fri, 27 Sep 2002 03:00:00 GMT

Page 1 of 1

[ 4 post ]