|
h****r
发帖数: 2056 | 2 The reason is I have to provide an updateDb API for other
people to
insert data to tens of differnet kind of table, and some
statement for
insert a record is definetly over 4k, use CLOB by
prepare/bind/exec will overcome the size problem, but
because every table has different coloums,
It is hard to provide an common updateDb API for all tables
by prepare/bind/exec.
for example,
table A is (Number, Number, CLOB),
table B is (Number, CLOB, string, CLOB);
we cannot provide a common updateDb API for |
|
h****r
发帖数: 2056 | 3 I found maybe use the prepare/bind/exec is a good way to
handle the
CLOB, but I meet some problem when use it. Do you ever have
expreience
and can point out what is wrong for my code?
I debugged it, the problem is from the SQLExecute, so the
SQLBindParameter
may have problem. But I really don't know where I can find
an example
to use them.
void updateClob(const char* lobString)
{
SQLRETURN lRetVal;
SQLHSTMT lSqlHstmt;
SQLINTEGER ind = SQL_DATA_AT_EXEC;
|
|
a****o
发帖数: 37 | 4 big string for a query is not good for network bandwidth.
why not try stored procedure? |
|
j***t
发帖数: 3 | 5 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. |
|
a*p
发帖数: 62 | 6 In some top-level API, like in PHP, you can specify which
line to return when you call function like
mysql_fetch_array
or
odbc_fetch_row
check API documentation. I specified row number in ODBC and mySQL before but
just no source code on hand right now.
but when you select, all the 10k rows should already be in the server's cache.
this method just saves the time to transmit, if say, your mySQL server is remote. |
|
k*******d
发帖数: 237 | 7 u need set up odbc, referring to sql svr db, in the computer on which the
access ap resides
try again
tables.
I
connection |
|
b******u
发帖数: 676 | 8 still old question:
I have a SQL server db and some Access front-end reports. I will have multiple
users that need to use the Access reports. I don't want to set system DSN for
everyone of them. because that would make it hard for me to modify my tables
since every time I would need to refresh the linked table for every computer.
So, I am trying to write a DSNless connection:
strCnct = "ODBC; DRIVER=SQL
server;SERVER=myServer;DATABASE=myDB;UID=myUser;PWD=myPWD"
DoCmd.TransferDatabase acLink, |
|
b******u
发帖数: 676 | 9 SQL db, Access front end, hosted on different servers. I can't figure out how
to set up DNSless ODBC connection between the two. Tons of sample codes, but I
just can't have it work...sigh...
So, I am doing this:
My end user uses short cut to access the Access reports. On every computer, I
set up same system DSN. Same name, and all pointing to the SQL db. Then, use
Access Link table.
When I modify the SQL table, seems that I can do it on any PC. just refresh
the linked table in Access Link Table |
|
|
st
发帖数: 1685 | 11 plz help:
line.Format("{call %s.dbo.p_getVDKFilters (%d, %s, null, ?, ?)}",
m_sDatabase, m_instance, from_date);
the call is like
{call p_getVDKFilters (-1,null,null,@errcode,@errmsg)}
I can get output result from query analyzer, the similar
java program works... but this one does...
very simliar call to another store procedure can work...
the problem is one of the "null" is a datetime type for output parameter.
the other store procedure has nothing like this...
it outputed once, after a minor c |
|
o***z
发帖数: 133 | 12 why can you use a null as output parameter? |
|
B**z
发帖数: 153 | 13 many of them
JDBC-ODBC bridge
IDS
AveConnect |
|
|
c*****t
发帖数: 26 | 15 Hi, guys,
I need to have access to a Federal public database. However, I do not know
what is ODBC drivers in Microsoft Access and how it works. Here is the
information about the database (See the website
http://rimsweb2.ferc.fed.us/form1viewer/). Frankly, I have no idea how to read
it in Access and Foxpro, although I can read them in Form1viewer. |
|
y**t
发帖数: 13 | 16 ODBC,crystal reports and FoxPro are the basic database/report knowledge,
without these knowledge how can you get the job done?
suggestion: go to www.google.com, then search them, there are lots of
information there.
read
Drivers) |
|
l*****k
发帖数: 6 | 17 don't laugh! I am just a beginner of MySQL!
I want to write a script that I can run to commit a serial of databases
queries (select, create table, etc.)
How can I do it with MySql? Right now, I am using Perl (ODBC) to do the job.
But just think there might be some ways to use transact sql in MySql.
Thanks for you help! |
|
F******y
发帖数: 1988 | 18 Hello,
I did successfully install oracle9i in redhat linux7.3.
And I did copy my old database tables from my MSSQL server to Oracle9i by
using the ODBC administrative tool in windows.
From the client side(Oracle9i client), i can connect to my oracle database,
and I can see the all the tables schema I copied there. But when I use "select
* from tUser" to get data, it give me error"table or views doest not exist"
I also use another oracle client tool (TOAD) to try, the error is the same.
But I can |
|
A***s
发帖数: 389 | 19 我写作：
UPDATE eW SET EnC = ( select InC from eC where DescC = 'strTemp') FROM eW,
eC WHERE InW = i
vb执行的时候出错了，说：
Run-time error '-2147217900 (80040e14)':
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression '( select InC from eC where DescC = 'strTemp') FROM eW
这是为什么呢？ |
|
A***s
发帖数: 389 | 20 UPDATE eW SET EnC = ( select InC from eC where DescC = 'strTemp') WHERE InW
= i
Run-time error '-2147467259 (80040005)':
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable q
uery |
|
A***s
发帖数: 389 | 21 UPDATE eW SET EnC = ( select InC from eC where DescC = 'strTemp') WHERE InW
= i
Run-time error '-2147467259 (80040005)':
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable q
uery |
|
o***z
发帖数: 133 | 22 you may need to use something designed for MS like MFC DAO
see MS KB Q270663
But |
|
z***y
发帖数: 13818 | 23 【 以下文字转载自 BuildingWeb 讨论区,原文如下 】
发信人: zmimy (咪咪), 信区: BuildingWeb
标 题: 我的asp脚本为什么总是出现"数据库对象不能更新"的错误 ？
发信站: The unknown SPACE (Sun Sep 1 00:46:08 2002) WWW-POST
我找了几个网站asp代码学习，装上以后首页能出来，但是经常出现"[microsoft][ODBC
microsoft Access Driver]不能更新。数据库对象为只读"的错误。我检查了半天，也搞
不懂是哪里除了问题。
我装了access2000，操作系统是win2000 pro和win2000 server。我在两套系统上都试过
，问题是一样的。
我检查asp脚本，似乎在定义access driver的一行代码就显示出错。比如：
Set conn=Server.CreatObject("ADODB.Connection")
conn.open "driver={microsoft Access Driver (*.mdb)}; & Dbpath
这一行就不对了， |
|
p******s
发帖数: 57 | 24 My question is very 初级。
The customer already has their own data warehouse which I have no idea what it
is.
I have a question to ask me whether my database is easy for the customer to
access for their data warehouse purpose.
I feel this quesiton is quite weird, however, because I have no idea about
data warehouse,
I mean my database is just normal SQL database, why say easy to access or not.
I think anyone can access it via ODBC.
However, I have no idea whether there is any standard software for |
|
m***e
发帖数: 6 | 25 我做了一个ＡＳＰ搜索ＡＣＥＳＳ数据库的页面，在我的local machine上运行的很好（
我自己set ODBC)。现在我想放到学校的服务器上，但我没有权限touch campus sever的
ＯＤＢＣ的setting,如何在ＡＳＰ的里连接我的数据库而不用修改sever的ＯＤＢＣ的set
ting呢？我的数据库和ＡＳＰ Page放在同一个folder下面. |
|
a*****a
发帖数: 438 | 26 better yet, dont use ODBC. it's a retiring technology.oledb is better. |
|
l*****s
发帖数: 2109 | 27 sqlstp.log 中的错误部分如下,哪位高人帮着看一看.
我的是 中文sqlsever2000的开发版.
=============================================================
21:17:48 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Chinese_PRC_CI_AS" -H 61
61030 -U sa -P
############################################################################
###
正在启
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
正在与服
driver={sql server};server=PSL-HC;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Serv |
|
c*****t
发帖数: 1879 | 28 I have a table view of a table. Since that table is being updated
sometimes in the background and needs to refresh the display. However
I wish to view the table w/o getting the complete full table each time.
What are the things to consider.
BTW, I use JDBC-ODBC bridge driver.
Thanks |
|
l*********l
发帖数: 1 | 29 Tricky question. There is a table in access 2000 which has a column with type
memo. The long (>255) length string is stored in that column. If I write a sql
in access to retrieve it, the length of the string returned is correct. The
insteresting thing is that when I write the sql in java application and
retrieve it through ODBC, the length of the string returned will be truncated
to 255 no matter how long it was.
My code is like:
...
Statement stmt = con.createStatement();
ResultSet rs = stmt.ex |
|
|
s******e
发帖数: 96 | 31 VC++，MFC，database 问题
1. Describe CObList, provide a sample that defines a class named MyClass
derived from CObject , then builds a CObList with a few of MyClass objects
in the process heap, then removes your CObjects from the list.
2. Describe try/catch logic and add try/catch logic to the sample in your
sample 1) above
3. Suppose you have an ODBC Data source named MyDB, provide a sample that
opens a CDatabase object using MyDB data source. Build a CString object
containing SQL to insert a rec |
|
aw
发帖数: 127 | 32 is it set to read-only? |
|
l*****n
发帖数: 92 | 33 No, I can write days ago. And I can write using ms access. |
|
b*e
发帖数: 3845 | 34 file must be locked. MS Access only allows single use to have write access. |
|
|
b*e
发帖数: 3845 | 36 if there is only one connection, there shouldn't have any problem.
otherwise, you should change to a real database system instead of Access. |
|
b******e
发帖数: 8 | 37 Do not know how to start my question,
Is there any text file based database?
I am not a programmer nor a database developer.
The only "program language" I'm using now is Matlab.
Matlab has a database toolbox/interface.
As my understanding, it works with standerd SQL.
I do not have too much data, upto thousands items and could
be multiple tables later.
Only myself access to it.
I want keep them in text format, coz it is sample, I can access
then even without dbtool.
I want it has a db structure a |
|
n********a
发帖数: 68 | 38 Oracle 9i has external table feature that may be helpful. |
|
n******n
发帖数: 602 | 39 【 以下文字转载自 Programming 讨论区 】
【 原文由 nicolson 所发表 】
Found problem: MS bug: If database doesn't have password, using ODBC
to access access database will result in this problem. |
|
m******t
发帖数: 2416 | 40
I'm not familiar with VBS, but there should be a way to explicitly
demarcate a transaction, i.e., something like transaction.begin(), and
at some later point either transaction.commit() or transaction.rollback().
At least that's how it works in Java with Oracle (and IIRC it's similar
in ODBC as well). |
|
P***y
发帖数: 2885 | 41 用VC来编数据酷程序，是不是感觉有点吃力不讨好？？？
请各位高手指教一下。 |
|
|
L*******r
发帖数: 1011 | 43 ADO is easy. OLE DB is not hard, either. |
|
w********c
发帖数: 2632 | 44 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); |
|
n********a
发帖数: 68 | 45 Did you explicitly turn off auto commit for the java.sql.Connection object?
JDBC set auto commit to true by default.
Another thing is to check if the JDBC driver functions correctly.
Did you use a Type4 driver or a JDBC-ODBC bridge?
1010 |
|
i*******l
发帖数: 6 | 46 ok, but is it for remote connection? And do I need to install ODBC driver in
my local machine?
怎么 |
|
n********a
发帖数: 68 | 47 啦?
sqlplus)?
sqlplus is just another client, nothing different than JDBC, ODBC, Pro C, and
the list goes on and on.
Your worry that Oracle cannot servive sqlplus stuffed with tons of
non-reusable SQL is warranted. There are several points to consider here:
1. sqlplus as you said, is an interactive client. A human being will type in
SQLs. Now, how many SQLs can you type in an hour? How long will it take you
to type hundreds of SQL statements? The point is that you are unlikely to
be able to gener |
|
w*********y
发帖数: 28 | 48 老板对数据库迷恋，尤其对oracle迷恋，别的DB都嗤之以鼻，真是搞不懂他。
现在老板要求在Oracle把一个Number类型，转变成一个IP地址，而且不能用JDBC，ODBC。
只能用QUERY。
其实我认为就是先把Number类型转换成Binary类型，再按8位分组，再把8位转变成NUMBER
。
其实如果不用Oracle， 我用MYSQL可以写成：
SELECT CONCAT(CONV(SUBSTRING(BIN(ip_src), 1, 8), 2, 10),'.',
CONV(SUBSTRING(BIN(ip_src), 9, 8), 2, 10),'.',
CONV(SUBSTRING(BIN(ip_src), 17, 8), 2, 10),'.',
CONV(SUBSTRING(BIN(ip_src), 25, 8), 2, 10))
FROM header;
但在ORACLE下就不知道怎么办了(没有BIN，CONV，CONCAT函数)，希望专家指点！谢谢！ |
|
y****i
发帖数: 5690 | 49
现在老板要求在Oracle把一个Number类型，转变成一个IP地址，而且不能用JDBC，ODBC。
其实我认为就是先把Number类型转换成Binary类型，再按8位分组，再把8位转变成NUMBER
！
Did you investigate before you say there is no such thing in Oracle.
I guess you don't like Oracle because you have little experiences with it :P
But it's nice to know more, isn't it?
tochar(): Convert from number to string
substring: same as in mysql
concatenation: ||
you can search on google for more details. |
|
j**i
发帖数: 419 | 50
现在老板要求在Oracle把一个Number类型，转变成一个IP地址，而且不能用JDBC，ODBC。
其实我认为就是先把Number类型转换成Binary类型，再按8位分组，再把8位转变成NUMBER
谢
to_number(),to_char(),substr(),||,:),easy bah. |
|
