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