SQL OLE DB And IPv6
Sep 10, 2007
We have encountered a problem connecting from our client code to SQL Server 2005 using raw Ipv6 addresses.
A small client application on Windows Server 2008 using SQL OLE DB interfaces WILL connect successfully to the raw Ipv6 address of the SQL 2005 Server (also on Windows Server 2008) but the same client will fail to connect if run from a Windows XP or Windows 2003 Server box.
I have seen another post to this forum entitled "IPv6 support for SQL Server ODBC Driver" which would seem to indicate that SQL Native Driver (SQLNCLI) should support IPv6 on 2k3 and XP but that was in the context of a ODBC driver and Vista.
Can we have confirmation from Microsoft that:
SQL OLE DB does NOT support IPv6 on 2k3 and XP?
SQL OLE DB DOES support IPv6 on Vista and Longhorn?
SQL Native Client DOES support IPv6 on 2k3 and XP and Vista and Longhorn?
View 4 Replies
Oct 3, 2006
Does SQL Server 2000 sp4 work with IPv6?
View 1 Replies
View Related
Sep 4, 2007
Hi,
I am unable to create the DSN using SQL Server ODBC driver(2000.86.1830.00)by specifying the server name as IPV6 Address.
Here are the steps that I have used to create the DSN.
1. Opened the ODBC Data Source Administrator(Start->Control Panel->Administrative tools->Data Sources(ODBC)).
2. GoTo System DSN tab and clicked on ADD buton, selected the SQL Server driver from the list of ODBC Drivers.
3. Entered the Name and Description.
4. Provided the IPv6 Address of machine in the Server Field. click Next.
5. Entered the SQL Server authentication details. Clicked Next.
6. The wizard poped up following error:
" Connection Failed:
SQLstate:'01000'
SQL Server Error:14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection open(parseconnectionParams())
Connection Failed:
SQLstate:'08001'
SQL Server Error:14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection."
By specifying the IPv6 address as server name I was able to create the DSN in Windows Vista but failed in other operating systems like 2k3 and XP. Could anyone of you please let me know the reason behind the failure of DSN creation? Does the SQL Server ODBC Driver supports IPv6?
View 6 Replies
View Related
Aug 24, 2006
Hello,
executing the first script listed below resulted in the error message (translation):
Message 7890, Level 16, Status 1, Line 1
Error when registrating Endpoint. Potential port conflict ...
use AdventureWorks;
go
CREATE ENDPOINT SQLEP_AWPersons
STATE = STARTED
AS HTTP
(
PATH = '/AWpersons',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'PersonInfo'
(NAME='AdventureWorks.dbo.uspGetPersonInfo'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'AdventureWorks',
NAMESPACE = 'http://Adventure-Works/Persons'
)
I changed the port in the script to 8084:
PORTS = (8084),
Error Message 102: Wrong Syntac near ')'.
I changed the port in the script to '8084':
Error Message 7888: The stated IPv6-Address is not supported. The server is potentially not configured for the IPv6 Connectivity or the address is not formated in an known IPv6-Format.
Could you help?
Best regards,
Wolfgang
View 3 Replies
View Related
