|
|
|
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 |
Filter by week: 1 2 3 4 5 how-to use ODBC C API to connect through named PIPE Posted by Dmitry Chumack at 3/21/2007 9:07:09 AM hi *
I have some program, written in C, that uses ODBC API to connect to
MSSQL Server 2000/2005. To create a connection with server I use
SQLDriverConnect function with such connection string:
"DRIVER={SQL
Server};SERVER=MY_SERVER;Trusted_Connection={Yes};DATABASE=MY_DB;"
How can I creat...more >>
Cannot connect to SQL Server 2005 Posted by CRush at 3/21/2007 7:50:05 AM I am receiving this error while trying to connect to a SQL Server 2005
instance.
"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 default settings SQL Server does not allow remote...more >>
Not able to connect SQL Server Posted by sudhakar.sub NO[at]SPAM wipro.com at 3/21/2007 4:55:15 AM We installed long horn server build 6001 and then we enabled
IISv7.0.Subsquently We installed SQL Server 2005 enterprise edition (EvAl)
After installation is completed all the SQl related services are up and
running.
When we are connecting to SQL data base we unable to login to the system....more >>
Error 17827 from SQL Server 2005 Express Edition Posted by vojat at 3/21/2007 3:19:10 AM Hi,
I'm using SQL server 2005 Express Edition in my solution and I've run into a
problem that I can't find any information about.
The application was running OK (for several days) until this happend just
out of the blue.
The application is written in C++ and we are using ADO to access the
d...more >>
Surface area configuration connection issue Posted by Sun at 3/20/2007 1:49:06 PM Hi,
I have Sql Server 2005 Std edition installed on a Windows 2003 server and
the client components installed on my machine with Win XP.
The Surface area configuration was configured on the server to allow TCP/IP
and named pipes.
My network login has been added to a group that has been ...more >>
can't drop user, owns objects Posted by totoro at 3/20/2007 11:09:03 AM I migrated copies of a database to a test server, but I cannot log on. My
admin account needs to be dropped and readded but every time I run
sp_dropuser in query analyzer I get the error :
Msg 15183, level 16, state 1, ....
"the user owns objects in the database and cannot be dropped."
then ...more >>
MSDE instance being broadcast Posted by Todd C at 3/20/2007 5:30:00 AM I work in a domain environment with a couple of Enterprise Edition SQL
Servers. Using SSMS, when I go to register a new installation and I 'Browse
for more' in the dialog box, I see a whole bunch of workstations that I know
are set up with MSDE.
How do I keep these machines from broadcasti...more >>
How to decrease database connectivity failure time Posted by Kumar at 3/20/2007 12:00:00 AM Hi All,
I am an VC++ programmer. I had written an VC++ application, which
will fetch data from SQL Server. I am doing DB Connectivity by creating a
DSN.
My application works perfectly. But it lacked with need some
performance issues when the DB Connectvity fails.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
import/export from to exel / access Posted by Casper at 3/19/2007 9:09:21 PM Hello,
i'm looking after the possibility of importing / exporting data from / to
Excel and Access.
Thanks for help
Casper
...more >>
equivalent of "load data local infile" of Mysql? Posted by Casper at 3/19/2007 9:07:51 PM Hello,
i'm looking after an equivalent T-sql command as "load data local infile
...." of Mysql, in order to import a textfile into sql server express 2005
containing data and delimited with tabs.
Thanks
Casper
...more >>
MSSQLServerOLAPService connection string name change Posted by EB at 3/19/2007 12:00:00 AM Hi all,
We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and seen ...more >>
Error On Loading Posted by Mahadevan at 3/18/2007 10:16:03 PM I receive Error 340: General Error when I try to open MSSQL7, Enterprise
Manager. Can someone help Please?...more >>
Problem with ADO in connecting SQL Server Express remotely Posted by Jack Zhong at 3/18/2007 12:52:32 AM Dear All,
I installed the SQL Server Express 2005 + SP2 on Windows XP x64 +SP2, the
TCP/IP, Named Pipes and SQL Browser services are enabled, and client
computer runns under Windows 2000 with Native Client driver installed.
I can connect the instance with ADO or Native Client within the same...more >>
Using "Windows Authentication" on a Home Network Posted by Robin Bowning at 3/17/2007 4:00:38 PM Hi everyone,
I'm quite new to SQL Server so maybe this is an easy question but I haven't
found the answer after 3+ hours of Googling and experimenting.
I have a simple set up - two computers named HELEN and DELORES, both running
Win XP Pro, SP2. These machines are connected via a home netw...more >>
connection to Analysis server failed Posted by Zdenek at 3/17/2007 4:21:03 AM May you help for beginner.
I have installed MS SQL server 2005 to local computer. I can not connect to
Server type "Analysis Services" from Management studio.
Message "A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)" appears.
But I...more >>
HOW LINKED DbASE FOLDER TO SQL 2005 64 BIT? PLEASE HELP ME!!!!!!! Posted by gramir NO[at]SPAM lanet.wroc.net at 3/17/2007 2:28:18 AM I HAVE SQL2005 32 BIT ( TEST) AND SECOND MACHINE 64 BIt
(PRODUCTION).
IN 32 BIT I LINKED SUCCESFULL DBASE FOLDER (FILES CLIPPER) BY
OPENROWSET BY:
select * from OPENROWSET('MSDASQL',
'Driver={Microsoft dBase Driver};SourceDB=c:\MyApp\;SourceType=dbf',
'select * from MyTable')
--------...more >>
Connecting to remote Express instance using SSMS Posted by Todd C at 3/15/2007 1:33:05 PM I have a server running SQL Server 2005 Ent. Ed. SP2 and locally, I can see
the default instance and two SQLExpress instances named 'sqlexpress' and
'officeservers', all withing SSMS, and can connect and manage them.
From my workstation, running SQL 2005 Dev, SP2, I can connect to the default...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |