?
Solved

Specify ip address in my connection string for sas

Posted on 2016-09-08
2
Medium Priority
?
87 Views
Last Modified: 2016-09-09
I have the below connection string, but it is failing to see the ip address.

Help

 sasb = New OleDbConnection("Provider=sas.LocalProvider; Data Source=\\10.156.62.49\aa_old\Uganda_old\data") : sasb.Open()
0
Comment
Question by:Anthony Matovu
  • 2
2 Comments
 
LVL 1

Accepted Solution

by:
Anthony Matovu earned 0 total points
ID: 41789322
I  changed \\10.156.62.49\aa_old\Uganda_old\data

to

'\\10.156.62.49\aa_old\Uganda_old\data'

and it worked

 sasb = New OleDbConnection("Provider=sas.LocalProvider; Data ource='\\10.156.62.49\aa_old\Uganda_old\data'") : sasb.Open()
0
 
LVL 1

Author Closing Comment

by:Anthony Matovu
ID: 41791282
I resolved this
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month6 days, 14 hours left to enroll

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question