Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [LanceWilson2] Setting up new SQL database

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!
Subject Author Views Date
Thread Setting up new SQL database LanceWilson2 5070 Nov 14, 2002, 9:35 PM
Thread Re: [LanceWilson2] Setting up new SQL database
604 4917 Nov 15, 2002, 9:58 AM
Thread Re: [TheStone] Setting up new SQL database
LanceWilson2 4921 Nov 15, 2002, 10:04 AM
Thread Re: [LanceWilson2] Setting up new SQL database
LanceWilson2 4888 Nov 21, 2002, 11:11 PM
Post Re: [LanceWilson2] Setting up new SQL database
LanceWilson2 4773 Dec 17, 2002, 10:23 PM
Thread Re: [TheStone] Setting up new SQL database
LanceWilson2 4916 Nov 15, 2002, 10:15 AM
Post Re: [LanceWilson2] Setting up new SQL database
604 4918 Nov 15, 2002, 10:33 AM