I want to check if a database server is listening for connection before to connect to this database server. I heard that Weblogic comes with a class called java.util.dbping which does this. However, I am not sure whether other lagnuages have a similar one. To make it short, I am looking fo...more >>

I am trying to connect to a MSDE database using SQL Query Analyser and Client Network Utility, using Windows authentication -- but I get this error.... Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. How do I set up my PC or the other PC so it...more >>

Hey, I have seen tons of posts but no real solution for the "Unable to open connection. Provider cannot be found. It may not be properly installed." error message when trying to connect to OLAP. Even after running SP3 it doesn't work. Well, you need to go to the sql2ksp3/msolap/install/ fol...more >>

I have a question on when and where we should create connections to SQL. I have a base class that handles all data access and dishes up connections etc as needed. I initially had a class level connection object that all general dataacess methods used to execute against. This introduced a proble...more >>

We have a SQL 2000 (SP3) server that is giving us a problem with a particular table. When we try to make any changes (additions or modifications) to records in this table through Access, there is a long pause and then we get the error: ODBC--update on a linked table 'TABLENAME' failed. [Micro...more >>

Hello, I would like to know if I can remote conect to an sql server using the IP adress instead of the server name. I want to administrate the database under internet (the target server has a known ip address). Thanks in advance for any help! -- Alberto van Drunen drunen@serttel.com.br ...more >>

Hello, I have been attempting to configure an intregrated (AD and Windows) authentication between two servers running an ASP.NET/SQL Server 2000 environment for months. I have not been able to make this work as documented, no matter what KB articles I follow or how much I upgrade software. ...more >>

we monitor "Number of Deadlocks/sec" use system monitor and SQL alert, but we get the very different result, system monitor only get 1 or 0 SQL alert get mor than 100. Why the value is so fidderent? which value can we use for performance tuning? Thanks....more >>

I have an application written using powerbuilder and want the application end users to connect using the OLEDB drivers. How do we setup the Client machines to be able to connect. In ODBC we created a system DSN. What do you need to do for OLEDB?? Thanks, Anjelina...more >>

Hi When connection from MS Project 2002 using the Enterprise options, I'm confronted with a dialogue-box saying: Connection failed: SQLState: '01000' SQL Server Error: 53 [Micosoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Ser...more >>

Hi, We have a SQL 2000 which is used as CMS and application database. Recently the web site seems very unstable and hangs a few times per day. When the problem occurs, we just stop and restart the SQL service, then it works. In the application error log, it says "[Microsoft ODBC Driver]...more >>

Is there a way to grant access to a SQL Server database while not permitting connections via SQL Enterprise Manager. We find that it is showing all the database names (even those for which the connecting user has no access/permissions), and this is a security exposure. Thanks! ...more >>

Hi, I'm getting the following error (loosely translated from the German) while trying to query a view in a linked server: View SELECT AUFTLT FROM AUFTRAEGE WHERE (AUFTLT > convert(datetime, '20030714',112 )) Error: During the converstion of a char-datatype in a datetime-datatype, the d...more >>

This is the error my user is getting. The environment is clustered. He can connect to the other two clustered environments in QA and dev. but not in production. Connection failed SqlState:'01000' SQL Server Error:10061 [Microsoft][ODBC SQL Server Driver][TCP/IP sockets] ConnectionOpen (...more >>

Hi, I'm running SQL Server 2000 that came with Office XP developer. I am trying to connect to a default instance of SQL Server through a C# file using the SQLConnection object. ie, SqlConnection cn; cn = new SqlConnection ("server=xxx;uid=sa;pwd=zzz;database=Northwind;" ); My O...more >>

I installed the SQL Critical Update Kit to get rid of the Slammer. I am now unable to use user id = sa to login. Any thoughts?...more >>

My NT4.0 server is running SQL 7.0. My clients are a mix of NT4.0 workstation and Win2k Pro. The problem is on my NT4.0 clients which are on a wireless network. I keep on getting the following error ... 7/22/2003 2:19:31 PM Module...Inven Activity...Inven.bas, GetPaperID. Error -21474672...more >>

Dear All, In my VC++ program I am trying to connect to SQL Server 2000 using ADODB. When I am using windows authentication ( ie strConnection = "Driver={SQL Server};Server=MyServerName;Database=MyDatabaseName;Trusted _Connection=yes;" ) it is very slow( Approx 60 %less) when compare...more >>

I'm working with SS2K, and this error appeared over the weekend. The error occurs during service startup when trying to create TEMPDB.MDF, and so, the SQLServer service will not start. Anyone see this before or have some suggestions? Thanks...more >>

Can SQL Server 2000 EE in a standalone environment automatically adjust to a change of the server IP address?...more >>

I have error in system log with master.mdf I have run the REBUILDM.....but get error with negative 1 I cannot restart the SQL SERVER at all PLEASE HELP...more >>

Hi to all, i just installed Sql Server 2000 in a machine and i want to connect from another one, that has Sql Server 7 installed on it. I use Enterprise Manager but it keep telling me that "No Sql Server found or access denied". I have tried to declare the alias in Client Network Utility b...more >>

I have 3 instances of SQL server running on a single box. How do I identify the TCP/IP port used by each instance on that box, so that I can define the network connections properly at any client site? Thanks......more >>

When a try to connect a SQL Server from another server, which is a Web Server (DMZ enviroment) it takes a lot of time. Is there any special configuration for this??? ...more >>

I would like to write a store procedure that authicates a user and their password against the SQL database user login and password. Since the password is encrypted I don't know how you would do this. Can some one help - this is my proposed procedure CREATE proc u...more >>

Can the SQL 2000 client network utilities ba installed on a Windows 2003 Web Edition server? I get an error when i try to run the setup program "windows cannot open this program since it has been disabled". ...more >>

I have never used MS SQL SERVER before but I've been asked to develop a system that has connections to an OPC SERVER, is this possible and if so, how easy/difficult is it to achieve the connection? Any help provided would be most appreciated. ...more >>

I get the following error when trying to connect to a server using SQLDMO in a VB Class -2147221499 [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION When the variable is declared local to the procedure... Dim objServer as New SQLDMO.SQLServer objServer.LoginSecure = False ...more >>

Goal To issue a command inside the SQL Server Query Analyzer that will display all the columns of a table. What I Tried To Do Issue a command inside the Query window of the SQL Query Analyzer "desc myTableName" and desc table myTableName" where myTableName is the name of a...more >>

I have just installed SQL Server 2000 SP3 on 2000 server and on my xp computer. I am attempting to connect to the Server through the Analysis Manager, and I am getting an error of: Cannot connect to the Analysis server on computer 'computer name' Connection to the server is lost. I can ...more >>

A customer uses sql7 in combination with my vb app. My connection is with ADO 2.5, de first 30 users works fine, average perfomance, then suddenly (possibly user #31 ?) the connection takes more then 5 minutes. the connect string is for all users is: "Provider=sqloledb;driver={SQL Server};u...more >>

I tried to open an application which connects to my SQL server 7 database but an error message appears stating that Login Incorrect - cannot connect to database error. What seems to be the error?...more >>

We have SQL2000 in our Los Angeles office. Our New York office workstations connect to the L.A. server via DSL. The time that it takes for the data to travel to New York is too long. If i setup a SQL2000 Server in New York to connect to L.A.'s SQL2000 Server and the NY stations to connect to t...more >>

Hi all, Is it possible to connect to and manage sql servers that are not part my AD domain. I have two sql servers that are part of a workgroup. I am unable to connect to these two servers. I keep getting a access denied error when i try to connect via enterprise manager. I am using the S...more >>

I'm trying to figure out how to connect to my SQL2000 server via VB6 code. I do not want to use an ODBC connection, but simply use a direct connection. Can anyone give me an example of how this should be written? Thanks in advance, Darrick ...more >>

Dear all, Can i install the SQL 2000 Server Enterprise Edtion into W2k Server Standard edition? Please advise. Thanks Regards, Stephanie Onf...more >>

-- I connect to server with: exec sp_addlinkedserver '172.30.170.16' go exec sp_addlinkedsrvlogin '172.30.170.16', 'false', NULL, 'sa', 'password' -- Select statments like below work fine: select * from [172.30.170.16].db_dibrs.dbo.rmt_db_table -- HOWEVER, the following statements generate e...more >>

I would like to connect to SQL Server from Access using OLEDB. So, setting up a ODBC data source. Does anyone have any code for that ? Thanks, Craig *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I am running an application that is running on the default instance of a SQL server. Users work on the application fine, but sometimes receive the following error. I contacted the software company for the application and they argue that it is a server issue. The error is as follows: ...more >>

Hi, instead of a pure linked server connection (which I have set up successfully already), I would need the functionality of liked tables (i.e. being able to access tables in regular, not 4-part syntax and get the access re-routed to the linked server). Is there any way of setting up t...more >>

Hello, I am having very strange behaviour from a SQL 2000 Box. We installed the box and it appeared to be working fine for some time. Recently it started giving problems for port 1433. SQL Server is started. If I telnet into port 1433 of the SQL box, it answers, but when I do several co...more >>

When I run the following query: SELECT A.EMPLID, A.NAME, (CONVERT(CHAR (10),A.PAY_END_DT,121)), A.DEPTID, A.ACCT_CD, A.DED_CUR, A.EARNINGS, A.TAX_CUR, A.ACCOUNTING_PERIOD, A.FISCAL_YEAR FROM PS_NSCC_PAY_DIST_V A WHERE A.FISCAL_YEAR = :1 AND A.ACCOUNTING_PERIOD = :2 I Get the follo...more >>

I have a problem after I install SQL and netSDK examples, I have problem with my internet connection. after instsalling the SQL I run my computer for about 30 mins to 1hr the internet connection will go down, and after I restart my computer I get connection againm but for about 30mins and 1hrs...more >>

Hi, I am having problems connecting to a recovered database. I recovered .mdf file from failed harddrive. Put file on a new machine, used "Attach Database" wizard, and am able to see it, run queries, etc. (as dbo, sa). All tables and stored procedures in the database are owned by a user (le...more >>

Hey List! I have a question regarding user permissions. When setting up a user to have access to a database on SQL Server 2000 I am able to deny him access to other databases on the server. Although the user does not have the ability to access other databases, the databases are still v...more >>

I would like to run a stored proc in a local database and do a select into a local table from a remote database. I know the tcpip address of the remote server, and have a login and password. How can I connect to the remote database, do the select and log off from within the local stored ...more >>

This is the error: Microsoft OLE DB Provider for SQL Server (0x80004005) Login failed for user 'et'. Reason: Not associated with a trusted SQL Server connection. However, the thing is, I dunno why it is getting that. I have created the 'et' user and it utilizes the SQL Authentication to g...more >>

Hi, I have had a problem with an user trusted (DOMAIN\USER). This user tries to connect to SQL2000 SP3 by a drive ODBC=20 for example and this message appears. This problem not=20 happen when used named pipes, but is too slow. There are many users, but only one user has the problem.=20 The...more >>

Would like some references to read about the ports in use for SQL traffic and Crystal Report queries to an SQL server. We have a client who's SQL access may move from the local LAN to a WAN access method and I need to determine how much bandwidth it could take. Much appreciation in advance ...more >>

Quick question: I have a Server 2003 box that I need's an ODBC connection to a NT 4 Server box with SQL 7 on it for old legacy home grown apps. When I try to setup the connection on the 2003 box, after selecting the SQL Server driver, it only shows our SQL 2000 boxes and none of the SQL 7 box...more >>