I have some SQL server jobs that connect to a linked DB2 on an AS400 and
fetches some data and inserts into SQL server.  The AS400 is set up as a
linked server.  The jobs fail at times and work at others.  The error message
I get when trying to look at the tables through ...

I need to engage an odbc consultant for a few hours to quickly go over some
code of mine.  You must be experienced in coding ODBC in C. The program uses
straight C (not C++ and not MFC).  I need this help immediately.
Please email right away if you can do it. Please include your ...

I've been searching the web for some time, without any luck ...
Is it possible to connect to a SQL Server using a domain account that is
marked as a non-interactive user ??
Thanks,

I just installed SQL SP3 and it immediately solved the problem....
Thanks for the opportunity to post.
Joe

I installed SQL server 2000 on three different machines. A, B, C.
A is running XP Pro
B is running XP Pro with SP2
C is running Windows 2000 server

I have two MS SQL servers: Server1 & Server2. Both are Win2003 Server
+ MS SQL 2000, but the first is 64bit version, while second is a 32bit
version.
When I try to do this:

I'm using c# to connect to a sql database.
My dev work is fine and it connects; when deployed to the live environment,
it needs to have special chacters (@ and !) in it. The ! goes through fine,
but @ is removed. If I hard code the @, it's fine, but my setting is held in

I do not have much of a programming background at all, so I am not sure how
to ask this, so I will try to keep it brief:
I am trying to teach myself SQL programming on my home PC using Windows XP
(using the book "Teach yourself SQL in 10 min.").  I searched my PC and do

Does anyone know if this article is valid for connection between servers.  
I'm getting an intermittent

website running on a windows 2000sp3 tries to write data to sql 2000 server

I am new to odbc - can anyone point me to a simple odbc example written in C
(not using MFC) that does a simple select and a simple insert? Thanks.

I have an issue with SQL 2000 Standard Edn (8.00.760 SP3) that I believe to
be "Bug #: 471578". It manifested after my SP3 install.
Manifest: I use a simple 3 table select "View" as a form recordsource in
read-only, no locks mode.  SQL, however, places locks on all the records.

i want to create some queerys in MS-SQL
1)
this queery in ORACLE-SQL works fine , in MS-SQL?
SELECT     code_card, card_date + 31

Connecting with query analyzer to a local default instance. 127.0.0.1 works,
localhost fails, . works, and (local) works. Why would localhost fail?
TIA,
Rick.

I'm having problems Registering servers in Enterrpise Manager.  
This problem is workstation specific.
Workstation is XP Pro SP1, in an Active Directory domain.  Only protocol in
machine is TCP/IP.  

I've created a database with 1 table, Articles. In that table, there are 4
colmns: ArticleID(autonumber), Title, XMLFile and Date(date/time).
I want to write an SQL command to get only the newest entries. How can I
solve this?