Connecting to sql server 2000 through database

[mic_louis]

please
i make a database on network and i tried a lot of connection string to connect to the server through TCP/IP , and i cannot login here is what i made
Data Source=" & ServerIP & ",1433;Network Library=DBMSSOCN;Persist Security Info=False;Initial Catalog=" & DataBaseName & ";User ID=" & UserDb & ";Password=" & PassDb & ";"
and it did not work
please send me something
thanks

 

[Soofi]

try using the simple string:

server=localhost;user id=<username>;password=<password>;database=<database>;pooling=false

for server, use computer name on which sql server is reside,
can u tell, what is the error meesage, many times the username and password conflicts, try to catch the error message too.

 

[TechGnome]

What's the ",1433" after the Server IP for? Is it supposed to be the port #? If so then it needs to be ":1433".... not a comma....

-tg

 

[mic_louis]

i still face the same problem

i change the mistake port number and here is the last connection string that didnot work also , please help me

Data Source=192.168.39.100:1433;Initial Catalog=DatabaseName;Persist Security Info=True;User ID=USERNAME;Network Library=dbmssocn;Password=ps;


thank you for your time

 

[mic_louis]

Thanks message

Thank you guys for helping me , the problem was in the integerated secutity it should be turned to true , to be able to connect via ip addresss,

Michael Louis Gabriel
Senior Developer
Gaeasoft Textile Management system Provider
http://www.gaeasoft.net
mgabriel@gaeasoft.net