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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|