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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|