| Thread | Last Post | Replies |
|
| Exception while using MS SQL SERVER 2005 | 31 Jan 2006 20:05 GMT | 4 |
Hi When I deploy my application on JBOSS connecting to SQL SERVER 2005 using the latest beta driver, I get this exception com.microsoft.sqlserver.jdbc.SQLServerException: Server failed to resume the transaction, desc: 5000000003 There is no transaction context here, its just a ...
|
| Batch Updates | 31 Jan 2006 19:30 GMT | 1 |
Does the driver support JDBC batch updates??
|
| Read Failure General SQL Error | 31 Jan 2006 18:51 GMT | 3 |
I am using Delphi 5 Enterprise version and SQL Server 2000. So, I use the odbc bridge. SQL Client connects through TCP/IP(not named pipes). My application works alright, but sometimes, the clients get this Error Read Failure General SQL Error [Microsoft][ODBC SQL Server ...
|
| add linked server problem | 31 Jan 2006 14:33 GMT | 1 |
Hi, there, I have two SQL Server 2000, which are SQLA -- with SAN connected; SQLB -- just a bald SQL Server. I want to set up linked server from SQLA , so I can run query like "select *
|
| Linked SQL Server table in Access | 31 Jan 2006 14:31 GMT | 2 |
Why does the ODBC Link Table utility prepend "dbo_" to each table I've linked into an Access database? I realize dbo stands for database owner, but why is this an issue? Can I get it to drop the "dbo_"? Thanks
|
| ODBC Data Source to a linked SQL Server | 31 Jan 2006 14:29 GMT | 1 |
I'd like to set up an ODBC Data Source to a table in a linked SQL Server, via my local SQL Server. When I use the ODBC Data Sources program to set up the ODBC DSN, it
|
| Ports to open in Windows Firewall for SQL Server 2005 | 30 Jan 2006 23:03 GMT | 7 |
I'm running the Develpers version of SQL Server 2005 on my developer machine. I want to test an application from another machine but can neither log on nor use the SQL Server Management Studio from the remote machine unless I turn off the Windows Firewall on the development ...
|
| Excel DBCC Error | 30 Jan 2006 20:11 GMT | 1 |
Forgive me for cross-posting but this involves ODBC as well. I'm getting "User 'Test1' does not have permission to run DBCC TRACEON." when trying to connect Excel to SQL Server 2005 using an ODBC System DSN. I've discovered that this is due to Excel or, more appropriately
|
| How to determine if a linked server is available | 27 Jan 2006 17:03 GMT | 1 |
I need to write data from one SQL server in to a linked server running on an other machine. How can i check with T-SQL commands if this server is available? If it is not available the stored procedure directly quits with an error.
|
| SQL Server very slow over internet... | 27 Jan 2006 12:25 GMT | 3 |
I have an application that uses SQL Server and can be run on mutiple computers over a local area network. One of my clients has requested to have SQL Server running at their main office and have each client machine at a different location connecting to SQL Server over the
|
| How to connect a workstation to SQL Server 2005 thru ODBC? | 26 Jan 2006 23:05 GMT | 3 |
I have installed a SQL Server 2005 named instance with mixed authentication on a Windows 2003 Standard Server. SQL Server Service is running under local system account. I have not changed any default setting. I want to set up a System DSN in ODBC Data Source Administrator on a ...
|
| Problem reusing the same connection in Sql Server 2005 with ms jdb | 25 Jan 2006 18:01 GMT | 2 |
Ok, I am really new at this and am having some issues and not sure where to start. Here is what I am seeing. I connect to sql server 2005 just fine.
|
| login failed for user error | 25 Jan 2006 16:08 GMT | 2 |
Hi, I'm fairly new at SQL access from an ASPNET webform and cannot seem to get the SqlConnection string to work properly. I'm running VStudio, C#, IIS 5.1, MSDE sqlserver, Net 1.1 framework. The connection code that causes the error is:
|
| Behavior of Connection.commit() | 25 Jan 2006 02:13 GMT | 31 |
Running with "SET IMPLICIT_TRANSACTIONS ON", with the old driver we would sometimes issue a commit on a connection when no work had been done on the connection, and we would never get "Msg 3902, Level 16, State 1, Line 1 The COMMIT TRANSACTION request has no corresponding BEGIN ...
|
| SQL 2000 Linked Server - Error 6: SQL Server not found | 24 Jan 2006 23:31 GMT | 1 |
I am new to linked servers and basically I want to query data from several tables on server A and then insert that data into a simple table on server B. I am hoping to do this from within a stored procedure on Server A rather than writing a small app.
|