Click here to Skip to main content
15,916,462 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Serialize the class Pin
Dave Kreskowiak28-Apr-07 5:21
mveDave Kreskowiak28-Apr-07 5:21 
AnswerRe: Serialize the class Pin
Eugene Ciloci28-Apr-07 12:31
Eugene Ciloci28-Apr-07 12:31 
GeneralRe: Serialize the class Pin
ParagGupta29-Apr-07 18:26
ParagGupta29-Apr-07 18:26 
QuestionMS Access and MS Outlook connection Pin
neeez28-Apr-07 0:57
neeez28-Apr-07 0:57 
AnswerRe: MS Access and MS Outlook connection Pin
Dave Kreskowiak28-Apr-07 5:12
mveDave Kreskowiak28-Apr-07 5:12 
QuestionAdob PDF Printer Pin
Ramuv28-Apr-07 0:32
Ramuv28-Apr-07 0:32 
AnswerRe: Adob PDF Printer Pin
Dave Kreskowiak28-Apr-07 5:13
mveDave Kreskowiak28-Apr-07 5:13 
QuestionRemote Sql Server Connectivity Pin
Rupesh Kumar Swami27-Apr-07 22:30
Rupesh Kumar Swami27-Apr-07 22:30 
hi all,
i use following two string to connect database located at remote sql server (mean on internet)

sql connection string
SqlConn = "Data Source=xxx.xxx.xx.xx\server;Network Library=DBMSSOCN;Initial Catalog=databaseName;User ID=Databaseuser ; Password=DatabasePassword;"

error:
“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)”

OLEDB connection string

oledbConn = "provider=SQLOLEDB; "Data Source=xxx.xxx.xx.xx\server;Network Library=DBMSSOCN;Initial Catalog=databaseName;User ID=Databaseuser; Password=DatabasePassword;"

error:
“[DBNETLIB][ConnectionOpen (Connect())]Specified SQL server not found”

I already have done the following steps:

1. Enable the TCP/IP protocol using the Surface Area Configuration Utility
2. the TCP/IP protocol is enabled in the SQL Server Configuration Utility
3. the SQL Server browser is started.
4. SQL Server and SQL Server Browser are exempted by the firewall on the server machine. This is done by putting sqlservr.exe and sqlbrowser.exe as an exception in the windows firewall.

i dont know where i m wrong. Please Help Me

any help will be appriciated. thanks

Rupesh Kumar Swami





AnswerRe: Remote Sql Server Connectivity Pin
kubben28-Apr-07 1:23
kubben28-Apr-07 1:23 
GeneralRe: Remote Sql Server Connectivity Pin
Rupesh Kumar Swami30-Apr-07 19:29
Rupesh Kumar Swami30-Apr-07 19:29 
AnswerRe: Remote Sql Server Connectivity Pin
Dave Kreskowiak28-Apr-07 4:56
mveDave Kreskowiak28-Apr-07 4:56 
Question2d array and 1d arrays Pin
mpyanap27-Apr-07 21:55
mpyanap27-Apr-07 21:55 
AnswerRe: 2d array and 1d arrays Pin
Sathesh Sakthivel27-Apr-07 22:11
Sathesh Sakthivel27-Apr-07 22:11 
QuestionwebClient On Vista Problem Pin
PCAVV27-Apr-07 20:29
PCAVV27-Apr-07 20:29 
Question[Message Deleted] Pin
navyasri27-Apr-07 18:42
navyasri27-Apr-07 18:42 
AnswerRe: very urgent Pin
Christian Graus27-Apr-07 19:54
protectorChristian Graus27-Apr-07 19:54 
AnswerRe: very urgent Pin
Dave Kreskowiak28-Apr-07 4:36
mveDave Kreskowiak28-Apr-07 4:36 
GeneralRe: very urgent Pin
Christian Graus28-Apr-07 13:07
protectorChristian Graus28-Apr-07 13:07 
GeneralRe: very urgent Pin
Dave Kreskowiak28-Apr-07 13:14
mveDave Kreskowiak28-Apr-07 13:14 
QuestionLogin Timer Pin
Polymorpher27-Apr-07 11:34
Polymorpher27-Apr-07 11:34 
AnswerRe: Login Timer Pin
kubben27-Apr-07 11:53
kubben27-Apr-07 11:53 
GeneralRe: Login Timer Pin
Polymorpher27-Apr-07 14:22
Polymorpher27-Apr-07 14:22 
GeneralRe: Login Timer Pin
Arun.Immanuel27-Apr-07 16:48
Arun.Immanuel27-Apr-07 16:48 
GeneralRe: Login Timer Pin
Polymorpher27-Apr-07 19:14
Polymorpher27-Apr-07 19:14 
GeneralRe: Login Timer Pin
kubben28-Apr-07 0:56
kubben28-Apr-07 0:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.