Hiya,
I am attempting to make a Linked Server connection within SQL to a .dbf
file (not a .dbc file, using open file connection) located on a network
server and am receiving the following error:

1) For performance of BLOB only data that will have at least 100 KB per BLOB,
what is the best network packet size setting? The resource kit indicates that
it is 8080. Is that correct, or is it a typo that should say 8192?
2) Does the client connection have to match the network ...

We are experiencing an intermittent problem where we loose our connection to
SQL server from RSSQL. The system logs are reporting this in the following
order:
1    8/23/2005    1:58:59 AM    5    256    RSSql    N/A    TSSFOOTAGECTR    (52152) SQL state

I am writing code to interface with a pre-existing and unchangeable dBase
database that we access through ODBC.  This database has column names of the
format "NAME$0101" and "NAME$0102" etc.  These column names work fine for
retrieving and updating data via SELECT and UPDATE, but ...

I have a linked server connection from sql server 2000 to access...once
someone puts a password on an access database does anyone know what the
default username is. I have tried Admin and Administrator with no luck while
using the correct password of course

I have a table with the fileds  empid,empname,designation,branch.. etc I
have 5 types of  designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next ...

The situation is as follows:
We have developed an application which uses SQL.  Our installer
(InstallShield 10.5) installs MSDE as part of the normal install.  The
MSDE is a passive install, i.e.,

AgileInfoSoftware DataStudio 4.2 is in beta and will soon be released,
please download your free evaluation and provide us your feedback.
Major Features:
1) Work with multiple databases concurrently (Oracle, SQL Server, DB2,

I've read that there is a bug in sql server 2000 when doing a bcp command
with dates in dd-mm-yyyy format. and to fix it there is a hotfix contained
in sp4 . I ve installed the sp4 but the bug remains anybody has an idea
about this hotfix and from where we can get it

My workstation is XP prof sp2 w/ office XP under a domain policy.
i act as "administrator" using Access XP to connect with SQL server.
i can view and add records to the SQL server.
at the same workstation, i act as "normal user with normal rights" using

After migrating to Windows Server 2003 with a MS SQL Server 200
installation, I've tried numerous variations to connect to the SQ
Server throug the IIS via ASP scripting in VB, but unfortunatel
without any luck.