Archived Months
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
August 2008


all groups > sql server connect > april 2007 > threads for april 22 - 28, 2007

Filter by week: 1 2 3 4 5

Number of allowed connections for SQL Server 2005 Standard on XP P
Posted by michael at 4/27/2007 7:30:04 AM
I assume that the number of connections that SQL Server 2005 Standard can concurrently have will be limited by the operating system it is running on. If that OS is XP Pro, how many concurrent connections can SQL Server 2005 Standard have? -- Michael...more >>

My SQL Provider
Posted by malek_che at 4/25/2007 7:08:01 AM
Hello to all, I have a problem in connecting in a MySQL database. I can create some ODBC connection, but I can't use it to manipulate data. I like Know if Existe a MySQL Provider for SQL Server 2005 that alow me to create connections and manipulate date withe this connections. Thank you in ...more >>

SQL 2005 64bit Connections to Oracle
Posted by Chuck P at 4/24/2007 8:24:00 PM
I have a Linked server from Sql05 64 bit to Oracle. I am using the Oracle OleDb driver because their is no MS to Oracle Provider for 64 bit SQL databases. If I am in management studio I can query the Oracle database. However, if I am in a .net 2.0 web application the Oracle connection will ...more >>

Howto pull SQL Server 2005 database tables into a SQL Server 2000 database
Posted by wit1 at 4/24/2007 5:30:43 PM
Is there any way to: pull SQL Server 2005 database tables into a SQL Server 2000 database, without installing Management Studio on the SQL 2000 server? ...more >>

SQL server express connection string
Posted by Dave at 4/24/2007 1:42:54 PM
I am connecting from an Access front end to a SQL Server 2005 Express database on a remote PC. I have enabled TCP/IP on the server and turned off firewalls on both boxes. The remote PC is called EmpDB, the instance is called SQLEXPRESS the database is called EmDataSQL6 My code follows - thi...more >>

SQL 2005 64bit ODBC Connections to AS400
Posted by RichardT at 4/23/2007 11:04:03 PM
I'm having problems setting up an ODBC Connection to AS400 The server is Windows 2003 R2 64 bit with SQL 2005 SP1 Standard Edition (64bit) Using the Iseries Access ODBC drivers I've created a system DSN called MSSQL_GACUPR01 (I have both 64 and 32 bit drivers from IBM and have each) From ...more >>

Shared Memory Provider error
Posted by UWide User at 4/23/2007 3:14:03 PM
I am having a problem logging in with the "SA" account on a SQL Server 2005 Express server (latest service pack). Here is the error message: "connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error:...more >>

A transport-level error has occurred when receiving results from the server.
Posted by Audrey Ng at 4/23/2007 1:27:10 PM
Hi all, I am getting the error below: I would like to also mention that this error is occuring randomly. I am running a web application under SQL Server 2005 and .NET framework 2.0. Has anyone encountered this issue. Error occurred during report data retrieving and binding. The actual erro...more >>



Access front-end to SQL back-end
Posted by mssbass at 4/23/2007 8:23:44 AM
I'm new to SQL Server 2000. I decided to purchase this server because my old company (UPS) used the server to help expedite queries and manage on-line reporting. So, now it's up to me to utilize and understand the new server. I have been using MS Access as my front- end for several ad-hoc dat...more >>

SQL2005 Man Studio cannot see SQL2000 Dev Ed
Posted by EdwardH at 4/23/2007 5:26:01 AM
I am failing to connect to any of three SQL2000 Dev Editions from Management Studio running on Vista machine. In MS I get "under default setting SQL Server does not allow remote connections (provider: Named Pipes Provider) ...". I have also tried TCP. ...more >>


DevelopmentNow Blog