Suppose I have an appliation made in VB6 which connects to SQL2000.
The applications creates a DSN(old style) to connecto to the server.
The user has a login an a password to use the application. The server
validades Windows NT login.

After I installated  Service Pack 4  on SQL 2000, suddenly all my ODBC
drivers
dissapered.
How I can get them back?

I am trying to pass two parameters to a stored procedure that works fine when
I use the code, for example:
param_user.Value = "blahblah@com"
The problem is the value I need is in a variable, but when I use:

Yes, I opened the ports 1433 and 1434 in Windows Firewall and SQL server is
set to windows or sql authentication. I believe I opened them with the
correct TCP/UDP combination. I also told windows firewall about
sqlserver.exe, however I suspect that is more for outbound connections.

At my workplace our ERP software in on a VFP database.  I have learned quite
a bit about extracting data with the select statements from the VFP
database.  We are in the talks of converting the the SQL version of our ERP
and I have some very basic questions since I am extremely new ...

What is the maximum number of Databases you can have connections to using
ODBC connection to SQL? I am talking hear about the entries in ODBC Data
Sources as System DSN's.
Anyone got any ideas? Assume  Windows XP SP2 workstation and Windows 20003

We have an instance of oracle on linux and another with sqlserver on
windows.
We need an odbc driver for the linux box to connect to the sql server.
Does anybody have suggestions on what odbc drivers there are out there for

I am writing an sql qry for cursor function. the Select qry is not working
properly. please check this and help me
declare @m as varchar(20)
declare @mm as varchar(400)

I want to take backup of my Sql server 2000 databases on network drive but I am unable to find the network drive only local drive are seen in Enterprise Manager of my Sql server. Actually I have tried both by, maping my network drive thru Domain/Administrator password as well as ...

My variation of this problem is as follows:
the server has the Windows authentication mode, I'am aware of it so I make
sure I comply with it in my connection attempt (through Enterprise Manager).
I attempt to

I am using SQL Server 2000 and running number of query simulatneously. While
running update query it is always giving above error. The error discriptions
are -
1. [SQL Server]Transaction (Process ID 52) was deadlocked on {lock}

  I have a windows service that I built in c#. I am trying to connect to a
sql server database with trusted authentication but I get login keeps on
failing. So I am assuming that I need to supply different login credentials
since its not accepting my windows nt login that I use ...

My problem is :
I have ASP.NET 1.1 app that must connect  to existing DBF data files.
I tried to do this with existing ODBC for DBF but I have following problem :
Either if DBF file had appropriate index NTX file, the unknown exception

Win 2000, sqlServer 2000 Personal edition
Trying ot connect using .asp Vb Script
1. Sql server set to use Windows Authentication
2. Log onto Windows 2000 as Jim Bunton {no password)

   I'm having some issues grabbing ODBC Settings. First off I need to
present a user with the options to select thier DSN, Server, UID, PWD, and
Database settings. I have come up with a way using the SQLBrowseConnect
function to obtain the Server and Database information I need. ...