I am trying to find out how to connect to a database, inside a stored
procedure...including identification (Username and passsword)?
I tried the CONNECT TO statement, but when I try to use it, I get the error:
[ODBC SQL Server Driver]Syntax Error or Access violation

what is the syntax the server alias and the server name?
Is this correct:  server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
                      server name should be the "ip-address\instance name"?

When i try to connect through dial up to sql server 2000 running on Windows
Server 2003, i get the following error message:
Run-time error '-2147467259 (80004005)':
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access

I receive a very much unstructured flat file, which I import into a SQL
Server database using DTS. After the import, one of the flat file columns is
in the format char(6) rather than datetime. The problem seems to be that the
text file column is in the format 'ddmmyy'. When I use ...

Am I missing somthing obvious here. I create an ODBC System dataSource
programatically and I can see it in the registry.
However Crystal Reports or ODBC Admin fail to list it. Is there some other
area this info is held?

I'm running a DTS package that imports data from various Excel spreadsheets
into a SQL Server database. Running the package from the command prompt, I
get information on each data pump task including each 1,000 rows imported
successfully. When all rows have been imported from a ...

I got this message when running the same project at my work which I worked on
at home without encountering it.  Thanks for the help.
Request for the permission of type System.Data.SqlClienAdditional
information: Request for the permission of type

I have J2EE web application, that uses Datasources, which works fine with SQL
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with running the same code against MSDE version of SQL Server 2000
running locally on Windows XP Professional.

I run the java application in console window and it is able to connect to
SQL 2000 server with JDBC. I put those mssqlserver.jar driver files to
jre1.4/lib/ext.
It has firewall and antivirus software and still able to connect to SQL 2000.

I have a Dell 2850 that is being setup for a SQL database.  In the past (for
example my Exchange 2003 server) I have had problems when teaming the NIC
cards on the server in a load balancing mode.
My question is, for SQL server (this server will also run IIS) where clients

I'm using ado to connect to a sql server 2000, and suddendly the line that
does the connection (conx.open) is taking a long time. All the apps that
connecto to the server take a long time also. Additionally, when you use the
sql manager, when you retrieve the rows from a table it ...

sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
Oracle 9i client installed.
We have set up a linked server to an Oracle instance using the 'Microsoft
OLE DB Provider for Oracle', this works for a while without any problems and

Is there an easy way to read a database table from a SqlServer database and
save it to an Access database?  I have tried reading the data into a dataset
(using .NET with C#).  This part works fine, but then I can't seem to get the
dataset to update or create a file in the Access ...

We have a multiple clients that do have all cients of different clients. We
would like to connect to SQL Server running on a WIndows 2003 Server.
We use Windows Authentication.
According to Microsoft: "SQL Server clients running on Windows Millennium

I also have started showing strange ODBC link failures on May 4th of 2005.  
I'm running asp pages on w2k3 standard server.  No known changes have been
made to the system prior to this error.  
The initial connection to any of these web pages works great, but if the