i**o
发帖数: 9 | 1 Sorry for writing in English - I can't type Chinese font in company PC.
I was trying to access microsoft SQL server using SAS oledb engine. The SAS
statement I use was "libname mydb oledb;". After running the statement, I
can see that a library 'mydb' was created in the library folder. However
that library folder was empty in the explorer window. I can still pull out
data in SAS since I know the name of the tables from microsoft SQL
management studio.
Can somebody advise me how I can directly se... 阅读全帖 |
|
c**t
发帖数: 2744 | 2 using OleDb to read a spreadsheet. Some user can't read a few cells, what
could be the reason? |
|
c**t
发帖数: 2744 | 3 The connection string:
@"Provider=Microsoft.Jet.OleDb.4.0;Data Source={0};Extended Properties=""
Excel 8.0;HDR=NO;IMEX=1"""
if IMEX=0; the datetime will be read in as number; and some "general" field
was
read as datetime!! |
|
a*****a
发帖数: 438 | 4 ADO/OLEDB is just a tech like ODBC. it's not a product.
You can download MDAC2.5 from http://www.mcirosoft.com/data
it's free. also you can learn sth about ADO/OLEDB and get some samples there. |
|
a*****a
发帖数: 438 | 5 *pulling my hair* how should I configure this Oracle8i
client on a win2000 pro/NT4 workstation?
I installed oracle client 8.1.6 for app user and run net8
configure agent to set up a listener. Using Oracle ODBC test
works without any problem - *but*, when I switched to use
"Microsoft OLEDB Provider for Oracle" or "Oracle Provider
for OLEDB", I always get the dreaded ORA-12514 error
TNSPING to my oracle8i server is okay. using sqlplus
scott/tiger also gives me the same error:(
oracle client setup |
|
a*****a
发帖数: 438 | 6 So I know how to use ADO to persist the XML output from SQL
Server 2000 ('SELECT * FROM AUTHORS FOR XML AUTO') to a
file. How do I do it with native OLEDB + DOM?
Too bad the XML OLEDB Provider for SQL Server isn't out
yet:( |
|
a*****a
发帖数: 438 | 7 I don't know much about DAO since it's obsolete now in VC7.
You can, however, use OLEDB. JET (OLEDB Provider for Access/Excel/etc) supports
this by CreateDataSource(). SQLOLEDB would be easier - just issuing a command
and execute it (ICommand::Execute).
You can esearch MSDN for more information.. |
|
a*****a
发帖数: 438 | 8 how about use JET provider instead of "OLEDB Provider for
ODBC"?
your connection string would be
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\server2\someshare\test.mdb" |
|
a*****a
发帖数: 438 | 9 If I were you, I'd use OLEDB instead of ODBC.
In OLEDB, you can just set all the column/param data and
then call IRowsetChan ge::SetData (equivalent of SQL UPDATE) |
|
k*z
发帖数: 4704 | 10 I have no problem to create a link server by MS OLEDB Provider for SQL
Server.
but I can not create a link server by MS OLEDB for ODBC Driver for the exact
same SQL server.
This ODBC driver has been tested without problem. |
|
k*z
发帖数: 4704 | 11 I have no problem to create a link server by MS OLEDB Provider for SQL
Server.
but I can not create a link server by MS OLEDB for ODBC Driver for the exact
same SQL server.
This ODBC driver has been tested without problem. |
|
k*z
发帖数: 4704 | 12 你应该介绍一下你的title，别人也好回答你，问的就神神叨叨，就不能怪别人不回答。
首先你应该说你简历上你写了啥，你把上面的都列了，自然人家就想问问你了。
如果什么都没写，直说自己会SQL,估计会考你一些 简单的 Query
感觉我给finance的人打的交道，如果你的title是Financial Analyst应该不会考你
SSIS, Trigger, SQL Tuning, index, odbc/oledb这类东西。如果你是cognos
application developer,他们倒是有可能问你sql tuning, index, framework之类的东
西。
如果他们没有成型的BI reporting system,他们 可能会问你一些SSRS的宏观概念和
SSAS的概念，如果是oracle可能会问你BIEE的一些粗浅问题，但是我觉得不会，除非你
的职位是是Financial Reporting Analyst。
ADO都是程序接口，一般来说不会要求finance的人自己去搞，通过ado链接数据库通常
都是不走寻常路。你估计会用oledb/odbc/jdbc链接数据库... 阅读全帖 |
|
k*z
发帖数: 4704 | 13 你应该介绍一下你的title，别人也好回答你，问的就神神叨叨，就不能怪别人不回答。
首先你应该说你简历上你写了啥，你把上面的都列了，自然人家就想问问你了。
如果什么都没写，直说自己会SQL,估计会考你一些 简单的 Query
感觉我给finance的人打的交道，如果你的title是Financial Analyst应该不会考你
SSIS, Trigger, SQL Tuning, index, odbc/oledb这类东西。如果你是cognos
application developer,他们倒是有可能问你sql tuning, index, framework之类的东
西。
如果他们没有成型的BI reporting system,他们 可能会问你一些SSRS的宏观概念和
SSAS的概念，如果是oracle可能会问你BIEE的一些粗浅问题，但是我觉得不会，除非你
的职位是是Financial Reporting Analyst。
ADO都是程序接口，一般来说不会要求finance的人自己去搞，通过ado链接数据库通常
都是不走寻常路。你估计会用oledb/odbc/jdbc链接数据库... 阅读全帖 |
|
w*******7
发帖数: 188 | 14 LZ 可以参考这个网站 http://archive.msdn.microsoft.com/mschart。
上面有aps.net和winForm的sample， 其中有如何“binging to Excel Files"
for example:
using System.Web.UI.DataVisualization.Charting;
using System.Data;
using System.Data.OleDb;
...
private void Page_Load(object sender, System.EventArgs e)
{
// resolve the address to the Excel file
string fileNameString = this.MapPath(".");
fileNameString += "..\\..\\..\\data\\ExcelData.xls";
// Create connection object by using the preceding connection stri... 阅读全帖 |
|
w*******7
发帖数: 188 | 15 LZ 可以参考这个网站 http://archive.msdn.microsoft.com/mschart。
上面有aps.net和winForm的sample， 其中有如何“binging to Excel Files"
for example:
using System.Web.UI.DataVisualization.Charting;
using System.Data;
using System.Data.OleDb;
...
private void Page_Load(object sender, System.EventArgs e)
{
// resolve the address to the Excel file
string fileNameString = this.MapPath(".");
fileNameString += "..\\..\\..\\data\\ExcelData.xls";
// Create connection object by using the preceding connection stri... 阅读全帖 |
|
n***m
发帖数: 292 | 16 把这个存为txt文档，然后sas 9.2 renew就可以了
这个到2012.2， 到时候应该有新的sid释放出来
[_SID_]
Version=9.2
Revision=9.2
Platform=Windows
Platform_long=Microsoft Windows Workstation 32-bit
Platform_short=win
Order=999HR5
Setnumid=10502896
SID_schema=2
ph_agreement=PROMPT
SID_header=SAS 9.2
[_Info_]
[_FileData_]
$_Filename=setinit.sss
$_Path=sas\core\sasinst\
$_Date=
$_Time=
$_Stream=——————– BEGIN ——————–
PROC SETINIT RELEASE='9.2';
SITEINFO NAME='CHUNGNAM NATIONAL UNIVERSITY'
SITE=10502896 OSNAME='W32_WKS' RECREATE WARN=30 G... 阅读全帖 |
|
l****z
发帖数: 29846 | 17 Now this is interesting. From Symantec, makers of the Norton Ant-Virus
family of products:
n the last couple of years, we have seen highly sophisticated malware
used to sabotage the business activities of chosen targets. We have seen
malware such as W32.Stuxnet designed to tamper with industrial automation
systems and other destructive examples such as W32.Disstrack and W32.Flamer,
which can both wiped out data and files from hard disks. All of these
threats can badly disrupt the activities ... 阅读全帖 |
|
a*****a
发帖数: 438 | 18 MDAC2.5
using ADO/OLEDB :) |
|
E********r
发帖数: 99 | 19 请问一个数据库连接的问题
我用ASP连接ACCESS数据库
尝试用了两种连接方式：
第一种是用DSN的，在执行任何SQL语句的时候
都没有问题。
但如果改成如下方法：
cn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & server.mappath("f
pdb\db1.mdb")
在执行INSERT，UPDATE操作比如：
sql2 = "INSERT INTO StudentInfo(StudentID) VALUES(1234567)"
cn.Execute sql2
结果就会出错：
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
我感到十分困惑，请指点。谢谢。 |
|
k****h
发帖数: 27 | 20 I have the following code in global.asa. But I found I can't call the session
in the global.asa.
Then in anothe asp file, I tried to call the sessions:
set dbMain = server.createobject |
|
z*******6
发帖数: 82 | 21 【 以下文字转载自 Database 讨论区 】
发信人: zhpeng116 (provence), 信区: Database
标 题: 菜鸟求帮助
发信站: BBS 未名空间站 (Tue Jan 17 19:46:37 2012, 美东)
从来没写过网页代码，有个小任务得完成，可惜不知道怎么解决这个错误，望大虾们指
点：
其中出错的部分如下
strProvider = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=
messageboard.accdb;"
Set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider
调试时候显示上面最后一行出错，错误提示：
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/messageboard.asp, line ... 阅读全帖 |
|
a****l
发帖数: 8211 | 22 我现在有一个存在文件中的Access数据库,可以使用Access打开.如果我要在别的程序里
打开这个数据库,我需要使用如下的命令:
"Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=C
:\Sample.mdb"
现在我给这个Access数据库加上密码,就是说,如果用Access双击该数据库文件的话,
Access会提示输入密码,然后输入密码比如ABCDE后就能打开该数据库文件.
我的问题是,数据库加密后,上面的那个命令就不好用了(显然的,没有密码),那么我应该
怎么样改变这个命令才能打开这个数据库呢? 密码不变的,可以用明文存储.
谢谢!
如果能提示一下相关的学习材料更好,谢谢! |
|
a*****a
发帖数: 438 | 23 Basically sdk is right.
However, ODBC is out-of-date now. MS now recommends using
ADO/OLEDB. It's easier to use and perform better. |
|
f******g
发帖数: 20 | 24 好像懂点了，不过又背这几个什么ADO/OLEDB几头雾水了
这些东东是不是也要money的说？
Visual InterDev?怎么学呢？从来没听说的说...
谢谢大虾们了先,偶还是一不不来吧 |
|
j***t
发帖数: 3 | 25 Many ways:
1) install the SQL server client software
2) ODBC or OLEDB connection
3) DTS
4) Create ACCESS database and after that using its upsizing
wizard. |
|
t*********r
发帖数: 4 | 26 Dear all,
I need your help on debugging:
I tried to update a record using aspx code. However, the server inform me
"System.Data.OleDb.OleDbException: Syntax error in UPDATE statement".
1) I output the string of update statement and run the sql directly as a query
on the server-side access file, it works.
2) The Web has the right to write to the database, I can delete a row using
aspx.
Can anybody help me figure out the problem?
Thanks. |
|
a*****a
发帖数: 438 | 27 sure. just use oracle oledb provider. |
|
k****h
发帖数: 27 | 28 I am using IIS 5.0 on windows 2000 to connect with access database.
It works if use the following code in the asp file
<% con= "Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=g:\pvd.mdb">
<% set dbMain = server.createobject("ADODB.Connection")
dbMain.open con
Set rsProducts = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM products WHERE beginspecial <= #" & date() & _
"#" & " AND endspecial >= #" & date() & "#"
rsProducts.open sSQL, dbMain, adopenstatic, adlockpessimistic |
|
a*****a
发帖数: 438 | 29 better yet, dont use ODBC. it's a retiring technology.oledb is better. |
|
y********o
发帖数: 2565 | 30 It seems your connection string is for OleDb instead of ODBC, judging from
the info at the following URL.
http://www.connectionstrings.com/?carrier=oracle
What if you try this connection string as shown from the same URL for ODBC?
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd
=myPassword;
def
Sour |
|
a9
发帖数: 21638 | 31 单用户我建议用sqlite，挺好用的。连oledb都不用。 |
|
z*******6
发帖数: 82 | 32 从来没写过网页代码，有个小任务得完成，可惜不知道怎么解决这个错误，望大虾们指
点：
其中出错的部分如下
strProvider = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=
messageboard.accdb;"
Set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider
调试时候显示上面最后一行出错，错误提示：
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/messageboard.asp, line 46
不知道怎么解决阿 谢谢各位 |
|
B***y
发帖数: 138 | 33 The linked server is actually created on the Server...I think the problem is
the report in the application was created by crystal report viewer. Per
some forum I revise the linked server provider from SQL server to OLEDB SQL
and it still gives me "Database DLL error". Since I don't have the source
code the VB application and I cannot open that report in a design view now I
'm wondering if there is nothing else I can do... |
|
b******g
发帖数: 3883 | 34 http://social.msdn.microsoft.com/Forums/sqlserver/en-US/bda433a
Steps:
1. Click on package properties. Set "DelayValidation" property to True.
The package will not validate tasks, connections, until they are executed.
2. Create a package level variable "XLFileRootDir" as string and set it to
the root
directory where you want the excel file to be created.
Example: C:\Project\Data\
3. Create an Excel connection in the connection manager. Browse to the
target directory
and select the destination XL... 阅读全帖 |
|
b******g
发帖数: 3883 | 35 我刚才做了一下是works,我是sql server 2008 bids,在"name of excel sheet" 右边
有个 new ,不知道你的为啥没有，你和oledb source 连了吗？ |
|
s**********o
发帖数: 14359 | 36 我的EXCELFILEPATH有些问题，因为是两个USER VARIABLE链接起来的，其实是@PATH+@
FILENAME，EVALUATE的话不出值，不过CREATE TABLE就是CREATE EXCEL FILE了，
CONNECT STRING显示这个
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=;Extended Properties="EXCEL 12
.0;HDR=YES"; |
|
z******4
发帖数: 4716 | 37 你理解错了，你应该反复强调，你用了很多SQL，从SQL SErver，Oracle里面提取数据
，Finance只关心你能，具体人家根本不懂，你讲了也白搭
倒是面对技术面试时，要小心，防止他强调你技术背景不够，你是技术转Finance吧
技术层面，你要注意，怎么写SQL，怎么写join之流的，还可以强调你用Macro,access
，就是ADO链接，OLEDB也行
DBA
application |
|
s******n
发帖数: 45 | 38 as long as you can find corresponding odbc driver or oledb provider, you
should be fine. just google those keywords bah. |
|
M*******r
发帖数: 522 | 39 最近正在把一个vb6 app转成vb.net。原vb6 app是用oo4o连接到oracle db。现在vb.net
里改用OleDb连接。原程序对DbException做如下处理：
Select Case oSession.LastServerErr
Case 1017
Msg = "Error trying to login into Oracle: Invalid User Id/Password."
Case Else
Msg = "Error trying to login into Oracle"
End Select
问题是，如何从OleDbException当中获取这个oracle error code 1017. 当然这个1017在
exception.message里，但问题是除了parse string之外是否有更好的办法？
多谢。 |
|
h*******t
发帖数: 1 | 40 在ASP.NET 中用ADO.NET 打开 ACCESS 数据库(用OLEDB), 出现如下错误:
The Microsoft Jet database engine cannot open the file
It is already opened exclusively by another user, or you need permission to
view its data.
把数据库所在的目录改成IUSER_COMPUTERNAME 可读写,还是出现这个错误.
请指点. |
|
i**p
发帖数: 902 | 41 still has error on eventsXMLDoc.WriteAttributeString("id", dataReader["
categoryID"]);
CS1502: The best overloaded method match for 'System.Xml.XmlWriter.
WriteAttributeString(string, string)' has some invalid arguments
Here is the source code.
System.Data.OleDb.OleDbDataReader dataReader =
dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
System.Xml.XmlTextWriter eventsXMLDoc = new
System.Xml.XmlTextWriter(Response.OutputStream, Encoding.UTF8);
// generate XM |
|
a****l
发帖数: 8211 | 42 【 以下文字转载自 CS 讨论区 】
发信人: acectl (磨), 信区: CS
标 题: 请问怎样打开一个有密码的Access数据库
发信站: BBS 未名空间站 (Mon Jan 18 10:27:29 2016, 美东)
我现在有一个存在文件中的Access数据库,可以使用Access打开.如果我要在别的程序里
打开这个数据库,我需要使用如下的命令:
"Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=C
现在我给这个Access数据库加上密码,就是说,如果用Access双击该数据库文件的话,
Access会提示输入密码,然后输入密码比如ABCDE后就能打开该数据库文件.
我的问题是,数据库加密后,上面的那个命令就不好用了(显然的,没有密码),那么我应该
怎么样改变这个命令才能打开这个数据库呢? 密码不变的,可以用明文存储.
谢谢!
如果能提示一下相关的学习材料更好,谢谢! |
|
s*********e
发帖数: 1051 | 43 to be a good user of access DB, you have to learn some SQL.
however, in most cases, you don't use access DB directly. Instead, you might
need to interface sas with access through libname by odbc or oledb. in this
case, tables in DB can be viewed and used as SAS tables. |
|
d*******o
发帖数: 493 | 44 I used to deal with the similar situation. The reason is that: Microsoft
ODBC/OLEDB engine for EXCEL/ACCESS is outdated and limited to handle large
datasets. However, Microsoft ODBC engine for SQL server is designed for
large scale. You could install Microsoft SQL server and use it as a middle
layer to import ACCESS datasets into SAS. |
|
s******y
发帖数: 352 | 45 下此问问题时，准备点包子，你就1个为币。唉。
add option schema=yourschema in your libname statment.
大多数时，schema=DBO 就行了。 如果不是default DBO, ask the Admin for the
name of schema you are trying to access.
SAS |
|
i**o
发帖数: 9 | 46 Thank you, Smileguy. I will save some Baozi next time. :-) |
|
|
p********a
发帖数: 5352 | 48 很多公司的数据都是SQL或者ORACLE的，每次搞ODBC/OLEDB转SAS很麻烦很慢的。我很多
程序都搞一个SAS版本一个SQL版本，SQL RUN得很快 |
|
y****d
发帖数: 432 | 49 这个SAS9.2比较大比较全面，3CD，大家可以去我的签名博客获得免费下载地址
本版本跟我之前分享的一个4.2G的SAS9.2软件有以下区别：
10G 4.3G
===================================================================
AF SAS/AF; 有 有
ASSIST SAS/ASSIST; 有 有
ASTERBNDL SAS/ACCESS Interface to Aster nCluster; 有
CONNECT SAS/CONNECT; 有 有
DB2 SAS/ACCESS DB2; ... 阅读全帖 |
|
y****d
发帖数: 432 | 50 这个SAS9.2比较大比较全面，3CD，大家可以去我的签名博客获得免费下载地址
本版本跟我之前分享的一个4.2G的SAS9.2软件有以下区别：
10G 4.3G
===================================================================
AF SAS/AF; 有 有
ASSIST SAS/ASSIST; 有 有
ASTERBNDL SAS/ACCESS Interface to Aster nCluster; 有
CONNECT SAS/CONNECT; 有 有
DB2 SAS/ACCESS DB2; ... 阅读全帖 |
|
