問題描述

我正在編寫一個需要訪問 SAS 數據的程序.我已經下載了 SAS 的 ODBC 驅動程序并安裝了它們，但我需要能夠以編程方式即時創建 ODBC 連接.以下代碼(在 Python 中)似乎應該可以工作:

I'm writing a program that needs to access SAS data. I've downloaded the ODBC drivers for SAS and installed them, but I need to be able to create ODBC connections on the fly, programmatically. The following code (in Python) seems like it should work:

import ctypes

ODBC_ADD_DSN = 1        

def add_dsn(name, driver, **kw):
    nul, attrib = chr(0), []
    kw['DSN'] = name
    for attr, val in kw.iteritems():
        attrib.append('%s=%s' % (attr, val))

    return ctypes.windll.ODBCCP32.SQLConfigDataSource(0, ODBC_ADD_DSN, driver, nul.join(attrib)) == 1

print add_dsn('SAS Test', 'SAS', description = 'Testing SAS')

但它會彈出SAS ODBC配置對話框，設置數據源名稱，并等待用戶輸入信息并關閉對話框.我怎樣才能避免這種情況?

But it pops up the SAS ODBC configuration dialog, sets the datasource name, and waits for the user to enter the information and dismiss the dialog. How can I avoid that?

推薦答案

為了獲得對 SAS 數據的 ODBC 訪問，您需要連接到某種正在運行的 SAS 會話；您無法使用 SAS ODBC 驅動程序直接訪問 SAS 數據表文件.

In order to get ODBC access to SAS data, you need to connect to a running SAS session of some kind; you can't access SAS data table files directly with the SAS ODBC drivers.

請參閱 SAS ODBC 驅動程序指南，我需要什么軟件?"部分.

See the SAS ODBC drivers guide, section "What Software Do I Need?".

您的問題并未說明您正在嘗試通過正在運行的 SAS 產品訪問 SAS 數據.SAS ODBC 驅動程序指南應告訴您如何根據您將通過的 SAS 產品建立連接.

Your question doesn't state that you are trying to access SAS data through a running SAS product. The SAS ODBC drivers guide should tell you how to set up the connection based on the SAS product you will make the connection through.

這篇關于如何創建與 SAS 的 ODBC 連接?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！