Search results for query: *

Okay. I see where you're coming from. I'll give it a try. Thanks again. wcprog

Hi Zathras, Thanks again for your response. The only places that I'm finding the SqlConnection being set is in the various TableAdapter classes. These each appear to be drawing their values from a ConnectionString value in the Application Settings individually. I'm not finding any central...

Zathras, Thank you for your response. I could understand how to apply your answer if I had created the connection and the dataset manually. However, I created the dataset using the "Datasource Configuration Wizard" from the "Data Sources" tab, and so all of the DataSet code is generated. I'm...

In building a simple C# application, I used the built-in tools on the DataSources tab to build a DataSet. We have three SQL Servers... development, model, and production. I was wondering if it's possible to use the same DataSet, but just change the connection string, depending on which SQL...

Thanks to both of you for your suggestions. Unfortunately when I initially installed the server, I didn't install it with the dual-mode login. I opted for only the Windows Authentication, so I didn't have an sa account. I ended up uninstalling the server and reinstalling it and restoring my...

Catadmin, The problem is that the server is on my local machine, so I am the only admin. ptheriault, All services are running. Here's what happened. I detached the database. When that was finished I immediately disconnected from the server. A few minutes later, I tried to reconnect, and...

I would think that the services would have to be running, because I am able to connect to another named instance with no problems. Same with my login info since both servers are running on Windows Authentication. Thanks, wcprog

ptheriault, Thanks for your reply. No, I am not trying to log into any web sites or application. I am using SQL Server Management Studio. When I try to connect to the server, I get the above-stated message "Cannot connect to <Server name>". I can connect just fine to another named server...

I'm a relative newbie to the wonderful world of SQL Server 2005. I have several small databases on my server (nothing very important). The other day I detached a database and then when I tried to log in again I got a "Cannot connect to ..." message. I asked a colleague about it, and he said...

My company has an Access database in 2000 format. We're coming up with some errors when running on a machine with Access 2003 installed. The scenario in question is a form with a subform on it. I discovered that, when stepping through the code on a machine with Access 2000 installed, the...

Thank you for your responses. Karlis Yes, I just noticed that. After reading linney's response, I went back in and tried pasting the results in various programs as you did (with the same results, of course). The difference must be in the e-mail client versions I am using (Work - Outlook 2000...

At work, I use the Print Screen feature on my computer (WinXP Pro SP1) all the time. It creates a .bmp formatted image. I them convert the image in Paint to .jpg format for my e-mails. I've never really questioned that things could be different until yesterday I had occasion to e-mail a...

I am creating a user control containing a ListBox and a Button. I am exposing to the user the Items property along with most of the other functionality of the ListBox. I was hoping that there would be an event that would notify you when the contents of the ListBox had been changed, but did not...

Thank you for your response. This is the approach that I am taking currently. In my particular case, I am combining a CheckedListBox and a Button. I want most of the CheckedListBox functionality and some of the Button functionality to come through with only a few "rewired" properties, events...

By the way... this is using the 1.1 framework :-)

I have created a user control with two or more constituent controls on it. Can anyone tell me what is the easiest way to allow certain properties, events, and methods from each of the controls to be "visible" to the user, but not other properties, events and methods? Thanks, wcprog

Actually I'm running this from Visual Basic 6 using ADO. In stepping through it I'm not getting any errors. The code snippit is as follows: strSQL = "ALTER TABLE [Location] " & _ "ALTER COLUMN [Location_Address] " & _ "SET DEFAULT" Call CON.Execute(strSQL) I just...

Yes. It's actually a whole series of the same statement, but specifying different tables and fields.

By the way, its for a Jet 4.0 database. wcprog

I inherited some legacy code that I'm trying to refactor. I found this SQL statement, and for the life of me can't figure out what it does: ALTER TABLE [Location] ALTER COLUMN [Location_Address] SET DEFAULT Now I know what it should do if there were a value of some sort after the SET...