n********6
发帖数: 1511 | 1 --Fixed---
It's more on IIS configuration.
set impersonate = 0 in php.ini
set network service in application pool.
set username & pwd blank in php page.
-----Problem------------
I can use the 'WebAppDBConn' user in Studio, but failed in web.
Internal Server Error CDbConnection failed to open the DB connection. An
internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
Thank you.
Connection String failed:
$databasetype =... 阅读全帖 |
|
N********g
发帖数: 132 | 2 3. there are different kind of databases; given a query, system will tell
you which database you should connect(system gives you a string like "Oracle
" or "MySQL"). Design a class that could handle any query.
这题考的是separation of interface and implementation，code against interface
，not against implementation，如果做过JDBC开发，立马就知道什么意思。
好比你写了一些DAO（Database access object），就是用来把数据从数据库里面读出
来，然后交给中间层处理的工具类，但是你们开发组在不久的将来，打算把数据库由
oracle转成mysql。如果这些DAO里面的具体选取数据的方法，都跟oracle数据库相关，
都跟oralce对应的java class相关，那转数据库的时... 阅读全帖 |
|
N********g
发帖数: 132 | 3 3. there are different kind of databases; given a query, system will tell
you which database you should connect(system gives you a string like "Oracle
" or "MySQL"). Design a class that could handle any query.
这题考的是separation of interface and implementation，code against interface
，not against implementation，如果做过JDBC开发，立马就知道什么意思。
好比你写了一些DAO（Database access object），就是用来把数据从数据库里面读出
来，然后交给中间层处理的工具类，但是你们开发组在不久的将来，打算把数据库由
oracle转成mysql。如果这些DAO里面的具体选取数据的方法，都跟oracle数据库相关，
都跟oralce对应的java class相关，那转数据库的时... 阅读全帖 |
|
b******a
发帖数: 20 | 4 My two cents:
You can create synonyms or grant read pemissions if you just need the same set
of data.
If you just want to copy the data one time and change them separately down the
road.
Inside one database, try following
For account B, run
create table T1 as select * from A.T1;
create table T2 as select * from A.T2;
... ...
Across different databases, use sqlplus COPY command
COPY FROM SCOTT/TIGER@MYDATABASE
INSERT T1 -
USING SELECT * FROM T1
... ...
to |
|
p******a
发帖数: 41 | 5 well, I am not sure if this will help. The database may be partially corrupt.
Backup before trying.
1. Delete the problem form.
2. Compact the database.
3. Close it.
4. At the command prompt, enter something like this. It's all one line,
and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"
5. Open it and compact again.
6. Open a code window, and choose Compile from the Debug menu. Repeat
until there are no compile errors.
7. |
|
d****u
发帖数: 275 | 6 各位大侠，我需要将一堆xml数据导入mysql的数据库中，
xml文件名001，输入的表是mytable，xml文件以rootTag开始，
运行的情况是，我的表里边相应的column都更新了，但是没有任何数值；
请问这段script到底哪里出错了？？非常感谢！！
LOAD DATA LOCAL INFILE 'H:\\XXX\\2011\\001.xml'
INTO TABLE mydatabase.mytable
LINES STARTING BY '' TERMINATED BY ''
(@award)
SET
AwardID = ExtractValue(@award, 'AwardID'),
FirstName = ExtractValue(@award, 'FirstName'),
LastName = ExtractValue(@award, 'LastName'),
EmailAddress= ExtractValue(@award, 'EmailAddress'); |
|
