[erlang-questions] ODBC driver

[Jan Jacobs]

Hi Jose,

Windows XP Pro has by default the "SQL Server" driver installed.

To locate and test:
-  Goto "Start->Settings->Control Panel->Administrative Tools->Data 
Sources (ODBC)".
-  Select "System DSN"
- Click "Add"
- Look for "SQL Server"

You need to construct a connection string inorder to instruct the 
odbcserver to connect to the necessary database, see exaples below.
Example MS SQL Server 2000: 
"Driver={SQL 
Server};Server=JAN03;Database=MaxMan;Uid=maxman;Pwd=maxmanpassword;"

Example MS SQL Express 2005:
"Driver={SQL Native Client};Server=JAN03\\SQLEXPRESS, 
1450;Database=MaxMan;Uid=maxman;Pwd=maxmanpassword;"

Example MySQL:
"Driver={MySQL ODBC 3.51 
Driver};Server=127.0.0.1;Database=maxman;User=maxman;Password=maxmanpassword;Option=;"

Example Firebird:
"Driver=Firebird/InterBase(r) 
driver;Uid=SYSDBA;Pwd=masterkey;DbName=127.0.0.1:c:/projects/DeepBlue/app/MaxMan/temp/MAXMAN.FDB;"

For more info on connection strings and connection strings for other 
DB's see: http://www.connectionstrings.com/

Cheers
Jan

Jose Enrique Benitez Jimenez wrote:
> Hi,
>  
> I want to connect to an SQL database, I receive the follow error
>  
> 7> odbc:start().                    
> ok
> 8> odbc:connect("DNS:localhost",[]).
> {error,"No SQL-driver information available. Connection to database failed."}
>
>  
> SQL server 2000 is already intalled, Do I need the ODBC driver or SQL server 2000 have it ?, in the first case, how can i get it??
> (I'm using Windows XP)
>  
> Thanks.
> _______________________________________________
> erlang-questions mailing list
> erlang-questions@REDACTED
> http://www.erlang.org/mailman/listinfo/erlang-questions
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.176 / Virus Database: 270.10.8/1898 - Release Date: 2009/01/16 03:09 PM
>
>