| Thread | Last Post | Replies |
|
| Connection Error using SQL Server ODBC | 15 Feb 2008 07:11 GMT | 2 |
Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in the
Machine name, but it won't let me connect.
Where the wizard asks me what the server name is that I want to connect to,
the drop down is empty. I thought it should show me a list of servers to
|
| SQL 2005 Not Using Configured Port | 14 Feb 2008 18:42 GMT | 2 |
I have a SQL Server 2005 cluster. when I open the configuration manager and
look at the ports configured for TCP/IP, it shows 1433. Yet, when I try to
connect using Management Studio from another machine, it can't connect on
port 1433. I used SQL Ping to scan the server, and it ...
|
| ADO (VB6 to SQLExpress2005 | 13 Feb 2008 19:59 GMT | 2 |
I suspect that this has been answered 1000 times but...
I am connecting from an older VB6 program running on Vista with
SQLExpress2005 installed. it was a standard install and everything can't be
completely wrong because the Management Studio works. I added the database
|
| How can i get all names where field2 is not equal to 'x' | 12 Feb 2008 19:56 GMT | 2 |
How can i get all names where field2 is not equal to 'x'?
I did this: select name from mytable where not (field2='x')
result: only joe is fetched
this is the table:
|
| Can't join tables from two databases using linked servers when DBs on same SQL instance | 11 Feb 2008 23:12 GMT | 1 |
I've got two databases on the same SQL server instance and I've
created a linked server to that instance from my host SQL instance. I
was wondering if I can create a join between tables on the two
databases. It appears as though SQL server only recognizes the first
|
| Tunneling + Sql Server 2005 Express | 11 Feb 2008 15:44 GMT | 1 |
As a result of the new network policy in our company, I can no longer
access a Sql Server instance located on a remote domain. Till now I accessed
it by using "DataSource=mssql.domain.com\SQLEXPRESS;..." . Right now I am
trying to access it by using a ssh tunnel. I set up a ...
|
| RPC error -Link server from MSSQL 2005 (32 bit) to MSSQL 2000 (32 | 04 Feb 2008 16:48 GMT | 1 |
Server A is having mssql 2005 (9.0.1399) while server B is having mssql 2000
(8.9.2187).
When a job is scheduled to transfer data from server A to B via linked
server, there is an error - 'Server B is not configured for RPC. [SQLSTATE
|
| cannot log into Reporting Services from SMSS | 04 Feb 2008 06:39 GMT | 12 |
I have SQL Server 2005 with a full installation, and Reporting Services is
running according to the Configuration Manager. In SMSS, when I try to
connect to the Reporting Services server (my server is called ASUS2), it
responds:
|
| SQL Native Client vs SQLOLEDB | 01 Feb 2008 15:32 GMT | 1 |
I work with Powerbuilder. SNC client has better performance than SQLOLEDB
when running Powerbuilder against SQL Server 2000. However, we found out that
SNC client requires that some stored procedures have the dbo prefix or else
the call the stored procedure fails. When connected ...
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread