k******s
发帖数: 272 | 1
现在老板要求在Oracle把一个Number类型，转变成一个IP地址，而且不能用JDBC，ODBC。
其实我认为就是先把Number类型转换成Binary类型，再按8位分组，再把8位转变成NUMBER
！ |
|
k******s
发帖数: 272 | 2
现在老板要求在Oracle把一个Number类型，转变成一个IP地址，而且不能用JDBC，ODBC。
其实我认为就是先把Number类型转换成Binary类型，再按8位分组，再把8位转变成NUMBER
！ |
|
k******s
发帖数: 272 | 3
现在老板要求在Oracle把一个Number类型，转变成一个IP地址，而且不能用JDBC，ODBC。
其实我认为就是先把Number类型转换成Binary类型，再按8位分组，再把8位转变成NUMBER
！ |
|
d********g
发帖数: 38 | 4 上周系统曾出过问题，后来执行一个.exe文件(需要调用数据库)时总是失败,并且给出提
示:〔microsoft][ODBC Drive Manager][Data source name not found and no default
driverspecified].当我点击"确定"后,又提示说Run-time error '-2147467259
(80004005)':Automation error.
请问这些代表什么意思啊?不知道是不是上周系统出问题时,把什么文件给弄坏了.数据库
我是一点也不懂,而且这些个数据对我太太太重要了.恳请请大家帮我看看,能否有补救的
办法?先谢谢了. |
|
d********g
发帖数: 38 | 5 我还用的是win2000，你指的就是ODBC data sources吧，那个我已经试着重新create了，
但还是不行。不过我也不太确定create得对不对。麻烦你能把create 的过程说得再详细
些吗?我是数据库盲，惨啊。谢谢谢谢你了。
出提
default
据库
救的 |
|
h****r
发帖数: 2056 | 6 知道有这种工具，象sniff一样，用于追踪所有被DB和JDBC/ODBC appliction交换的sql语
句。
请问谁知道工具的名称，或者哪里可以找到。
谢谢。 |
|
n****f
发帖数: 905 | 7 很容易.
要先在 Access use ODBC Driver 连接 ORACLE
然后将 ACCESS 数据加进 ORACLE.
里
简单的VBA编程还是要会一点的，比如FORM上的数据你想处理一下再插入数据库TABLE，
把
文
据
？ |
|
r***o
发帖数: 1 | 8 i installed the mysql 4.0.20a on windows server 2003.
everything looks fine at first. the mysql-nt.exe starts normally.
but when i try to create a new user using mysqladmin, their is a error
so i can not creat a new user with password
and also with the default account ODBC i can not create a new database.
i dont know why..
please help me if you know how to solve the problem.
Thanks. |
|
n****f
发帖数: 905 | 9 如果只是TABLE的生成，我用POWER DESIGNER。
如果输入数据，直接用ODBC就可以。 |
|
w*r
发帖数: 2421 | 10 by using ODBC connection, you can use ANSI SQL for forxpro DBMs,
it is just a variation of Dbase. |
|
s******n
发帖数: 45 | 11 I think oracle client is needed. |
|
o******r
发帖数: 259 | 12 google了一把，
发现好多人碰到了这个问题，
有人质疑是不是ODBC bug
还有人建议把记录置空，不删除，
这个主意太差，
因为下次加新记录就会中间空老大一段，
而且用久了记录只会越来越多，
手工删容易出错，尤其是table 直接有dependency时。
以下是比较肯定的结论，
也不知道MS这帮人是怎么想的，不让人家delete a record
http://www.kbalertz.com/kb_Q257819.aspx
You are more restricted in deleting Excel data than data from a relation
al data source. In a relational database, "row" has no meaning or existe
nce apart from "record"; in an Excel worksheet, this is not true. You ca
n delete values in fields (cells). However, you cannot:
1. |
|
c*a
发帖数: 806 | 13 Have anyone tried base? it's very slow if trying to access table from oracle
server using odbc.
what's the problem |
|
c**t
发帖数: 2744 | 14 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? |
|
f******e
发帖数: 144 | 15 I'm using -odbc load- to read an access table into memory in Stata. But all
the Chinese Characteristics become question marks, in both variable names
and variable contents. Does anyone know how to dealwith this?
Also, with this Fterm I'm using now, Chinese I input are shown to be
question marks, but I can read others' posts in Chinese. Is this the same
problem? If yes, is this still a database related question? Or is it about
system setting? I've already changed the regional and language setting |
|
E**i
发帖数: 116 | 16 ☆─────────────────────────────────────☆
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 |
|
L****6
发帖数: 31 | 17 Today I learned how to use SAS and SPSS to access and query databases
through ODBC.
Could you please tell me any other ways to access and query databases? |
|
d****e
发帖数: 2856 | 18 Since M$ declared they will drop the support of Embedded SQL for C (ESQL/C)
in the furture versions of SQL Server after SQL Server 2000, what are the
alternatives when porting the existing applications which uses the ESQL/C?
Do we really have to rewrite the ESQL in ADO, OLE DB or ODBC? It sucks. |
|
B*****g
发帖数: 34098 | 19 想加external data source（txt, excel, odbc, ....), 没找到。谢谢 |
|
y*******f
发帖数: 26 | 20 这位兄弟好牛啊，嗬嗬，你是在Teradata工作的么？以后有问题的话多请教你可以么，
赫赫。
ODBC/ |
|
j*****n
发帖数: 1781 | 21 check out if you have ODBC driver for excel 5. |
|
I******e
发帖数: 101 | 22 Still not sure whether they are in the same session.
Session means your JDBC or ODBC or other interface opens a connection to the
database. If one session delete, the other session insert. Even though
the deleted session committed, the insert session can still see the deleted
row after. This is by design in Oracle.
If you guarantee that your delete/insert are in the same session, you need
to make sure that your commit succeeded.
For update slow issue, it is most likely caused by rollback segm |
|
e******r
发帖数: 220 | 23 let's say I have several tables, then after running some database
application (like ODBC),
How do I check which tables are populated ?
i.e. how to check which tables are modified and what kind of
modification they are.
thanks
|
|
n**y
发帖数: 68 | 24 需要建立mysql数据库做数据分析，请问MySQL ODBC Driver软件是我唯一需要的软件，
对吗？多谢！ |
|
j*****n
发帖数: 1781 | 25 might be the driver problem.
You can find out whether you already have the Visual FoxPro ODBC Driver
installed by checking to see if a file called VFPODBC.DLL exists in your
Windows System directory.
http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx |
|
B*****g
发帖数: 34098 | 26 俺没办法了，没法解释为啥ODBC可以连。
database |
|
j*****n
发帖数: 1781 | 27 同不懂...
试了一下，得到如下error message...
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on
object 'AWBuildVersion', database 'AdventureWorks', schema 'dbo'.". |
|
a*******t
发帖数: 891 | 28 ODBC can setup to have different login than your windows account |
|
o******5
发帖数: 29 | 29 Bethic Software's impexp32 is the best tool I used for importing data to
Oracle. However it need to have the target table already exists.
The other easy solution is Access. You first dump data to Access and save it
to Oracle via an ODBC connection. It will create the table.
Oracle's own SQL loader or external table are also useful. However it
requires some coding. |
|
c*****d
发帖数: 6045 | 30 在mysql里有一个系统表user
里面有哪个用户允许从哪里登录
desc user;
Field |
|
|
|
j*****n
发帖数: 1781 | 33 check your SQL Server Surface Area Configuration, make sure your Remote
Connections are turned on. |
|
h**h
发帖数: 488 | 34 我是做统计/经济的，用SAS和Excel。上一个工作我们那里economics的人喜欢用access
。现在我找工作，看见很多job要求懂SQL（Structured Query Language）。 这个是指
的哪种，数据库的还是编程的？我基本是都不懂的，就是跟着我老板学会用Access，也
就是从ODBC database里调个数。我想自己看看这方面的东西，起码知道基本原理。 |
|
i****a
发帖数: 36252 | 35 the query designer in Access is just a graphical interface to build SQL
commands for you.
If you look at the ODBC on the computer the Access is running on, you can
see the details on the connection.
that tutorial website talks about the basic and standard SQL, which is
almost the same for all systems.
with
"MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database
systems", which one I should take a look? |
|
t***u
发帖数: 368 | 36 tried that one (odbc_net.msi) before, no work...
thx |
|
s***z
发帖数: 9 | 37 我有一些javadb的database，需要把他们导入oracle中，在做成cube进行分析，不过
javadb不能
直接dump数据，好像也没有odbc支持，有什么什么办法可以做这个工作啊？谢谢！ |
|
s***z
发帖数: 9 | 38 jdbc是有的，应该是可以把数据都用jdbc读出来在写到oracle里。但是oracle里不知道
有没有什么工具可以直接load他们。owb好像只支持odbc。 |
|
y****w
发帖数: 3747 | 39 问题，用java的client我把jdbc driver烤过来就行了，要是.net,我岂不是还得配置
odbc数据源之类？ |
|
|
|
M*****r
发帖数: 1536 | 42 请问如何得到如下的trace/log:
submit a query against a database (not oracle), the return contains some
junk characters.
OBIEE server is on linux and on the same linux machine， using the odbc
driver used by OBIEE， I can get the correct return in other tools.
那怎么能trace/log到OBIEE读入的数据那？ |
|
n****7
发帖数: 8354 | 43 Thank you. I am still working on it.
I tried to use XML on that chart. But I don't know how to use it. I type "
Sequential". It come out something. But I don't know select which one.Also
there are two methods, get and set. I don't know how to use them also. I
just want to open a file and override recorded data.I will look the link you
give me. I am an ABC level.
DataSource("System.Data.Odbc", "Dsn=Excel Files;Driver={Microsoft Excel
Driver (*.xls)};dbq=|DataDirectory|\Data.xls;defaultdir=.;drive... 阅读全帖 |
|
k*z
发帖数: 4704 | 44 能请教一下你是怎么配置的么？ iseries odbc？
SSIS visual studio 2010打开以后只有有限的几个数据库让你链接吧。例如oracle,
sql, db2. |
|
k*z
发帖数: 4704 | 45 能请教一下你是怎么配置的么？ iseries odbc？
SSIS visual studio 2010打开以后只有有限的几个数据库让你链接吧。例如oracle,
sql, db2. |
|
i*****w
发帖数: 75 | 46 就我的经验, iSeries的DB2 Provider在处理大数据量时不如Microsoft 的DB2
Provider. 你们在
SQL上有相应的 linked server吗？可以参照着配置library,catalog等。
用OLE DB Provider, not ODBC.
另外，回写到AS400时有时候需要IBM Provider. |
|
|
A*********n
发帖数: 637 | 48 我们用ODBC连接到TERADATA， 帐号三次密码输错后就被LOCKOUT了。有没有人知道怎样
调整帐号的失误次数？找DBA还是找UNIX ADMIN？ |
|
s**********o
发帖数: 14359 | 49 EXADATA好歹也是个新产品，ORACLE会给微软提供DRIVER吗，
再说微软推销自己的SQL 2014和DW APPLIANCE，会正经开发
EXADATA的DRIVER吗，能不能读，速度快不快，最后都落到
ODBC DRIVER上去啦，这种HETEROGENEOUS的东西，哪里有
什么成熟的技术，将来麻烦不断也不好说 |
|
a****g
发帖数: 295 | 50 这个有点想当然了吧。 you can use either oracle ole db driver or odbc driver.
of cause it is possible you might not fully reap the benefit of exadata if
the sql sent to exadata by SSRS is not well optimized, but it is the same
problem for any kind of reporting tool. |
|
