sql server 2000 enterprise edition

[alf]

How can i connect directly from my pda to main database (not sql ce edition)
thanks

 

[William Ryan eMVP]

use the SqlClient library and set up your connection string the same way you
would on the desktop.

 

[Alberto García]

i am doing this you say but appear error i have show in previous message

 

[Alberto García]

**"I put in other forum"****


how can connect from my vb.net application to sqlserver 2000 in server.

I can connect to sql server ce but i would like connect to central ddbb.
when i try connect using propertly connection string appear this error .
Same connection string in desktop work well.

after 15 seconds execute
....
ocnn.open
...

appear

" a native exception has occurred in sde.exe ...

exceptioncode : 0x8000002
exceptionaddress 0x008c2800

 

[Paul G. Tobey [eMVP]]

You're doing something along these lines?

sqlconnect = new SqlConnection( connectionstring );

sqlconnect.Open();

with a connection string that might be something of the form:

database=Northwind;server=<servername>?



Paul T.

 

[alf]

i know what was the problemnt i will explaint for may be help other user

1 Sql server configure to use windows user (not sql user)
2 In connection string use Integrated Security =SSIP
3 Use domain\user to connect (user created in both windows and
sqlserver)

thanks