|
Typically you set the userid and password when you build your database. In the VS.NET IDE add a textbox dialog and set up the properties to store the userid and password. Then configure the custom action that runs the script to create your database toi receive these property values and set the userid and password in your SQL script.
Robert
|
|
|
|
|
you are right but i want to set the password for "sa",during sqlserver installation from the setup file, i can determine the sa password and now i want to do so by merge modules.
thanks
|
|
|
|
|
I am not sure I understand why you would need to do this. You can run the built-in system stored procedure named sp_password to change the sa password from a script after a SQL Server is installed, so why would it matter if you set the sa password during the actual SQL Server installation itself, or if you set the sa password in a final custom action in the same package that installs the SQL Server?
The final result - setting the sa password - is the same in either case...???
In any case, a merge module is not a distinct physical entity in terms of an actual running setups. Merge modules cannot be "run" and do not exist as any sort of separate "setup". A Merge Module is nothing more than a set of Windows Installer tables and possibly CAB files. When you add a merge module to a Windows Installer package, what happens is the merge module tables are copied into the installer database along with any CAB files. The final result is a single MSI with additional table entries, not an MSI plus merge module components that are also run by the setup.
So you cannot change the behavior of a merge module by, for example, setting command line arguments.
The only way to change the behavior of a merge module is to manually author new functionality into the Windows Installer tables. Since a merge module becomes part of your final MSI, it does not make any difference if you change the merge module itself, or change your final MSI package after you've added the merge module. The net result is the same, because Windows Installer does not understand the concept of "running a merge module".
It would make more sense to change your final MSI package - which is essentially what I've already described: Add a dialog to collect the SQL Server parameters from the user interface and then run a script in a custom action that configures the SQL Server.
Robert
|
|
|
|
|
I am trying to do this application that when the form loads, a listbox fills with the users on the server/machine. I found a way to do it using a console, but I want to do it in a GUI. This is what I have so far.
NET_API_STATUS nas; //return code from NetMessage....()
LPBYTE buff; //buffer
MSG_INFO_0 *msg0; //message array info structs
DWORD handle, dwEnumCnt, dwEnumTot; //output from NetMessageNameEnum()
//get list of users on the server or machine
nas = NetMessageNameEnum(NULL, //use this server
0, //MSG_INFO_0 structures used
&buff, //*bufptr
256, //prefered max len of results
&dwEnumCnt, //LPDWORD etries read
&dwEnumTot, //LPDWORD total entries
&handle); //LPDWORD resume_handle
if(nas != NERR_Success)
{
MessageBox::Show(stderr);
}//end if
//display list in listbox
msg0 = (MSG_INFO_0*) buff;
for(i = 0; i < dwEnumCnt; i++)
{
userLbx->Items->Add(msg0[i]);
}//end for
I got that from some website, and changed the variables, but I keep get build errors, can anyone help? Thanks
|
|
|
|
|
Hi all, i have a pda application that uses SQLServerCE, and i would like to have wireless support for it so that i can use Remote data access to access SQLServer on a desktop terminal, and synchronise the data on the pda with the data on the desktop. I have a few questions here:
1)do i need any extra hardware or software on the desktop to enable for wireless connection?
2)In the code i have below, i left InternetUrl as blank as i'm not sure what i am supposed to put there. what is the parameter supposed to be? address of the desktop?
3)Is the code below sufficient for me to connect to the desktop database wirelessly?
Dim conn As String = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=admin;" & _
"Data Source=terminal;Packet Size=4096;Workstation ID=terminal;User Id=;Password="
Dim rda As SqlServerCe.SqlCeRemoteDataAccess = Nothing
Try
rda = New SqlServerCe.SqlCeRemoteDataAccess
'rda.internetUrl = "?"
rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\test.sdf"
rda.Pull("admin", "Select * from admin", conn, RdaTrackOption.TrackingOnWithIndexes, "ErrorTable")
Catch err As SqlServerCe.SqlCeException
MessageBox.Show(err.Message)
Finally
rda.Dispose()
End Try
Thanks for looking at my post =)
|
|
|
|
|
SqlServerCE uses IIS (a web server) to bounce over to your SqlServer2000 server.
The connection string would be a URL to the IIS page. The page would query the server, and forward it back to the device.
See "SQL Server CE Database Development with the .NET Compact Framework" by Rob Tiffany
I JUST got a wireless ppc yesterday, so I'm eager to try this book out.
Top 10 Geek Resulutions:
5. To decipher what that big room is, which has the blue ceiling and poor climate control.
|
|
|
|
|
Hi, having trouble with .NET CAS configuration:
1. I want to add a Code Group with membership condition:
1.1 All applications running under "c:\inetpub\wwwroot\"
I tried doing this using dot-Net Framework Configuration Tool. To configure membership condition, there are various options: SPC, Hash, Strong Name, URL, site, zone, Application Dir... but nothing seems to suit this purpose. The closest thing I found is "Application Directory", but there's no place where you can specify the specific application directory desired.
1.2 I want to DENY file IO permission.
2. If my ASP.NET apps runs under a user acc, say, "MyAPPAcc" (by way of impersonation)... then ... What's the implication? The security privileges assigned by way of CAS applies? The resultant privilege that an ASP.NET app has is the intersection between:
a. privileges assigned to ASP.NET assembly (by CAS config)
b. privileges assigned to user account "MyAppAcc"?
Thanks in advance!
Norman Fung
|
|
|
|
|
Hi,
[Delphi Windows Forms .NET]
I have a problem with Opacity. When I change the opacity in the loop (list.1), first the WinForm will change color to black and then this black form will disapeare. If I change the Opacity to 99% and then do the same, this "black bug" won't happen. Why?
List.1.
var i,step: real;
begin
i:=1.0;
step:=0.01;
repeat
Opacity:=i;
i:=i-step;
until i
|
|
|
|
|
This might be either a video driver problem or a problem with Delphi.NET. I can't reproduce the problem on VB.NET on the .NET Framework 1.1 or 2.0.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I think this might be a problem with Delphi .NET (I use Delphi2005). Till now, I have only one solution: change the Opacity value to 99% an then start the loop, but this isn't good solution.
Thanks for your answer
|
|
|
|
|
What I am trying to do is launch a windows application from within my WinForms application. Once this is done I want to have this external application behave like a control on my WinForms app (no longer appears in status bar, no frame etc.).
I remember seeing a Code Project article describing how to do this,
but days of searching here and on google for it has not turned up anything. Does anyone reading this remember the article? If so can you remember the title? Or even better, post a link?
Its driving me nuts being unable to track it down.
|
|
|
|
|
Boy is my face red. Just did another search before logging off and found it:
http://www.codeproject.com/cs/miscctrl/AppControl.asp
|
|
|
|
|
I am working with a test suite which operates on an IWebBrowser2 object. Is there a way to clear all cookies for this browser ? I would like to get rid of possible cookies set by earlier test runs.
Thanks,
Michael
|
|
|
|
|
The browser object that you instantiate uses the same cookies that any open IE window uses. There's no mechanism to determine which browser window, or control on your form, created the cookies. You either wipe them all out, or none of them.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
and how can I wipe them all out ? That would be all I need
Thanks, Michael
|
|
|
|
|
hello.
i am trying to creat a server/clients application and i want the server to hold an object and the clients to recive references to that object. (so far easy)
but i also want to do databinding on some of the propertyes so when someone changes a property the other clients will see the change live...
i tryed treating the remote object as an ordnary object and creat databinding but it didnt work..
is it even posible?
can any one here give me an example of how to do it?
|
|
|
|
|
Try using one event so the other clients know that they need to refresh their data. I don't think u have a refference to the data, but u have a ref to the object, so the properties of ur client ref object will change when u call them again, not when some other client set them .You still have to deal with concurency.
I hope u undestand, my english is bad.
|
|
|
|
|
I really need a 'C++ source code' edit .NET control.
|
|
|
|
|
I hope that someone already stumbled with this. I'm starting a new Interop project having Java webservices and a .Net invocation manager for this services. All our DTOs (Data Transfer Objects) are specified as XSD files, and we generate our serializable objects from there. Now, I was able to generate classes from the schemas, but I have a problem with the properties, I cannot generate the properties with setters/getters wrapping around private fields.
Is there a way to achieve this using the xsd.exe shipped with VS? Is there any other tool to do it?
Thx...
Fabian
|
|
|
|
|
Are there any good articles or resources available for resolving the external IP address of a router from an internal computer. I have a computer that is using 192.168.0.x and I want to know the external IP address of the router that is located on the same network.
I have looked at the System.Net namespace, and it appears to have a very limited functionality for IP address querying, unless I'm missing something.
Thanks in advance!
|
|
|
|
|
How to ping an IP address by using sockets in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;828993
|
|
|
|
|
|
Hi coders,
I was wondering about the apis used while writing the SetStyle Method. I am creating an API control class using NativeWindow class in .net framework. I need to set styles of the window (like double buffer, userpaint, resize redraw...)
Some of these styles can be applied by using SET... apis (like instead of SetStyle Opaque, True ; SetBkMode api can be used)
I need to know the apis used for all other styles in ControlStyles enum.
Thank you for your time
Best Regards
Emre YAZICI
|
|
|
|
|
The ControlSetStyle method *is* used to set the ControlStyles bits.
Or, are you talking about a different API other than .NET?
PeterRitchie.com
|
|
|
|
|
Thank you for your answer. I know what the ControlStyle bits, and I know what is it doing, the reason why i am asking for a way to perform the SAME thing(as SetStyle does)
I think we are able to set the styles with API
e.g (As I mentioned) Instead of SetStyle (opaque,true) you can use the SetBkmode API, and (I am not sure) instead of Double buffer, you can use CreateCompatibleDC API. I am asking for the other ones' apis.
Do you know them?
Thanks
Best Regards
Emre YAZICI
|
|
|
|