s**********o 发帖数: 14359 | 1 你的问题问的很奇怪,你是TRUE CLIENT SERVER DOMAIN系统么,ACCESS database
file 必须能LOG ONTO SERVER,ACCESS数据库和FILE是完全的两个概念,装SQL SERVER
要求你给SERVICE ACCOUNT的,一般确定了就不能改了 |
|
y***c 发帖数: 676 | 2 【 以下文字转载自 Programming 讨论区 】
发信人: Warrick (采蘑菇的大白兔), 信区: Programming
标 题: 借人气问一下:ACCESS转成SQL
发信站: BBS 未名空间站 (Thu Sep 12 01:28:31 2013, 美东)
有一堆分开的ACCESS的MDB格式文件,想把它们弄成SQL的方便访问
有什么办法吗? |
|
l******9 发帖数: 579 | 3 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error of access IBM Netteza database from C# in Visual Studio
发信站: BBS 未名空间站 (Thu Jul 17 10:02:59 2014, 美东)
I need to access IBM Netteza database from C# in Visual Studio 2013 on win 7
.
connectionString="Driver={NetezzaSQL}; Server=xx.x.xxx.xxx;Database = my_db;
Uid=my_user_id;Pwd= my_password; ReadOnly=true;
I got exception:
An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in
System.Data.dll
Addit... 阅读全帖 |
|
l******9 发帖数: 579 | 4 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: change year format in Access by SQL query
发信站: BBS 未名空间站 (Mon Oct 13 12:50:53 2014, 美东)
I am working on Access 2012 on win 7. In a table, I need to change a year
date format from '1-Jan-06' to 2006 and from '1-Jan-90' to 1990. I only need
year.
This is my query
SELECT *,
CASE
WHEN CAST(right(year_date,2) , INT) <= 12
THEN 2000 + CAST(right(year_date,2) , INT)
ELSE 1900 + CAST(right(year_date,2) , INT)
END
FROM my_table;
I ... 阅读全帖 |
|
M**********n 发帖数: 4964 | 5 很少用Access,实在对Access不熟悉。请大牛们指点指点怎么做,给个方向/idea。
比如我现在有一个十万record的table,我想根据三个fieldname(假设fieldnameA,
fieldnameB,fieldnameC) filter table,然后generate report。
我现在根据这三个fieldname弄了三个group by query,每个query只有这个fieldname
,没其他field了。比如queryA有100行,queryB有300行,queryC有500行。然后在form
上弄了三个combo box,每个combo box的dropdown list来自各自对应的query,ComboA
有100 dropdown item,ComboB有300 dropdown item,ComboC有500 dropdown item.
其实这个十万record的table是dynamic的,每过一段时间就要import new data append
到这个table里面。所以那三个query的行数(dropdown item)有可能是... 阅读全帖 |
|
x******m 发帖数: 736 | 6 给postgre remote access,改了 pg_hba.conf, 加了host all all ipaddrss trust
。在postgresql.conf中listen_addresses = '*' 重起了postgres,还是不能remote
access,网上搜了无数,都是这么弄得。请教大家可能是什么原因。 iptables也看了
,没有block ip。 |
|
e*********y 发帖数: 972 | 7 把SQL 学完了,
发现需要学MS Excel 和 MS Access
请问MS Excel 和 MS Access 需要学到什么程度? |
|
j**o 发帖数: 102 | 8 想学学DOTNET. 装了vs2005,安装时没有任何问题。建了一个"HELLOWORLD",确不能编译
。说什么’Binding Handler Invalid", 网上搜了一下,好像是VS2005的一个BUG.下
载了SP1,问题解决了。然后试图打开一个ACCESS DB,总是说Frame2。0要求MDAC 2。6
以上。在微软网站上找到了2。7和2。8的MDAC. 2。8下了之后说操作系统不对, 不
安装。2。7安装成功,可是还是打不开ACCESS文件,还总是说我的MDAC版本是2。1。什
么的。机器也重新启动过了。我用的是单位的机器,没有管理员权限,但安装没有问题。
我在家里也装了,两个问题都没有出现。
另外,我还有VB2003, 我是不是从2003开始学比较好。
谢谢。 |
|
s*******z 发帖数: 422 | 9 I have two domains: A & B.
I host the ASP.NET site on Domain B, but need to access a folder on Domain A
. I can physically open the folder on B, but when I click the link on the
webpage, it gave me this error message:
Access to the path '\AAA\BBB' is denied.
Can anyone help? Thanks a lot! |
|
O*****c 发帖数: 171 | 10 3.0 beta radmin was once running on it but now it expired before I can
install any other remote access software. The windows 2003 intrinsic remote
desktop access service is not started either.
thanks a lot! |
|
j*****o 发帖数: 320 | 11 I think I should add the access-list to an access-group for the
interface net2. |
|
n*****y 发帖数: 71 | 12 according to my experience with PIX, you can only do translation from high
security interface to low security interface. Try to do a translation from high to
low, e.g. static (net2, net1) 192.168.2.x 192.168.1.y netmask 255.255.255.0,
if you just want PCs connected to high sec interface to access to the low
sec interface. if you want the whole high sec subnet to be able to access to
the PC in the low sec interface, try to use global + nat command.
if you got any other question, you can try to se |
|
s*******z 发帖数: 422 | 13 I have Domain A & Domain B
I host the ASP.NET site on Domain B, but need to access a folder on Domain A
. I can open the folder on A from B, but when I click the link on the
website, it gave me this error message:
Can anyone help? Thanks a lot!
Access to the path '\AAA\BBB' is denied. |
|
x*********n 发帖数: 28013 | 14 比如
access-list 50 deny host10.2.2.2
这里的50是有顺序的,对吧?
平日里这个数字不好用,因为如果ACL很多的话,我们要做文字标记。
比如
access-list NoNat extended permit ip object-group StoreLan 172.25.0.0 255.
255.0.0
那么这个时候,device怎么知道先后顺序呢? |
|
b********6 发帖数: 35437 | 15 【 以下文字转载自 shopping 讨论区 】
发信人: beetle1986 (beetle), 信区: shopping
标 题: ·[包子求助]X200的access connections找不到无线网
发信站: BBS 未名空间站 (Tue Feb 23 21:56:31 2010, 美东)
之前可以正常使用
借出去一天回来,发现thinkvantage里access connections找不到无线网
但是从win7的控制面板connect to a network里能够找到无线网并能够联接
请问这是哪里的设置出了问题?
包子谢~ |
|
p****0 发帖数: 1786 | 16 【 以下文字转载自 Statistics 讨论区 】
发信人: pn2010 (pn2010), 信区: Statistics
标 题: does any know how to access sas via Xming and putty?
发信站: BBS 未名空间站 (Fri Sep 10 18:18:51 2010, 美东)
the linux server in our university has sas and I could login. but when I try to run the program, I get some error information:
The connection to the X display server could not be made. Verify that
the X display name is correct, and that you have access authorization.
many thanks |
|
m*****n 发帖数: 166 | 17 Will stay in China for several weeks. Still want to access MITBBS. I have
set up a OpenVPN at home here. How can I use it to access to MITBBS? Or have
any other ways? |
|
o****e 发帖数: 916 | 18 车库的网络摄像头连不上无线网了,有线的倒是可以,想弄个access point(或bridge
)转一下,有高手推荐一下便宜的解决方案么?手头上倒是有个dlink (di-524),居
然不能做access point,悲剧了。
谢谢!一定包子奉上 |
|
o****e 发帖数: 916 | 19 我想用一个无线access point放车库,连上家里的无线网,然后摄像头插这个access
point上,这样就不用拉网线去车库了,是不是就是个bridge啊?
在网上搜了搜,好像di-524不能做bridge的,求高手指点,谢谢 |
|
c*******t 发帖数: 1095 | 20 我在router里面设置的port forward。然后用router的dynamic_ip:port 是可以access
的。 但问题是每隔一段时间ip就变了,我就access不了因为不知道新的ip是啥,那应
该怎么设置(在不支持static ip的情况下)?
谢谢 |
|
n*******e 发帖数: 1369 | 21 Be careful when you access internet at home!!
I have never enrolled in any AT&T's long-distance service,
but I was surprised to find that there is a long-distance
call
on my phone bill this month---the phone bill showed I called
San Tome.Faint!!! San Tome is an Afican country.
When I called AT&T just now,I was told that I was billed for
long-distance
service when I accessed some web sites( probably some
gamling web sites).
I have never browsed those kinds of web sites. I asked what
web sites I w |
|
t********k 发帖数: 808 | 22 在Access中有一个表table1
表中有三个字段
first last age
aa AA 10
bb BB 20
能不能用一个select语句
取出二行first last两个字段的值,
并且放成一行?
结果要如下
aa AA bb BB
这样能做到么?
把上面的结果在Access做个report
又是如何做呢?要用语句来写,
而非手工操作鼠标去建report.
谢谢 |
|
j*w 发帖数: 5 | 23 U.S. Robotics USR2410 Wireless Access PC Card是无线网卡吗?
Features:
This requires an 802.11b Access Point
Operates on the Direct Sequence Spread Spectrum (DSSS)
Delivers a data rate up to 11Mbps
Working range up to 300 ft. in an open enviornment
64 or 128 bit encryption for security
下面这些又是什么呢?
Wireless USB
Wireless PCMCIA
Wireless PCI
Wireless LAN
Wireless ISA
怕买错了,请指教,谢谢。 |
|
h*****g 发帖数: 3 | 24 I just come to canada and want to access the websites of .edu in china for
downloding softwares. for example, ftp, music, movie.....
but i cannot access any website in education network of china. is there
anybody know that, please tell me about that.
thanks alot. |
|
b*g 发帖数: 644 | 25 By default, cookies are accessible to every HTTP request for
the current
directory, and any subdirectories. Now on most web servers
and servlet engines,
servlets are located in a special directory. For example,
when using
servletrunner (which ships with the Java Servlet Development
Kit), servlets
must be invoked under the /servlet/ directory.
http://webserver/servlet/servletname
If you want your cookies to be accessible elsewhere, you
must specify the
root path of your webserver, using the
javax |
|
xt 发帖数: 17532 | 26
First, it is called "Overridden";
Second, you can use super.b to access the one in super class,
provided that variable has appropriate access level (protected
or public). |
|
n*****r 发帖数: 9 | 27
it doesn't work
In case you didn't understand my question, please re-read it again.
I want to access it outside the B's method body.I know use super to
access it inside B's method body |
|
N***m 发帖数: 4460 | 28 Forbidden
You don't have permission to access /spring/docs/3.0.x/spring-framework-
reference/html on this server.
But I can still access 2.5 document. |
|
a***h 发帖数: 1222 | 29 试了几种办法都不行:
open office Base 不支持access数据库
试了mdbtool,功能很弱,只能看表格
在wine下面安装office 2003, 其他word, excel, powerpoint 都能运行,唯独access不好使
有没有知道的指点一二 |
|
y*******g 发帖数: 6599 | 30 不用access...转mysql吧
access不好使 |
|
a***h 发帖数: 1222 | 31 有一大堆access数据库,还有个程序要用access ODBC |
|
r***e 发帖数: 2000 | 32 I have a question when setting up a new laptop.
I plan to divide the hard drive into 3 partitions.
One to install Windows 7 Enterprise, the other Fedora 14;
while using the third one for file/data sharing.
I understand you can read NTFS from Linux, and read EXT4
from Windows, by some utility, however, they are not
stable and could corrupt the file system by accident.
That's why I do not want to read/write from one OS
to a foreign file system directly.
I hope I express myself clearly so far.
The ... 阅读全帖 |
|
c*****m 发帖数: 1160 | 33 已经用 smbclient -L 看见在windows上share出来的目录 ,用户名/密码也没错。在/
etc/fstab中我直接列出用户名和密码 “username=u,password=p”,肯定没有输入错
误,怎么还是在mount的时候出现access denied呢?
windows的主机,ubuntu12.4的VM,上面要挂主机的一个目录。先头用一个旧的ubuntu
10.4的VM,被access denied,所以赶紧找12.4的ISO新装的VM,却还是相同的错误。
两个VM都可以成功访问互联网,也可以smblient -L看见那个share目录。windows主机
上的防火墙已经关闭。 |
|
on 发帖数: 199 | 34 【 以下文字转载自 Windows 讨论区 】
发信人: on (一瞬), 信区: Windows
标 题: Outlook .pst file access
发信站: BBS 未名空间站 (Mon Oct 9 23:00:04 2006)
I have some personal emails from my company; i saved them in a folder in a .
pst file. When i get home to read it, told the access is denied. i guess
this is because i don't use my corporate email login / passwd? if so, how
can i get around this? |
|
t****t 发帖数: 6806 | 35 doesn't matter what cast you use. you access it with "incompatible" access
path, you get undefined behaviour. |
|
s*****w 发帖数: 1527 | 36 if i create a database based on each student id,
can i access certain student's entry directly.
now i'm lazy, just created a txt file,
each line for 1 student, the 1st several chars is student_id.
how can i access this line very fast if given the studnet_id ?
thanks ! |
|
l******n 发帖数: 9344 | 37 I have some macros in access to do some queries. The output are needed in
excel. I am writing VBA in excel to do that. Can I reuse all the macros in
access? How can I do that?
Thanks |
|
c******n 发帖数: 4965 | 38 if you have a and b both in package AA,
and a accesses b's package member, it's fine if you build them together and
run them together,
but if u do
java a
and inside a you load b using a classloader, the access is denied.... |
|
s*****w 发帖数: 1527 | 39 【 以下文字转载自 Seattle 讨论区 】
发信人: somehow (淡泊明志,宁静致远), 信区: Seattle
标 题: Help: windows debugging question: "new" caused access violation
发信站: BBS 未名空间站 (Sun Dec 12 22:07:02 2010, 美东)
We develop a SW, after install and reboot.
The 1st time it runs the app, there's a "just-in-time" error.
So hook it to the VS 2005, from the stack i can see our app calls "new",
it calls malloc/heap etc.
Now if i reboot the pc, retry all these, everything is ok now.
Our app has that "user access control" thing, if turn o... 阅读全帖 |
|
e*****r 发帖数: 700 | 40 请教各位VBScript大牛
如何变成让VBScript自动执行拷贝Access文件里的一个表格?
例子:
Access 文件 A.mdb, 有两个表格C,D.
要通过VBScript自动 copy C, and save as D.
请问如何实现?
谢谢 |
|
l******9 发帖数: 579 | 41 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: change year format in Access by SQL query
发信站: BBS 未名空间站 (Mon Oct 13 12:50:53 2014, 美东)
I am working on Access 2012 on win 7. In a table, I need to change a year
date format from '1-Jan-06' to 2006 and from '1-Jan-90' to 1990. I only need
year.
This is my query
SELECT *,
CASE
WHEN CAST(right(year_date,2) , INT) <= 12
THEN 2000 + CAST(right(year_date,2) , INT)
ELSE 1900 + CAST(right(year_date,2) , INT)
END
FROM my_table;
I ... 阅读全帖 |
|
l******9 发帖数: 579 | 42 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: pypyodbc error access netezza SQL server on win7
发信站: BBS 未名空间站 (Sun Dec 21 10:15:22 2014, 美东)
I need to access IBM netezza SQL database from python on win 7. I have
installed Eclipse and python 3.2, pydev, and pypyodbc https://pypi.python.
org/pypi/pypyodbc/1.3.3). It worked well for MS SQL server.
But, it got error for IBM netezza.
import pypyodbc
conn = pypyodbc.connect("DRIVER={NetezzaSQL};SERVER={my_server_name};
D... 阅读全帖 |
|
l******9 发帖数: 579 | 43 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: access violation of C# in Visual Studio 2013
发信站: BBS 未名空间站 (Mon Jan 12 12:59:14 2015, 美东)
I need to debug an exception of "access violation" in C# (web forms
applications) of Visual Studio 2013 in win 7.
There is no "call stack" button in "debug" --> "windows".
So, I tried to use k (Display Stack Backtrace) commands in "immediate window
" by following
http://msdn.microsoft.com/en-us/library/windows/hardware/hh4395 and htt... 阅读全帖 |
|
|
f****r 发帖数: 311 | 45 【 以下文字转载自 Linux 讨论区 】
【 原文由 fencer 所发表 】
Does anybody have successful experience in using
/etc/security/access.conf
to limit the access right of some users? I tried many configurations on
my Red Hat 6.1, but it seems that it doesn't work at all. Any trick?
Thanks. |
|
t*********g 发帖数: 4 | 46 【 以下文字转载自 Biology 讨论区,原文如下 】
发信人: tianqizhang (hometown), 信区: Biology
标 题: help needed for Nature access!
发信站: The unknown SPACE (Mon Jun 4 18:19:42 2001) WWW-POST
Hi, I wonder if anyone can share the nature online access
since I need to copy some pictures from the article Merkel
et al, Nature 1999, 397, 50-53. Thanks a lot! |
|
m*********s 发帖数: 590 | 47 【 以下文字转载自 Windows 讨论区 】
发信人: mitbbssucks (补)(丁), 信区: Windows
标 题: 请教:access denied
发信站: BBS 未名空间站 (Tue Mar 4 00:27:01 2008)
最近发现想装新软件装不上了,每次装一半的时候就提示access denied,
问是retry还是ignore,但随便点那个都不管用。
觉得应该不会是病毒,不记得以前改过什么configuration还是删过什么和系统有关的
东西了。。。
我用的是xp
有没有大侠知道如何解决的?先谢过了。 |
|