No, I never figured it out. I just gave up and moved on to a different function. It took me a while, but I got SQLBrowseServer to work for me. halblonious

Thank for responding. Somehow, I got SQLBrowseConnect to work for me, so that serves the purpose I needed. Thanks, though. --Evan halblonious

Maybe I'm just dumb, but even using the code provided by MSDN, I still cannot get this function to work. Please help. halblonious

Thanks, that did seem to work. The sweet irony is, though, that the Sqlfront.h has a compiler error itself: Compiling... testLibraryDlg.cpp c:\program files\microsoft visual studio\vc98\include\sqlfront.h(126) : error C2146: syntax error : missing ';' before identifier 'LPINT' c:\program files\microsoft visual studio\vc98\include\sqlfront.h(126) : error C2040: 'PTR' : 'int' differs in levels of indirection from 'void *' c:\program files\microsoft visual studio\vc98\include\sqlfront.h(126) : fatal error C1004: unexpected end of file found Error executing cl.exe. I'm trying to use SQLBrowseConnect to connect to an unknown server name now, but I'm having even less luck with that. I cut and pasted the example in the MSDN help, but it's got it's own compile errors. halblonious

I'm trying to use this function, but my debugger doesn't recognize it. Is there something I need to define or add to my stdafx? Or, is there a better way to find out the name of the SQL server if it isn't local? halblonious

Thank you very much for you response, but can you please give me a little more in-depth syntax on how to do this? Maybe an example? Thanks again. Evan halblonious

Can anyone help me connect to a database ( an .mdf) and modify it and stuff without using a DSN? I'm not sure why this program that I'm trying to interface with doesn't use a DSN, but it doesn't seem to. Should I create my own DSN in order to access it? Any ideas would be helpful. halblonious

I never even knew to check that. Sadly, though, it doesn't really tell me much. Do you know of a good place to find prototype syntax for this stuff? What I had works for modifying an Access database, but doesn't seem to work on SQL. halblonious

Here's what I've got: CDatabase DataBase; TRY { DataBase.OpenEx(_T("DSN=test;UID=;PWD="),CDatabase::noOdbcDialog); } CATCH(CDBException,e) { #ifdef _DEBUG MessageBox("ERROR Connecting"); #endif } END_CATCH TRY { DataBase.ExecuteSQL("INSERT INTO Annotation (AnnotationID,ImageID,Text) VALUES ('1','2','Capsule')"); } CATCH(CDBException,e) { #ifdef _DEBUG MessageBox("ERROR Inserting"); #endif } END_CATCH It appears to be connecting fine, but I always get "ERROR Inserting". 'Annotation' is the table I'm trying modify fields in. When I set up my DSN, I put the default database to the one that the table 'Annotation' is in (instead of master or model, etc). What am I doing wrong or failing to do? halblonious

Thanks to those who answered my last message. Now, I've found a way to actually LOOK at the database, and I can connect to the DSN. The only problem is: How do I connect to the actual database that I want. I mean, there's like 6 databases in that DSN, and only one of them is the one I want, the rest are master, model, msdb, etc.... How to I access the one I want. I tried doing an INSERT INTO statement to the table I wanted, but it failed (I can only assume it's because I don't yet know how to specify which database it is). Thanks for any help you can give me. halblonious

Okay, so I have this product that modifies a jet database, and now it doesn't work. The program who's database I was modifying switched to MSDE databases. So, I'm assuming that I must do something different programmatically. I just don't know what. Also, I can't even figure out how to create a test MSDE database. I don't even know if it's still a .mdb. Can anyone help? halblonious

--Manually, by keeping several bitmaps with transparency keys. Where can I find how to do this? --No, they don't have a transparent background, unless you're using W2000 or higher ( maybe ) So, is there a way to do something like save the visual aspects of a CStatic as a bitmap, and then layer it for display? Or would that cause weird laggy stuff for the user, or other lame problems? halblonious

I can't seem to figure out how one layers bitmaps. And, can one layer things that aren't bitmaps, like CStatics? Also, what's the best REDO/UNDO method for a publisher-like program? halblonious

OK, thanks. I don't suppose you could give me a quick run-down or a little example of how to do that? I've been programming for like a year now, but everything's still news to me. halblonious

So...I want to be able to layer CBitmaps,CStatics, and CRichEditCtrls in a way similar to either Microsoft Publisher or Adobe Photoshop. What's the best way to do this? (and, maybe you could also give me some hints as to how to properly print something like that). halblonious

I'd first like to say that this website and you people who help me out are amazing and wonderful, and I'm thankful for you. Well, the program I'm making is a report generator for doctors. Basically, the visual part for the user will be kinda like Microsoft Publisher. They can make squares, rectangles, and lines, each with whatever thickness or color, and the shapes will have borders and frames. Plus, there'll of course be text boxes. The reason I want to change how I'm doing it is: if I have to plan ahead for ANY possible way someone might want to use this, I'd have to setup at least like 10 of each type of thing from the get go, which I'm assuming uses more overhead than would be good. But, then what if they want 11 text boxes, or 11 ovals? Well, maybe I should create 20 of each? See the issue, there? So, I figured that a dynamic way of creating them would be better, so I'm only using the space needed for what the user wants, and they can create as many whatevers as they so desire. A question: CStatic m_Statics[1000]; Wouldn't that use a ton of memory, or is there really no way to avoid it? Is this an stl vector? Or is that something different? halblonious

You'll have to pardon my ineptitude, but can you tell me what a vector is, and how to use them? I figured there must be some well-known way to do what I want, I just didn't know about it. halblonious

So...I want users to be able to create an unlimited number of CStatics dynamically in my program, and save & load them. Right now, I'm just defining 20 of them in OnCreate, then serializing data about those 20 (blank data for those not yet created). My problem is: how do I create dynamically any number of them, yet still have a way of say painting/updating them, or even knowing how to refer to them from a function other than the one in which they were created (my only guess on how to make unlimited is just to have the same variable name for each one as it's created, then store the data, but then I'd have to re-create each one on EVERY update or painting for the user to be able to see all of them? Wouldn't this be a horrible waste of resources?) Or, is there nothing to be done, and I should just define like 200 from the beginning and hope they don't want to go crazy with creating things? halblonious

What's the best method for having resizable boxes that can display images imported by a user? halblonious

Thanks for the reply, and I may have to resort to that, but I'm trying not to have to subclass the rich edit if I can help it. There must be some other way, I'm hoping. halblonious