Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Setting up new SQL database

Quote Reply
Setting up new SQL database
Ok... here is what I want to do and I seem to be stuck on how to do it. Direction in where I should go would be appreciated but a full step-by-step procedure is not necessary.

My primary webserver is a Linux based system running the DBMan SQL software (latest version). I have a remote Microsoft SQL server where all of the tables, etc will be stored. I have TCP/IP port turned on on the SQL server. I am reading that DbMan only uses ODBC to communicate to MS SQL server. How do I get my linux machine and DBMan to see my Miscrosoft SQL server?


WebServer / DbMan ->>> TCP/IP ->>> MS SQL Server

Last edited by:

LanceWilson2: Nov 14, 2002, 9:38 PM
Quote Reply
Re: [LanceWilson2] Setting up new SQL database In reply to
Hi,

Have a look at the steps below to set it up:

1. Create the DSN:
- Goto: Setting - Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN
- Follow step by step to create a DSN

2. Install DBMan SQL
3. Set SQL server info: The SQL Database should be DSN name which is just created.

Hope that helps.

TheStone.

B.
Quote Reply
Re: [TheStone] Setting up new SQL database In reply to
OK... But that sounds like it is instructions for if DbMan was installed on a Windows box... correct? I'm running DbMan on the webserver (Linux based) and then trying to connect to the MS SQL server on a windows system (behind a firewall). How do I setup the ODBC for Linux? Was DbMan SQL never designed to run a on a Linux system? Or am I totally missing something major here? Crazy
Quote Reply
Re: [TheStone] Setting up new SQL database In reply to
Ok... I humored myself here and did as you said and setup the System DSN on the server hosting the database and this is the response I got from DbMan when I configured all of the correct values in DbMan SQL:

Error: Database driver ODBC is not installed. Available drivers: ExampleP,Proxy

What does that mean?
Quote Reply
Re: [LanceWilson2] Setting up new SQL database In reply to
That means you need to install the database driver ODBC into your system, to download it at:

http://www.microsoft.com/...D=925&Show=Alpha

TheStone.

B.
Quote Reply
Re: [LanceWilson2] Setting up new SQL database In reply to
Ok... I think I have this worked out so that it works. After MANY hours of searching and reading and yet more searching, I think I have found the best way to get DBMan SQL to work on a Linux Box while connecting to a Windows MS SQL server. It takes some money and some time so if any of you have a better approach please let me know.

First, read this article here and make sure this is what you want to do: http://www.easysoft.com/...ucts/2002/main.phtml

Basically I don't think that Gossamer-Threads did a good job (at all) in documenting how their script works in this type of configuration. In a small README file it states that you must access through ODBC and the PERL libraries but that is about it. So you will first need to install the Perl DMI Libraries (Database access core component) on your Linux Box, found at: http://www.perl.com/...uthors/id/T/TI/TIMB/

Install and Configure per instructions.

Next Install your EasySoft ODBC Bridge... (note: also install the unixODBC software that comes with the distribution) This was the easy part thanks in part to a wonderful installation program on both the Windows and UNIX side. (I would hope so... the program costs $850.00!!) Here is a walk through that someone created: http://tlowery.hypermart.net/...linux_easysoft.shtml

Configure your ODBC.ini file and now after that is thoroughly running and tested, install the DBD::ODBC Perl libraries found at: http://www.perl.com/...uthors/id/J/JU/JURL/

This is the tricky step so be sure to read the documentation very carefully. After that is done then DBMan SQL should see your database. Use localhost as the database and enter in your database source name and the username/password can stay blank (because you already placed them into the ODBC.ini file). You should be up and running. This is NOT for the faint of heart and some system level knowledge is needed. Have fun!
Quote Reply
Re: [LanceWilson2] Setting up new SQL database In reply to
As a followup to this posting (always a good thing) you need to MAKE SURE that you have the latest versions of DBI and DBI::ODBC (by Jeff Urlwin) as this is the only way to make it work. Even after you do that you will still need Gossamer to make a modification to your CGI script (something about how a UNIX box works with integers???) But I did get the system up an running, although it still has some minor bugs that Gossamer is working on.