Re: Connecting to Database



you definitely have your work cut out as microsoft expects a local
DataSource to have all the DB connection info
which of course you do not have on a nix box

from what I gather from CPAN this is the official release
http://search.cpan.org/~evo/DBIx-SQLEngine-0.93/SQLEngine/Driver/MSSQL.pm

I also saw this workaround on google
http://freetds.org/userguide/perl.htm#DBD.SYBASE

maybe some of the perl gurus such as tim bunce will have more info...


----- Original Message -----
From: "Moon, John" <John.Moon@xxxxxxxxxxxxxxxxx>
To: <dbi-users@xxxxxxxx>
Sent: Saturday, December 08, 2007 10:49 AM
Subject: RE: Connecting to Database


Sent: Friday, December 07, 2007 8:52 AM
To: dbi-users@xxxxxxxx
Subject: Connecting to Database

Hello

At the present time I am using Perl, cgi, Apache Web Page, SQL, and
SYBASE database on a unix server(SUN Fire V 880). I have no problem
accessing the Sybase database, fetching records and display them on the
web page.

My Available Database Drivers are.
DBM
ExampleP
File
Proxy
Sponge
Sybase

Now, I would like to connect to another database on a Microsoft SQL
Server, using Perl from my unix server.

What do I need?

Where can I get information? (book or web page)

Thanks

Oscar


Here's one article...

http://www.sqlservercentral.com/articles/Miscellaneous/connectingtosqlse
rverusingperlwin32odbc/863/


.



Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Repairing / modyfing Exchange
    ... Customer Service and Support for more immediate assistance. ... This service gives you access to Microsoft technical support engineers who ... database by using the old Server's database files, ... >> up with the First Storage Group, so you would like to delete it and then ...
    (microsoft.public.windows.server.sbs)