Visual Basic

Setting Priorities for Pre-Requisites

18-Mar-14 9:38

Felix Fosu wrote:
I am new to ASP.Net

You might want to consider the ASP.NET forum. You might also want to specify whether you mean the default DataGrid[^], or really a DataGridView[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

SPSandy17-Mar-14 1:06

17-Mar-14 1:06

HI
Is there any way to set the priorities of the Pre-Requisites. I have created a setup in VS2008 and added all the pre-requisites. But not able to set the priority. For Example I have the following products as per pre-requisites:
MYSQL
DbCreate
Dot Net 4.0

I would like the priority to be
Dot Net 4.0
MySql
Dbcreate

Can anyone help me please?

Dave Kreskowiak17-Mar-14 3:24

17-Mar-14 3:24

There is no "priority" support built into MSI. If you want to support this kind of thing, you'd have to wrap your entire installation in a Setup.exe that your write yourself.

This .EXE would check to see if each product is installed and then launch the installers for them seperately.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

Eddy Vluggen18-Mar-14 9:31

18-Mar-14 9:31

SPSandy wrote:
Is there any way to set the priorities of the Pre-Requisites

That does not sound logical.

It's the installer that determines the priorities, based on dependencies; if DbCreate is using .NET, then it should either be contained in the package for DbCreate, or be listed as a dependency for DbCreate.

Why do you want to influence the order of execution?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

SPSandy19-Mar-14 7:19

19-Mar-14 7:19

Thanks for the reply.
I will try to put my doubts in words.

As given in the example, Dot Net4.0 is a pre-requisite for the installation of MySql. And MySql is a pre-requisite for the execution of DbCreate.

This is the reason I am a little confused whether it will run according to this steps or will it just run whichever comes first.

Eddy Vluggen20-Mar-14 21:43

20-Mar-14 21:43

SPSandy wrote:
As given in the example, Dot Net4.0 is a pre-requisite for the installation of MySql.

No, it's not. MySQL does not NEED .NET 4 to run.

IF it did, then the package that installs MySQL would need to install .NET 4; it would not be a separate install.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

SPSandy21-Mar-14 7:03

21-Mar-14 7:03

I am sorry but it does need Dot Net 4.0 to install and it does not come with the installer. It has to be installed separately. At least this is true for MySql Server 5.1

Eddy Vluggen21-Mar-14 7:37

21-Mar-14 7:37

SPSandy wrote:
I am sorry

Don't be - you obviously tried it, and I'm merely whining about how they should have created their installer.

I've been Googling a minute for an MSI that includes .NET 4, but can't find it. Will be looking for a place to complain next.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

SPSandy21-Mar-14 7:47

21-Mar-14 7:47

I have actually solved the problem of defining the steps for installer.

SPSandy20-Mar-14 4:27

VB6 Cennect with SQL Server

20-Mar-14 4:27

Hi
Thanks. I was able to sort out according to the required steps.

This issue can be treated as closed.

Ardi Durres15-Mar-14 23:38

Ardi Durres

15-Mar-14 23:38

Hello which is the best way of connecting VB6 application with sql serverv 2000 ? Confused | :confused:

Re: VB6 Cennect with SQL Server

Eddy Vluggen16-Mar-14 1:08

change connection with database on runtime

16-Mar-14 1:08

VB6 support ended in april 2008. Support for Sql Server 2000 ended in april 2013[^]. The combination will be limited to 32-bits, and, hence, 32-bit libraries and controls.

The "best" way to connect a VB6-application has not changed; you'd use ADOX as described. There's enough examples on the internet[^].

I'd also like to point out that there are FREE alternatives to the tools you named; VB.NET can be downloaded for free (search vb.net express) and same goes for Sql Server (search for sql server express). There's a LOT more examples on using those, as they have replaced the older tools.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

alejx15-Mar-14 4:25

15-Mar-14 4:25

Hello !

I have an application on Visual Basic 2013 , Entity Framework 6.02 , Sql server 2008R2.

I have several identical databases.

on design , I have created through wizard the connection with one of them ( For example MyDB1) and I have configured the Entity. Now , on runtime , I want to give the users the possibility to disconnect from the database MyDB1 and to connect to another (identical) database for example MyDb2.

How can I do this through code ?

Thank you !

Dave Kreskowiak15-Mar-14 6:55

15-Mar-14 6:55

There are two things you have to do. The first is change the connection string to whatever you need.

All you have to do is replace the part of the connection string that specifies the database and/or server name the database is on.

The second is that you have to wrap your DbContext class with a partial class and supply a new constructor that accepts a connection string:

Partial Public Class MyDbContext

    Public Sub New(connectionString As String)
        If String.IsNullOrWhiteSpace(connectionString) Then
            Throw New ArgumentNullException("connectionString")
        End If

        Database.Connection.ConnectionString = connectionString
    End Sub

End Class

Whenever you need to create a new instance of your DbContext, you just pass the connection string to the wrapper which will pass it to the ConnectionString property of the DbContext for you.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

alejx15-Mar-14 8:03

15-Mar-14 8:03

Hello !
But how to change the connection string ?
As I can see inside visual studio , the connection string is inside the app.config.How can I change on runtime the part that specifies the database and server ?

For the second thing , where should I put the code ?

And finally , let suppose that I have a textbox where I write the name of the database that i want to connect. And I have a button that make the connection. What code should I pass to the button.click event ?

Thank you !

Dave Kreskowiak15-Mar-14 10:01

15-Mar-14 10:01

This is simple string manipulation. In the app.config file, replace the database name in the connection string with a tag that's easily locatable, like this:

Server={SERVER};Database={DATABASENAME};User Id=myUsername;Password=myPassword;

* This connection string will only an example. Copying and pasting it will do you no good.

The tags, "{SERVER}" and "{DATABASENAME}" are easily found by code and replaced with a line like this:

Dim newConString As String = connStringTemplate.Replace("{SERVERNAME}", serverName).Replace("{DATABASENAME}", databaseName)

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

alejx15-Mar-14 11:29

15-Mar-14 11:29

in my app.config , there are many lines , but Connection string is :

XML

<connectionStrings>
    <add name="MyEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=USER-PC;initial catalog=MyDB1;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

I don't have Server=.... and Database=....
???

Dave Kreskowiak15-Mar-14 12:11

15-Mar-14 12:11

Excuse me, but where in this process did I say "stop thinking for yourself"?

Do you see anything in your connection string that looks familiar?? Like that "MyDB1" looks like your database name!!

How about "USER-PC"?? Doesn't that look like the name of your own workstation?? You apparently have SQL Server installed on your machine!

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

alejx16-Mar-14 6:06

16-Mar-14 6:06

Thank you !
in this line :

Dim newConString As String = connStringTemplate.Replace("{DATABASE}", "MyDB2")

I get an error connStringTemplate is not decared.
How should I declare ?
Thank you !

Dave Kreskowiak16-Mar-14 7:25

16-Mar-14 7:25

That's what you get for blindly copying and pasting code without thinking about it. You're not even ATTEMPTING to figure out what's going on, are you?

That variable doesn't exist in your code because IT'S AN EXAMPLE! connStringTemplate would be replaced by the variable you define in your code that is holding the connection string template that you're searching and replacing the tags in.

Start THINKING! Mad | :mad:

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

alejx16-Mar-14 8:35

16-Mar-14 8:35

Thank you !
I thought that connStringTemplate was a system object that hold the connection string.
Ok but if I declare this variable , how can I set his value to current connection string ?
Thank you !

Dave Kreskowiak16-Mar-14 14:15

16-Mar-14 14:15

Start reading: Google for "ConfigurationManager C#"[^]

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

alejx17-Mar-14 5:32

17-Mar-14 5:32

Thank you !
This is my code for changing the connection String :

Dim connstringtemplate As String = System.Configuration.ConfigurationManager.ConnectionStrings(1).ConnectionString.ToString

 Cnstring = connstringtemplate.Replace("{DATABASE}", "MyDB2")

This is My partial class

Partial Public Class MyEntities
    Inherits DbContext

    Public Sub New(connectionString As String)
        If String.IsNullOrWhiteSpace(connectionString) Then
            Throw New ArgumentNullException("connectionString")
        End If

        Database.Connection.ConnectionString = connectionString
    End Sub

Entity declaration :

context = New MyEntities(cnstring)

But now on runtime i get an error on the line

Database.Connection.ConnectionString = connectionString

An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll

Additional information: Keyword not supported: 'metadata'.

alejx18-Mar-14 4:56