Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server connect > may 2005 > threads for may 8 - 14, 2005

Filter by week: 1 2 3 4 5

SQL Express & .NET Framework 2.0.50215.45
Posted by Loane Sharp at 5/14/2005 12:00:00 AM
Hi there I'm using the .NET Framework 2.0.40903 ... I had some interoperability issues between SQL Express and the Framework 2.0.40607, so I'm reluctant to do anything drastic with 2.0.50215. Has anyone taken the plunge? Best regards Loane ...more >>


Best way to install data files?
Posted by kvr901 at 5/13/2005 6:56:09 AM
Warning beginner here. I posted this in the setup news group but haven't received and replies, so perphaps someone here can help me. I am developing a small ASP.NET web application that will use an SQL Server 2000 database. The database will start with 1,000 records in a main table and ...more >>

Cannot start MSSQL Server 7
Posted by Water Cooler v2 at 5/13/2005 2:07:02 AM
I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know if the network would have something to do with it, but I am just providing informati...more >>

Registering a server
Posted by Gary at 5/12/2005 8:26:04 AM
I am having difficulty registering to a newly installed server. The server resides in a remote location. The server is using mixed mode. I set a user up on the server named SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL with the same rights. Whe I attempt to re...more >>

Cannot connect to remote server with enterprise mgr
Posted by francis at 5/11/2005 8:28:08 AM
Hi I am a newbie so I will try to describe my situation below. I purchased a Server running Windows 2003 and installed SQL 2000 with SP4. The server is hosted in a co-location building at my ISP. I have terminal Server access. I have a application that I will use to connect thru the interent t...more >>

Sql server down when Edit Data
Posted by vichet at 5/11/2005 12:00:00 AM
Dear All; I use Access 2003 with Sql Server 2000. While i edit data at client, sql server downs. So when i click Save, error message appears. How to reconnect, when sql server restart? Thanks ...more >>

connecting to sql remote database
Posted by uday at 5/10/2005 3:00:55 AM
i am trying to connect to sql server in a remote database by using windows authentication. I tried to connect using php and cgi. The apache service under which i am running my cgi or php is under localsystem account. If i change it to administrator account, i am able to connect to remote sql s...more >>

Client Network Utility - tcp/ip
Posted by Robert A. DiFrancesco at 5/9/2005 5:55:40 PM
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"? ...more >>



Request for the permission of type System.Data.SqlClien
Posted by bic at 5/9/2005 11:20:01 AM
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 System.Data.SqlClient.SqlClientPermission, S...more >>

Oracle linked server error
Posted by Chris NO[at]SPAM CambridgeUK at 5/9/2005 7:58:09 AM
Hello, 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 then for an unknown reason ceases to work....more >>

SQL Server 2000 Connectivity
Posted by Jamil Anwar via SQLMonster.com at 5/9/2005 12:00:00 AM
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 denied. I am using VB6 running on Windows XP....more >>

Connection to a database
Posted by Albano Alves at 5/9/2005 12:00:00 AM
Hi, 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 I am using the ...more >>

convert from char(6) to datetime
Posted by Loane Sharp at 5/9/2005 12:00:00 AM
Hi there 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 t...more >>


DevelopmentNow Blog