|
|
|
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 August 2008 |
Filter by week: 1 2 3 4 5 SQL Server 2000 connection problem - dbmssocn work in Excel 2k but not XP Posted by dengcharles NO[at]SPAM hotmail.com at 10/14/2004 5:06:18 PM Hi All,
An interest question about "Network Library=dbmssocn" in connection
string.
I have a Excel VBA application which I used to connect to SQL Server
2000 server. my connection string is:
"Provider=SQLOLEDB; Data Source=servername; Initial Catalog=dbname;
User ID=username; Password=pwd;...more >>
Error 18452 Posted by Andrew Chalk at 10/14/2004 4:38:36 PM I have created a user (calladmin2) of a database in SQL Server Enterprise
Manager. When I load SQL Query Analyzer and attempt to File->Connect using
this user name I get:
Msg. 18452, Level 16, State 1
Login failed for user 'calladmin2'. reason: Not associated with a trusted
SQL Server conne...more >>
Connection problem with WinXP SP2 Posted by John Wilheim at 10/14/2004 3:59:09 PM We have several loptops that run Windows XP and have SQL
Server databases, which we access through a Java
application. After WinXP Service Pack 2 was installed,
none of the laptops can connect to the database. We have
tried opening port 1433 for TCP/IP and port 445 for Named
Pipes; still n...more >>
Connection string Posted by cds at 10/14/2004 1:49:41 PM Hi
Can someone tell me where the connection string is set up in MSDE
TIA
cds
...more >>
Connecting to SQL server 7 behind ISA server Posted by Steve at 10/13/2004 9:40:35 AM Hi,
I recently upgrade a WinNT 4 SP6a Proxy server to Win2K SP4 with ISA SP2. I
have to allow remote users to connect to a SQL server 7 SP4 on Winnt 4 SP6a
behind ISA. The IP is static. It was working fine with Proxy but now I have
the following with clients on the Web:
[Microsoft][ODBC SQ...more >>
Error trying to execute a sp on a remote server with an SQL agent Posted by Nico at 10/13/2004 1:45:05 AM Job 'bla' : Step 1, 'execute spbla' : Began Executing 2004-10-13 10:33:13
Msg 7410, Sev 16: Remote access not allowed for Windows NT user activated by
SETUSER. [SQLSTATE 42000]
I get the above error when I try to execute a sp sitting on a remote server
with a SQL Server Agent job.
The sp e...more >>
Access SQL server from AS/400 DB2 Posted by Farmer at 10/12/2004 4:21:16 PM Hi everyone,
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!
...more >>
Temporary Tables on Internet Posted by Warren Patterson at 10/12/2004 3:41:50 PM Hi,
Can you use #temp tables in stored procedures that access data for a
website?
Will this not cause a slowdown if say 5 users of the website access the same
Stored Procedure at the same time? As far as I can tell if I use a
statement like this "select * into #temp from tblOrders" a prob...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem with sp_attach_db Posted by Israel at 10/11/2004 8:18:33 PM Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Serve...more >>
How to record if a Linked Server is offline? Posted by Drake Teran at 10/11/2004 10:48:44 AM I created the below script to track my linked servers. I set it up that it
would record a record for each server along with all its corresponding
databases. Unfortunately, I have not been able to successfully track a
server which is offline.
Currently, I am using cmdshell to ping linked serv...more >>
Named Instance into a IP Server Posted by Ing. Mike at 10/11/2004 9:15:27 AM Hello,
May be my question its simple, but I don't know the answer, I need to
connect to a named instance into a Remote Server using an IP Address, how I
can do that ???
Thanks
...more >>
Connection string Posted by cds at 10/10/2004 7:37:35 PM Hi
Can someone advise where I locate the connection string in SQL server 2000.
I keep getting a "Server does not exist" message when trying to connect to
another SQLserver computer (although the server is running).
TIA
cds
...more >>
Attach/Detach database Posted by vul at 10/10/2004 11:37:53 AM I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attac...more >>
Connecting from Powerbuilder through ole db, column defaults not r Posted by roz at 10/8/2004 10:13:03 AM I am connecting through ole db from Powerbuilder to Ms Sql Server 2000.
Powerbuilder is not recognizing the column defaults which leads to problems,
especially for inserts. Has anyone run into this and can you help me out?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |