Differences string connection

fran

Hello, there are some difference in a string connection if you use '.' or
'(local)?

When I use '.' I have the error:

"SQL server does not allow remote connections"

Thanks

Sep 19 '06 #1

Subscribe Post Reply

1186

John Timney \(MVP\)

Are your using SQL Express - have you configured it for remote connections?
http://www.datamasker.com/SSE2005_NetworkCfg.htm

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com

"fran" <fr**@discussions.microsoft.comwrote in message
news:29**********************************@microsof t.com...

Hello, there are some difference in a string connection if you use '.' or
'(local)?

When I use '.' I have the error:

"SQL server does not allow remote connections"

Thanks

Sep 19 '06 #2

fran

I'm using Sql Server 2005 Enterprise
I have configured it for remote connections.

"John Timney (MVP)" wrote:

Are your using SQL Express - have you configured it for remote connections?
http://www.datamasker.com/SSE2005_NetworkCfg.htm

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com

"fran" <fr**@discussions.microsoft.comwrote in message
news:29**********************************@microsof t.com...
Hello, there are some difference in a string connection if you use '.' or
'(local)?

When I use '.' I have the error:

"SQL server does not allow remote connections"

Thanks

Sep 19 '06 #3

John Timney \(MVP\)

I've only ever seen a local connection using (local) and a remote one using
a named server or IP - never using (.). Perhaps the error is a driver error
failing to connect to a db it can't find and reporting it mistakingly as not
being allowed.

Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
"fran" <fr**@discussions.microsoft.comwrote in message
news:8D**********************************@microsof t.com...

I'm using Sql Server 2005 Enterprise
I have configured it for remote connections.

"John Timney (MVP)" wrote:

>Are your using SQL Express - have you configured it for remote
connections?
http://www.datamasker.com/SSE2005_NetworkCfg.htm

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com

"fran" <fr**@discussions.microsoft.comwrote in message
news:29**********************************@microso ft.com...
Hello, there are some difference in a string connection if you use '.'
or
'(local)?

When I use '.' I have the error:

"SQL server does not allow remote connections"

Thanks

Sep 19 '06 #4

Kevin Spencer

I find it better not to use [local} or any reference to the local machine.
It is too easy to deploy an app to a different machine, and now the
reference points to a different machine than it did before. I believe it is
best to use the IP address of the SQL Server, or at least the machine name
(in a LAN).

--
HTH,

Kevin Spencer
Microsoft MVP
Digital Carpenter

A man, a plan, a canal,
a palindrome that has gone to s**t.

"John Timney (MVP)" <x_****@timney.eclipse.co.ukwrote in message
news:us********************@eclipse.net.uk...

I've only ever seen a local connection using (local) and a remote one
using a named server or IP - never using (.). Perhaps the error is a
driver error failing to connect to a db it can't find and reporting it
mistakingly as not being allowed.

Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
"fran" <fr**@discussions.microsoft.comwrote in message
news:8D**********************************@microsof t.com...
>I'm using Sql Server 2005 Enterprise
I have configured it for remote connections.

"John Timney (MVP)" wrote:

>>Are your using SQL Express - have you configured it for remote
connections?
http://www.datamasker.com/SSE2005_NetworkCfg.htm

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com

"fran" <fr**@discussions.microsoft.comwrote in message
news:29**********************************@micros oft.com...
Hello, there are some difference in a string connection if you use '.'
or
'(local)?

When I use '.' I have the error:

"SQL server does not allow remote connections"

Thanks

Sep 19 '06 #5

Similar topics

empty connection string

by: AMC | last post by:

Hi, I'm using an include file to store the connection string to a database. Whenever I try to reference that string to open a connection in the page that includes the file I get the error 'empy...

ASP / Active Server Pages

Differences - Syntax & Form operations

by: MS | last post by:

Just a general question here re VBA. Can anyone explain the differences between "!" and "." when refering to a control? eg Me!TxtBox and Me.TxtBox. What is difference between "+" and "&"...

Microsoft Access / VBA

change connection string dynamically

by: sam44 | last post by:

Hi, At startup the user log on and chooses the name of a client from a dropdownlist, which then changes dynamically the connection string (the name of the client indicates which database to use)....

ASP.NET

php find differences in multi dimensional arrays

by: trpost | last post by:

I am looking for a way to find the differences between 2 multidimensional arrays. I have found ways to do this based on 1 key, but I want to be able to look at differences based on all keys: For...

PHP

server.createobject differences between c# and vb.net

by: quintesv | last post by:

hi all, Running VS.2003 , framework 1.1. I have a COM object written in Delphi which im trying to call through ASP.NET. The COM object connects to a folder on another machine and opens a...

ASP.NET

string differences libraries

by: Jeroen | last post by:

We have update operations on strings, where we know the "New" and "Old" version of the string. A html report will be generated about many of these changes. I would like to mark these changes with...

C# / C Sharp

Change Connection String during runtime

by: Sankalp | last post by:

Hi, I am using VB 2005. My application has many data bound controls. The connection is stored in the app.config file. I want the application to start with a default connection string and while...

Visual Basic .NET

List of differences in headers between C90 and C99?

by: Spiro Trikaliotis | last post by:

Hello, does anyone know of any list which presents the headers that differ between C90 and c99, and where they differ? Searching on the web, I found many web sites about the differences between...

C / C++

Differences between perhaps-similar constructs?

by: gentsquash | last post by:

Inside of <script></script>, inside of <body></body>, what are the differences between document.body.className="mystyle"; and document.body.setAttribute("class", "mystyle"); ? (...assuming...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server