LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 10-28-2007, 03:03 AM   #1
topcat
Member
 
Registered: Feb 2003
Distribution: ubuntu 6.06, ubuntu 7.04 AMD 64bit, 7.10 AMD 64bit
Posts: 62

Rep: Reputation: 15
accessing SQL server via wine on a network


here is my situation.
Running a multiuser networked accounting application written in VB on a windows XP Pro machine with sql server backend. It will be a long time before that system ported to a non windows platform.

During setup we are asked to provide the Drive where the server side of the application is located.
With other windows machines, we just mount the remote shared drive containing the server side files as T or S or whatever and at the time of client installation, provide this address and it works fine.

Under wine, i tried mounting the remote drive as a samba drive symlinked under the user's wine directory.

And during the installing of the accounting client i provided this drive as the location of the server, but it refuses to connect to the sql server DB running under windows XP pro. The client installs fine otherwise.. just cannot find the sql server.

The alternative (which i think is an overkill) is to install VM player or QEMU or virtualbox and install the entire windows OS as a guest OS.

I was wondering if anyone was able to connect to a sql server over a network using wine?
 
Old 10-28-2007, 05:30 AM   #2
keratos
Member
 
Registered: May 2007
Location: London, UK.
Distribution: Major:FC8. Others:Debian;Zenwalk; Arch; Slack; RHEL.
Posts: 544

Rep: Reputation: 30
No sure how your client access the SQL server but from the thin information you provide:

Is it linux or wine that cannot see the Windows drive?

Things to check:

1. Make sure the Windows XP drive with the server backend on is a share, e.g. SQLSHARE$
2. Install the smb package on the linux box to gain access to the window share. smb is a samba like service.
3. Check to see if the Windows share (i.e. SQLSHARE$) is available using the smbtree command.
4. If you can see it it should be connectable via wine by mapping the share to a drive letter.
 
Old 10-28-2007, 07:29 AM   #3
topcat
Member
 
Registered: Feb 2003
Distribution: ubuntu 6.06, ubuntu 7.04 AMD 64bit, 7.10 AMD 64bit
Posts: 62

Original Poster
Rep: Reputation: 15
linux can see the drive, it is wine which though can see the drive, fails to allow my accounting client to detect that server.

the windows XP drive is shared. yes.
the linux box has smb as it can access other samba drives.

essentially this was what i was trying, but it did not work. i was thinking on the lines that maybe some additional drivers ODBC? need to be hacked in?
 
Old 10-28-2007, 04:11 PM   #4
keratos
Member
 
Registered: May 2007
Location: London, UK.
Distribution: Major:FC8. Others:Debian;Zenwalk; Arch; Slack; RHEL.
Posts: 544

Rep: Reputation: 30
Quote:
Originally Posted by topcat View Post
linux can see the drive, it is wine which though can see the drive, fails to allow my accounting client to detect that server.

the windows XP drive is shared. yes.
the linux box has smb as it can access other samba drives.

essentially this was what i was trying, but it did not work. i was thinking on the lines that maybe some additional drivers ODBC? need to be hacked in?
Ok, but as I said you have not provided any information on the client and how the client accesses the SQL server.

With this limited knowledge all I can suggest is you install an ODBC layer either on linx native or ODBC in wine (I think MSoffice has these drivers so you could use this inside wine).

This is a good start for linux native ODBC: http://www.freetds.org/

Some linux distros have freetds in their repositories (synaptic/apt-get). Yours may have?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing mail server from internal network yantor Linux - Networking 2 09-22-2006 06:17 AM
Problem with accessing other network server when connected from a dial-in server radatan71 Linux - Networking 0 11-22-2005 03:20 AM
Installing MS SQL Server 2K on RHEL3 using wine? krishvij Linux - Newbie 1 03-16-2005 10:27 AM
Accessing server behind router :: setting up network slackwarefan Linux - Networking 7 06-03-2004 05:14 PM
Accessing An External VPN Server from NAT'd Network dmarien Linux - Networking 1 06-04-2003 02:05 AM


All times are GMT -5. The time now is 10:50 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration