Solved

How to change VB data Environment Initial catalog (Default Database)

Posted on 2003-11-25
4
306 Views
Last Modified: 2013-12-25
Hi

I am facing problem with data environment. I want to change the default database property which is used by the data environment's connection dinamically. I have added some commands to that connection which are record sourse to some reports. But On some condition i want to change the default database property to some other database which is on the same server to fetch records.

Any help would be highly appreciated.
0
Comment
Question by:indian_vb_dev
4 Comments
 
LVL 29

Accepted Solution

by:
leonstryker earned 25 total points
ID: 9817916
0
 
LVL 96

Assisted Solution

by:Bob Learned
Bob Learned earned 25 total points
ID: 9819532
Check the connect string for the connection object used within the Data Designer.  You can change it and reset the designer.
0
 
LVL 1

Expert Comment

by:ayufans
ID: 10512125
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- Points split between leonstryker and TheLearnedOne

Please leave any comments here within the next four days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

ayufans
Cleanup Volunteer
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Spell Check in VB6 13 126
I need help using System.Web.HttpUtility.HtmlEncode in my VB.Net application 3 94
VB 6 error 5 in windows 10 but not in XP 7 63
Advice in Xamarin 21 97
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question