all groups > sql server connect > august 2006 > threads for august 1 - 7, 2006
Filter by week: 1 2 3 4 5
Connecting to another SQL Server
Posted by Chamark via SQLMonster.com at 8/7/2006 8:54:04 PM
I think I have done my homework and research on this. I'm in a company
Intranet and through Enterprise Manager, I have added the server I want to
access (FES89TXNCEV501) in my server group. I can access the that server and
open a view on that server (read only).
I want to write a query (see be... more >>
sql 2000 vs slq2005
Posted by ginger8990 at 8/7/2006 9:47:01 AM
I am not a programmer nor a developer. I just want to get familair with SQL
administration stuff. I knew there is no enterprise manager in SQL 2005.
Which new tool did replace the enterprise manager?... more >>
Unix applications and supported MSSQL driver
Posted by Mo at 8/7/2006 8:47:02 AM
Dear experts
I have a customer requirement. App is a C application deployed on Solaris.
The database is inteded to be MS SQL SERVER 2000 or 2005.
Before I even get started, will Microsoft support such a mix - i.e.,
connecting to SQL Server from unix.
Does a supported driver exist?
... more >>
SQL Server broadcasting
Posted by Mark B at 8/7/2006 12:00:00 AM
Hi,
Is it possible to have an SQL Server NOT broadcast the fact it's an SQL
Server? In a school environment, with Visual Studio 2005, this product gives
the students a mite too much connectability to network resources. Would it
be possible to have a 'passive' SQL server? One that doesn't ap... more >>
ASP.NET 2.0 and connection to remote SQL 2000 server
Posted by Mitya Mitriev at 8/5/2006 11:06:33 PM
Hi
I created ASP.NET 2.0 web application that uses SQL Server 2000 database and
it works perfectly when website and Sql server were on local machine.
Then I installed application on production server. Database is placed on
another server.
I received the error:
An error has occurred while e... more >>
connection problem
Posted by Krzysztof at 8/4/2006 10:17:40 PM
Hi.
I have installed Microsoft SQL Server Desktop on Windows Xp Pro. I can
connect to database from remote machines with Windows 98Se, but i can't
connect from machines with Windows XP.
Chris
... more >>
sql 2005 problem connecting in vb2005
Posted by Jeremy at 8/4/2006 5:55:23 PM
I have sql 2k5 installed (developer ed) on my advanced server 2000. It
allows remote connections. I'm trying to connect using sql authentication.
The server is not a member of a domain.
I try to connect from an XP system using an IP number, sql user and
password. The attempt fails and the e... more >>
Cannot connect to server
Posted by childothe1980s at 8/4/2006 8:16:02 AM
Hello:
When I try to connect to an instance of SQL 2005 in Management Studio on my
laptop, I get the following error message:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the de... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to Enable Connection Pooling
Posted by robin9876 NO[at]SPAM hotmail.com at 8/3/2006 3:12:43 AM
How can you enable connection pooling from an application server that
connects to a SQL server on a different server?
... more >>
command line local login to SQL failed
Posted by light_wt at 8/2/2006 5:53:01 PM
Pardon if this has been asked before. If so, please post the URL.
Could someone please tell me how to fix this login/pipe? Notice the 3rd
login is fine with "/E". It is a SQL2005 Enterprise on Win2003 Server Ent.
C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin>... more >>
SQL Server Management Studio Express
Posted by Victor at 8/2/2006 2:41:41 PM
Just downloaded & installed SQL Server Management Studio Express on my desktop as part
of SQL Server 2005.
I can see how I can view my database tables, and columns in the tables. But is there a
GUI-type interface to view the data database, like Access has?
Vic
... more >>
Errors collection in connection object disapearing
Posted by Larry at 8/1/2006 7:40:35 PM
In VB 6.0, (sp6), using sql server 2000 (sp2), and ADO 2.8
the following code keeps crashing when I get an error.
If mconTheConnection.State = 0 Then
strEmailBody = strEmailBody & "The program was unable to establish a connection to the database " & mstrDataBase
strEmail... more >>
import data from excel sheet to sql server
Posted by shybi at 8/1/2006 3:19:53 AM
i am using an OPENROWSET method to import from excel data to sql server. i am getting an error like
ADO error:[OLE/DB provider returned message: Operation wa canceled.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitializ
Initialize returned 0x80040e4e
Could not initialize data source ... more >>
|