| Thread | Last Post | Replies |
|
| SQLDMO connects to wrong sql server instance | 21 Sep 2006 09:29 GMT | 2 |
I have a small utility that is used to run sql script files from command line. It's created in c#. This utility uses sqldmo objects to connect to server and run script. I have two SQl server instances installed - 2005 and 2000. I'm using
|
| Need Help! Connection Count to Linked DB2 Server Reaches limit (SQL1040N) when execute dynamic generated OPENQUERY T-SQL | 21 Sep 2006 06:39 GMT | 1 |
Need Help! Connection Count to Linked DB2 Server Reaches limit (SQL1040N) when execute dynamic generated OPENQUERY T-SQL Hello, every body. I created a linked server to DB2 8.1 database which called
|
| Insert fails on linked server to Sybase | 21 Sep 2006 05:58 GMT | 1 |
I have set up a linked server on our SQL2005 using MSDASQL that maps to a system ODBC dns pointing to a Sybase server. The Sybase OLD DB Provider is very unreliable, so we have to use the ODBC thing.
|
| Can I manage SQL Server 2000 with Mangement Studio Express 2005? | 20 Sep 2006 20:52 GMT | 1 |
I'm new to the MS SQL Server world. Couple quick questions: 1) Can I use the current version of Mangement Studio Express (MSE) to create/update/delete fields/tables on an existing SQL Server 2000? 2) How do I get connected over the 'Net? I have created an ODBC system
|
| ASP.NET 2.0 and SQL Server 2000 connection issue | 19 Sep 2006 22:38 GMT | 5 |
I am developing an ASP.NET 2.0 application and SQL Server 2000 as back-end. The connection to DB works fine if I connect to my local or our dev databases. It is giving me the error when I try to connect to Test database. However, I am able to connect to the same database
|
| ODBC Connection Problem | 19 Sep 2006 15:22 GMT | 1 |
I'm attempting to setup a linked server to a cache database within Enterprise Manager. I setup an ODBC driver on the server and the connection worked when tested. Selected Micorsoft OLE DB Provider for ODBC Driver from the drop down
|
| Supersocket Unable to bind to 1433 | 19 Sep 2006 14:45 GMT | 3 |
We are running a cluster with SQL Server 8 on Windows 2000 advanced server. Recently, we changed the IP address of just the virtual server, for the cluster. Not long after we were unable to connect to port 1433. I checked in the regestry and the cluster setting is pointing to ...
|
| help with emergency--sql server 2000 sp4 | 19 Sep 2006 06:17 GMT | 3 |
Our site is running fine until our hosting company applied sp4 to our sql server 2000 on windwows 2000 server. It seems that our asp program cannot talk to you sql server 2000 any more. the error message is like this:
|
| MS SQL server login failed | 18 Sep 2006 16:44 GMT | 2 |
I have MS SQL server desktop version installed localy and I have been using it till last time I had to change my windows XP password. After that I could not start service and I am getting an error message: "The service did not start due to a logon failure", and "An error 1069 - ...
|
| Stored procedure output to MS-ACCESS in SQL Server 2000 | 18 Sep 2006 01:15 GMT | 3 |
I have a stored procedure which upon execution, the output needs to be wrote onto a .mdb file..i need to do this as writing it through MS-Access data component makes it very slow when used in c#.
|
| SQLBrowseConnect and Trusted_Connection=yes, Bug? | 17 Sep 2006 08:49 GMT | 1 |
I am trying to use SQLBrowseConnect to obtain a list of databases on the server with Trusted_Connection=yes in the connect strings. I am unable to get it working. I can get it working when not using trusted connection. I found lots of other people complaining about this on the ...
|
| TCP/IP Port question | 17 Sep 2006 04:19 GMT | 2 |
If the TCP/IP is set to Listen All, what does it mean when a specific value is entered against TCP Dynamic Ports, and which is not 0? I checked the documentation and I can't find anything to say what that would mean. I thought it might be the specific port on which SQL Server is ...
|
| crystal report exits on access MS-SQl server 2000 and 2005 with O | 17 Sep 2006 00:17 GMT | 1 |
Setup details: Crystal report : 8.5 Ms-Sql server 2000 and 2005 Crystal report uses MSSQL ODBC driver to get the data from database and
|
| pb odbc error | 17 Sep 2006 00:10 GMT | 1 |
>"[Microsoft][ODBC Driver Manager] Program Type out of Range" |
| Timeout when connecting to SQL server | 16 Sep 2006 21:25 GMT | 1 |
I have an application (winform vb.net 2005) installed on some computers. There is a connection to an sql server on the companys server. This works OK on all machines except one, where I get the message 'TimeOut on trying to connect to sql server.'
|