As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.
Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.
Course Of The Month
8 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Connect vb6 app to remote db
Posted on 2013-01-05
I am trying to connect my vb6 app to either a local or a remote database, depending on which is selected. Here is my connection string:
I get a "server not found" error when I try to connect. Is there an error in my string or my process?
If sWhichSrvr = "Remote" Then
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CCMeet;User ID=id;Password=pwd;Data Source=209.185.199.1,1433\SQLEXPRESS"
Else
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CCMeet;UID=id;Pwd=pwd;Data Source=VIRA-5\SQLEXPRESS"
End If
I get a "server not found" error when I try to connect. Is there an error in my string or my process?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
Active today
SQLOLEDB is an old driver. The preferred and current driver for SQL Server 2008 is the SQL Server Native Client 10.0 which can be downloaded here: http://www.microsoft.com/en-us/download/details.aspx?id=16978 Look for Microsoft® SQL Server® 2008 R2 Native Client in the middle of the page and pick the version for your computer.
On this page are connection strings for using SQLNCLI10: http://www.connectionstrings.com/sql-server-2008
SQL Server must also be setup for TCP/IP remote access using SQL authentication. If you are trying to access it using 'named instance' like 209.185.199.1,1433\SQLEXPR
On this page are connection strings for using SQLNCLI10: http://www.connectionstrings.com/sql-server-2008
SQL Server must also be setup for TCP/IP remote access using SQL authentication. If you are trying to access it using 'named instance' like 209.185.199.1,1433\SQLEXPR
Good information. Sqlbrowser.exe (I assume that is SQL Server browser in the "Services" area?) is running but I can't see how to check the port it is running on? TCP/IP is enabled but how do I check if it is using SQL authentication?
Active today
Sqlbrowser.exe always runs on port 1434 as far as I know. Allowing Remote connections is a checkbox on the Properties for the server instance (top of the list). SQL authentication is set up for a user in the Properties for their Login when it is created. And under the Properties for the database you're using, you may have to setup permissions for that login.
Featured Post
![[Live Webinar] The Cloud Skills Gap](https://filedb.experts-exchange.com/files/public/2017/5/29/3249c5dc-214e-4f8f-afab-ef354630e19f.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 9 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.