| Thread | Last Post | Replies |
|
| 'Crosspost' Structure a New App (SQLServer C# - Security & Db Connecctions) | 30 Dec 2007 20:05 GMT | 4 |
Hi Folks - first off, apologies for the cross post but I'm not really sure which group would be most appropriate for these questions - no offence intended! Porting an app from MS Access to VS with C# and SQLServer, I've come across
|
| why suddenly need to change option "remote connection" from off to on? | 27 Dec 2007 17:40 GMT | 1 |
i installed sql server express 2005. Everything worked good until yesterday .. Indeed, since yesterday and for an unknown reason, i get this error when attempting to login via Management Studio:
|
| Authentification problem with SQL Server 2000 | 27 Dec 2007 09:11 GMT | 4 |
We use SQL Server 2000 (standard edition) under Windows 2003 Server. Due to a hardware failure, we have fully set up the server after having formating the hard drives. After having installed Windows Server 2003, we have installed SQL Server 2000, then we have restored the ...
|
| Locking problem with Access 2002 and SQL 2000 | 24 Dec 2007 20:01 GMT | 3 |
We have a datawarehouse on SQL 2000 were users are free to query using any tools available. I have discovered that users who use Access Linked Tables and Queries hold Shared Locks on the SQL tables while they browse data. This subsequently prevents the replication task from ...
|
| Help! - detached default database.... | 24 Dec 2007 14:46 GMT | 5 |
Hope someone can help me with this. I am new to SQL Server and am using the express edition. I detached my 'Default' database and now I can not connect to the server and do anything! Short of uninstalling it and and reinstalling it - have any ideas on how I can 'reset'?
|
| Connecting to SQL 2005 via DBI Perl and Vista problems. | 24 Dec 2007 03:53 GMT | 1 |
I am trying to connect to a 2005 SQL server though perl using the DBI module. When the perl script is uploaded to my web server the connection is made with no problems but if I download the file to my local machine and run the file I get "[Microsoft][ODBC Driver Manager] Data ...
|
| Change password in ODBC..? | 24 Dec 2007 03:50 GMT | 1 |
I have an Access appl. with linked SQL-server tables. The user have a SQL-server login from a ODBC datasource. How can I get the user to change password themselves after a temporary password?
|
| provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server | 22 Dec 2007 08:07 GMT | 5 |
I have a sql server install / database on the web server. Work great, all my asp.net 2.0 code on that server can access the database with no problem. I can access the database on the web server from my development
|
| SQL2005: Triggering Alerts for logout events | 21 Dec 2007 23:08 GMT | 3 |
is it possible to trigger alerts for login/logout events on a specific database? I want to setoff a job when this happens. Thanks in advance
|
| Connection from MS Access MDB | 21 Dec 2007 22:50 GMT | 4 |
This is a cross-post (I originally posted in the ODBC forum). I have an Access MDB with linked tables to a database that is running in 2005 SQLExpress. We created a new instance of SQLExpress and loaded the database from a
|
| Data type 0x38 is unknown. | 21 Dec 2007 17:51 GMT | 1 |
[IBM][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown. configured latest drivers in directory
|
| Why do connections from Access change UID to dbo? | 21 Dec 2007 14:35 GMT | 2 |
This is a problem which has baffled my team for a long time. We can establish a connection using MS Access 2002 to SQL Server 2000 using a linked table or view or through a pass-through query with a non-SA UID. This credential will remain for a while, and then spontaneously, it ...
|
| ODBC Access Link to SS2K5-Cannot update new records. | 20 Dec 2007 19:06 GMT | 1 |
Access 2003 connected via ODBC using ODBC;Driver={SQL Native Client};Server=ServerName;Database=DbName;UID=xx;PWD=xxx Originally the data was imported from Access tables. All imported records
|
| how to remove sharepoint database and service | 19 Dec 2007 21:31 GMT | 1 |
I'm trying to install doubletake, but it is complaining about SHAREPoint, unable to connect, etc. That isn't the database I want to connect to anyway. Is it possible to remove it and also remove the service for it? I tried to export it and then delete it, but doubletake ...
|
| User() always returns "dbo" when using MS Access Pass-Thru | 19 Dec 2007 15:22 GMT | 2 |
For my stored procedures, I need to retrieve data based on who the user is, which I determine using the USER function. My client is an Access pass-through query with the userid embedded in the connection string. However, when each stored procedure checks the user id it is ...
|