Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008
all groups > sql server connect > february 2005 > threads for february 22 - 28, 2005

Filter by week: 1 2 3 4

as/400 linked server
Posted by Francesco Trigiante at 2/28/2005 9:38:36 PM
Hi everybody, I have a problem in SQL Server 2000. I need to connect as a linked server the AS400 database (V5R3). I read in the SQL documentation about the SP_ADDLINKEDSERVER stored procedure and the linked server from SQL Manager but I'm not to be able to have success using its. The b...more >>


Communications link failure #0
Posted by Scott McDonald at 2/28/2005 6:04:53 PM
We are intermittently getting this error on our SQL server. The front end is access and this happens every so often causing the users to have to exit out of access and reconnect. I'm by no means a SQL expert, and our programmer who manages this database isn't sure what it is either, he says it...more >>

Connection to remote sql server db
Posted by shan at 2/27/2005 3:23:03 PM
Hi, I'm new to SQL and would like to connect to a remote sql server where a website is hosted and do some updates. I have a local sqlserver setup here, could you pl guide me some doc or urls. I have to backup the db frm the remote sqlserver, my host company told me to use dts to carry out ...more >>

SQL Table prefixes -how get rid ???
Posted by Jim McDonald at 2/25/2005 3:04:12 PM
Hi Thi sis probably another dumb question, but any advice would be great. I have an SQL db under a website that I have to get to with an Access fromt end, with ODBC. When ever I get to a table it has various prefixes added, so that when I load up Stored Procs locally they fail bercause the t...more >>

SQL Server drops off port 1433 on first request
Posted by J. R. Tessier at 2/25/2005 11:49:04 AM
I have what I see from this forum and other places is a common symptom: "SQL Server does not exist or access denied". I have tried every approach I could glean from the responses posted, but nothing's worked. I did a little network sniffing (with Ethereal), and what I see when I try to est...more >>

SQL Tables as Exchange Address Books
Posted by Ken VdB at 2/24/2005 2:43:28 PM
Hi everyone, Please excuse the cross posting but I have been searching long and hard for an answer to this and haven't been able to find one. I can't be the only person who needs to do this. I have Exchange 2000 and SQL 2000 running on the same box. I have a number of tables in...more >>

Advantage Database Server
Posted by Geri Reshef at 2/23/2005 7:41:08 PM
I have to pass some data from Advantage Database Server (a database wich = is used generally with Delphy) to SQL-Server. In order to create a Linked Server from SQL-Server to the above = mentioned database- what should I do? If there is an ODBC for the database- should it be installed on the = ...more >>

linked win2003 server with sql2000 problem
Posted by nivek at 2/23/2005 2:47:24 PM
I have two new win2003 server running sql2000. I am using mapped logins to get from a win2000/sql2000 to win2003/sql2000 and am getting access denied. Everything is set up exactly the same on machines running this config with win2000 and am having no problems. I have also enabled DTC access in th...more >>



Error opening socket
Posted by danA at 2/23/2005 1:50:03 PM
The incident involves two Windows Server 2003 based computers S and C. They are hosted by two different hosting companies in two different countries. They both have SQL Server 2000 SP3 installed and running. The development is done on an XP Professional SP2 based desktop. The objective is to ...more >>

What does Named Pipes do and why does it affect Named Instances?
Posted by Pat Frost at 2/23/2005 7:47:05 AM
I work for DataDirect-Technologies. A customer of ours uses our ODBC driver on UNIX to connect to a SQL Server 2000 Named Instance. We have noticed that in the Enterprise Manager if you right-click on the Named instance and open the Properties menu and then open Network Configuration, TCP/IP a...more >>

Access -> ODBC -> SQL Server connection hangs
Posted by Davey at 2/22/2005 6:21:15 PM
I have an MS Access 2003 database that uses a SQL Server 2000 database as it's back-end. The database runs well most of the time but if the users dont use the database for a period of time (approx 10 minutes) and return to it then the connection hangs. When they try to perform any action that ...more >>


DevelopmentNow Blog