Board index MS SQL Server

Connection Not Updating Data Source

Connection Not Updating Data Source

Post by KJ » Sun, 28 Jul 2002 00:08:15



I am trying to dynamically update a Paradox 5.0 connection
by using the datasource property of the connection
object.  I am able to see that the datasource is being
updated by displaying the datasource property in a message
box, however, I am certain that when a task is executed
using the connection, the original datasource is still
being used.  It seems that my connection is not updating
the datasource even using a Dynamic Properties task.  Are
there any known bugs or does anyone know of a fix for
this?  Any help will be appreciated.

Thanks in advance,
Kevin

 
 
 
Top

1. Changing a DTS connection data source does not propagate to SQL Exec Tasks

I have defined a SQL Server 7.0 DTS package with one SQL Server Connection.
Lets assume the database associated with that connection is called
JOE_TEMPLATE. In this same DTS package, I have several SQL Tasks that
perform miscellaneous operations using the connection I just mentioned.

Now, in my visual basic application, I create a DTS package object and load
it from the existing DTS package above. Based on login parameters, I
dynamically change my connection's database to JOE_TESTDB. The
transformation into this connection works fine. However, all my SQL Tasks
associated with that connection still think they are pointing to database
JOE_TEMPLATE.

Its as if when I change the database of my connection, the other SQL tasks
associated with that connection fail to use that new DB name and use the
original hard-coded one.

Does anyone know if this is a bug or if there is something else I need to do
besides changing my connection's data source?

2. User Account

3. ODBC Connection error - Data Source Name not found and no default server specified

4. Simple data dictionary

5. open connection using Prividers and DSN not data source

6. Help Please-

7. record sections do not match data source ( data report)

8. SqlServer vs Access

9. Data Source: Programmatically Configuring an ODBC Data Source - HELP PLEASE

10. cannot add MSAccess 97 data source in ODBC Data Source Admin

11. Help:ODBC Data Source Admin doesn't show Names of new Data Sources

12. VFP3.0, W95 - Views not Updating Source Tables

13. ODBC to VMS source; Connection not being dropped


All times are UTC
Board index