如何用asp连接Paradox数据库的

huolin 2007-01-17 02:50:35
如何用asp连接Paradox数据库的,在网上找到一个,但试了总是连接不上的,DBC已经安装过的???

http://p2p.wrox.com/topic.asp?TOPIC_ID=2510
...全文
202 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
擒兽 2007-01-20
  • 打赏
  • 举报
回复
没用过,关注

你去它官方找资料
huolin 2007-01-20
  • 打赏
  • 举报
回复
问题已经解决:连接代码如下:
strConn = "Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;" & _
"Dbq=c:\db\;DefaultDir=c:\db\;" & _
"CollatingSequence=ASCII"

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Mode = 3
objConn.Open strConn

可是新问题又出来了,下面的语句执行时,总是提示错误信息
strSQL = "SELECT * FROM Magic.DB"
var rs=objConn.Execute(strSQL)

================================

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC Paradox Driver] 外部数据库驱动程序 (11265) 中的意外错误。

/b.asp,行 14
huolin 2007-01-19
  • 打赏
  • 举报
回复
急用,有没有知道的
Parole 2007-01-17
  • 打赏
  • 举报
回复
db的没有试过-_-!
软件简介:RazorSQL 是数据库查询工具、SQL的编辑、数据库管理工具,可以通过ODBC,JDBC连接数据库,已经证实可以使用的数据库种类,达到了29种. RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 29 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases Enhanced Feature Set Standard Feature Set DB2 Ingres Pervasive Cache Mimer SQL Derby InterBase PostgreSQL Daffodil Netezza Firebird JavaDB SQLite DBASE Paradox FrontBase MS SQL Server SQL Anywhere FileMaker PointBase H2 MySQL Sybase (ASE) Mckoi Solid HSQLDB OpenBase Teradata Microsoft Access Informix Oracle Features * A Database Navigator for browsing database objects. * An SQL Editor for creating SQL queries. * Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences * Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers * A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more. * Export Tool - Export data in various formats * Import Tool - Import data from delimited files, Excel files, or fixed width files into tables * Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration * A Generate DDL Tool for generating table, view, and index DDL. * Table / SQL Query Compare tool for comparing tables or queries across multiple connections * Database Data Search tool for searching single or multiple database table and view data. * Database Object Search tool for searching for database objects. * Backup tools such as the Database Backup Tool and Table Backup Tool * Auto column and auto table lookup * SQL Formatter * SQL Query builder tool * SQL Query Scheduler tool * Command Line Interface * PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers * An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers * SQL GUI Tools for generating SQL for various operations * Edit, delete, and insert database data with the Database Editor * Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS * Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata

28,391

社区成员

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