Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to manage them all. When I tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a message saying it's not compatible, so I'll have to use 2005 I guess. We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM work with these okay? Also I want to make sure SQL 2005 Enterprise Manager won't be adding to, changing, or 'upgrading' the DTS scripts or anythi...

Sql Server 2000 linked server to Access 97/2000 incompatability
We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. The link on this upgraded machine no longer works, giving this message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Cannot open a database created with a previous version of your application.] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize r...

Multiples Instance of SQL server 2000/SQL server 7.0 on Windows server 2003
Hi, Is it possible to install on a Windows server 2003, SQL SERVER 2000 in the folowing configuration : SQL server 7.0 as a default Instance and SQL server 2000 as a named instance. Thanks for your answer. riless (g.carali@voila.fr) writes: > Is it possible to install on a Windows server 2003, > SQL SERVER 2000 in the folowing configuration : > > SQL server 7.0 as a default Instance > > and > > SQL server 2000 as a named instance. If SQL 7 can be installed on Win2003, yes. But I would not really expect SQL 7 to be welcome on Windows 2003, although I don't...

FileMaker Server 7, Filemaker Developer v7 WinALL Mac, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MicroSoft SQL Server 2000, Service Pack 2, AppDe
FileMaker Server 7, Filemaker Developer v7 WinALL Mac, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other ... FileMaker Server 7 (26/Oct/2004 Filemaker Developer v7 WinALL Mac SN:3V294-57K77-8TKNX-7K26K-228K9-13T33-X29T9 CD NR 15 792 Clarion.v6.0.Enterprise.Edition.Incl.Keygen.WinALL (wee...

Explicitly fail a SQL Server Job in SQL Server 2000
I have a SQL Server job, which runs mutiple steps. One of the steps (step 3) looks for a record in the database. How can I explicitly fail the SQL server job if the database record does not exist? You can use RAISERROR with a severity level of 11 or higher to indicate failure. Simon Thanks Simon. That worked. ...

MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the MS SQL Server 2000 onto two computers, which reside on the same network. (In fact, these two computers comprise the entire network). The network server (computer name=SUNCDS1), and the lone node (SUNCDS2), each have their own SQL Server 2000 instance. The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2. It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise console does not show the SQL Server Agent as being started, but I can navigate to the SUNCDS2 databases, and display the table information. If I try to start the SQL Server Agent for SUNCDS2, I receive the message "Access is Denied". The enterprise console on the SUNCDS2 machine indeed shows the SQL Server Agent as being started. I have written a sample Java application that uses both the MS SQL Server ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish a connection to the SUNCDS2 instance. This application resides on the SUNCDS1 network server. The ODBC driver will connect to SUNCDS2 instance wihout a problem. The JDBC driver does not connect to SUNCDS2. The JDBC driver will, however, connect to the local SQL Server instance that resides on SUNCDS1. Following are the code snippet to est...

SQL Server 2000 Failover Cluster upgrade to SQL Server 2005
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4) database that it finds on the server. When I ckeck the install details it tells me that "Your upgrade is blocked becuase of cluster upgrade rules" I have tried searching the MS site but none of the entries I found appear to apply. Any ideas? -- Mark D Powell -- Mark D Powell (Mark.Powell@eds.com) writes: > I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) > to ...

tcl database connection for Oracle MySQL PostgreSQL Sybase "Microsoft SQL Server 2000 Desktop Engine" DB2 Interbase/Firebird SQLite Microsoft Access
Hello everyone, There are many people that are looking for/missing the support for their database within TCL. Somehow this was overlooked: http://sqlrelay.sourceforge.net/index.html It has native TCL API and supports most popular databases. One problem: It doesn't have production ready support on Windows, but for the lucky people who use Linux/Unix, it seems to be an excellent solution, while TDBC is being developed. One small correction, the TCL part of the db connection will work just fine on Windows connecting to sqlrelay running on Linux/Unix (which, in turn, can connect to the database running on Windows :) ). What doesn't have production ready support (according to developers) is sqlrelay running on Windows. ...

