s***z
发帖数: 6 | 1 在两个领域都打过酱油，
感觉范围差别不小，虽然DSN中会有security的paper，但是总体DSN名声要好不少，而
且DSN是Dependability中的顶会。在Security中感觉DSN算2，AsiaCCS算3吧。 |
|
h****t
发帖数: 93 | 2 请教. thx :)
DSN: The International Conference on Dependable Systems and Networks
DSN 2005 homepage http://www.dsn.org/ |
|
b***x
发帖数: 2 | 3 【 以下文字转载自 Internet 讨论区,原文如下 】
发信人: boylx (canon), 信区: Internet
标 题: How to remote access the Access Database file besides through System DSN?
发信站: The unknown SPACE (Fri Feb 18 17:40:11 2000) WWW-POST
In a Active Sever page, how to remote access a MDB file?
I've tried System DSN, but always failed:
1)NT/IIS, i added a new system DSN "test" into ODBC manager (in Control Panel)
2)in ASP
Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "test"
3) But I always get |
|
s****i
发帖数: 90 | 4 想请问下这两个会议哪个更好呢？看网上排名似乎 DSN 更好？
谢谢！ |
|
d***a
发帖数: 13752 | 5 当然是DSN了，那个是领域中最好的会了。另外这两会领域不同啊，一个是安全，一个
是可靠性。 |
|
b******u
发帖数: 676 | 6 still old question:
I have a SQL server db and some Access front-end reports. I will have multiple
users that need to use the Access reports. I don't want to set system DSN for
everyone of them. because that would make it hard for me to modify my tables
since every time I would need to refresh the linked table for every computer.
So, I am trying to write a DSNless connection:
strCnct = "ODBC; DRIVER=SQL
server;SERVER=myServer;DATABASE=myDB;UID=myUser;PWD=myPWD"
DoCmd.TransferDatabase acLink, |
|
k*******d
发帖数: 237 | 7 As what I know, ODBC is the only way for connection between SQL Server and
Access. Even you set up a connection string, Access still askes you for the
ODBC information including UID and PWD.
My suggestion is: set up a system DSN without login information, for all
users. When user uses access, it will ask user to input the login information.
multiple
for
computer.
still |
|
b******u
发帖数: 676 | 8
This one I understand..What I am trying to get, is a DSN-less ODBC connection.
I assume it's not too hard to do. For example ADO/RDO are all doing this,
right?
information.
tables
"ODBC: |
|
D****N
发帖数: 430 | 9 Try distributing it with a file dsn.
[ODBC]
DRIVER=SQL Server
UID=myUser
PWD=myPWD
Trusted_Connection=NO
DATABASE=myDB
APP=MicrosoftAccess
SERVER=myServer
It'd still be an ODBC datasource but doesn't need setting up.. |
|
c**t
发帖数: 2744 | 10 in XP, created system DSN with Microsoft ODBC for Oracle driver. In VBA, def
ined:
adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data Sour
ce=myDataSource;Persist Security Info=True"
but it always failed at: cn.Open adostring! any clue why? |
|
y********o
发帖数: 2565 | 11 This is what I use for my .Net applications:
connectionString="DSN=MyDSN4Oracle;UID=johndoe;PWD=wassup; DRIVER={Microsoft ODBC for Oracle}; SERVER=110.119.114.120;" providerName="System.Data.Odbc"
Try it out and see if it works. |
|
c**t
发帖数: 2744 | 12 It worked; including previous. Have to reboot to make the DSN work.. |
|
E**i
发帖数: 116 | 13 ☆─────────────────────────────────────☆
cogt (苦荆茶) 于 (Thu Apr 26 21:08:39 2007) 提到:
in XP, created system DSN with Microsoft ODBC for Oracle driver. In VBA, def
ined:
adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data Sour
ce=myDataSource;Persist Security Info=True"
but it always failed at: cn.Open adostring! any clue why?
☆─────────────────────────────────────☆
yiyayiyayo (Mera naam Itiaan hai) 于 (Fri Apr 27 00:01:05 2007) 提到:
It seems your connection string is fo |
|
s*******2
发帖数: 499 | 14 SAS advanced 50题有一道题是这样的。
The following SAS program is submitted:
%let a=cat;
%macro animal;
%let a=dog;
%mend;
%animal
%put a is &a;
Which one of the following is written to the SAS log?
Correct answer: d
a. a is
b. a is &a
c. a is cat
d. a is dog
这个题答案的讲解说用local macro variable.
但是sas online的学习资料给的讲解似乎相反（具体内如如下）。请指点迷津。多谢。
The %PUT statement within the macro definition will write the value of the
local variable dsn to the SAS log, whereas the %PUT statement that follows
the macro definition wil... 阅读全帖 |
|
b*****o
发帖数: 817 | 15 为什么总是出现
run time error '424'
object required
Private Sub RunSAS1_Click()
Dim RunSAS1 As Object
Dim folder As String
Dim dsn As String
Dim outdir As String
Dim charvar As String
Dim numvar As String
outdir = TxtOutdir.Text
charvar = TxtCharVar.Text
numvar = TxtNumVar.Text
dsn = File1.FileName
folder = File1.Path
If Len(dsn) > 0 Then
pos = InStr(dsn, ".")
dsn = Left(dsn, pos - 1)
Set RunSAS1 = CreateObject("SAS.Application")
RunSAS1.Submit (" %let dir=" & folder & " ;")
RunSAS1.Submit (" %let dsn=... 阅读全帖 |
|
n****e
发帖数: 226 | 16 第二个例子里 macro 内的dsn是local macro variable
只在 macro 内部有效
如果你再加两个 %put statement 来显示 local MV, global MV
你会发现 %put _local_ 给你的是：PRINTDSN DSN sasuser.register
%put _global_ 给你的是：GLOBAL DSN sasuser.courses
%macro printdsn;
%local dsn;
%let dsn=sasuser.register;
%put The value of DSN inside Printdsn is &dsn;
%put _local_;
%put _global_;
%mend; |
|
b****u
发帖数: 67 | 17 1. 请问b为啥不对呀 ?? 谢谢
%macro printdsn(dsn,vars);
%if &vars= %then %do;
proc print data=&dsn;
title "Full Listing of %upcase(&dsn) data set";
run;
%end;
%else %do;
proc print data=&dsn;
var &vars;
title "Listing of %upcase(&dsn) data set";
run;
%end;
%mend;
a. %printdsn(sasuser.courses, course_title days);
b. %printdsn(dsn=sasuser.courses, vars=course_title days)
c. %printdsn(sasuser.courses, course_title days)
d. %printdsn(sasuser.courses, cours... 阅读全帖 |
|
z*******e
发帖数: 32 | 18 第8题
¯o houses(dsn=houses,sub=RANCH);
data &dsn;
set sasuser.houses;
if style = "&sub";
run;
%mend;
%houses(sub=SPLIT);
%houses(dsn=ranch);
%houses(sub=TWOSTORY);
which one of the following is the value of macro variable SYSLAST?
A. work.ranch
B. work.houses
C. WORK.RANCH
D. WORK.HOUSES
我的理解是syslast是系统最后generated一个dataset，所以在最后一次call这个叫
houses的macro的时候，dsn值是缺损的，那么就使用default值就是dsn=houses, 所以
生成的dataset就是houses。这样理解对吗？如果是的话，答案B和D的区别又在哪里呢
？从没觉得大小写有区别啊？
跪谢！！ |
|
m**h
发帖数: 22 | 19 asp运行正常
sql server 运行正常
在ODBC Driver里设置了File DSN, 产生了一个名字叫sqlserver.dsn 的文件
运行下面这段code:
<%
'Create a connection object
Set cn = Server.CreateObject("ADODB.Connection")
'Open a connection; the string refers to the DSN
cn.Open "FILEDSN=sqlserver.dsn"
%>
出错信息如下:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'xxx\IUSR_xxx' 登录失败。//(xxx is the server name)
/myweb/testasp.asp, line 13
Any idea? thanks |
|
i**p
发帖数: 902 | 20 Finally, I got it work by following connection string:
oracleConn.ConnectionString = "Driver={Oracle in XE};Server=XE;Uid=user/
passwd;";
I still wonder why my DSN setting does not work. DSN OracleXE is set to the
same as above. It passes connection test succesfully. But .Open() fails when
I use the following connect strings:
oracleConn.ConnectionString = "DSN=OracleXE;";
oracleConn.ConnectionString = @"DSN=OracleXE;";
Any reasons?
c |
|
l******r
发帖数: 99 | 21 the whole steps:
1. make sure you create some good mdb files somewhere your user account have
permission to read and/or write.
2. make data source name, choose MS Access Driver ==> go to User DSN (only for
local usage) or System DSN (for mapped drives and web server usage) to create
your DSN. supposed the name is "example".
3. then your dsn is "jdbc:odbc:example"
4. use JDBC API, load jdbc driver first, then connnect to DB use
"jdbc:odbc:example", after that you can execute your SQL statements. |
|
a****a
发帖数: 3411 | 22 新手问一个宏的问题
我想根据continuous variable的percentile value做一个categorical variable，比
方说有100个categories的categorical variable。
如果分组很多，输入不方便，修改一次变量名累也累死。
如何修改下面这个宏，能够实现划分任意多的category？
多谢 (包子不多2个)
%macro quint(dsn,var,quintvar);
proc univariate noprint data=&dsn;
var &var;
output out=quintile pctlpts=25,50,75,100 pctlpre=pct;
run;
data _null_;
set quintile;
call symput('q1',pct25) ;
call symput('q2',pct50) ;
call symput('q3',pct75) ;
call symput('q4',pct100) ;
run;
data &dsn;
set &dsn;
if &var =. ... 阅读全帖 |
|
v**m
发帖数: 242 | 23 My web page is in server1. The access database is in
server2.
How can I connect to the database on server2.
Now I am doing is:
objConn.Open "DSN=testDB;UID=;PWD="
and the error message is:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'
Operation was canceled."
Any idea, how to solve it. Thanks so..... much!!!
BTW, the DSN is system DSN. |
|
s****y
发帖数: 95 | 24 I created a database in MS Access 2000 and a DSN with name "TestDSN" in ODBC
manager. In my C program, I connect it with its DSN. So I pass a string like
"DSN=TestDSN" to a function to connect. It worked fine. But I need to add a
database password (not user-level password) to ensure security. Once I add the
password, I cannot connect to the database anymore.
Is there any expert who can give me a hand on how to connect to it. Thanks in
advance. |
|
y********o
发帖数: 2565 | 25 Do you know how to create a DSN?
The code I showed you uses a DSN connection. The name can be anything you c
hoose. Once you have the DSN set up, the connection will be OK.
default
value |
|
i**p
发帖数: 902 | 26 I tried to create system and user DSN with both "Oracle in XE" and "
Microsoft ODBC for Oracle" driver, but all of them got an error when the
code reached to oracleConn.Open().
There is a testing procedure when I set system DSN with driver "Oracle in XE
" and connection test is successful.
Could you show me how you set your DSN in your method?
Here is my error meesage from oracleConn.Open().
ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]Error while trying
to retrieve text for error OR |
|
f******b
发帖数: 1148 | 27 已发！不过有一个小问题，要设Static IP的时候，Router Address 和DSN一般不都是
192.168.1.1吗。。。我一直是这么设的，没想到DSN要设到跟Comcast的DSN那级。 |
|
f******b
发帖数: 1148 | 28 已发！不过有一个小问题，要设Static IP的时候，Router Address 和DSN一般不都是
192.168.1.1吗。。。我一直是这么设的，没想到DSN要设到跟Comcast的DSN那级。 |
|
u*****o
发帖数: 1224 | 29 The following SAS code is submitted:
%macro houses(dsn =houses,sub =RANCH);
data &dsn;
set sasuser.houses; if style ="&sub";
run;
%mend;
%houses(sub =SPLIT)
%houses(dsn =ranch)
%houses(sub =TWOSTORY)
Which one of the following is the value of the automatic macro variable
SYSLAST?
A. work.ranch
B. work.houses
C. WORK.RANCH
D. WORK.HOUSES
Answer: D
这个题我在版上搜过，没人问。可是我却不会。。。想知道为何houses变大写了？ |
|
h*******d
发帖数: 272 | 30 KILLTEST 关于MACRO 的一系列题 我都错了 想破脑袋还是不明白
先放3道 请大家指点我一下吧 真的真的十分感谢
78
The following is submitted:
%macro print(dsn=sashelp.class, var1,var2=name);
Proc print data=&dsn;
Var&var1&var2;
Run;
%mend;
%print(dsn=sashelp.prdsale, age name, var2=height)
What is the result?
答案： the macro variable VAR1 has no value , the macro failed to compile.
为什么不是C：the value of the macro variable VAR1 is age name.
79
The following is submitted:
%macro test;
Data out;
Set sashelp.prdsale end=final;
If predict>500 then |
|
h***i
发帖数: 115 | 31 书上的例子
1. p403
%macro counts (cols=_all_,rows=,dsn=all);
proc freq data=&dsn;
tables
%if &rows ne %then &rows * ; (为什么这里需要 ; ) ???
&cols;
run;
%mend counts;
%counts(dsn=all,cols=paid,rows=course_number)
2. P394 point 7
%macro outer;
%local variX;
%let variX=one;
%inner
%mend outer;
%macro inner;
%local variY;
%let variY=&variX;
%mend inner;
%let variX=zero;
%outer
书上说when executes macro Inner, the local Macro variable variY is assigned
the other local macro variabl |
|
g******7
发帖数: 1739 | 32 The following SAS code is submitted:
%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "&sub";
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable
SYSLAST?
A. WORK.HOUSES
B. work.ranch
C. WORK.RANCH
D. work.houses
Answer: A
求解释，为什么啊？多谢大家乐 |
|
Z********6
发帖数: 10 | 33 The answer is D. syslast, the name of the most recently created SAS data set
, seems always uppercased.
%macro cars(dsn=cars,sub=Acura);
data &dsn;
set sashelp.cars;
if make = "&sub";
run;
%mend;
%cars(sub=Audi);
%cars(dsn=ACURA);
%cars(sub=BMW);
%put &syslast.;
*WORK.CARS; |
|
发帖数: 1 | 34 中国22家直销公司中多数曾陷入传销争议，有的涉及公司、有的涉及产品、有的涉及品
牌名。权健事件持续发酵，使直销与传销之间的多年“捆绑”再次进入大众视野。12月
26日，权健公司对有关权健涉嫌传销的质疑，回应新京报记者：“我们是拿到合法资质
的直销。”
新京报记者注意到，我国的直销模式是由国外引入。美国直销杂志《直销新闻》《
Direct Selling News》公布的2018年度“DSN年度全球直销100强榜单”(DSN Global
100 )上，我国共有22家直销公司上榜，这些公司分别是：无限极、中脉、尚赫、新时
代、隆力奇、权健、三生、华林、金天国际、罗麦科技、绿之韵、太阳神、安惠、安然
、北方大陆、绿叶、美罗国际、康力、理想国际、金木、天狮、金士力佳友。
另一方面，由于多层直销与传销存在明显交叉等原因，上述很多企业曾陷入传销争议。
财经评论人远山指出，“直销行业存在的最大问题之一，就是多层直销的泛滥。”
“2017年业绩为176亿，权健实际负债1.4亿？”
权健事件持续发酵，使直销与传销之间的多年“捆绑”再次进入大众视野。12月26日，
权健公司对有关权健涉嫌传销的质疑，回应... 阅读全帖 |
|
l****z
发帖数: 29846 | 35 Policeman on Brown: 'He Grabbed My Gun, He Twisted It, Pointed at Me'
November 25, 2014 - 12:26 PM
By Brittany M. Hughes
(CNSNews.com) – One day after fatally shooting Michael Brown, an unarmed
black teenager, Ferguson, Mo., police officer Darren Wilson, who is white,
gave his account of the incident to two detectives from the St. Louis County
Police Department, explaining in detail how Brown attacked him through the
police car’s open window, wrestled for the officer’s gun, and then pointed
it... 阅读全帖 |
|
a*****i
发帖数: 4391 | 36 Can not you use System DSN (instead of FIle DSN)? |
|
b****e
发帖数: 1275 | 37 recreate your DSN. control panel->settings->administrative tools->DSN |
|
t*****s
发帖数: 124 | 38 MS should support oracle ODBC connection
1. install the latest MDAC (it's free from MSDN)
2. create a DSN in ODBC data source manager (the manager is in control panel)
3. use the DSN in your code
please check msdn for more details
for iis problem, please change the ip address to your real ip on the property
dialog of default website in iis manager. |
|
B********r
发帖数: 16 | 39 我是会计，请教版上各位科技牛人一些初级问题，请大家轻拍。
我前任设计了一个EXCEL SHEET，连接到ACCOUNTING DATABASE，从DATABASE的TABLE中
提取出有用的DATA。我们现有系统中带的REPORTS很少，格式也不好用。他设计的EXCEL
可以让我的工作快数倍。
CONNECTION STRING:
DSN=AUNC;ServerName=BETS-LPC11.1583;ServerDSN=AUNC;ArrayFetchOn=1;
ArrayBufferSize=8;TransportHint=TCP;ClientVersion=10.30.017.000;
CodePageConvert=1252;PvClientEncoding=CP1252;PvServerEncoding=CP1252;
AutoDoubleQuote=0;
COMMAND TEXT:
SELECT GLAMF.ACCTID, GLAMF.ACCTDESC, GLAMF.ACCTTYPE, Sum(GLPOST.TRANSAMT) AS
'Sum of TRANSAMT'
FRO... 阅读全帖 |
|
G****e
发帖数: 1480 | 40 PEST功能中总是找不到对的参数。。。
需要输入observed data set的DSN，我不知道怎么输入observed data set，也不知道
对应的DSN阿。 |
|
j********z
发帖数: 423 | 41 谢谢你提到DNP！
护理目前doctor level的学位有PhD,DSN(跟PhD相似，不过名字不一样，强调是nursing
的博士），还有就是DNP.相比前两个，DNP是个新东西，就是doctor level的NP。主要
针对临床培养的。据说2015年之后，advanced nursing practice都要求有doctor
level的学位，现在的NP是master level的，以后就不行了。现在也不是所有学校都有
DNP。我也就知道这些。以后只有master的NP肯定是不行了，至于有PhD学位的NP还能不
能继续做NP，我就不清楚了。
PhD当然不是NP啦，NP本身也不是学位(MSN也不都是NP，即使从NP program毕业的，也
得考了执照才能真正做NP呀),但NP也可以读博呀。在DNP出来之前，NP们想继续读，就
只有读PhD或者DSN了。不少老师都是从临床出来的，读博之前就已经是NP了；也有PhD+
MSN的，又专门修相应的NP的课程，然后考相应的NP执照。因此很多有PhD学位的老师都
有NP的执照，看他们名字后面一串名称就知道了。他们在学校工作，同时也在临床兼职 |
|
g****i
发帖数: 2269 | 42 RN salary check at
http://nursing.advanceweb.com/Salary-Information/Salary-Survey/
两个附件图片是那个杂志发到我家的：
average salary by state:这个统计做的很差，没有说明是带不带overtime，如果加班
多的那就收入相差很大
average earnings by work setting：school nurse一直都听说收入低一些，但是职责
可能也简单一些；home health不知道跟inpatient比为什么低那么多；academia 和我
听说到的差不多，但是florida的academia高出很多，不知道为什么，florida的school
nurse and home health又低了很多
average earnings by highest degree: 一直都不明白diploma是什么意思；DSN/DNP/
PHD可以达到$75,500是我没有想到的，通常这些人都是在学校教书，我认识的教书的人
都反映收入低；florida的DSN/DNP/PHD象aver... 阅读全帖 |
|
s********l
发帖数: 245 | 43 Here is the code:
option symbolgen mprint mlogic;
%macro parametric(original=, dsn=, marker1=, marker3=, upper=, lower=,
constant=);
data &dsn;
set &original;
%let constrain1 =%sysevalf(abs(%str(&marker1 - &constant)));
%let constrain2 =%sysevalf(abs(%str(&marker3 - &constant)));
%if &marker1 NE &constant and &marker3 NE &constant %then %do;
&upper=abs(&marker1-&marker3);
&lower=abs(&marker1-&marker3);
%end;
%if &marker1 NE &constant |
|
n******0
发帖数: 298 | 44 麻烦那位大牛帮看一看，谢谢。
我想用PROC IML里的subroutine求exponential duration model 的MLE,这是我的CODE
，得到的error message是"ERROR: (execution) Matrix has not been set to a
value.",到底是哪儿的问题？exp是读入的data set，t是random numbers generated
from an exponential distribution.
%macro test(dsn=,x=);
proc iml;
reset noname;
use &dsn;
read all var {&x} into tt;
print tt;
start LL(beta);
f=sum(log(beta)-beta#tt);
return(f);
finish LL;
start grad(beta);
g=j(1,1,0);
g=sum(1/beta-tt);
return(g);
finish grad;
start hess(beta);
h=j(1,1,0); |
|
d******9
发帖数: 404 | 45 1.If you want to use keyword macro parameters, you need declare them in the
macro definition first.
However, the definition here:
%macro printdsn(dsn,vars);
is not correct, it define the positional parameters.
If you want to use b, then you should define macro like this:
%macro printdsn(dsn=,vars=);
2. data _null_;
set sasuser.courses;
call symput('class', course_title);
run;
variable class是local 还是global ne ?
it is global, because it is defined in open code. |
|
n*****n
发帖数: 3123 | 46 你是不是用没有repeat statement的来做independent covariance structure
proc genmod data = dsn;
class subjid y x;
model y = x/link = logit distribution = binomial;
run;
你可以试下
proc genmod data = dsn;
class subjid y x;
model y = x/link = logit distribution = binomial;
repeated subject=subjid/type=ind;
run;
如果两个差的很大，说明1是有问题的。就是说是有correlation的。因为1是用model
based covariance. 而GEE用的是sandwich covariance matrix. |
|
p********a
发帖数: 5352 | 47 I used the following codes. Could you help me to take a look and see what is
wrong? Thanks
%let datestamp=%sysfunc(today(),yymmddn8.);
%let datestamp1=%sysfunc(datetime(),datetime20.);
%let datestamp2=%substr(%sysfunc(tranwrd(&datestamp1,:,_)),1,15);
%put &datestamp1 &datestamp2;
ODS listing close;
ODS tagsets.ExcelXP path = "/sassvr1/test_report" file="sassrv1_at_%bquote(
&work1pct.)._&datestamp2._CST.xls"
style=EGDefault options( autofilter='all' embedded_titles='yes' autofit
_height= 'y... 阅读全帖 |
|
c******y
发帖数: 3269 | 48 I'm not 大牛, and no longer use MS SQL server. Below is a real-life example,
hope it helps.
Background: VPN network to connect database, a bottleneck to overcome.
implicit sql-passthrough is exchanging data intensively, which choked the
VPN network, where you would see huge difference between real time and cpu
time.
explicit sql-passthrough only sends a command to the database, the database
do the data manipulation within itself, and sends final data back to SAS,
costing way much less network reso... 阅读全帖 |
|
C******g
发帖数: 2930 | 49 各位朋友们，确实不希望你们进来看，进来看帖的都是发生若干问题，既然问题已发生
，希望这里能给大家作点参考，以下的原文只有少部份有提示解决方法（非官方），而
且错误码不齐全（8001000A也没收录），有待更新及修改。
以下全部是个人翻译，本人英语水平不高也不是计算机專材，此文虽已反复检
查核对多次，个人认为此帖还存在错漏，希望各方高手加以纠正，不胜感激
有“注”释的为翻译者个人见解，不一定正确。
PS3 Error codes
80029945
Can’t playback burn BDr movie
不能播放烧录格式蓝光影碟
710102
DNS Error; No DSN server available
DNS错误，没有可用的DSN服务器
8013030
System Error due to failed update download
系统错误由于没有更新下载
80010001
Major Error，Game ability stopped
严重错误，游戏功能停止
80010017
Can't star |
|
