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
August 2008


all groups > sql server connect > march 2004 > threads for march 22 - 28, 2004

Filter by week: 1 2 3 4 5

Error connection to MSDE
Posted by Pedro at 3/27/2004 6:55:31 PM
Hi all, I have the Windows 2003 Server in my company and the MSDE SP3 install with an instance for a program. But the program can't access the database, I have tried to create a new data source to SQL Server in ODBC and it tells me SQL Server Error: 11004 (Connection failed) and SQL Server...more >>

SQL Server connection errors
Posted by aquafoil NO[at]SPAM comcast.net at 3/27/2004 6:10:43 AM
First, may I say that I truly appreciate the time people spend on these forums to help others out; it's a wonderful community. Second, I'm afraid that my problem has been answered many times in the plethora of material I've researched and referenced trying to solve my particular problem. How...more >>

limiting database listings
Posted by ariel at 3/27/2004 4:05:40 AM
When I connect to my MSSQL 2000 host with Enterprise Manager using my own private username/password, I still get a listing of all the other databases (owned by all the other users). It is not bad incredibly bad for security as you can only view that the databases exists, but the problem i...more >>

Windows Authentication on SQL 2000 and Oracle
Posted by Piotrek at 3/26/2004 8:08:23 AM
Hello, I'm working on one database in Oracle and I have to get data from MS SQL Server which is located on other server in other domain. Does any one knows how to connect MS SQL 2000 using Windows Authentication bur from other domain. Which solution I should use to solveing this problem with...more >>

SQL Server Connection
Posted by Anon at 3/25/2004 10:12:03 PM
Hi, I have SQL Server 2000 default instance and have recently created a named instance of the developer version. Afterwards, I could still access the default instance but now I am having connection problems. Please advise thanks...more >>

Connection security problems with a 3 tier application
Posted by Roy Chastain at 3/25/2004 2:14:56 PM
Please bear with me as you read this description. I am trying to finish up and productize some code that I inherited from a contract programmer that allegedly knew what he was doing. I know that I don't know what I am doing. I have an application that is written in C# for .net. It has a clien...more >>

Recordset Not Updatable -- Table Has PK!
Posted by (roberts NO[at]SPAM saintpatrick.org) at 3/24/2004 2:42:51 PM
I have a several tables in a SQLServer database, all of which have primary keys defined. When manually linking to three of those tables with MS Access, I get prompted to provide a Unique Record Identifier as if there was no primary key defined. Arrrrgggg! I am trying to automate a process to rebuild...more >>

Link to dbf file
Posted by mj at 3/24/2004 2:12:32 PM
Hi. I have a dbf file that has about 1.2 million lines of data. That file is produced by another system's proecesses. I'm wondering if there's a way for me to link my SQL Server database to that file? Any suggestions would be great. Thanks! dbf file is: M:\Data\Shipped.dbf ...more >>



Problem with SQLOLEDB and iis 6 - threading?
Posted by Fredrik Gjärdman at 3/24/2004 1:42:20 PM
I run a website on a dual proc. W2003 box with a clean setup running iis 6.0. The site does a ton of data access using PROVIDER=SQLOLEDB against a SQL 2000 server with all the latest stuff. When I put load on it it starts to process requests and perfmon counters look as expected but efter a mi...more >>

Error with Registering a SQL Server 2000.
Posted by Jackson_Greg at 3/24/2004 12:58:00 PM
Anyone heard of this error when attempting to Register a SQL Server from Enterprise Manager Standard 2000 client. Invalid attribute/Option Identifier. If so, how have you resolved it?...more >>

SQL Server login window
Posted by Kamran Ahmad at 3/23/2004 11:37:48 PM
Hi all, I have installed SQL Server 2000 personal edition on Windows XP. When I run 'Return all rows' from Enterprise Manager/Databases/<Any database table>, a small SQL Server Login window comes forward. I have checked ODBC settings all is OK. What change I need to do so that this small windo...more >>

Can't connect to databases through Enterprise Manager
Posted by Brendan at 3/23/2004 7:45:52 PM
Understand I am not a DBA. I am just the guy who has to work with this stuff. We have client software that uses SQL 7 as a database. Winpak is a door access software made by Northern. It stores proxy card info, access levels, historys, etc. in a SQL 7 database. I know the databases...more >>

SQL server does not exist or access denied
Posted by CHRISTIE at 3/23/2004 3:46:09 PM
We have a sql server loaded on a workstation. Our Asp.Net application can pull data from that workstation, however when it tries to connect to the Production database in the same domain it gets the following error.. Source Error: An unhandled exception was generated during the execution of the ...more >>

max prefixes
Posted by phil at 3/23/2004 9:56:42 AM
The object name 'dbServer.pubs.dbo.authors' contains more than the maximum number of prefixes. The maximum is 2. when i tried selecting data from a linked server i get this. Thanks!...more >>

Replication for non-trusted domains through VPN can only allow push subscription.
Posted by Joe Mine at 3/23/2004 2:41:36 AM
The current setup: -2 different non-trusted domains(NARC and HOT). -The connection is VPN and NARC domain has the VPN server. -2 SQL server are installed upon 2 Application Server in each domains(SQL11Server & SQL22Server). -In each domain SQL server/agent starts up with a common local pass-thr...more >>

Timeout
Posted by nelsonchang NO[at]SPAM tristateww.com at 3/22/2004 12:46:07 AM
Hi In our offsite, the users always experiences the timeout problem. Can I set it longer?...more >>


DevelopmentNow Blog