SQL works in Access but not in SQL Server 2000 ! Why?
I am new to MS SQL Server. I have SELECT statement which works fine using Access 2000 but when I try to use this in SQL Server 2000 I get error. Statement works fine in Access 2000: SELECT Field1, Field2 FROM Table WHERE Field1 & Field2 LIKE '%keyword1%' AND Field1 & Field2 LIKE '%keyword2%' Error I get using SQL Server 2000: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean AND, type equals float. Does anyone know how to fix this? I would really appreciate ...

Migrating From Access 2000 To SQl Server 2000
Hi, I have developed an application using VB 6 (SP 5), MS Access 2000 and Crystal Reports 9. I migrated from from access to SQl Server 2000. This wasn't a problem as i could import all the tables to SQL Server. Also, i could make VB6 talk to SQl Server. The problem arsies when i run my application. The sql syntax for access seems to be different than that for SQL Server. A simple example being: In access boolean datatype is true/false ,whereas in SQL Server the boolean equivalent is bit (numerical 1 or 0). These kind of issues are causing problems and most queries don't run. Would ...

Converting SQL Server 2000 query to MS Access 2000 query
Hello! I am trying to convert a query written for SQL Server 2000 database tables, to a MS Access query. Here is what I have in SQL Server: SELECT t2.*, CASE WHEN t2.QType = '3' THEN t1.Note ELSE CASE WHEN t2.QType = '2' THEN CASE WHEN CONVERT(varchar(100), t1.ANumber) = '1' THEN 'Yes' ELSE 'No' END ELSE CASE WHEN CONVERT(varchar(5), t2.Qnumber)+'.' + CONVERT(varchar(5), t1.ANumber) = t2.SubQ THEN 'Selected' ELSE 'Not Selected' END END END AS Client_Response FROM (SELECT * FROM ClientAnswer WHER...

Access database(Jet Engine) and SQL Server or SQL Server express
Hi, I am trying to find out what are the big differences between access database Jet engine and SQL Server? If I have serveral web applications (same content different copies) running as different sites(on IIS), each site using an access as a back-end database, all sites will be running simultaneously, all the access databases are on the same machine, on this approach, does each copy of access has its own Jet engine to handle database transaction or only has one Jet engine with multiple threads handles multiple copies of access database. Also, I'd like to know what kind database, and database engines are used by big sites such as Yahoo, Hotmail, MSN, etc, and what are the good database structures for the hosting applications that deal with huge,complex information and large number of users. Thanks a lot, your time and help are highly appreciated. On 13 Sep 2004 18:37:35 -0700, penghao98@hotmail.com (Leon) wrote: I think there is only one instance of Jet running. You can check this using Task Manager. More than likely you don't have to worry about Yahoo et al. They take many orders of magnitude more traffic then yours. One thing for sure: they are not using an Access back-end :-) -Tom. >Hi, > I am trying to find out what are the big differences between access >database Jet engine and SQL Server? If I have serveral web >applications (same content different copies) running as different >sites(on IIS), each site using an access as a back-end database...

migrate Progress database to MS SQL Server 2000 #2
I am afraid that our customer has already made up his mind about movin to MS SQL server and there is nothing that we can do about it Is there a migration tool -- panagiotis@mel ----------------------------------------------------------------------- panagiotis@melo's Profile: http://www.progresstalk.com/member.php?action=getinfo&userid=817 View this thread: http://www.progresstalk.com/showthread.php?threadid=7937 Yes ther is. You'll find it between your ears. Regards...Dan. "panagiotis@melo" <panagiotismelo.1gvuzm@progresstalk.com> wrote in message news:panagiotismelo.1gvuzm@progresstalk.com... > > I am afraid that our customer has already made up his mind about moving > to MS SQL server and there is nothing that we can do about it. > > Is there a migration tool? > > > -- > panagiotis@melo > ------------------------------------------------------------------------ > panagiotis@melo's Profile: > http://www.progresstalk.com/member.php?action=getinfo&userid=8173 > View this thread: > http://www.progresstalk.com/showthread.php?threadid=79374 > crossmerge.com ? Regards...Dan. "panagiotis@melo" <panagiotismelo.1gvuzm@progresstalk.com> wrote in message news:panagiotismelo.1gvuzm@progresstalk.com... > > I am afraid that our customer has already made up his mind about moving > to MS SQL server and there is nothing that we can do...

