[ic] MS SQL & Interchange

[Neil Lunn]

>-----Original Message-----
>From: Scott Fletcher [mailto:scott@abcoa.com]
>Sent: Thursday, July 19, 2001 4:53 AM
>To: 'interchange-users@developer.akopia.com'
>Subject: RE: [ic] MS SQL & Interchange
>
>
>I like ODBC because it is universal, so I do not have to change the
>programming codes and stuffs like that.  I find it useful!

Which is largely the point of DBI for perl and thus Interchange. So a round
up of the options should be FreeTDS and DBD::Sybase, a commercial driver &
Proxy combination via ODBC, or even perhaps using DBD::Proxy and proxy
server that ship with your DBI installation and either ODBC or ADO
connection with the proxy server.


I guess you could have something like this in catalog.cfg

#Variable    SOMESQL         1
#Variable    MYSQL
#Variable    PGSQL           
#Variable    ORACLE
#Variable    SQLDSN
dbi:Proxy:hostname=myhost;port=6969:dsn=dbi:ODBC:mssqldsn

Try looking at 'perldoc dbiproxy' for more information.

--Neil

>
>-----Original Message-----
>From: Andreas, Scott [mailto:Scott.Andreas@learningco.com]
>Sent: Wednesday, July 18, 2001 12:33 PM
>To: 'interchange-users@developer.akopia.com'
>Subject: RE: [ic] MS SQL & Interchange
>
>
>there are 2 different perl drivers that you can use for MSSQL 
>dbi::sybase or
>freeTDS which also connects to sybase
>
>The reason why sybase works is because microsoft uses the same CTLib as
>sybase or you can say that they leveraged the rights.
>I think that freeTDS would work much better for you and there 
>is a threaded
>discussion group if you have any problems
>
>I don't like using ODBC because of the extra overhead on the server
>
>And the drivers are free-o-charge
>
>Scott
>
>-----Original Message-----
>From: Sergey Sheykin [mailto:sheich@mosinfo.ru]
>Sent: Wednesday, July 18, 2001 12:46 AM
>To: Interchange-Users
>Subject: [ic] MS SQL & Interchange
>
>
>Hello!
>
>Can I use MSSQL as DB-server with Inhterchange?
>In catalog.cfg only for Oracle, PostgreSQL and MySQL
>exist parameters.
>How about MSSQL?
>
>Sergey.
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users
>

__________________________________________________________________________
Please Note :
Only  the intended recipient is authorised to access or use this e-mail.  If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately.   The contents
of this e-mail are the writer's 
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.

We use virus scanning software but exclude all liability for viruses or
similar in any attachment.