h****r
发帖数: 2056 | 1 Sorry, forget to mention I use the openlink ODBC driver |
|
s****y
发帖数: 95 | 2 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. |
|
o***z
发帖数: 133 | 3 maybe the database password is for MS Access only, not for ODBC
the
in |
|
s****y
发帖数: 95 | 4 Thanks. I found it is actually very easy. Just leave out the user ID.
For example
CString CSecuredRSSet::GetDefaultConnect()
{
return _T("ODBC;DSN=Secure;PWD=Lamont");
}
It works fine. Thank you ottoz. |
|
l*****n
发帖数: 92 | 5 数据库是access xp, 采用的是system dsn，其余都是缺省设置。
更新记录语句为：
update people set lastname='hhe', firstname='hehe', middlename='',
emailaddress='',
homepage='', institute='University', memo='' where peopleid=1
出错信息如下：
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query.,
SQL state S1000 in SQLExecDirect in people_save.php on line 40
但是读取数据没有任何错误，请问可能是什么原因，怎么解决？谢谢 |
|
f*y
发帖数: 6 | 6 【 以下文字转载自 Programming 讨论区,原文如下 】
发信人: fay (小飞), 信区: Programming
标 题: intensive I/O and odbc problem
发信站: Unknown Space - 未名空间 (Wed Aug 27 14:09:26 2003) WWW-POST
I have a segment code calling stored procedures to update a record and insert
a new record to another database, after these, there's a file copy. Due a bug
in the code, the file copy part uses _read and _write for 400MByte file in one
function call. After the write finishes, the system hung.
The weird thing is the two stored procedures |
|
O*****c
发帖数: 171 | 7 MSSQL数据库的server上建个ODBC能连，在别的机器上就连不通，是怎么回事呢？
1433端口在防火墙上也打开了
3x |
|
O*****c
发帖数: 171 | 8 装的是2000的access,odbc已经改成用那个syswow64下面的了 |
|
|
t***u
发帖数: 368 | 9 thanks for reply;
there is a mySQL DB behind ODBC...
any better way to export sql server db to mysql ? |
|
B*****g
发帖数: 34098 | 10 可能需要mysql odbc driver，到mysql网站去下 |
|
k*z
发帖数: 4704 | 11 这个DB2 on iSeries很诡异啊，我ODBC和JDBC从来没配置成功过。 |
|
k*z
发帖数: 4704 | 12 牛人，我彻底改成用AS400的JDBC了。 任何DB2-ODBC/JDBC都不work。 |
|
l******9
发帖数: 579 | 13 how to access two databases in one ODBC connection from pyodbc ?
thanks ! |
|
a*c
发帖数: 701 | 14 请问如何通过ODBC读DBISAM 数据库，
电脑白痴，切勿耻笑。 谢谢 |
|
g*****u
发帖数: 727 | 15 试图使用pdf里面的js来call相应ODBC，然后从里面调数据来自动完成表格。
请问如何实现js和数据库的关联？
最好有个范例
多谢！！！！ |
|
w*r
发帖数: 2421 | 16 registry table check local_machine\software\microsoft\odbc... |
|
g***o
发帖数: 297 | 17 when I try to export data from ACCESS to ORACLE,
I got an error like:
ODBC call failed.
[microsoft][ODBC driver for oracle][oracle](#0)
[microsoft][ODBC driver manager][driver's SQLSet
ConnectAttrfailer (#0)[microsoft][ODBC driver manager][driver's SQLSet
ConnectAttrfailer (#0)
Does anybody know what this means. How to solve this problem? thanks so much. |
|
s***t
发帖数: 7 | 18 Developer 2000 2.0 is supposed to work with Oracle8. But it did
not work on mine. My suggestion is to install Developer 2000 1.X(1.3 or 1.6)
and Oracle7. These two will work together.
It seems that ODBC dirve for Oracle8 can not be properly installed.
Even though the database itself works properly, the ODBC driver does not.
You can not create valid DNS for Personal Oracle8, since the ODBC drive
does not work. Though behind the scenes, Developer 2000 also uses ODBC
driver to connect to the databa |
|
b*e
发帖数: 3845 | 19 I connect C# to mysql throught ODBC.NET and MySQL ODBC.
ODBC.NET is downloadable from MS website
You need to find Oracle ODBC driver. |
|
o******r
发帖数: 259 | 20 发现跟Dao没有关系，
试着直接用ODBC，用excel file做data source
update还是可以，
但delete 一条记录时，报错
“Deleting data in a linked table is not supported by this ISAM.
State:S1000,Native:-5410,Origin:[Microsoft][ODBC Excel Driver]”
Microsoft网站上，同样的报错出现在delete csv database
If you are deleting records:
Database Results Error
"Description: [Microsoft][ODBC Text Driver] Deleting data in a linked tab
le is not supported by this ISAM.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers"
解释是：
The OD |
|
i**s
发帖数: 97 | 21 Seems you are confused by these concepts.
1. Java has nothing to do with Javascript.
2. JDBC is Java's API to SQL database.
3. If you write ASP program, you can use both VBScript
and Javascript to access ODBC data source.
4. If DBMS and Web server reside in different machines,
it is perfect for ODBC to work. You need to build an
ODBC data source in the machine where web server runs,
while the ODBC specifies the DBMS running in another machine.
5. If you write Java Applet, DBMS should |
|
n***m
发帖数: 292 | 22 把这个存为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... 阅读全帖 |
|
B*******n
发帖数: 58 | 23 在XP下做好的网页(ASP+Access mdb)，移到2003上无法运行，
出现错误
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supp
orted by the operating system.
/asp/logon.asp, line 15
如果要使用Access mdb作为网页的数据库的话，是不是一定得装Microsoft Access?
看到在ODBC里面有mdb driver啊？ |
|
a****g
发帖数: 9 | 24 Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.
I use dreamweaver to build a ASP page.
Use access + ODBC as database server. |
|
o**y
发帖数: 1466 | 25 我有一个数据库（CENSUS〕要在网上发布，它的字段数超过2500个，现在我只能用TAB
DELIMITED 格式存储和发布，维护起来非常困难。用ODBC在网上发布时，ODBC的TEXT
DRIVER也不能支持这么大的数据库，想问一下各位，是否有哪个软件可以支持2500个字段
的数据库？这个软件最好还能提供ODBC driver, 并且在WINDOWS或者WINDOWS
NT下运行。谢谢各位！ |
|
j***e
发帖数: 19 | 26 我的ODBC配置已经成功，在ASP连接该数据库时,却不成功,运行到
Conn.open "DSN=infotest;uid=informix;pwd=informix"
时出错,信息为:
MicroSoft ole DB provider for odbc drivers 错误:80004005
[odbc informix driver][informix] unable to load locale
categories.
而同样的代码在VISUAL BASIC下可以成功连接。
十万火急，先谢谢各位大虾。 |
|
D****N
发帖数: 430 | 27 Control Panel/ODBC Data Source
Setup a new SQL data souce (from the "system" tab)
You'll have to know the server ip/name and ur username/password.
Then it'll be accessible to all programs with ODBC connectivity.
Say you want to look at the table in Access:
You can open a file, under "Tables"
Create new linked table... Again select SQL datasource
Then select your odbc data source and one of the table associated with it.
So if your datasource is "TestDB" and the table is "dTest"
You'll be selectin |
|
m**h
发帖数: 22 | 28 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 |
|
B*******n
发帖数: 58 | 29 【 以下文字转载自 BuildingWeb 讨论区 】
【 原文由 BoyzToMen 所发表 】
在XP下做好的网页(ASP+Access mdb)，移到2003上无法运行，
出现错误
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supp
orted by the operating system.
/asp/logon.asp, line 15
如果要使用Access mdb作为网页的数据库的话，是不是一定得装Microsoft Access?
看到在ODBC里面有mdb driver啊？ |
|
r*******d
发帖数: 117 | 30 入门问题.
我想用JDBC打开一个MS access数据库.准备用JDBC:ODBC bridge连接.
在Data Source里定义了User DSN:
Data Source name: access
Driver: MS access Driver
Database: Test.mdb
Connection connectionAccess =
DriverManager.getConnection("JDBC:ODBC:access");
然后程序返回出错:
java.sql.SQLException: No suitable Driver.
这是怎么回事? 是不是还需要先load一个JDBC:ODBC driver,
具体怎么做?
多谢指点. |
|
y********o
发帖数: 2565 | 31 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 |
|
d********2
发帖数: 1042 | 32 如题，数据库是Postgresql管理的，需要在Mac下access数据库并进行查看编辑等操作
之前用过ODBC的，使用actual的driver 和 ODBC manager 可以正确设置
这个Postgresql的怎么设置呢？下载了它的driver后，在ODBC下找不到能够设置HostIP
和user的地方，哪位有经验指导一下？
谢希 |
|
r*******d
发帖数: 117 | 33 入门问题.
我想用JDBC打开一个MS access数据库.准备用JDBC:ODBC bridge连接.
在Data Source里定义了User DSN:
Data Source name: access
Driver: MS access Driver
Database: Test.mdb
Connection connectionAccess =
DriverManager.getConnection("JDBC:ODBC:access");
然后程序返回出错:
java.sql.SQLException: No suitable Driver.
这是怎么回事? 是不是还需要先load一个JDBC:ODBC driver,
具体怎么做?
多谢指点. |
|
k*z
发帖数: 4704 | 34 last questin for you. sorry bother too much.
how about i want to join two tables from two odbc datascr?
or I have to write two proc sqls to bring two tables then join?
proc sql;
connect to odbc as lib1 (user=&user1 password=&pwd1 DATASRC=&dsn1) ;
connect to odbc as lib2 (user=&user2 password=&pwd2 DATASRC=&dsn2) ;
create table temp2 as
select * from connection to lib
(
select col
from lib.table
where col="XXX"
);
disconnect from lib;
quit; |
|
d*2
发帖数: 2053 | 35 http://vision.cloudera.com/impala-v-hive/
by Mike Olson
December 22, 2013
We introduced Cloudera Impala more than a year ago. It was a good launch for
us — it made our platform better in ways that mattered to our customers,
and it’s allowed us to win business that was previously unavailable because
earlier products simply couldn’t tackle interactive SQL workloads.
As a side effect, though, that launch ignited fierce competition among
vendors for SQL market share in the Apache Hadoop ecosystem, w... 阅读全帖 |
|
l******9
发帖数: 579 | 36 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
Additional information: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified
I have installed 32/64 bits data base driver.
Thanks |
|
l******9
发帖数: 579 | 37 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'
ESCAPECHAR ''
)
AS
SELECT *
FROM admin.my_table
I logged in as admin in the database. But, I got error:
Exception captured: System.Data.Odbc.OdbcExce... 阅读全帖 |
|
s********e
发帖数: 893 | 38 公司里有个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里了。可是都没用。搞了好几天了都没进展，现在星期天了还
得接着试，周一老板要问了。我是做.net的，对... 阅读全帖 |
|
z****e
发帖数: 54598 | 39 Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/member/AddUser.asp, line 66
我汗啊，这个网页怎么搞的 |
|
m**i
发帖数: 89 | 40
I think so
There are some fatal memory leak errors in MSSQL, and NT is unstable.
My scores: DB2 on AS400: 9.5 , Oracle 8.0* on Solaris 9.5, Oracle 8i
on Solaris: 9.0 Oracle 8i on Linux 7.0, MSSQL:6.0
You don't know OEM? MSSQL:10 DB2:8 Oracle: 9
Both MSSQL, DB2 and Oracle support ODBC well. There is no difference here.
For JDBC:MS SQL can use ODBC-JDBC bridge. DB2 supports JDBC 1.0 only.
The latest Oracle JDBC driver is JDBC2.0 compliant. IBM WebSphere can use
both DB2 and Oracle as its resourc |
|
a*p
发帖数: 62 | 41 The simpliest way to make it working is mounting server2's
driver virtually as like G: in server1, and configure ODBC
on server1
this will cost lots of resources and it is very very slow.
Another way, I know there're some third part ODBC connecting
server which you might be able to use. Or maybe you can use
mySQL or something like SQL server. |
|
h*****l
发帖数: 184 | 42 我用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.open "driver={Microsoft Access Driver (*.mdb)}; dbq=
"&dbpath&""
RS = Server.CreateObject("ADODB.Recordset")
SQLSel = "Select * from mbaalumni Where fname = '"&
Request.Form("fname") |
|
m******t
发帖数: 2416 | 43
Basically an ODBC driver process database access requests in standard
SQL format. It's hard to give a tutorial about ODBC in this one single
post. You might want to check out some introductry books. |
|
j*****y
发帖数: 33 | 44 It is used for the non-default database on the concurrent node.
I haven't used it. But I think you can configure it bu using
SQL*NET easy configuration tool (for Oracle 7.x) or Net8(for
oracle 8). It will add the entry in the tnsname.ora and
listen.ora. Then you configure it in the ODBC or JDBC. I
suppose that the db_string is the string you add in the ODBC/JDBC. |
|
S****y
发帖数: 8 | 45 When I tried to use jdbc to create a table T using uid u1
in SQL server, but there is a table with the same name T
created by user u2?
Using sun.jdbc.odbc.JdbcOdbcDriver, I got an error message:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]
There is already an object named 'T' in the database.
How to deal with this problem?
Thanks |
|
m****a
发帖数: 394 | 46 hi,
MySQL: mysql-3-23-21-beta-win.zip
MSACCESS: MS OFFICE 2000 suite
MyODBC: myodbc-2-50-19-nt.zip
i installed all of them in my own machine, windows 2000, and start the MySQL
as a service, and i can import the data from MySQL server to MSACCESS smoothly
BUT when I tried to export the M.S.ACCESS data to MySQL, i got below error
mesg:
error: ODBC call failed
[Microsoft][ODBC driver manager(#0)
what does that mean? I need your help, guys. |
|
z***h
发帖数: 7 | 47 create a table login then try this code:
import java.sql.*;
import java.io.*;
public class JdbcTest
{
public static void main(String args[])
{
//String update = "INSERT INTO login(user_name, password,
user_type) VALUES ('Guest', '143456', 'adminis')";
String query = "SELECT * FROM login";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:ORACLE";
String username = "scott";
String password = "tiger";
try {
// Load the driver to allow connection to the database
Class.forName( |
|
n**b
发帖数: 6 | 48 I installed Developer /2000 and Oracle8 personal edition on
my PC. Now I don't know how to connect the developer to my
database. In developer, it asks me for the name of the
database, I entered the name, but it doesn't work. It is
always not responding. So I had to kill the process. I
already installed the oracle ODBC driver to my "ODBC data
source". Is there any other thing that I should do? Can
anybody help me? Thanks a lot. |
|
a*****a
发帖数: 438 | 49 You will need MDAC2.5 (from http://www.microsoft.com/data)
If you have to use C (not VC++), then you don't have much
choice but stick to ODBC. Search MSDN for ODBC samples.
真钠?>) 的大作中提到: 】 |
|
b*********l
发帖数: 30 | 50 DXs,
I am trying to learn a little ASP and ACCESS on my IIS
server. Below is an error when I tried to run a ASP script
(which connects to ACCESS DB).
I believe this must be a common type of bug -- can anybody
give me a pointer on this?
Thanks in advance!
==========================
GIVEN BACK BY IE5.05
...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error
Unable to open registry key 'Temporary (volatile) Jet DSN
for process |
|
