Connecting database at the user end
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I made a small application that getting data from a .accdb file and make some reports using .rdlc report.
The problem is that i need to give this application to an end users woking in different workstations which means the connection string will be different than the one which i used in the application , i’ve tried to make it dynamic by letting the use select were the db file , but it will not be successful for the table adapters which been created for reporting.
Any idea how this can be solved?
Thanks all.
vb.net rdlc ms-access-2013
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
add a comment |
I made a small application that getting data from a .accdb file and make some reports using .rdlc report.
The problem is that i need to give this application to an end users woking in different workstations which means the connection string will be different than the one which i used in the application , i’ve tried to make it dynamic by letting the use select were the db file , but it will not be successful for the table adapters which been created for reporting.
Any idea how this can be solved?
Thanks all.
vb.net rdlc ms-access-2013
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
Can you use relative path? If the adapters have hard coded path, it will need to be changed to dynamic path. The connection string can be loaded at the beginning of the application.
– the_lotus
Nov 16 '18 at 15:21
How can i change the table adapters path to dynamic one? Best
– A..R.Azzeh
Nov 16 '18 at 15:23
Is each instance of your app using a separate database?
– HardCode
Nov 16 '18 at 19:18
No it uses’s one database only
– A..R.Azzeh
Nov 16 '18 at 19:20
I think i need to change it in App.config file but i don’t know how ..
– A..R.Azzeh
Nov 16 '18 at 19:23
add a comment |
I made a small application that getting data from a .accdb file and make some reports using .rdlc report.
The problem is that i need to give this application to an end users woking in different workstations which means the connection string will be different than the one which i used in the application , i’ve tried to make it dynamic by letting the use select were the db file , but it will not be successful for the table adapters which been created for reporting.
Any idea how this can be solved?
Thanks all.
vb.net rdlc ms-access-2013
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
I made a small application that getting data from a .accdb file and make some reports using .rdlc report.
The problem is that i need to give this application to an end users woking in different workstations which means the connection string will be different than the one which i used in the application , i’ve tried to make it dynamic by letting the use select were the db file , but it will not be successful for the table adapters which been created for reporting.
Any idea how this can be solved?
Thanks all.
vb.net rdlc ms-access-2013
vb.net rdlc ms-access-2013
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
asked Nov 16 '18 at 15:10
A..R.AzzehA..R.Azzeh
205
205
Can you use relative path? If the adapters have hard coded path, it will need to be changed to dynamic path. The connection string can be loaded at the beginning of the application.
– the_lotus
Nov 16 '18 at 15:21
How can i change the table adapters path to dynamic one? Best
– A..R.Azzeh
Nov 16 '18 at 15:23
Is each instance of your app using a separate database?
– HardCode
Nov 16 '18 at 19:18
No it uses’s one database only
– A..R.Azzeh
Nov 16 '18 at 19:20
I think i need to change it in App.config file but i don’t know how ..
– A..R.Azzeh
Nov 16 '18 at 19:23
add a comment |
Can you use relative path? If the adapters have hard coded path, it will need to be changed to dynamic path. The connection string can be loaded at the beginning of the application.
– the_lotus
Nov 16 '18 at 15:21
How can i change the table adapters path to dynamic one? Best
– A..R.Azzeh
Nov 16 '18 at 15:23
Is each instance of your app using a separate database?
– HardCode
Nov 16 '18 at 19:18
No it uses’s one database only
– A..R.Azzeh
Nov 16 '18 at 19:20
I think i need to change it in App.config file but i don’t know how ..
– A..R.Azzeh
Nov 16 '18 at 19:23
Can you use relative path? If the adapters have hard coded path, it will need to be changed to dynamic path. The connection string can be loaded at the beginning of the application.
– the_lotus
Nov 16 '18 at 15:21
Can you use relative path? If the adapters have hard coded path, it will need to be changed to dynamic path. The connection string can be loaded at the beginning of the application.
– the_lotus
Nov 16 '18 at 15:21
How can i change the table adapters path to dynamic one? Best
– A..R.Azzeh
Nov 16 '18 at 15:23
How can i change the table adapters path to dynamic one? Best
– A..R.Azzeh
Nov 16 '18 at 15:23
Is each instance of your app using a separate database?
– HardCode
Nov 16 '18 at 19:18
Is each instance of your app using a separate database?
– HardCode
Nov 16 '18 at 19:18
No it uses’s one database only
– A..R.Azzeh
Nov 16 '18 at 19:20
No it uses’s one database only
– A..R.Azzeh
Nov 16 '18 at 19:20
I think i need to change it in App.config file but i don’t know how ..
– A..R.Azzeh
Nov 16 '18 at 19:23
I think i need to change it in App.config file but i don’t know how ..
– A..R.Azzeh
Nov 16 '18 at 19:23
add a comment |
1 Answer
1
active
oldest
votes
I am assuming you are using ado.net typed table adapters.
Usually, the typed table adapter uses the connection string defined in the setting file (app.config file). You can override the setting value programmatically when the application loads the setting file for the first time.
- In the visual studio, open the project properties page (right-click the project and select Properties),
- Select the Settings tab page.
- On the Settings tab page, find and click '<> view code' button (it is located on the top of the tab page).
Override the files as you needed:
Imports System.Configuration
Namespace My
Partial Friend NotInheritable Class MySettings
Private Sub MySettings_SettingsLoaded(sender As Object, e As SettingsLoadedEventArgs) Handles Me.SettingsLoaded
Item("<your connection string name here>") = "<your connection string here>"
End Sub
End Class
End Namespace
answered Nov 20 '18 at 8:47
FerryFerry
112
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53340494%2fconnecting-database-at-the-user-end%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I am assuming you are using ado.net typed table adapters.
Usually, the typed table adapter uses the connection string defined in the setting file (app.config file). You can override the setting value programmatically when the application loads the setting file for the first time.
- In the visual studio, open the project properties page (right-click the project and select Properties),
- Select the Settings tab page.
- On the Settings tab page, find and click '<> view code' button (it is located on the top of the tab page).
Override the files as you needed:
Imports System.Configuration
Namespace My
Partial Friend NotInheritable Class MySettings
Private Sub MySettings_SettingsLoaded(sender As Object, e As SettingsLoadedEventArgs) Handles Me.SettingsLoaded
Item("<your connection string name here>") = "<your connection string here>"
End Sub
End Class
End Namespace
answered Nov 20 '18 at 8:47
FerryFerry
112
add a comment |
I am assuming you are using ado.net typed table adapters.
Usually, the typed table adapter uses the connection string defined in the setting file (app.config file). You can override the setting value programmatically when the application loads the setting file for the first time.
- In the visual studio, open the project properties page (right-click the project and select Properties),
- Select the Settings tab page.
- On the Settings tab page, find and click '<> view code' button (it is located on the top of the tab page).
Override the files as you needed:
Imports System.Configuration
Namespace My
Partial Friend NotInheritable Class MySettings
Private Sub MySettings_SettingsLoaded(sender As Object, e As SettingsLoadedEventArgs) Handles Me.SettingsLoaded
Item("<your connection string name here>") = "<your connection string here>"
End Sub
End Class
End Namespace
answered Nov 20 '18 at 8:47
FerryFerry
112
add a comment |
I am assuming you are using ado.net typed table adapters.
Usually, the typed table adapter uses the connection string defined in the setting file (app.config file). You can override the setting value programmatically when the application loads the setting file for the first time.
- In the visual studio, open the project properties page (right-click the project and select Properties),
- Select the Settings tab page.
- On the Settings tab page, find and click '<> view code' button (it is located on the top of the tab page).
Override the files as you needed:
Imports System.Configuration
Namespace My
Partial Friend NotInheritable Class MySettings
Private Sub MySettings_SettingsLoaded(sender As Object, e As SettingsLoadedEventArgs) Handles Me.SettingsLoaded
Item("<your connection string name here>") = "<your connection string here>"
End Sub
End Class
End Namespace
answered Nov 20 '18 at 8:47
FerryFerry
112
I am assuming you are using ado.net typed table adapters.
Usually, the typed table adapter uses the connection string defined in the setting file (app.config file). You can override the setting value programmatically when the application loads the setting file for the first time.
- In the visual studio, open the project properties page (right-click the project and select Properties),
- Select the Settings tab page.
- On the Settings tab page, find and click '<> view code' button (it is located on the top of the tab page).
Override the files as you needed:
Imports System.Configuration
Namespace My
Partial Friend NotInheritable Class MySettings
Private Sub MySettings_SettingsLoaded(sender As Object, e As SettingsLoadedEventArgs) Handles Me.SettingsLoaded
Item("<your connection string name here>") = "<your connection string here>"
End Sub
End Class
End Namespace
answered Nov 20 '18 at 8:47
FerryFerry
112
answered Nov 20 '18 at 8:47
FerryFerry
112
answered Nov 20 '18 at 8:47
FerryFerry
112
answered Nov 20 '18 at 8:47
FerryFerry
112
112
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53340494%2fconnecting-database-at-the-user-end%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you use relative path? If the adapters have hard coded path, it will need to be changed to dynamic path. The connection string can be loaded at the beginning of the application.
– the_lotus
Nov 16 '18 at 15:21
How can i change the table adapters path to dynamic one? Best
– A..R.Azzeh
Nov 16 '18 at 15:23
Is each instance of your app using a separate database?
– HardCode
Nov 16 '18 at 19:18
No it uses’s one database only
– A..R.Azzeh
Nov 16 '18 at 19:20
I think i need to change it in App.config file but i don’t know how ..
– A..R.Azzeh
Nov 16 '18 at 19:23