clisp、plain-odbc 以及连接到 sql server 数据库

发布于 2024-12-17 08:17:37 字数 1028 浏览 4 评论 0原文

我在使用 unixODBC 从 openbsd 盒子连接到 sql server 数据库时遇到问题。当我使用 isql 时，我的表现很好：

$ isql localProdSqlServer jegdemir GBE#oct 
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

所以我知道 DSN 已设置并且 unixODBC 工作正常。然而，当我打开 clisp 并尝试使用 plain-odbc 连接时，我无法到达那里：

$ clisp

<..snip..>>

[1]> (asdf:oos 'asdf:load-op :plain-odbc)

<..snip..>

[2]> (setf *con* (plain-odbc:connect "localProdSqlServer" "jegdemir" "GBE#oct")) 
*** - [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, error
      code 0, State: S1000.
The following restarts are available:
ABORT          :R1      Abort main loop
Break 1 [3]>

我对 lisp 相当陌生，所以我在诊断问题时遇到了一些麻烦。任何帮助将不胜感激。

原文

I'm having issues connecting to a sql server database from an openbsd box using unixODBC. When I use isql I get through just fine:

$ isql localProdSqlServer jegdemir GBE#oct 
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

so I know the DSN is setup and unixODBC is working properly. However when I crack open clisp and try to connect using plain-odbc I can't get there:

$ clisp

<..snip..>>

[1]> (asdf:oos 'asdf:load-op :plain-odbc)

<..snip..>

[2]> (setf *con* (plain-odbc:connect "localProdSqlServer" "jegdemir" "GBE#oct")) 
*** - [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, error
      code 0, State: S1000.
The following restarts are available:
ABORT          :R1      Abort main loop
Break 1 [3]>

I'm fairly new to lisp so I'm having a bit of trouble diagnosing the issue. Any help would be most appreciated.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟凡古楼 2024-12-24 08:17:37

根据 plain-odbc 的工作方式，您可能需要在 /etc/odbc.ini 中指定 DSN，例如：

[localProdSqlServer]
Driver          = FreeTDS
Description     = localProdSqlServer TDS driver (Sybase/MS SQL)
Trace           = No
Servername      = localProdSqlServer
Database        = DATABASE_NAME

作为替代方案，CLSQL 库有一个支持连接字符串的 ODBC 后端

(clsql:connect '("friendly-server-name" "friendly-username" "" 
     :connection-string "DRIVER={FreeTDS};SERVER=localProdSqlServer;DATABASE=DATABASE_NAME;UID=jegdemir;PWD=GBE#oct;PORT=1433;TDS_Version=8.0;APP=clsql") 
           :database-type :odbc)

：工作我使用 CLSQL 连接到 SQL一直都是服务器。

Depending on how plain-odbc works, you may need to specify a DSN in /etc/odbc.ini, something like:

[localProdSqlServer]
Driver          = FreeTDS
Description     = localProdSqlServer TDS driver (Sybase/MS SQL)
Trace           = No
Servername      = localProdSqlServer
Database        = DATABASE_NAME

As an alternative, the CLSQL library has an ODBC backend that supports connection strings:

(clsql:connect '("friendly-server-name" "friendly-username" "" 
     :connection-string "DRIVER={FreeTDS};SERVER=localProdSqlServer;DATABASE=DATABASE_NAME;UID=jegdemir;PWD=GBE#oct;PORT=1433;TDS_Version=8.0;APP=clsql") 
           :database-type :odbc)

At work I use CLSQL to connect to SQL Server all the time.

回复收藏 0 原文

~没有更多了~