c*****a 发帖数: 5 | 1 I have several questions about the use of SQL Server. Hope
there is some guru
can give me a hand.
1. If I want to do jdbc connection. What type of jdbc do I
use? I know that jdbc-odbc
bridge is free. But seems it has many restrictions, like I
have to install ODBC and
client library on each client machine, and also some of the
untrusted applet can't
visit the DB.
But I heard that other 3 types jdbc connection's drivers are
all commercial and not
free for download. Is that true? I'd like to try if |
|
h*****l 发帖数: 184 | 2 【 以下文字转载自 BuildingWeb 讨论区,原文如下 】
发信人: hanibal (汉尼拔), 信区: BuildingWeb
标 题: ASP问题: Operation must use an updateable query
发信站: The unknown SPACE (Fri Jun 8 23:04:03 2001) WWW-POST
我用ASP处理ACCESS数据库。
但运行INSERT时,出来错:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use
an updateable query.
百思不得其解, 请帮我看看, 错误出在SQLInsert那句上:
Set corConn = Server.CreateObject("ADODB.Connection")
dbpath = Server.mappath("fpdb\mbaalumni.mdb")
corConn.ope |
|
b******u 发帖数: 676 | 3 I have an SQL server database host on the server. And I have a tiny Access
application, which just includs some reports, base on those SQL server tables.
I used link table in the Access.
The problem is, to use link table, I need to set up ODBC for the SQL server. I
set it up on the computer that SQL db is hosted. Both Access application and
the SQL server are on network. I want to open the Access application from
another computer in the network, but I got error that says "ODBC - connection
to [S |
|
k*******d 发帖数: 237 | 4 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 | 5 Thanks a lot for your help.
I can do something like
strCnct = "ODBC; DRIVER={SQL
server};SERVER=ABC-SQL-01;DATABASE=ABC2;trusted_connection=yes"
As I understand it, the "trusted_connection=yes" is supposed to antomatically
use the UserName and Password that the person used to log into thier windows
boxes. This way I don't need a login screen...
sigh. but I still get same error...
information.
tables
"ODBC: |
|
b******u 发帖数: 676 | 6
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 | 7 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.. |
|
s****y 发帖数: 18685 | 8 报错说: Operation must use an updateable query
我上网查了查是说:
Operation must use an updateable query
具体错误如下:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error:[Microsoft] [ODBC Microsoft Access Driver] Operation must use a
n updateable query.
这是更新 Access 数据库常见的错误,大多是由权限的问题引起的。我们知道 Access 数
据库是基于文件的,也就是说,通过
ASP 对 Access 的任何修改必须在权限允许的情况下才能进行。
解决方法:
进入 Access 数据库所在的文件夹(目录),在文件夹的权限中,设置 IUSER_ComputerNam
e 的权限为 'Change' 。在数据库文件
的权限中,也要这样进行设置。
可是还是不会改,在那里改?用什么软件改?
第一次接触,不好意思:) 多谢多谢! |
|
c*****t 发帖数: 1879 | 9 What is fast refresh? I am using JDBC-ODBC bridge driver. ODBC is
MS Access.
Thanks |
|
c*****t 发帖数: 1879 | 10 I have a JDBC program which may do simultaneous ODBC accesses. Should
I do critical section read/write protection or Access ODBC driver can
handle it? Thanks. |
|
n********a 发帖数: 68 | 11 What JDBC driver did you use?
If JDBC-ODBC bridge, check if ODBC data source is setup properly.
If Type4 JDBC driver, check if the jar files for the driver are
in the classpath env.
些
在 |
|
b*e 发帖数: 3845 | 12 go to find mysql.odbc driver,
then create odbc link tables in access |
|
n********a 发帖数: 68 | 13 First, you need JDBC driver for MS Access or
ODBC driver combined with ODBC-JDBC bridge.
With JDBC, you can write a java program that
would extract data from Access files.
And then, you have two options:
1. Use Oracle JDBC driver to write a java
program that would dump the data into Oracle.
Use java.util.Timer to schedule to your two
java programs to run.
2. Load your previous extraction java program
into Oracle as stored procedure. Write a PL/SQL
store procedure inside Oracle that would dump
th |
|
p*****e 发帖数: 58 | 14 If data is in SQL Server 2000 (English edition) or Access, when I use ODBC (or
jdbc:odbc) to get data into the web pages, all the Chinese characters are
changed into question mark(?). Is there anyway to get the correct characters
out of the database?
Many thanks! |
|
y********o 发帖数: 2565 | 15 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. |
|
y********o 发帖数: 2565 | 16 Did you dry Tis out? I'm goncerned abou dju. :-)
Microsoft ODBC for Oracle}; SERVER=110.119.114.120;" providerName="System.
Data.Odbc" |
|
B*****g 发帖数: 34098 | 17 I think the easiest way is use access as you have ODBC
or .net, java, asp, coldfusion, php.
or informatic, pervasive.......
As you can connect through ODBC,
For oracle, you can install oracle client then use TOAD(not free) or SQL
developer
For sql server, install one on your pc
For mysql, use TOAD(free)
.................. |
|
w*r 发帖数: 2421 | 18 use ODBC based tool or fast export to write data into file (named pipe under
unix) and import to Oracle using build loader such as SQLLoader.
The benefit of using ODBC tool is it is simple and easy to migrate. Fast
export for Teradata is very very fast.
SQLLoader for oracle need some tuning of the table and infrastructure
parameter.
You can also use build insert (nolog no redo no undo) mode for oracle stack
tables (not index organized) .
easist way to do it is to use informatica to build a direc |
|
p********a 发帖数: 5352 | 19 不是SQL PROGRAMMER,但需要从SQL SERVER PULL DATA
用SERVER MANAGEMENT STUDIO CONNECT进去了,在那个DATABASES下面,点了DATABASE
的名字BSC,然后TABLES下面怎么只有SYSTEM TABLES,什么都没有呢?DEFAULT的
SCHEMA不就是DBO吗
我用SAS ODBC进去是看得见DATA的
libname bsc odbc datasrc=BSC schema=dbo User=xxx Password=xxx;
谢谢帮助 |
|
p********a 发帖数: 5352 | 20 谢谢2位
不会吧,我用SAS ODBC就可以看见所有的DATASETS,同样的GROUP LOGIN和PASSWORD。
难道ODBC 和直接连SQL有不同的privilege? 以前用同样的方法连过其他数据库,两种
方法都能读入数据。
回BEIJING:我是用DBA ASSIGN的LOGIN PASSWORD,不是那个什么WINNT LOGIN |
|
p********a 发帖数: 5352 | 21 没有。DBA又给了我一个SERVER,这些ODBC和SQL都可以看见DATA了
原来的那个,还是ODBC可以,但SQL就不行。我这次用的是SQL 2005 Management
Studio
懒得管了,DBA也不告诉原因。 |
|
h**h 发帖数: 488 | 22 Thanks. So this refers to a programming language.
I remembered, we used ODBC database, my boss used to design the query with
Access to perform the functions with excel, so he was using the SQL
programming language as well?
Also, linking with the ODBC, it manipulate data on what database? I saw "MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems", which one I should take a look? |
|
k*z 发帖数: 4704 | 23 你应该介绍一下你的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 | 24 你应该介绍一下你的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链接数据库... 阅读全帖 |
|
l******9 发帖数: 579 | 25 【 以下文字转载自 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 | 26 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error export sql table from IBM netezza database to a file
发信站: BBS 未名空间站 (Fri Nov 28 16:33:15 2014, 美东)
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
E... 阅读全帖 |
|
t*****s 发帖数: 124 | 27 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. |
|
y********o 发帖数: 2565 | 28 O, sorry, that code is for oracle jdbc.
I can connect to my Oracle 10g using ODBC, not sure if this is what you wann
a use.
oracleConn = new OdbcConnection();
oracleConn.ConnectionString = @"DSN=OraServiceName; UID=myusername;PWD=my
passwd; DRIVER= {Microsoft ODBC for Oracle}; SERVER=110.119.114.120;";
oracleConn.Open();
I hope this would help.
OracleDataSource |
|
i**p 发帖数: 902 | 29 Thanks! I like this method.
I am confused by OraServiceName. I installed Oracle 10g XE with all default
settings in my computer(Name: blue, IP:168.192.0.5). What is the
OraServiceName?
Aslo, Do I need convert {Microsoft ODBC for Oracle} to some string or value
or just it? I am wondering how Microsoft ASP.NET can regnize {Microsoft
ODBC for Oracle} if we don't convert it to some driver file name.
wann
my |
|
i**p 发帖数: 902 | 30 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 |
|
s********e 发帖数: 893 | 31 公司里有个7,8年前开发的ASP老程序。现在大家的workstation要upgrade到windows 7
,IE 8,这些老程序就用不了了。我track了一下,就是到打开数据库cn.open(connect_string)
的这个地方IE左下角就出现 javascript error
Safety Settings on this computer prohibit accessing a data source on another domain.
以前每次装新机器在XP下也出现过这个问题,只要enable IE security里的Allow Data
Acces Across Domain就可以了。可是这次尝试了修改IE的setting,或者修改ODBC
connection的 Provider成
Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE} 而且还在workstation把
server加到trusted site里了。可是都没用。搞了好几天了都没进展,现在星期天了还
得接着试,周一老板要问了。哪位高手能给指点一下。... 阅读全帖 |
|
|
l*s 发帖数: 783 | 33 ☆─────────────────────────────────────☆
sunnystone (sunnystone) 于 (Sun Oct 2 17:13:55 2011, 美东) 提到:
公司里有个7,8年前开发的ASP老程序。现在大家的workstation要upgrade到windows 7
,IE 8,这些老程序就用不了了。我track了一下,就是到打开数据库cn.open(connect_string)
的这个地方IE左下角就出现 javascript error
Safety Settings on this computer prohibit accessing a data source on another domain.
以前每次装新机器在XP下也出现过这个问题,只要enable IE security里的Allow Data
Acces Across Domain就可以了。可是这次尝试了修改IE的setting,或者修改ODBC
connection的 Provider成
Provider=MSDASQL;DRIVER={Microsoft ... 阅读全帖 |
|
t******t 发帖数: 2 | 34 我的ASP文件在我本机上运转正常,但当我把它放到SERVER机子上后出现了错误:
Error Type:
Microsft OLE DB provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]Operation must use an updateable
query.
/pfhssurvey/survey.asp, line 631
而这行我的语句是这样
Objconn.execute("UPDATE survey SET A11=" & Q11 & ", A12=" & Q12 & ",A13=" &
Q13 & ",A14=" & Q14 & " WHERE num=1")
这是怎么回事呢
我用的是MS Access 作为后台数据库。 |
|
m******y 发帖数: 588 | 35 You can use DSNless connection so that you don't need to add the connection in ODBC in
Control Pane every time.
The code is like this if the Access file is test.mdb:
import java.sql.*;
public class ConnectionDB
{
static String filename = "test.mdb";
static String database = "jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=";
static Connection aConnection;
static Statement aStatement;
// establish the database connection
public static void initialize()
|
|
g**********y 发帖数: 14569 | 36 Sun太懒了,我总共做了288道mock题。其中还有一堆EJB 1.2, 2.0等不考的。结果,今天
见到的题,有一半都是288道里的。
说实在,出题的水平不敢恭维,288道里,逻辑混乱得一塌糊涂,但事实证明:大部分都
是真题。
举个例子:You are writing a Java program to connect to a legacy server, which
has ODBC driver installed. What technology you will use?
A. JDBC
B. JDBC-ODBC bridge
My answer is B. And the "right" answer is A. Explaination is: It doesn't say
that JDBC is not supported on server. So you only need JDBC.
这个例子极端一点,但是Sun的真题逻辑跟这差得不远。
75分钟的考试,我检查了两遍也就50分钟。结果,91%。不能说我91%, 其实是网上的答
案得了91%. 我个人已经和网上的 |
|
l********r 发帖数: 187 | 37 I am always getting a "Exception: No suitable driver found for jdbc:mysql://
localhost:3306/test" from the following program. I have installed mysql
connector for Java and ODBC driver. Could anyone tell me what might be wrong
? I am using Fedora Linux 6.. The source code is listed bewlow:
import java.sql.*;
public class DBJava {
public static void main(String args[]) {
Connection con = null;
String query = "SELECT * FROM temp";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriv |
|
b***y 发帖数: 2799 | 38 ☆─────────────────────────────────────☆
jingriver (fairyland) 于 (Fri Dec 5 12:18:21 2008) 提到:
which library are you using to access db? ODBC? or some third party lib?
☆─────────────────────────────────────☆
PaulPierce (Paul) 于 (Fri Dec 5 13:32:22 2008) 提到:
没有用C++干这些的拉
以前用ASP+IIS
现在不知道用什么
☆─────────────────────────────────────☆
TaiYouCai (有才) 于 (Fri Dec 5 13:33:19 2008) 提到:
圡
☆─────────────────────────────────────☆
TaiYouCai (有才) 于 (Fri Dec 5 13:33:42 2008) 提到:
odbc或者db提供 |
|
h******k 发帖数: 810 | 39 jdbc学的是odbc,odbc是纯C,那时候java还没生出来了。
你想说明什么? |
|
l******9 发帖数: 579 | 40 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error export sql table from IBM netezza database to a file
发信站: BBS 未名空间站 (Fri Nov 28 16:33:15 2014, 美东)
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
E... 阅读全帖 |
|
p*o 发帖数: 99 | 41 NT SQL Server ODBC 连接被修改,删除被改动odbc连接后冲启动,刚被删除的连接又出
现。有没有遇到过的? |
|
a**e 发帖数: 5794 | 42 你熟悉什么语言?
Java: JSP/Servlet
VB或C#: ASP.NET
PHP
上面这些语言工具都可以用ODBC或ODBC-Bridge的方式访问你的
excel文件。可以用绝对路径或给那个excel文件设一个DSN |
|
l******9 发帖数: 579 | 43 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error export sql table from IBM netezza database to a file
发信站: BBS 未名空间站 (Fri Nov 28 16:33:15 2014, 美东)
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
E... 阅读全帖 |
|
l******9 发帖数: 579 | 44 【 以下文字转载自 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... 阅读全帖 |
|
B***y 发帖数: 138 | 45 用libname odbc链接sql server 数据库。连接显示成功,也能对table进行操作,
但是为什么点击进入那个lib name ,看不到table 和 view 呢。 我在自己机器上试验
过其他数据库可以看到,说明这个libname odbc code 没问题。 是sql server user
id 的权限问题么?我的user id是dob_owner的权限啊。 有人能知道怎么回事呢? |
|
d*******o 发帖数: 493 | 46 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. |
|
y****d 发帖数: 432 | 47 这个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 | 48 这个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********0 发帖数: 638 | 49 最近用proc sql通过ODBC连接数据库,用的A left join B查询,其中B是SQL
architecture数据库下的一个table. 速度极其的慢,大约要一两个小时,最近老被管理
员揪,说没有看见where-
filter,会造成服务器负担.
我的proc sql 下使用了where,但是管理员端收到的query里没有看到任何的filter. 想
问一下:
1. sas 下的proc sql是什么原理阿,是发送query到服务器端,然后接受结果么? 还是
sas自己本身集成了SQL module,把那个服务器端的server当作linked server? (这个问
题有可能问的不对,错了请指正).
2. SAS odbc连接原理和sql server management studio 原理一样吗?同样的query, 用
sql sever mgt studio只需要一两分钟.但是SAS真的很慢阿.
谢谢啦. |
|
c******y 发帖数: 3269 | 50 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... 阅读全帖 |
|