I did the same thing as this poor soul -- I thought I could delete WordPerfect TryBeforeYouBuy -- and now I cannot connect to my local instance of SqlServer, nor my remote host. Can anyone help? This almost seems like it's worth a lawsuit. http://groups.google.com/groups?q=wordperfect+g...more >>

I use an application in my office that utilizes an SQL database. I have no problems using this program on my Tablet-PC so long as I am connected to the network through the local network connection (Cat5 cable). If I try to use it through my wireless connection, I cannot. I get an error mes...more >>

Hi all, Most of the connections I used in my apps are occupied by one SQL query (VFP's remote view). However, in a case where I need atomic transaction, I would share a connection and perform table insertion/update inside SQL's BEGIN TRANSACTION and SQLCOMMIT pair. Question: Are there any ...more >>

Hi I am trying to connect 2 sql servers over the internet, though I want to use Encryption. I was told to make a server certificate so that I could use SQL replication. I made a server certificate though sql service is failing to start cause of an "Invalid certificate". Any idea what type of ...more >>

Hi all, Is there any ways I can write a program to Auto kill those non active process in my SQL2000 server, those unwanted process is killing our SQL performance. Thanks very much!...more >>

Hi: I am working on the walkthrough samples for Visual C# and I run into trouble with Walkthrough: Creating Read-Only Data Access in a Web Forms Page. The error message I have is: Server Error in '/ReadOnlyDataAccess' Application. -------------------------------------------------------...more >>

My understanding of sp_reset_connection is that SQL Server executes this SP every so often so that the settings for a single connection within a pool are reset. Thus allowing the same connection to be used indefinately. However I seem to be getting errors saying that there are no pooled c...more >>

I am in the local SQL server 2000 & the web assistant wizard is available . I connect to a remote sql server 2000 OK but when I click on tools wizards it does not show the set of wizards that I saw in my local server. What is the delio ? ...more >>

I was trying to restore my db and it suddenly stopped and then next time I was trying to restore, It just stopped working. It continues to show that DB is loading. I am trying to delete the DB so that I can recreate it, but cannot do anything. This is my test server so I can play around w...more >>

Hi, I want to connect to multiple servers (ms sql server, oracle, ASA, and ASE) and I plan to use SQLDriverConnect(). Reading over the documentation on MSDN I see that the connection string for SQLDriverConnect() allows braces (e.g. { } ) for attribute values.. such as PWD={xxx} -- (though it...more >>

I want to control the amount of concurrent users that access a SQL database via a VB6 application. Take Note: Concurrent users to a database in SQL, not concurrent users to a SQL server. ...more >>

i would like to know how to connect and call data from a particular sql database using windows scripting. i would like to create some users based on the names in a database. Please help. thanks....more >>

I am currently only connecting to 2 outside SQL DB's using Enterprise Manager. I have had no problems with either account as of last Thursday. I started my system up after 4 days out of town and found that I could not connect to either DB, always getting the following error "Sql Server doe...more >>

Hi! I have trouble with VB6.0 program. You know, I use VB program to connect to SQL Server2000, it works well on Window 98 and 2000, but when I run it on Window XP, error occured when I changed the default database of SQL connection, and hereafter program code: SqlCnn is Adodb.connect...more >>

Hi all, i've just set up an mysql server on my computer and now i want to connect to a mysql database with an ASP page but i can't find the correct connection string. I always get an error that the datasource can not be found. ConnString = "Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID=us...more >>

I am fetching encrypted password from registry and building a connectionString from it but my Open method throws error 18456. When I fetch an encrypted password from database, everything is fine, the problem is when I fetch it from registry. I am using MD5 to encrypte passwords. Any help w...more >>

We are making use of Actuate Reports for one of the projects and presently it is making use of Oracle Database, now the requirement is that we need to port everything from Oracle to MS SQL server, Please let me know how to go about with this? Regards, ...more >>

HI' I installed MS SQL 2000 on Windows2k Server and when I activate it my network or internet connections stucks. It doesn't disconnects but all network activity stops. If I kill the sql prosses everything works normal again. I have a modem alcatel that needs VPN to be connected. All th...more >>

Trying to insert into a field that is varchar(20) but I want to pad the entry with "0" on the beginning of it... so if the item to be written is 10 chars long I want to write 10 "0" on the front of the item.. how to accomplish? Thanks -- Austin Henderson <>< Network Administrator ...more >>

Looking to create a flat file from a stored proc that is comma delim.. can this be done? I know I can use DTS but the table is a temp table and that wont work. Thanks for your help in advance. -- Austin Henderson <>< Network Administrator ...more >>

I need to be able to call a .sql file from within access and have it execute the contents against a .sql server connection. The code in the file is approximately four times longer than a string variable will hold. What is the best method for pulling this off? thanks a million ...more >>

I just installed SQL 2000 Ent Ed on a cluster windows 2003 enterprise Ed O/S. I can attached to the SQL Server using Enterprise Manager from other computers. I can Attach using SQL Query Tool. When I run an asp page I get the following Error Microsoft OLE DB Provider for SQL Server (0x800...more >>

Hi, We have a linked server setup as follows MSSQL ->Linked Server (ODBC) -> Progress 9.01D(AIX) When running a stored procedure on mssql i can insert/update rows on the linked server using openquery. However if those same statements are wrapped in a transaction then they fail with ...more >>