Course 2073: Programming a Microsoft SQL Server 2000 Database
Hello I need this course (Course 2073: Programming a Microsoft SQL Server 2000 Database ) from Microsoft materials. If someone knows from where can I download this materials or could sent mi thsi course, please help me. I will be very gratefull. Thanks ...

Entreprise Manager error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '#####'. The user is not associated with a trusted SQL Server connection.(28000,18452)"
Can anyone give a quick description of the meaning of this message and what needs to be done to get a connection. I'm running DBArtisan with SQLServer 2000 client SP4 installed. I also get the same message with MS Enterprise Manager so this is coming out of the actual ODBC connection attempt. Thanks in advance! In the future, please do not put part of your message in the subject line. Makes it harder to read. In any case, you're trying to do integrated login and don't have that login set up in the DB. You need to add that login, or change to a SQL Login. -- Greg Moore SQL...

Once a week Kerberos failure between IIS6 web server and SQL Server 2000 db server
Hi, Regularly once a week we get problems with a Kerberos failure on ouintranet application. Kerberos is set up with Constrained Delegation and Protocol Transition. Configuration: S3 ...

Access 2000 Linked to SQL Server 2000, openRecordset error
I'm trying to access data in vba using the openrecordset command. The data in on a SQL Server 2000 database, and I have linked tables to that data. the Table I'm trying to access is one of these linked tables, and my codes is as follows: Set vRS = CurrentDb.OpenRecordset(tbl_DataCommentLog) when this line is executed I get the error: "Run-time error '3622': You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an Identity column. " so I changed my code to: Set vRS = CurrentDb.OpenRecordset(vSQL, , dbseeChanges) Wh...

Installing MS sql server 2000 on win 2003 server
How do I do this when my instalation cd is an old veriosn with no SP�s? Win 2003 requires MS SQL 2000 SP3 sp what do I do??? Regards Anders > When you get the prompt saying that it must be SP3 you can continue to the > end of the installation as per normal. You should then install SP3 > immediately before you do anything else. SP3a can be download from the > microsoft web site. Actually not. It says: Ms SQL Server 2000 Enterprise Ediditon server componenet is not supportet on this operating system. Only client componentes will be avaible for instalation. I juts read that bef...

Microsoft Access 2003 with SQL 2000 Server
Hi, Just wonder is access 2003 compatible to sql 2000 server??? -- Message posted via http://www.accessmonster.com saya via AccessMonster.com wrote: > Hi, > > Just wonder is access 2003 compatible to sql 2000 server??? > It will connect to one if that's what you mean. -- 1f u c4n r34d th1s u r34lly n33d t0 g37 l41d ...

Database link to a MS SQL Server 2000
Hi NG, we have to replikate some data between an oracle DB and an application with MS SQL Server. There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines directly. Is there a possibility to create a DB link from oracle to MS SQL Server or otherwise? thanx abbas On Thu, 9 Jun 2005 00:13:02 +0200, "Abbas" <ar.newsgroup@web.de> wrote: >Hi NG, > >we have to replikate some data between an oracle DB and an application with MS SQL Server. > >There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines >directly. > >Is there a possibility to create a DB link from oracle to MS SQL Server or otherwise? > >thanx >abbas > Look into using Heterogeneous Services in your Net administrators manual. -- Sybrand Bakker, Senior Oracle DBA Are you willing to install a bridge program to create this "link"? If so, then try www.examinstudio.com Do as Sybrand told you, look at the Heterogenous services of Oracle. Oracle even supports natively DRDA towards a DB2 z/OS mainframe, and they also support SQL Server. They all end-up like a database link with a totally quallified names in the "from" clause. Be aware of that distributed joins between different DBMS systems might cause huge performance problems, keep the functionality when dealing with multiple DBMS systems simple, no dist...

Performance Issues
Hi, Simple question: A customer has an application using Access 2000 frontend and SQL Server 2000 backend. Data connection is over ODBC. There are almost 250 concurrent users and is growing. Have they squeezed everything out of Access? Should the move to a VB.Net frontend taken place ages ago? Cheers Mike Hi Mike, I just completed a similar conversion if that's what you're thinking of doing. We converted 100 forms, 60 access reports and 15,000 lines of code "TO" 100 forms, 60 crystal reports, and 75,000 lines of VB.net code. It was a nightmare. We spent a good 50 perc...

