Hallo !
Gibt es eine Möglichkeit per Perl oder PHP auf eine ODBC-Quelle (zum Beispiel einen MS SQL-Server) zuzugreien ?! Habe bisher keine Dokumentation zu diesem Thema gefunden. Wäre für Hinweise/Links dankbar.
Danke ... Stephan !
ODBC-Connection
Re: ODBC-Connection
Hallo !
Also: Ich benutze als Datenbank Adabas D. Die haben sofort ein Perlmodul mitgeliefert. Klappt (eigentlich) ganz gut. Vielleicht gibt es ja bei M$ auch ein Perlmodul, welches du einbinden kannst...
Viel Glück
Der Ich
Also: Ich benutze als Datenbank Adabas D. Die haben sofort ein Perlmodul mitgeliefert. Klappt (eigentlich) ganz gut. Vielleicht gibt es ja bei M$ auch ein Perlmodul, welches du einbinden kannst...
Viel Glück
Der Ich
Re: ODBC-Connection
Bei Perl muss das Modul DBI mit dem für die Datenbank passenden DBD-Modul verwendet werden. Beides sollte sich bei CPAN finden lassen.
<a href="http://cpan.valueclick.com/modules/by-c ... nterfaces/" target="_blank"><!--auto-->http://cpan.valueclick.com/modules/by-c ... <!--auto-->
PHP kann von Haus aus mit mSQL-, MySQL-, Oracle-, oder MS-SQL-Datenbanken umgehen.
PHP-Manual
Kapitel "IV Function Reference" Abschnitt "XXX. Microsoft SQL Server functions"
<a href="http://www.php.net/manual/html/ref.mssql.html" target="_blank"><!--auto-->http://www.php.net/manual/html/ref.mssq ... <!--auto-->
XXX. Microsoft SQL Server functions
Table of Contents
mssql_close — Close MS SQL Server connection
mssql_connect — Open MS SQL server connection
mssql_data_seek — Move internal row pointer
mssql_fetch_array — Fetch row as array
mssql_fetch_field — Get field information
mssql_fetch_object — Fetch row as object
mssql_fetch_row — Get row as enumerated array
mssql_field_length — Get the length of a field
mssql_field_name — Get the name of a field
mssql_field_seek — Set field offset
mssql_field_type — Get the type of a field
mssql_free_result — Free result memory
mssql_get_last_message — Returns the last message from server (over min_message_severity?)
mssql_min_error_severity — Sets the lower error severity
mssql_min_message_severity — Sets the lower message severity
mssql_num_fields — Get number of fields in result
mssql_num_rows — Get number of rows in result
mssql_pconnect — Open persistent MS SQL connection
mssql_query — Send MS SQL query
mssql_result — Get result data
mssql_select_db — Select MS SQL database
<a href="http://cpan.valueclick.com/modules/by-c ... nterfaces/" target="_blank"><!--auto-->http://cpan.valueclick.com/modules/by-c ... <!--auto-->
PHP kann von Haus aus mit mSQL-, MySQL-, Oracle-, oder MS-SQL-Datenbanken umgehen.
PHP-Manual
Kapitel "IV Function Reference" Abschnitt "XXX. Microsoft SQL Server functions"
<a href="http://www.php.net/manual/html/ref.mssql.html" target="_blank"><!--auto-->http://www.php.net/manual/html/ref.mssq ... <!--auto-->
XXX. Microsoft SQL Server functions
Table of Contents
mssql_close — Close MS SQL Server connection
mssql_connect — Open MS SQL server connection
mssql_data_seek — Move internal row pointer
mssql_fetch_array — Fetch row as array
mssql_fetch_field — Get field information
mssql_fetch_object — Fetch row as object
mssql_fetch_row — Get row as enumerated array
mssql_field_length — Get the length of a field
mssql_field_name — Get the name of a field
mssql_field_seek — Set field offset
mssql_field_type — Get the type of a field
mssql_free_result — Free result memory
mssql_get_last_message — Returns the last message from server (over min_message_severity?)
mssql_min_error_severity — Sets the lower error severity
mssql_min_message_severity — Sets the lower message severity
mssql_num_fields — Get number of fields in result
mssql_num_rows — Get number of rows in result
mssql_pconnect — Open persistent MS SQL connection
mssql_query — Send MS SQL query
mssql_result — Get result data
mssql_select_db — Select MS SQL database
Re: ODBC-Connection
http://www.easysoft.com/products/oob/demos.phtml
Easysoft ODBC-ODBC Bridge 2000
Extending ODBC to non-Windows Platforms
Online Demonstrations
Demonstration 1
Linux Apache webserver using PHP to retrieve data from a Microsoft Windows NT Server.
Three datasources are available:
Northwind - Standard Microsoft Access sample database
Pubs - Standard Microsoft SQL Server sample database
Combined - Northwind and Pubs accessed as a virtual heterogeneous database created
via Easysoft SQL Engine
Demonstration 2
Linux Apache webserver accessing SQL Server with Perl
This demonstration uses the DB_Browser Perl scripts via CGI which in turn uses Perl DBI,
DBD::ODBC and the Easysoft ODBC-ODBC Bridge to access data on Microsoft SQL Server.
Easysoft ODBC-ODBC Bridge 2000
Extending ODBC to non-Windows Platforms
Online Demonstrations
Demonstration 1
Linux Apache webserver using PHP to retrieve data from a Microsoft Windows NT Server.
Three datasources are available:
Northwind - Standard Microsoft Access sample database
Pubs - Standard Microsoft SQL Server sample database
Combined - Northwind and Pubs accessed as a virtual heterogeneous database created
via Easysoft SQL Engine
Demonstration 2
Linux Apache webserver accessing SQL Server with Perl
This demonstration uses the DB_Browser Perl scripts via CGI which in turn uses Perl DBI,
DBD::ODBC and the Easysoft ODBC-ODBC Bridge to access data on Microsoft SQL Server.