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 > december 2004 > threads for december 15 - 21, 2004

Filter by week: 1 2 3 4 5

SQL Server does not exist or access denied
Posted by Pietro at 12/21/2004 7:58:01 PM
My Asp.net application can't connect to the SQL server from the app server, but an asp page and I can connect to the SQL server, the server also can't connect to a database in other machine. Tks, Pietro...more >>

Unable to connect to server CSPL. Server Msg 160, Level 16, State 1. Specified driver could not be loaded due to system error 126 (SQL Server)
Posted by Peri at 12/21/2004 12:28:03 PM
Hi All, When I open SQL Query analyser and If I try to connect, I am getting this error. Unable to connect to server CSPL. Server Msg 160, Level 16, State 1. Specified driver could not be loaded due to system error 126 (SQL Server) Please help me out of this. Thanks and Regards Peri...more >>

SQL Server does not exist or access denied (after XP SP2)
Posted by Vincent Verheul at 12/21/2004 10:21:31 AM
Hello, I use MsAccess 2002 on a Windows XP platform, together with SQL Server 2000. I installed SQL Server on my XP machine prior to installing Service Pack 2 for XP. Everything worked fine: could use the Upsize Wizard, ADP etc. After installing Service Pack 2, I can no longer get a connec...more >>

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server
Posted by Bob Albert at 12/21/2004 3:01:45 AM
Have an APP running IIS on one box and SQL on a Win 2K3. When running through a browser located on a completely different box (double hop) the credentials get lost (as designed by MS) and user is only known as Anonymous. Everything is fine and expected so far. SQL on Win 2K allowed such...more >>

Connection Problems
Posted by Michael O'S at 12/21/2004 2:56:45 AM
Hello, I have a small workgroup of computers (4) all running windows xp sp2. One of them is running msde2000. I can connect to a named instance of sql server but can not connect to the default instance. I am using osql and using trusted connection. I am not sure what other information is n...more >>

how to connect ORacle Forms 6i with SQL Server 2000
Posted by Wazb at 12/20/2004 2:53:03 PM
i tired my best to get answer of my issue but no one helped me in ORacle OTN newsgroups , please if you know how can ORacle Forms 6i can connect with SQl Server 2000, kindly write. Thanks ...more >>

Odd results from query
Posted by Dave at 12/20/2004 12:29:05 PM
The environment is ASP.Net accessing the SQL server through IIS. While, I've been told that .Net does not create a cache the behavior I'm observing for intensive purposes looks as if there is a cache. I'm at a bit of a loss to explain this behavior. Also, if I wait five or ten minutes, and ...more >>

working with SQL and access
Posted by Neil Jarman at 12/20/2004 12:05:01 PM
Hi, I have an access DB (2000) with links to tables in SQL server. If I go back to my original DB and add a field, it doesn't show in the Access list. I have to delete the link and then re-connect it. Is there a better way of dealing with this? Thanks, Neil ...more >>



IIS and SQL Server on separate machine
Posted by Kavi at 12/19/2004 5:31:03 PM
Hi, Can anybody please help me how to set up a conncetion between IIS & SQL Server on seperate machine. 1. Domain is same 2. I've tried as per the article 176380, but we are facing some problem on IIS. So my Network manager said I need to try something else. Please let me know the step...more >>

Problem getting external data using Access
Posted by Seefahrer at 12/19/2004 5:13:01 PM
Hello. I would appreciate any assistance in finding a solution to this problem. I am using an access program that connects to an access database. The program was written using Access 2000. However, the program does not properly connect to the database, depending on the computer on which it...more >>

Cached Logon
Posted by Roland Hall at 12/19/2004 5:16:15 AM
If IIS cached a logon just for one particular page, but not for other pages performing the same logon, is that normal? I know it sounds bizarre but I have an ASP page that makes an ADO connection to MS SQL Server. Authentication on SQL is set to SQL and Microsoft. Authentication in IIS is ...more >>

sudden disconnect from SQL
Posted by Bill H at 12/17/2004 12:56:04 PM
We've been running a web app for months now, and then suddenly, that web = server could not connect to the remote SQL instance anymore. We are = using a standard TCP configuration with SQL default port. No alias is = used. We use the SQL instance name (as opposed to IP) to connect. We reboote...more >>

error 7405
Posted by Jim Capehart at 12/17/2004 8:11:02 AM
I have created a stored procedure wich queries a linked ORACLE database. When I try to save the procedure I get the following error Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these option...more >>

Windows Firewall makes it impossible to connect to SQL from client
Posted by Larry at 12/17/2004 7:35:03 AM
Is there a way to allow a client PC connect to my default SQL instance on an XP Pro SP3 machine without turning off the Windows Firewall? ...more >>

SQL through ISA - authentication
Posted by SÁRINGER Zoltán at 12/16/2004 12:12:51 PM
Hello, system administrator asked me to modify my VB application to authanticate itself for ISA when wants to connect to an outer sql server. the system administrator dont want to open fully the port 1433 (from inner LAN), and also dont want to set my application name at ISA. Is any way to sol...more >>

SQL Server 2000 Connection Error
Posted by Rod at MHC at 12/16/2004 9:37:08 AM
We have recently upgraded to SQL Server 2000 and Server 2003. We're running with TCP/IP and can access the db but the connection appears to then drop. The message is Connection Failed: SqlState 01000 [Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Open Connection(Connect()). Connec...more >>

MSSQL - DB2 Connectivity
Posted by Erich Kolb at 12/16/2004 12:22:17 AM
We are planning to start warehousing some of the data that currently resides on an as400 (using DB2) on a MSSQL 2000 server. Has anyone monitoring this group gone through such a project? ...more >>

SQL 7 to Oracle Openquery
Posted by BR at 12/15/2004 8:13:22 AM
I have a list of CustomerID's that I need to oull address information from a linked Oracle database. I can query individual numbers from query analyzer. However I would like to have my list of CustomersID's be automatically processed through the openquery command. Here is what I currently ha...more >>


DevelopmentNow Blog