MS-SQL Server 2005 Connection String to Connect via IP

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

MS-SQL Server 2005 Connection String to Connect via IP
Posted: Thu Dec 17, 2009 06:43 AM

Hi,

I am using ADO
Can any one provide the ADO connection string to connect to a MS-SQL Server 2005 via Internet (Via IP On a Remote Server)

I tried the following but was unsuccessful

Code (fw): Select all Collapse

cConnectSring:="Data Source=xxx.xxx.xxx.xxx,1433;Network Library=DBMSSOCN;Initial Catalog=DataBaseName;User ID=username;Password=password;"

Dear Mr.Antonio

This is for your information While compiling I am getting warning message which says duplicate declaration
In ADO.CH, I checked ADO.CH and found that the duplicate declaration exist in the file

I am not sure anybody else is having the same problem.

Code (fw): Select all Collapse

D:\FWH\include\ADO.Ch(196) Warning W0001  Redefinition or duplicate definition of #define adSearchForward
D:\FWH\include\ADO.Ch(197) Warning W0001  Redefinition or duplicate definition of #define adSearchBackward

ADO.CH

Code (fw): Select all Collapse

*** Line 191 Constant Group: SearchDirectionEnum
#define adSearchForward 1
#define adSearchBackward -1

*** Line 195 Constant Group: SearchDirection
#define adSearchForward 1
#define adSearchBackward -1

Regards
Anser

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: MS-SQL Server 2005 Conn String to Connect via IP (Solved)
Posted: Thu Dec 17, 2009 07:20 AM

Problem solved,

Code (fw): Select all Collapse

"Provider=SQLOLEDB;server=xxx.xxx.xxx.xxx;database=DbName;uid=UserName;pwd=password"

Regards
Anser

FiveTech Support Forums

Continue the discussion