Linked Server Limit in SQL Server 2000
I am about to start working on a project where I would be required to dynamically create linked servers during the execution of an application. One of the requirements is for the Link Servers to be created and dropped before and after the retrieval of the data. My question is about any type of cap on the number of linked servers SQL Server 2000 can have registered at any single time. If I find out that there is some type of cap, I would need to look into another way to deal with my linked server needs. Thanks for any help/information you might be able to provide. TBlair (tblair23221@yahoo.co...

Problem mit der Abfrageansicht bei Access 2000 / SQL Server 2000
Ich habe eine Datenbank die vorher komplett in Access war. Jetzt habe ich die Tabellen von Access auf SQL-Server portiert und in die Access-Datenbank als Frontend verkn�pft. Jetzt habe ich folgendes Problem: Vorher als die Tabelle noch in der Access-Datenbank war konnte ich die Tabelle (oder auch eine Abfrage darauf) �ffnen und wenn ich durch die Tabelle gescrollt habe indem ich den Scrollbalken auf der rechten bewegt habe (nicht mit dem Mausrad!) wurden w�hrend des Scrollens die Inhalte der Datens�tze in echtzeit mitbewegt. Bei der Variante wo die Tabellen jetzt auf dem SQL-Server liegen ist es nun so, dass der Inhalt der Datens�tze erst dann angezeigt wird, wenn ich mit dem Scrollbalken wieder anhalte (w�hrend des Scrollvorgangs selber wird also immer das Bild mit den Ursprungsdatens�tzen angezeigt) Hat jemand eine Idee ob es m�glich ist, die "alte" Funktionalit�t durch Einstellungen von Access oder SQL-Server wieder hin zu kriegen? Ich habe schon nach Einstellungen gesucht, die bewirken, dass man beim �ffnen sofort die ganze Tabelle geladen wird oder sowas �hnliches, aber ich hab nichts derartiges gefunden. Vielen Dank im Voraus. Matthias J�rgens ...

Using both IS NULL and IS NOT NULL in Access 2000 Pass Through Query (for SQL Server 2000)
Hello, I'm in the process of changing our 'normal' Access 2000 update queries to Update Pass Through Queries. We have a SQL server 2000 database and we're using an Access 2000 database as our front end. In the criteria of one of our update query fields, we use both the isnull(field1) and Not IsNull(field2) then Field3, otherwise, set the updated field as null. Here's my converted Pass Through Query : UPDATE Vsel SET VSel.Cert1 = IIf(IsNull(VSel.Cert1), RenArch.Cert1), VSel.Cert2 = IIf(IsNull(VSel.Cert2), RenArch.Cert2), VSel.Cert3 = IIf(IsNull(VSel.Cert3), RenArch.Cert3), VSel.Cert4 = IIf(IsNull(VSel.Cert4), RenArch.Cert4), VSel.Cert1ExpDt = IIf(IsNull(BDACmpltDt) AND IS NOT NULL (RenArch.Cert1), RenArch.CDDt), VSel.Cert2ExpDt = IIf(IsNull(BOMSADtIssd) AND IS NOT NULL (RenArch.Cert2), RenArch.CDDt), VSel.Cert3ExpDt = IIf(IsNull(BDPMADtIssd) AND IS NOT NULL (RenArch.Cert3), RenArch.CDDt), VSel.Cert4ExpDt = IIf(IsNull(BOACmpltDt) AND IS NOT NULL (RenArch.Cert4), RenArch.CDDt), VSel.BDACmpltDt = IIf(IsNull(BDACmpltDt), RenArch.Cert1DOC), VSel.BOACmpltDt = IIf(IsNull(BOACmpltDt), RenArch.Cert4DOC), VSel.BDPMADtIssd = IIf(IsNull(BDPMADtIssd), RenArch.Cert3DOC), VSel.BOMSADtIssd = IIf(IsNull(BOMSADtIssd), RenArch.Cert2DOC) FROM VSel INNER JOIN RenArch ON VSel.SSN = RenArch.SSN This is the original criteria in the access update query for line #6 (when I start to use both is null and is not null) IIf(IsNull([BDACmpltDt]) And Not IsNull([RenArch].[Cert1]),[Re...