I'm not sure which newsgroup to ask this question, so I'll try to do it here first. I have a domain called Tower, subnet is 192.168.1.* I have a SQL 2k server where my webpages and tables reside. The client details page has the client's home info, and a <img scr> link to their photo. ...more >>

Hello, I posted this to the FrontPage Programming list last week but was unable to resolve the problem. I am reconstructing a web site for a remote customer and have a login problem with an FrontPage 2000 database results page. Database Results Error [Microsoft][ODBC SQL Server Driver][S...more >>

I have a .net web application that is running on a w2k server located in our DMZ it has a private address. The SQL server is also running on a w2k server but it is located in our private network. I have opened port 1433 on the firewall from the DMZ to Lan and from Lan to DMZ. Since neither server...more >>

I saw a previous post regarding a similar situatiuon I have but do not have a solution yet. In my case, I have created and instance of MSDE2000A and it runs fine with securitymode=sql and sapwd set etc. In my application, I connect to the instance of the server and the application runs fin...more >>

I have a server with sbs2003 and isa, where is my sql database. I need to connect some clients to my database over the internet. What sould I do. Thanks...more >>

I ran the Upsizing wizard to convert an Access file to a SQL file. Everything worked fine before. I changed my connection string and now I get: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbl_MRSongs'. /impulse/i...more >>

Hi NG, I have problems when trying to restart my SQL-Server programmatically by using SQL-DMO. Restarting of SQL works fine, if SQL is already running. But when SQL is stopped I get a HR 0x80070006 (E_HANDLE) when calling Start(): Any suggestions? Thanks for help, rene Example: if ...more >>

Hi My SQL server is lisening on port 1433 for security reasnd I would like to change to another port can anyone recommed another specific port or it desn't matter. Thanks in advance, Shmuel ...more >>

I restored a database called 'MyDatabase' from a backup file. It created a user for me with the same name but no login with the same name. When I tried to create a login id with the same name (MyDataBase), it does not let me the same login id have privileges to access that database. I tried to do th...more >>

HI, I have attempted to connect a user to a SQL 2000 server, running on a Windows 2000 server using Windows Authentication and always get the follwoing error message: Connection failed SQLstate:'28000' sql server error: 18456 [microsoft][odbc sql server driver][sql server] login failed fo...more >>

Hello When I use a PreparedStatement (in jdbc) with the following query: SELECT store_groups_id FROM store_groups WHERE store_groups_id IS NOT NULL AND type = ? ORDER BY group_name It takes a significantly longer time to run (the time it takes for executeQuery() to return ) than ...more >>

I'm creating connection object to SQL Server db this way Set objConn = New ADODB.Connection objConn.CursorLocation = adUseClient objConn.ConnectionString = "PROVIDER=MSDASQL;dsn=Coordinator;uid=vladc;pwd=developer4444;database=SRS;" objConn.ConnectionTimeout = 1 objConn...more >>

Sorry if this question is a little high-level, I'm the DBA and don't really know too much about ISA. We have a web server in our DMZ that wants to connect through an ISA server to a SQL Server. There is a rule setup on the ISA server that allows connectivity on port 1433 (sql) which will point t...more >>

I have a stored proc on a server called lax-dd and the stored proc name is test. Both servers are in the same domain and the sa passwords are the same on both servers. I in query analyzer run exec lax-dd.dbname.dbo.test. I get errors it doesn't understand the dash(-) in the servername. ...more >>

I have two servers that have IIS and SQL 2000. the first one is where I have my webpages. The second one is where I have my sql tables. The second server's IIS has anonymous login unchecked (same with the first server). I want to use the person's windows login for authentication. In th...more >>

I am running a third-party web application (mainly ASP and specific pages with their own extension that are processed by a third-party ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain controller and has MS SQL 2000 installed. Anonymous access in IIS for this application is se...more >>

I have our DBA complaining that I have changed something on the network. He can only browse for available SQL servers in the subnet where Enterprise Manager is installed. I verified that this is indeed the case. He has a need to use a SQL database monitoring software to monitor SQL servers tha...more >>

I'm using Port Reporter to check what ports are being used between client machine and SQL Server machine. I cannot find any entry using port 445 except an entry related the loopback address 127.0.0.1. But I see port 139 being used between client machine and SQL Server machine....more >>

I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange server received the email directly fro...more >>

When i start mssqlserver service, it do not start SQLAgent It is listed in the dependancies of both when i start the sqlAgent manually, there is a command window that opens up with nothing in it, just the cursor blinking, BUT everything runs fine, the msssqlServer and the SQLAgent are both run...more >>

Hi Guys I am trying to import data to a user table using DTS Import/Export Wizard in SQL 2000 Server from MS Excel 2002, the table has 800 plus rows of data. Necessary Identity, Seed and Increment in table design have been set. However, data fails to import. I tried importing the view and...more >>

Please help, deadline approaching. I used the listsvr utility supplied from http://www.sqldev.net/misc/ListSQLSvr.htm. And on Sql 2000 machines it works fine returning all the instances on those machines. Yet on a particular SQL 7.0 machine, it returns a network sql 2000 server, and also a '(...more >>

Please help, deadline approaching. I used the listsvr utility supplied from http://www.sqldev.net/misc/ListSQLSvr.htm. And on Sql 2000 machines it works fine returning all the instances on those machines. Yet on a particular SQL 7.0 machine, it returns a network sql 2000 server, and also a ...more >>

I have a Windows Server 2003 terminal server with a client installed to connect to a SQL 6.5 database. I'm supposed to run windbver.exe to specify the name, IP address, etc. of the SQL server that holds the database. This information is only being stored per user and not globally... Does anyone ...more >>

If on the General tab of the Client Network Utility, TCP/IP is the only protocol enabled. Does it mean that other protocols are disabled and will not be used in communicating to SQL Servers on other machines? In this case, should the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Clien...more >>

A user creates forms in dBase5.7 and now uses a SQL2000 database on our network to access tables via dBase. He has made an application that requires an ODBC DSN (System DSN) to be created on the local machine and this gets posted to a config file called BDE Configuration (part of dBase) a...more >>

MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section ...more >>

I have installed Windows XP SP2 RC2 on a machine with SQL Server 2000. I cannot connect to that machine's port 1433. I have disabled the Windows Firewall. I have run netstat -a to check what ports are listening but I don't see port 1433 and port 1434. I have not tried telnet to that port yet....more >>

MSSQLSERVICE will not start. I am getting "Error 1053: The service did not respond to the start or control request in a timely fashion" and "Timeout 30000 milliseconds waiting for the MSSQLSERVER service to connect". The server was working fine until it was moved from our development rack to our...more >>

Hi ! I'm running SQL Server 2000 Dev on Win XP Prof and having problem = connecting via Enterprise manager, getting this error in Event-logg:=20 17310 : FRunCM: Process 3084 generated fatal exception c0000005 = EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. When c...more >>

I would like to take the data from a sql backup and view in access as a backup method....more >>

Hi all, We're working on an ASP.Net Web Application that makes several calls to a SQL Server database. Everything was running correctly when the database and the web server were on the same computer, but we have sinced moved them to separate computers; IIS V6 on Win2000 and SQL Server 8(SP...more >>

Hi, I am trying to use "The Raiser's Edge" to connect to a SQL 2000 server (on a remote network). I keep getting the error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen (Connect()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or ...more >>

I am using Access 2002 as a front end and SQL Server 2000 as a back end. I am using an ODBC connection and TCP/IP After I have connected, I use ADO to run a process that gets ten different sum queries from various SQL Server tables and writes the results to local Access table. This loops th...more >>

I can do everything with the server on the local LAN, but can make connection if using ip address of server. please help....more >>

...more >>

How to connect linked sql for Oracle 9i?...more >>

Hi, I have an issue when a client tries to connect to an application, he gets the error message saying: "MSDTC on server <ServerName> is unvailable" for now, we are using two methods to work around the problem: - uninstall and re-install the MSDTC service on the server - rebbot the server...more >>

Any idea on what can cause this error message? "Possible Network Error: Write to SQL Server Failed" Is it due to a network disconnect? We are running the application thru Metaframe XP to SQL Server 2000 with SP 3. Thanks...more >>

Hi, I'm having a problem connecting to a SQL Server 2k (SP3) db using oledb provider in a VBS. Running on a Win2k server. This is what happens. If I use a localhost sql server, and have in my connection string data source=(local) I can connect to the database. But when I'm using a server i...more >>

Hello. I run into many instances where I have 50+ .sql scripts that I need to run on multiple SQL installs. I want to automate this process some by being able to drop all my .sql scripts into a folder and then click on my batch file that will run all scripts in that folder, and create a log fil...more >>

Hi all, Has anyone ever successfully connected to a SQL2000 server running on a Windows2003 Standard Server box via OLEDB? If so, PLEASE tell me (and hundreds of others) how to configure Windows2003 server to allow OLEDB connections. I have found dozens of posts on this problem, but there are...more >>

I work in a print shop that uses Franklin Estimating 2004 for all of the jobs. The Franklin software uses MS SQL Server 8 for the database. The boss wants to be able to connect to the database from home to work on estimates for jobs he didn't have time to finish at work. The work is beh...more >>

Is the "connectivity only installation" is equvilant to installing MDAC on the client machines, or the "connectivity only installation" has more functionality to do. Thanks ...more >>

Using the server configuration utility, I have configured my SQL Server 2000 box to listen on multiple ports: (ie (1433, 9000, 9001, etc). http://support.microsoft.com/?id=294453 Now I would like to be able to tell a client to connect to the server through any of these available ports. How...more >>

Is this strange: "SQL server listening on TCP, TCP, Shared Memory." ? It's SQL Server 2000 on a dual-homed W2K DC. I have two "listening on" records for every IP. Also, the SQL Sever application is running on the first port using the correct IP and port # and IP 0.0.0.0 is on the second (di...more >>

Thanks in advance. I have a webserver with win2000 advanced server and sql server 2000 installed in one physical drive with different logical drive. I have back up everything into tape. After a hard drive failure, I restored everything into the new drive. The only different is that, the size of ...more >>

Bulk insert report the following code after being used for a period. When this happens, we need to re-start the SQL Server and then it will disappear for a while and then happen again. Any body have idea about how to work around this problem? Server: Msg 7302, Level 16, State 1, Line 1 C...more >>

I hope this is the correct place to post this. I have a VB program that is running on a server. It connects clients to a SQL database. All of the clients are connecting except for one. This one will run the program (so I know it is mapped to the correct drive), take the login info and then t...more >>

I have opened ports 1433 and 1434 on a SQL Server on our network to allow our customers to receive a monthly subscription "key" for the software they lease from us. Within an encrypted Stored Procedure I am using the OPENDATASOURCE method with a connect string containing our IP address. It is wo...more >>