VB6 ADO 2.7 connection to a SQL Server 2000 database over Internet

[acad]

I have a VB6 client app which need to access a SQL Server database located on my Server...

My vbClientApp must pass through the web to access my server...

Is there a way my vbApp can connect to my database using ADO control ??

Thanks!

[MAK]

Use ip address to access your sql server via web.

[acad]

well,

should I create user DSN on my client pc to my SQL Server using IP as server name ??

if so, I've tried, and it always says me an error with trusted something...

[acad]

state 01000
error 1326

state 08001
error 17

what do I have to do to make my SQL Server available to accept ip connection like this...

Thanks

[skhanal]

May be you are trying to connect using trusted connection. This will not be available to you when coming through internet. Use SQL Server authentication and specify SQL user name/password.

[acad]

even if i select SQL Server authentication in my dialog creating the DSN, it still says :

Not associated to a trusted connection...etc

Is there something to change in my SQL Server to change this situation...

Thanks

[acad]

state 28000
error 18452

...what can I change in my SQL Server to accept any type of connection with user id located in my Logins directory...


thanks

[skhanal]

What is your SQL Server security setting? Make sure it is SQL Server and Windows.

[acad]

it is SQL and Windows

[MAK]

make sure your ip address is right. do not think 192.168.1.something is your ip address, it is your routers ip address.

See whats your real ip addres by going to network neighbourhood and also by pinging the server.