wine users - Dec 2010 - How To Run VB6 Appliactions with SQL Server 2000 at back end

AOA

Dear friends we have a Windows 2003 network. I want to run VB6 Applications in
Ubuntu 10.10 under Wine. So far I have managed to run the Application by running
the exe of the application through Wine but the application cannot access the
database which is SQL-Server 2000 and this SQL server is running on Win2003
Operating system and the name of this machine is "webserver" and its
ip is 192.168.41.87.

Actually the developer has used either machine name or ip in the code. How can
this be configured so that Wine can see it and able to read and write data.
Please guide me I am a new bie in Linix.

On Fri, 2010-12-10 at 10:30 -0600, ssamir wrote:
> Dear friends we have a Windows 2003 network. I want to run VB6
> Applications in Ubuntu 10.10 under Wine. So far I have managed to run
> the Application by running the exe of the application through Wine but
> the application cannot access the database which is SQL-Server 2000
> and this SQL server is running on Win2003 Operating system and the
> name of this machine is "webserver" and its ip is 192.168.41.87. 
> 
Check these points and fix any which you can't answer 'yes' to.

1) Are you sure that SQL Server is running?

2) Do you know what port SQL Server is listening on?

3) Is SQL Server configured to listen for network connections, not
   just those from localhost?

4) Are you sure that there is no firewall blocking that port on
   'webserver'?

5) Can the Ubuntu host ping 'webserver'?

6) Run the command "nmap webserver". Does it show that SQL Server
   is listening on the port you expect it to listen on?

7) Is the VB6 app configured to contact SQL Server on 'webserver'
   using that port? 


Martin

Check these points and fix any which you can't answer 'yes' to.

1) Are you sure that SQL Server is running?

2) Do you know what port SQL Server is listening on?

3) Is SQL Server configured to listen for network connections, not
   just those from localhost?

4) Are you sure that there is no firewall blocking that port on
   'webserver'?

5) Can the Ubuntu host ping 'webserver'?

6) Run the command "nmap webserver". Does it show that SQL Server
   is listening on the port you expect it to listen on?

7) Is the VB6 app configured to contact SQL Server on 'webserver'
   using that port? 


Martin


Dear Martin SQL server is running fine and VB application is running properly
from Windows XP workstation in the network.

Dear Vitamin 

Actually when this VB application runs under wine it has to read and write data
on the SQL server 2000 which is on another machine in the network.

The error is that VB application is unable to find the SQL server which is
running on Windows 2003 machine and its ip is 192.168.41.82 and its name is
webserver.

So far I am able to ping this machine by ip and by name also from command
prompt.

ssamir wrote:
> The error is that VB application is unable to find the SQL server which is
running on Windows 2003 machine and its ip is 192.168.41.82 and its name is
webserver.
Post terminal output. Also, is that server configured to work via named pipes
and TCP?