CR9 does not change table location at run time 
Author Message
 CR9 does not change table location at run time

This works fine in CR 8.0, but not in CR9:

        dbtable.SetLogOnInfo mODBCName & Chr(0), _
                mTableName & Chr(0), mUid & Chr(0), mPwd & Chr(0)

I tried this, but nothing happens:

      With dbtable.ConnectionProperties
            .Item("DSN").Value = mODBCName
            .Item("Database").Value = mTableName
            .Item("User ID").Value = mUid
            .Item("Password").Value = mPwd
       End With

I applied the cr90dev and cr90main hot fix, but ... the same: it does not
work !!!

Help
many thanks



Tue, 23 Aug 2005 00:36:04 GMT  
 CR9 does not change table location at run time

The solution is to change table location by adding this:
            Call dbtable.SetTableLocation(mODBCName & "." & mUid & "." &
dbtable.Name, dbtable.Name, "")
Ciao!



Quote:
> This works fine in CR 8.0, but not in CR9:

>         dbtable.SetLogOnInfo mODBCName & Chr(0), _
>                 mTableName & Chr(0), mUid & Chr(0), mPwd & Chr(0)

> I tried this, but nothing happens:

>       With dbtable.ConnectionProperties
>             .Item("DSN").Value = mODBCName
>             .Item("Database").Value = mTableName
>             .Item("User ID").Value = mUid
>             .Item("Password").Value = mPwd
>        End With

> I applied the cr90dev and cr90main hot fix, but ... the same: it does not
> work !!!

> Help
> many thanks



Tue, 23 Aug 2005 01:39:42 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Changing Database\Table locations at run-time from VB6

2. Run Time Change of DB Location, Setting Passwords, and Rpt Location

3. How to change Database location at run time

4. Changing database location at run-time

5. Changing database location at run time

6. Changing Access mdb location in run time

7. Change Database Location at run-time

8. Change TTX location at Run-Time - Please Help....

9. ADO Data Control - Design Time/Run Time database locations

10. Changing a tables name at run time

11. Change does not take effect in run time

12. changes to inherited form not appearing at run time

 

 
Powered by phpBB® Forum Software