Rookie
|
| Posted: 10/13/2004, 7:23 AM |
|
When I change the connection name, CCS change it in the property window, but not in the code, I had to change it manually from DBTEST to DBAccountant in all pages...
is this a bug?
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 10/13/2004, 7:28 AM |
|
It's not a bug. The connection name should never be changed (at least I never change it). But of course you can change connection settings/configuration, while leaving the connection name unchanged.
If you have a strong reason to change the connection name then you may need to run Find & Replace to change it in all your files.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
rosorio
Posts: 9
|
| Posted: 10/14/2004, 7:37 AM |
|
The problem is the following one
Conecction with the data base is made in the file common.asp
This file load,after of some first page of the project
Solution:
.- modifies the user table
.-creates a field with the name of the data base
.- creates a pages of login outside your project of CCS
.- read the table of users and to obtain the name of the data base
.- keeps the name from the data base in a session variable
sql =SELECT Company, CustomerName FROM lsCustomers WHERE (CustomerName = '" & customername & "')"
Set oRs = oConn.Execute(sql)
session("DataBase")= oRs("CustomerName")
my data bases are called with nick name of clients
.- changes conecction in common.asp file
ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=(local); Initial Catalog=" & session("DataBase")
this way , you can read all them data base, that it wants, with same
proyect of CCS,
Saludos desde Panama
|
|
|
|
rosorio
Posts: 9
|
| Posted: 10/14/2004, 7:38 AM |
|
The problem is the following one
Conecction with the data base is made in the file common.asp
This file load,after of some first page of the project
Solution:
.- modifies the user table
.-creates a field with the name of the data base
.- creates a pages of login outside your project of CCS
.- read the table of users and to obtain the name of the data base
.- keeps the name from the data base in a session variable
sql =SELECT Company, CustomerName FROM lsCustomers WHERE (CustomerName = '" & customername & "')"
Set oRs = oConn.Execute(sql)
session("DataBase")= oRs("CustomerName")
my data bases are called with nick name of clients
.- changes conecction in common.asp file
ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=(local); Initial Catalog=" & session("DataBase")
this way , you can read all them data base,  that it wants, with same
proyect of CCS,
Saludos desde Panama
|
|
|
|
|
