|
j****y 发帖数: 178 | 2 不知道装ODBC后,是不是对数据库的其他操作都跟以前一样。不需要做其他修改吧?(
除了创建数据库连接的部分) |
|
b*******c 发帖数: 77 | 3 这个asp.net 就是w3school 上面的ASP 对吧
这个是免费的吗
我是不是也可以用access 和ODBC那 |
|
a*******t 发帖数: 85 | 4 We have all common php extensions ready other than imagemagick.
for example:
bz2, curl, gd, ldap, libxml, mbstring, mcript, memcache, mysql, mysqli,
odbc, openssl, pcre, sqlite, zip, zlib.... |
|
l*****l 发帖数: 25 | 5 受委托来此咨询公司网站设计报价/项目承接. 欢迎建议意见. 有意者请站内联系或留
下联络方式.
网站功能要求 (refer to: www.goldenlighting.com for an example):
1. General Search for keyword/string on top right corner; Advanced Search
fields on left side for 2-3 combinations (e.g. price range; product color;
etc).
2. Slide/VideoShow of featured products. Flipping/interactive product
catalog (such as generated by FlipHTML5).
3. Dealer/Sales Representative account module. Need to manage several
thousands dealers and dozens sales representatives: onl... 阅读全帖 |
|
t**o 发帖数: 620 | 6 【 以下文字转载自 JobHunting 讨论区,原文如下 】
发信人: taro (非典型芋头), 信区: JobHunting
标 题: 急需Java 或者GSM的人才!
发信站: Unknown Space - 未名空间 (Sat Sep 25 18:59:16 2004) WWW-POST
代友发文。
北京一家大型软件外包公司(美资),客户大多是国外
知名公司,比如摩托,西门子等。
急需Java 或者GSM的人才,多个职位空缺。
待遇从优
职位描述:
PC Application Developer (Beijing)
Qualification:
Bachelor degree, Mater degree is preferred.
Major in software or related.
At least 3 years experience in software development.
Excellent in VB, good at C/C++
Good at SQL and RDBMS
Experience in ADO or ODBC
Experience |
|
s**t 发帖数: 1 | 7 头痛 ODBC
DMS ba0-c24 ENTER SQLAllocEnv
HENV * 1F6CCDBC
DMS ba0-c24 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6CCDBC ( 0x010b1540)
DMS ba0-c24 ENTER SQLGetEnvAttr
SQLHENV 010B1540
SQLINTEGER 201
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012E418
DMS ba0-c24 EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQ |
|
S*******0 发帖数: 208 | 8 Can someone help me with the code, simply put is : find a cell in excel, and
copy the sql reusult dataset starting from the cell found, my code is as
follows, it did not indicate any error, but could not run, please help me to
identify where the problems, many thanks
Sub reshnepoolmonthValues()
Worksheets(2).Activate
Dim valuedt As String
Dim sql1 As String
Dim sql2 As String
Dim sql3 As String
Dim wrk As Worksheet
Dim inRng1 As Long
Dim inrng2 As Long
D... 阅读全帖 |
|
s*f 发帖数: 20 | 9 If you are working on Windows 95/98/NT, Microsoft Access is
sufficient for your purpose. |
|
R***r 发帖数: 322 | 10
I should be able to find these in VisualStudio 6's CD_ROM, won't I?
I guess I need the standard documents themselves?
Thank you anyway. |
|
G**T 发帖数: 388 | 11 maybe u can use ODBC read it then write it to another
DB.
not sure |
|
m******t 发帖数: 2416 | 12 There is an ODBC driver coming with VB which deals with Excel files. |
|
s**a 发帖数: 2 | 13 what is ODBC? //wuwu. I do not know. Can you speak in more details/ |
|
s*****e 发帖数: 33 | 14 Just ODBC for Excel, install it, then you can manage the data in excel as any
other database table. |
|
z****a 发帖数: 1 | 15 以满足轻量级数据在win32平台上的快速访问
打算用C++编写, 同时兼容SQL89和OQL
相信这个dbms的编写成功会给很多软件带来一个有利的工具
现在暂定有以下计划:
1) 支持多进程(多线程)同时操作
2) 暂时不支持用户的概念
3) 支持"角色表"的概念,可对数据操作和查询进行权限认定
4) 强壮的文件管理系统,尽量减少crash给系统带来的副面影响 保证数据的完整
性
5) 暂时不支持锁定和事务处理
6) 对OQL的有限支持,使得开发者可以使用更加直观的OQL语言进行查询
7) 其他小型数据库的性能指标(尤其强调的是速度和稳定性)
8) 整个dbms server可执行文件小于2M,便于携带提供在低性能机器上的高性能表
现
9) 给程序员一套完整的接口,包括有C/C++/COM接口和ODBC驱动程序
10)在稳定的基础上根据实际需要在未来适当扩充,但仍然遵循一条原则:
"small is beautiful"
11)除非非常非常非常有必要,不会移植到windows以外的系统上.一方面是因为
本dbms格守其设计目标:win平台上的轻量级数据库系统,另一方面是因为其他平台
上 |
|
b***x 发帖数: 2 | 16 【 以下文字转载自 Internet 讨论区,原文如下 】
发信人: boylx (canon), 信区: Internet
标 题: How to remote access the Access Database file besides through System DSN?
发信站: The unknown SPACE (Fri Feb 18 17:40:11 2000) WWW-POST
In a Active Sever page, how to remote access a MDB file?
I've tried System DSN, but always failed:
1)NT/IIS, i added a new system DSN "test" into ODBC manager (in Control Panel)
2)in ASP
Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "test"
3) But I always get |
|
m******t 发帖数: 2416 | 17
You can generate SQL statement dynamically and execute it w/
a CRecordSet object. Read thru the document of CRecordSet bah. |
|
w******n 发帖数: 692 | 18
You can use ODBC to connect ORACLE. Be careful with the two drivers,
provided by M$ and ORACLE. I recommends M$. |
|
b*******r 发帖数: 6 | 19 土问题:
INSERT INTO MyTable (PriKey, Description) VALUES (user_input_key,
user_input_description)
被写成了:
INSERT INTO MyTable (PriKey, Description) VALUES
('user_input_key','user_input_description')
结果居然还是work,但就是如果user输入了,for example,"mark's",就会报错:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression "mark's', '".
WHY?Thanks |
|
S****n 发帖数: 46 | 20 I tried to do
"SELECT * FROM user WHERE made_time > " + login
in ASP. login is a variant, do I need single quote?
Error message:
Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
criteria expression.
What's wrong? |
|
a**m 发帖数: 17 | 21
Dose informix provide ODBC driver? If this is the case,
should be ok for you. |
|
w******n 发帖数: 692 | 22 我装了Logic works Desktop erwin 3.5.但我想
使用"server"->"target server"的时候,只有很少
几种Target SQL DBMS能让我选择,连ODBC都没有,
是我安装错了,还是要另外装软件,请指教。
能选的只有SQLBase, InterBase and SQL Anywhere. |
|
w******n 发帖数: 692 | 23 这个我刚知道,但我的问题能解决吗? 至少ODBC应该出的来
呀. |
|
l****r 发帖数: 34 | 24 请大侠们帮帮忙:
ENV:
服务器UNIX, 用PERL编程CGI, DATABASE 由MICSOFT ACCESS 创建.
服务器的PERL 运行环境不用我设置了, 但ODBC怎么用实在糊涂.
且Http://~~mywebsitename/www/cgi-bin/test.cgi无法在浏览器中
运行
(注: 在UNIX 上运行的好好的) |
|
a***e 发帖数: 188 | 25 One of my databases in SQL Server is marked as "Suspect"
state and is not accessible. I don't know what this means. I
need to access it from ODBC,and an error occured. When I
checked the database, I found it was marked as "Suspect".
Can anyone tell me how to solve this problem?
Thank you very very much. |
|
|
o******r 发帖数: 346 | 27 I tried "winodbc.h",but said no such file. :( |
|
s*****c 发帖数: 36 | 28
hope that it can work. |
|
o******r 发帖数: 346 | 29
I also tried, you recommended that webpage talking about
these,but
doesn't work, I tried "sql.h" too, but something errors
related with "sqltype.h",I didn't know why.
I searched MSDN, got no answer, does anyone have code
examples? |
|
|
f******g 发帖数: 20 | 31 How much will ACCESS cost? I am in US now. Any ideas?
If using ACCESS at last, which programming language is
easier for a
green hand? VB or VC++?
Actually, for days' inquiry, all these concepts seem a
little bit
messy in my mind right now.
My understanding is:
HTML VB/VC++
user----->server----------->DB(eg. ACCESS)
in which, DB is operated by SQL
VB/VC++ is connected with DB with ODBC interface,
is this correct?
also, I always heard you guys talk about CGI, ASP?
What are these stuff |
|
s*k 发帖数: 144 | 32
For C/S programming, VB is easier for beginner.
For Web related programming, I suggest use Visual InterDev
if you don't need complex business logic(complex processing
of your data).
user--------------------->IIS(ASP Engine)-------------->DB
HTML,ASP(by Visual InterDev) ODBC(SQL)
Using above architecture will be easier for web development
on windows platform.
Here HTML and server side script ASP are written using
InterDev,
and ASP will call functions of ASP excution engine which can |
|
a*****a 发帖数: 438 | 33 Basically sdk is right.
However, ODBC is out-of-date now. MS now recommends using
ADO/OLEDB. It's easier to use and perform better. |
|
a*****a 发帖数: 438 | 34 ADO/OLEDB is just a tech like ODBC. it's not a product.
You can download MDAC2.5 from http://www.mcirosoft.com/data
it's free. also you can learn sth about ADO/OLEDB and get some samples there. |
|
s*****c 发帖数: 36 | 35 you can use ODBC to solve this problem. |
|
m**********y 发帖数: 14 | 36 Hello:
Who got ole db driver for DB2 (not through ODBC)? Can
give me a copy??? Thanks a lot. |
|
a*****a 发帖数: 438 | 37 *pulling my hair* how should I configure this Oracle8i
client on a win2000 pro/NT4 workstation?
I installed oracle client 8.1.6 for app user and run net8
configure agent to set up a listener. Using Oracle ODBC test
works without any problem - *but*, when I switched to use
"Microsoft OLEDB Provider for Oracle" or "Oracle Provider
for OLEDB", I always get the dreaded ORA-12514 error
TNSPING to my oracle8i server is okay. using sqlplus
scott/tiger also gives me the same error:(
oracle client setup |
|
b********g 发帖数: 10 | 38 我在Win2000 Server上装了Oracle8i,包括Enterprise Edition,
client and Programming tools.
装完之后,SQL_Plus可以正常运行, 但是当我在JBuilder 3.0 中试图
去连接Oracle的数据库的时候( 在安装的时候已经建立了一个数据库
, 我的程序好象被刮起了: 不再往下执行,
但是也并不占用系统的CPU或者内存资源).
请教各位高手, 这是怎么回事呀?
而且, 我已经在系统的"Data Source(ODBC)"中配置了Oracle的Sys
DSN.
非常感谢!
|
|
xt 发帖数: 17532 | 39
Of course. There is no other version Access.
Yes, through JDBC. You should add your database file to your system
ODBC data source. Then you can access. |
|
e******e 发帖数: 44 | 40 Remote server is SQL. HOw to set up from control panel ODBC
and connect to the SQL Server.
After set up, HOw to create table and connect to it?
Thank you in advance. |
|
k****a 发帖数: 10 | 41 Does OracleDriver support setting up the
userID and password in the URL string?
so when making the connection, no userID
and password are needed to passed?
it could be done with ODBC, but I tried
with both DB2 and Oracle, won't work.
I could not find the answer in oracle specs
or the JDBC specs :(
please help... |
|
z*q 发帖数: 29 | 42 As I know, to use batch insert/update, you should use
record/collection/table_of_record type in PL/SQL, just like the following:
forall i in tbl_interval_meter.first .. tbl_interval_meter.last
INSERT INTO interval_meter_temp VALUES tbl_interval_meter (i);
Your begin end code will work in PL/SQL, but is not a batch sql, it is just a
block in PL/SQL.
Hope it is useful. |
|
w******n 发帖数: 692 | 43 用odbc连paradox后就可以用sql语句了. 我以前用delphi,操作起
来也很方便. |
|
h****r 发帖数: 2056 | 44 please point out where can find code example or guideline to
do this,
Thanks a lot. |
|
x****g 发帖数: 6597 | 45 各位大虾:
我的硬件配置
PIII-700,256MRAM,100GB HD GATEWAY原装机
WINNT平台,ORACLE数据库有250,000条记录,大小3GB
用VC+ODBC查询,SQL 语句SELECT
当用SELECT获得RECORDSET很大时如50,0000条
移动记录MOVENEX,总在C盘根目录(或TEMP)产生临时文件
msorclr.x 较小,几十M
msorclr.x+1 巨大,几百M到2G
x为一整数,如2或19等,每次运行不一样
原来我C盘空间不够,产生“General Error”,后来整理后
有10个G剩余空间,但是,当临时文件msorclr.x+1涨大到
2个GB的时候,就不再增加了,也出现“General Error”
运行完成后,临时文件自动删除。
这是啥毛病?难道我要扩内存,老板到是批准1G。
谢谢!
x********[email protected] |
|
w*r 发帖数: 2421 | 46 I doubt about whether the nt OS can handle the file
larger than 2G.
Why not tune your program to make the recordset smaller
in the practically way, handling such big recordset
consumes all your system resource and
it is not a practical way to have the program
use ODBC as client to retrive so much data
by one transaction |
|
v**m 发帖数: 242 | 47 My web page is in server1. The access database is in
server2.
How can I connect to the database on server2.
Now I am doing is:
objConn.Open "DSN=testDB;UID=;PWD="
and the error message is:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'
Operation was canceled."
Any idea, how to solve it. Thanks so..... much!!!
BTW, the DSN is system DSN. |
|
a*****a 发帖数: 438 | 48 how about use JET provider instead of "OLEDB Provider for
ODBC"?
your connection string would be
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\server2\someshare\test.mdb" |
|
h****r 发帖数: 2056 | 49 Hi everyone,
my problem is when using C++ and oracle ODBC driver to
connect to Oracle 8.1.6, if the sql string size exceeds 1k,
then my application will stop. But the same string can be
accepted by using SQLPLUS, is there a way to increase the
default buffer size for long Columns?
Thanks a lot |
|
a*****a 发帖数: 438 | 50 I don't see why you absolutely need a statement longer than
4K chars.. something must be wrong here.
And actually calling a stored procedure is almost always
faster in such case. |
|