Ask Question
Ask a Question
Ask Question Login
Gen AI
All Gen AIGen AIAgentic AI
AI & Machine Learning
All AI & Machine LearningAI Master TrainingData ScienceData EngineeringPython Master TrainingMachine Learning Master TrainingDeep Learning TableauData Science Certification Training using RData Visualization
Cloud Computing
All Cloud ComputingAWSAWS SysOpsAWS DeveloperMicrosoft Azure Solution ArchitectVMware
Salesforce Cloud
All Salesforce CloudSalesforceSalesforce AdminSalesforce DeveloperSalesforce App BuilderSalesforce LightningSalesforce Service Cloud
Cyber Security
All Cyber Security GRC & Risk ManagementCyber SecurityCompTIA security+CISSPCEH - Master
QA Testing
All QA TestingAI in Automation TestingQASelenium Testing Manual Testing Training & CertificationAutomation Testing TrainingPerformance TestingQTP/UFTAppium Certification Training
Business Analyst
All Business AnalystBusiness AnalystPMPSix SigmaScrum Master
Data Management
All Data ManagementSQL (Power BI)MS SQL ServerMSBISQL DBA Training TableauData AnalyticsOracle DBAHadoop
DevOps Master
All DevOps MasterDevOps
Data Science
All Data ScienceData ScienceData Science Certification Training using RDeep LearningData Visualization
Business Intelligence
All Business Intelligence TableauMSBITableau Admin
Digital Marketing
All Digital MarketingDigital MarketingSMO
Programming
All ProgrammingJava.NETPython Master TrainingiOS Android App DevelopmentRPA BlockchainFull Stack Developer
Self-learning
All Self-learning Cybersecurity Self LearningAWS Self-LearningSQL Server Self-LearningBusiness Analyst Self-LearningQA Self-LearningSalesforce Self-LearningTableau Self-LearningData Science Self-LearningiOS Self learningDevOps Self-Learning
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

Connecting to SQL Server in R with ODBC package to a non-default port

Asked by Test Ankesh Nov 15, 2019 3.7K views 7 answers
Share

Your answer

7 Answers

Nebelbach Latest answer

Answered on Mar 12, 2026

thanks!
Was this helpful?

Praveen

Answered on Nov 7, 2023

Testing
Was this helpful?

Ranjana Admin JanBask Expert

Answered on Feb 13, 2020

Thanks.
Was this helpful?

Ranjana Admin JanBask Expert

Answered on Feb 13, 2020

Thanks.
Was this helpful?

Ranjana Agrahari JanBask Expert

Answered on Nov 20, 2019

For 4 I would say build a b-tree plus index.

Was this helpful?

Amit Verma JanBask Expert

Nov 21, 2019

thanks.

Ranjana Agrahari JanBask Expert

Nov 20, 2019

True. The index has next and previous pointers for nodes within a level for efficient range scans. That’s definitely a plus.

Test Ankesh

Answered on Nov 20, 2019

Good answer is there any way to learn SQL Server R with ODBC etc by ourself.

Was this helpful?

Ranjana Agrahari JanBask Expert

Answered on Nov 20, 2019

Thanks for your help.

Was this helpful?

Ranjana Agrahari JanBask Expert

Nov 20, 2019

Excelent

More SQL Server discussions

“chrome://flags/#allow-insecure-localhost” - Is it secure? How to enable it on chrome? 6 answers · 191.5K views What Can Someone Do With My IMEI Number if he has it? 3 answers · 84.6K views First day of next month: Get the first day of the current month and add 1 month? 4 answers · 75.8K views How to import a jar file in Eclipse 3 answers · 53.6K views How do I find long running queries in SQL server with process ID, process name , login time, user , start time and duration? 2 answers · 41.6K views Python error IndentationError expected an indented block 3 answers · 36.7K views

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

SQL Server Tutorials

Step-by-step SQL Server guides from industry experts

  1. Database Files-Heart of SQL Server Database SQL 6.4K reads
  2. Data Definition Language (DDL) Commands in SQL SQL 5.8K reads
  3. Different Types of DBAs and Their Roles SQL 5.5K reads
  4. What is Schema in SQL With Example: All You Need to Know SQL 5.0K reads
  5. What does a Database Administrator do? A Detailed Study SQL 5.0K reads
  6. What is Microsoft SQL Server Native Client? SQL 4.8K reads
Browse all tutorials →

SQL Server Interview Q&A

Common SQL Server interview questions, answered

  1. Top SSRS Interview Questions And Answers SQL Server 4.6K views
  2. SQL Server MERGE Statement: Question and Answer SQL Server 4.4K views
  3. Most Frequently Asked RDBMS Interview Questions And Answers SQL Server 4.1K views
  4. Mastering Power View: Creating Interactive Visualizations: Question and Answer SQL Server 3.8K views
  5. Mastering SQL Server Security: Question and Answer SQL Server 3.8K views
  6. Top Datastage Interview Questions and Answers SQL Server 3.8K views
Browse all interview Q&A →

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.

SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions… Jul 20, 2025 · 907.3K reads Read more → SQL Server How to Become a SQL Database Administrator? How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn… Jul 18, 2025 · 7.5K reads Read more → SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system… Jun 20, 2025 · 2.3K reads Read more → SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.… May 23, 2025 · 897.8K reads Read more →
View all SQL Server blogs →