spssstatistics19.0配置odbc连接远程oracle数据库
本文档讲的是spss statistics 19.0如何配置odbc连接本地oracle数据库，步骤如下： 1、开启远程oracle数据库服务，开启以下两个即可 2、在本地客户端中，安装好oracle数据库（版本为win32_11gr2_client，主要是为了安装oracle的odbc驱动），通过PL/SQL客户端
本文档讲的是spss statistics 19.0如何配置odbc连接本地oracle数据库，步骤如下：
1、开启远程oracle数据库服务，开启以下两个即可
2、在本地客户端中，安装好oracle数据库（版本为win32_11gr2_client，主要是为了安装oracle的odbc驱动），通过PL/SQL客户端远程连接数据库，测试是否正常。喎?http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+1NpEOlxhcHBcQWRtaW5pc3RyYXRvclxwcm9kdWN0XDExLjEuMFxjbGllbnRfMVxuZXR3b3JrXGFkbWluxL/CvNbQo6zQwr2odG5zbmFtZXMub3JhzsS8/qOsxNrI3cjnz8KjujwvcD4KPHA+PC9wPgo8cHJlIGNsYXNzPQ=="brush:sql;"># tnsnames.ora Network Configuration File: D:\app\1\product\11.1.0\client_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. MYORAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.194.13)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = MYORAL) ) ) 如果正常的话，即可：
3、在spss statistics打开后选择：文件—打开数据库—新建查询
选择“添加odbc数据源”：
点击“添加”，弹出下图，并选择你所用的数据库，这里选择”oracle in oradb...”,（因为我装的是oracle11G的数据库，这里有对应的驱动）：
1.数据源的名称（后面会用到） 2.描述可以随意填写 3.选择数据库的服务名（在tnsnames.ora文件配置正确的话，会自动匹配现的） 4.随便填写一个存在的数据库用户。剩下的默认，填写完成后点击test connection 会让你输入数据库用户的用户名和密码。点击确定，如果提示成功就说明你配置成功了，剩下的一路确定就行了。
然后odbc配置窗口多了一个源如下图：
最后，就可以添加数据库的数据了：
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1377
52
How to connect keep body fat scale
Mar 07, 2024 pm 04:50 PM
How to connect the keep body fat scale? Keep has a specially designed body fat scale, but most users do not know how to connect the keep body fat scale. Next is the graphic tutorial on the connection method of the keep body fat scale that the editor brings to users. , interested users come and take a look! How to connect the keep body fat scale 1. First open the keep software, go to the main page, click [My] in the lower right corner, and select [Smart Hardware]; 2. Then on the My Smart Devices page, click the [Add Device] button in the middle; 3 , then select the device you want to add interface, select [Smart Body Fat/Weight Scale]; 4. Then on the device model selection page, click the [keep body fat scale] option; 5. Finally, in the interface shown below, finally [Add Now] at the bottom
The working principle and configuration method of GDM in Linux system
Mar 01, 2024 pm 06:36 PM
Title: The working principle and configuration method of GDM in Linux systems In Linux operating systems, GDM (GNOMEDisplayManager) is a common display manager used to control graphical user interface (GUI) login and user session management. This article will introduce the working principle and configuration method of GDM, as well as provide specific code examples. 1. Working principle of GDM GDM is the display manager in the GNOME desktop environment. It is responsible for starting the X server and providing the login interface. The user enters
Understand Linux Bashrc: functions, configuration and usage
Mar 20, 2024 pm 03:30 PM
Understanding Linux Bashrc: Function, Configuration and Usage In Linux systems, Bashrc (BourneAgainShellruncommands) is a very important configuration file, which contains various commands and settings that are automatically run when the system starts. The Bashrc file is usually located in the user's home directory and is a hidden file. Its function is to customize the Bashshell environment for the user. 1. Bashrc function setting environment
How to connect OnePlus watch to Bluetooth headset_How to connect OnePlus watch to Bluetooth headset
Mar 23, 2024 pm 01:16 PM
1. Place the earphones in the earphone box and keep the lid open. Press and hold the button on the box to enter the pairing state of the earphones. 2. Turn on the watch music function and select Bluetooth headphones, or select Bluetooth headphones in the watch settings function. 3. Select the headset on the watch to pair successfully.
Shared printer cannot connect to printer
Feb 22, 2024 pm 01:09 PM
With the development of the digital era, shared printers have become an indispensable part of the modern office environment. However, sometimes we may encounter the problem that the shared printer cannot be connected to the printer, which will not only affect work efficiency, but also cause a series of troubles. This article aims to explore the reasons and solutions for why a shared printer cannot connect to the printer. There are many reasons why a shared printer cannot connect to the printer, the most common of which is network issues. If the network connection between the shared printer and the printer is unstable or interrupted, normal operation will not be possible.
Three Ways to Fix Edge Your Connection Isn't Private
Mar 13, 2024 pm 01:30 PM
When you use the Edge browser to access web pages, have you ever encountered a prompt that your connection is not a dedicated connection, causing web browsing to fail? How is this going? Many friends don’t know how to deal with this problem. You can take a look at the following three solutions. Method 1 (simple and crude): In the edge browser, you can try to solve the problem of the website being inaccessible by entering the settings and turning off the security function, and then blocking location permissions in the website permissions. It is important to note that the effectiveness and duration of this approach may vary, and specific effects cannot be determined. After restarting your browser, you can try visiting the website to see if the issue is resolved. Method 2: Adjust the keyboard to English input
How to configure workgroup in win11 system
Feb 22, 2024 pm 09:50 PM
How to configure a workgroup in Win11 A workgroup is a way to connect multiple computers in a local area network, which allows files, printers, and other resources to be shared between computers. In Win11 system, configuring a workgroup is very simple, just follow the steps below. Step 1: Open the "Settings" application. First, click the "Start" button of the Win11 system, and then select the "Settings" application in the pop-up menu. You can also use the shortcut "Win+I" to open "Settings". Step 2: Select "System" In the Settings app, you will see multiple options. Please click the "System" option to enter the system settings page. Step 3: Select "About" In the "System" settings page, you will see multiple sub-options. Please click
Steps to connect game controller to Gohan Arcade
Mar 19, 2024 pm 03:55 PM
How to connect Bluetooth controller to Gohan Arcade? Gohan Game Center is a game box used by many mobile game players. It contains a large number of popular game resources and rich game-related functions. Below, the editor will introduce the game controller connection method. Players, please take a look. 1. First go to the homepage of Gohan Game Center APP, and then click the "My" option in the lower right corner of the homepage; 2. Find the [Controller] function in the My page, the location is shown in the picture below, and click to go to settings; 3. Select to turn it on For the Bluetooth function of the mobile phone, confirm that the power of the controller is on; 4. Finally, follow the instructions of the controller to make a matching connection. If the connection is successful, you can use the mobile game to experience various games.
