S***x 发帖数: 2382 | 1 星期五把SAS ODBC搞定了,本来想休息两天,暂时不去碰这些东西,呵呵
不过今天看到oloolo和ciarad的回帖,心想早点写出来免得过两天忘记了,
而且也请高手们指正。。
言归正传,前几天装好MySQL远程机之后就想试试用SAS连,网上看了看有两种
方法,一种是libname xxx ODBC, 一种是libname xxx MySQL, 星期五一早先试
了试ODBC,发现不work,系统给了个CLI, 代号113的错误,又试了试mysql,还是不work,
mysql说找不到mysql engine,想了想觉得是license的问题,中午打电话给sas
公司,被告知我的版本不包括mysql engine,只能用ODBC。
既然ODBC不work,显然要装ODBC driver,上网找了找,unixodbc.org上都有,下了
一个2.2.11,然后开始装,一开始装就出错,半道上configure不走了,说要qt2.2,
于是跑去下qt,qt的网站巨慢,吃完中饭回来还没下完,2:30 qt下好,开始装,装到
一半报错,说xxx没有装,没耐性再去找了,就ignore,装好qt之后装 |
|
h**i 发帖数: 54 | 2 Do I have to have a web server program on my Win98 to serve ODBC? I
use Xitami's free web server for Win98. Is that OK? What is the port
number for ODBC?
Also if I connect to ODBC, and the backend driver under ODBC is Access
or Exel. Are those two different from my program which is using SQL to
drive ODBC? |
|
W**H 发帖数: 716 | 3 I have installed MS SQL server in my machine.
But whenever I tried to use it, I got error
message as follow;
The ODBC resource DLL (C:\\windows\system\odbcint.dll)
is a different version than the ODBC setup DLL(c:\\
windows\system\odbccp32.dll).
You need to reinstall the ODBC components to ensure
proper operation.
Can some Gao Shou tell me what I should do? How can I install
the ODBC components again? Actually I don't even know where to
get the ODBC compon |
|
h****r 发帖数: 2056 | 4 Now the idea is,
1. Oracle DB will run on NT server;
2. Plan to run application on solaris, the application will
access
DB on NT server by odbc;
question:
I think I need to install 3rd part odbc driver on solaris,
and my
application wrote by C++, so I need lib to provide SQL Api,
in windows,
I use the visual studio's odbc32.lib provide "sql.h" header
file. Now
I only install the client component of openlink odbc driver
at solaris,
is it provide the odbc lib? if not, where can I get the lib |
|
s**u 发帖数: 17 | 5 I am trying to connect to access database through JDBC:ODBC in a java
programm
I tried to connect to the following url:
JDBC:ODBC:MyServer;database=mydb.mdb
and establish the access file with corresponding server and filename.
but when I run the program, it keep on telling me the following:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3661)
at sun.jd |
|
l******g 发帖数: 5 | 6 【 以下文字转载自 Programming 讨论区,原文如下 】
发信人: langlang (家养小精灵), 信区: Programming
标 题: an Oracle ODBC question
发信站: Unknown Space - 未名空间 (Tue Feb 15 13:51:37 2005) WWW-POST
My program is using Oracle ODBC to connect to Oracle on Windows XP. If a
client installs my software, how will my program talks to Oracle? If still by
using ODBC, do I need Oracle Client software and ODBC driver to do so? Is
there any way to connect to Oracle database without using Oracle client
software?
Thanks a lot |
|
f***h 发帖数: 2 | 7 Hi,
我要写 ASP 网页访问MS SQL Server, 但是 administrator
说不愿意在 web server 上装 ODBC driver.
能不能在 ASP 里用 ODBC 之外的方法访问 SQL Server , 比如专有
的连接?
另外, 如果不用 ODBC, 兼容性会差些吗?
请大侠指点一二.
ffish |
|
o**k 发帖数: 5 | 8 how to establish sun.jdbc.odbc.JdbcOdbcDriver
in ODBC? and the user DSN in ODBC?
thx |
|
s*k 发帖数: 144 | 9
As far as my knowledge, ODBC is an industry standard,
initialized by Microsoft.
If you want to learn more, you can go to:
http://msdn.microsoft.com/library/default.htm
see Platform SDK --> Data Access Services -->
Microsoft Data Access Component (MDAC) SDK -->
Microsoft Data Access 2.5 SDK -->
Microsoft Open Database Connectivity.
For a comprehensive background, see
http://technet.microsoft.com/cdonline/default.asp
Technologies --> ODBC --> Inside ODBC chapter 5 |
|
h**i 发帖数: 54 | 10 I have access, and when I tried to set up ODBC on my Win98, I got
options of drivers like, TEXT DRIVER (.txt; .csv). Does this mean if I
use Perl's DBI or Java's JDBC to connect to my ODBC and I will be able
to use SQL on my TEXT files on my Win98? I know ODBC is a commom gate,
does this mean this will hide EVERY DIFFERENCE before different
drivers: such as Access, Exel and TEXT will be the same for SQL? |
|
c**e 发帖数: 3760 | 11 【 以下文字转载自 Programming 讨论区 】
【 原文由 cure 所发表 】
I reinstalled teh Microsoft peer web services on my NT,
then I found that when I use VC4 or VC6, i was told that:
the ODBC resource DLL (C:\winnt\system32\odbcint.dll) is a
different version thatn the ODBC driver manager
(C:\winnt\system32\odbc32.dll).
you need to reinstall the ODBC components to ensure proper operation
what's the problem? how to solve it?
Thanks! |
|
c*****t 发帖数: 1879 | 12 【 以下文字转载自 Java 讨论区 】
【 原文由 coconut 所发表 】
Is it possible to create a database file through jdbc/odbc?
In the ODBC data source window, I see
MS Access Database
but, what is the url for creating database? I know that I
could create an empty access database before hand, and put
that file into the User Sources, but that's requires user
configuration, which is bad.
Anyone can help?
BTW, when I get an SQL exception such as
SQLException: [Microsoft][ODBC Microsoft Access Driver] Table 'COFFEES' |
|
r********n 发帖数: 7441 | 13 mysql server 在本地机器上, windows 7 操作系统
重新装机后,mysql数据源怎么都找不到了,请问咋回事?
就是在windows下ODBC设置里面,我已经下载安装了新的mysql odbc driver
启动mysql后,在odbc中无法找到本地mysql数据库 (下拉列表无法自动列出mysql中已
经装载的数据库),请问是咋回事?其他安装数据源(access 和 sql server)都没问题 |
|
c*****t 发帖数: 1879 | 14 Is it possible to create a database file through jdbc/odbc?
In the ODBC data source window, I see
MS Access Database
but, what is the url for creating database? I know that I
could create an empty access database before hand, and put
that file into the User Sources, but that's requires user
configuration, which is bad.
Anyone can help?
BTW, when I get an SQL exception such as
SQLException: [Microsoft][ODBC Microsoft Access Driver] Table 'COFFEES'
already exists.
Is the connection still |
|
t*********u 发帖数: 26311 | 15 如果用ODBC先连接了一个hive table
然后中间对这个table进行了write的操作
write完以后马上通过odbc进行query,但是query显示最新的data不在里面,
如果等一会儿就能看见最新加入的data
会不会是ODBC的caching导致的latency issue? |
|
l******9 发帖数: 579 | 16 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: access two databases in one ODBC connection from pyodbc
发信站: BBS 未名空间站 (Sun Aug 3 09:28:06 2014, 美东)
how to access two databases in one ODBC connection from pyodbc ?
thanks ! |
|
p*****e 发帖数: 58 | 17
If you do not have ODBC on your machine, you need ADO
Provider, a software component for accessing your DB server.
ADO provider's role is similar to ODBC. They provide
uniform programming interface to access various db servers.
There are provider for MS SQL server, provider for Oracle,
... As an ASP developer you only need to find the right
provider for your DB, and make a connection string using
that provider and info about your DB, then you don't care
what DB you are talking to. If you have O |
|
s**u 发帖数: 17 | 18 I am developing some java program and I need to demo the jdbc to odbc
connection. because it is only a demo and I don't want to use the
existing database for security reason.
any one know where I can download some sql server with odbc driver.
Any information is highly appreciated! |
|
m******t 发帖数: 2416 | 19
You don't need to do that. It's a JDBC-ODBC bridge driver, meaning
you only need to set up the ODBC entry for your database as usual. |
|
m****r 发帖数: 17 | 20 From Sun's website, it seems there is JDBC-ODBC bridge that supports
JDBC API 2.0. But I can't find it at Sun's homepage. Right now, the
JDBC-ODBC driver shiped with JDK 1.2 only supports JDBC API 1.1.
If I want to purchase a pure JDBC driver(type 2, 3, 4), which vendor is
the best choice?
thanks. |
|
h****r 发帖数: 2056 | 21 Got a problem on ODBC.
say in Oracle, I store a struct(user defined type) data to a
table, then want retrieve this struct data back from the
database.
I have to use ODBC to do it, anybody have some idea on it. |
|
d******e 发帖数: 2265 | 22 hi, everybody,
I just download a Clinet SDK , with ODBC driver 3.32.
I try use it to connect the IDS2000 server on the
Solaris2.7.but it reports as follows:
State: S1000
Error: [Informix][Odbc Informix Driver][Informix]Cannot
locate ius912 service/tcp service in /etc/services.
File: ..\sql\ntcon.c
Line: 268
Expert, help me! |
|
h****r 发帖数: 2056 | 23 want porting my application from NT to Solaris,
on NT, I link Microsoft Visual Studio/VC98/Lib/ODBC32.LIB to
provide the
odbc 3.0 API, what is the corresponding lib I should use on
Solaris(Both NT
and solaris I installed oracle 8i)?
Thanks a lot! |
|
e****m 发帖数: 484 | 24 You have to get 3rd party odbc libs from any vendors. |
|
h****r 发帖数: 2056 | 25 But getObject only exists in Java, not C++, and my problems
is, say
SQL string like
"select .... from ... where ...", if its size over 1K, then
ODBC driver
will not accept it. Is there a way to extend the ODBC SQL
String 1K
limitation?
Thanks. |
|
s**n 发帖数: 33 | 26 Hi, I want to install a software, while it told me that my system doesn't
have ODBC 3.0 or later, which is required by that software. Could anybody
tell me how can I get ODBC 3.0? I am using Windows 98.
Thanks. |
|
s****y 发帖数: 95 | 27 Thanks. I think you are right the database password is for MS Access only. But
do you know whether there is an ODBC API which is compatible with this
protocol?
ODBC
like
a |
|
b****b 发帖数: 1 | 28 我有一些旧的代码使用odbc写的,现在在新的功能里面要用ado,但是又不想重写旧的代
码,又没有什么方法把ado的interface封装起来,成为统一的odbc接口,这样旧的代码仍
然可以用?
多谢! |
|
t***u 发帖数: 368 | 29 Am trying to export some DB on SQL server 2005 to ODBC, selecting Tasks->
Export-> Wizard dialog pops out then.
select source DB, click "Next" and go to destination screen, trying to
find something like "Miscrosoft Ole DB provider for ODBC" but nothing,
do Google but no real answer to deal with, can any super guy here give me
some good hints?
appreciate! |
|
i****a 发帖数: 36252 | 30 ODBC is connection, not a database
what is the ODBC setup to connect to? export directly to there
>
me |
|
i****a 发帖数: 36252 | 31 I just looked and actually you can export via a ODBC connection
.NET Framework Data Provider for ODBC |
|
k*z 发帖数: 4704 | 32 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 | 33 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. |
|
l******r 发帖数: 99 | 34 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. |
|
l******9 发帖数: 579 | 35 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: access two databases in one ODBC connection from pyodbc
发信站: BBS 未名空间站 (Sun Aug 3 09:28:06 2014, 美东)
how to access two databases in one ODBC connection from pyodbc ?
thanks ! |
|
l******9 发帖数: 579 | 36 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: access two databases in one ODBC connection from pyodbc
发信站: BBS 未名空间站 (Sun Aug 3 09:28:06 2014, 美东)
how to access two databases in one ODBC connection from pyodbc ?
thanks ! |
|
l******9 发帖数: 579 | 37 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: access two databases in one ODBC connection from pyodbc
发信站: BBS 未名空间站 (Sun Aug 3 09:28:06 2014, 美东)
how to access two databases in one ODBC connection from pyodbc ?
thanks ! |
|
p*****e 发帖数: 58 | 38
Your admin may not want you to use ASP to access SQL
directly because there is some known security leak in
IIS/ASP server. You can make COM component for your logic
to access the database and the COM can be on any other
machine. All you need is DCOM or MTS for your web server and
app server (the machine with COM), and between COM and DB
you can use ODBC, or ADO, whatever. |
|
a*****i 发帖数: 4391 | 39
Order oracle for NT (The free version) or mysql (it supports odbc) or MSsql
server (ack!). |
|
m******t 发帖数: 2416 | 40 Did you create a data source with that specific name in your ODBC
settings? |
|
s**u 发帖数: 17 | 41
I set up the data source with "ODBC datasource administrator". I added a MS
Access driver, setting as following:
DRIVER={Microsoft Access Driver (*.mdb)}
Server=MyServer
database=mydb
then I selected the file mymd.mdb to link to the datasource
source file named mydb.dsn was constructed by computer.
there must be something wrong, but i just don't know it |
|
m******t 发帖数: 2416 | 42 What is the name you gave to the data source? It has to be
the one you passed to the JDBC:ODBC bridge in your program. |
|
R***r 发帖数: 322 | 43 Hi, all,
Does anyone know where someone could find ODBC Standard.
Any suggestions for where to find them?
Thank you. |
|
d****g 发帖数: 210 | 44 I install Windows 2000 server(with IIS 5.0) and MS Visual InterDev. Then
install the Sample Project("Gallery") on my machine. But when ever I
browse the website and click the link of "Data Entry" -> "run sample",
which is supposed to show something from MS Access database using ODBC, it
just show me an error message:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services |
|
j******f 发帖数: 228 | 45 in ODBC, how can i first specify a table
and then using "select * from " that table
to retreive all its rows?
In MFC, you should map a CRecordset on
a certain table. is there a way that this
process could be dynamic?
thanx! |
|
h****r 发帖数: 2056 | 46 Try to use batch SQL like
"begin
insert into table1 values('0', 0);
insert into table1 values('1', 1);
end /"
it works fine in SQLPLUS as a SQL statment,
but use it in ODBC programming it will not works fine,
any shrimps has experiences on it, please share your
idea, thanks a lot. |
|
a*****a 发帖数: 438 | 47 I'm a bit confused with what you want.
Are you talking about the lenght of your sql command
statement, or the length of the column?
* If it's command statement, you may try put it in a stored
proc.
* If it's the length of the column (assuming you are using a
TEXT field):
If you use VC++'s ODBC, TEXT column is mapped to RFX_TEXT.
And it takes a default nMaxLength of 255 (you can check the
prototype of RFX_TEXT in afxdb.h). Just supply your length
to overwrite the default value. |
|
h****r 发帖数: 2056 | 48 yes, I mean the lenght of the sql command statement, store
procedure
is good, but maybe not fast. Now I overcome the 1k
limitation to 4k
limitation, it is the limiation of the ODBC packet size,
which is 4k.
Do you have some good way to over the 4k limiation of sql
statement? |
|
a*****a 发帖数: 438 | 49 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) |
|
h****r 发帖数: 2056 | 50 Hi everyone,
I use ODBC driver to connect C++ application to Oracle Databse,
The C++ application use standard SQLEndTran to do commit, sometime
it worked as expected, some time it is not return SQL_SUCCESS or
SQL_SUCCESS_WITHINFO, this means the commit action failed, Could
somebody explain how the SqlEndTran works, and what could be the
reason it failed during the commit process?
Thanks a lot. |
|