ODBC Connection String

[Jose Sebastian Calvo]

Hi,

I've read that the preferred method in windows to use MSSQLServer is trough odbc.

In Dolphin Smalltalk I can use a connection string to do a "dns less" connection so there is no need to define an specific DNS in the windows dns manager.

e.g. 'UID=my_uid;PWD=my_pwd;DATADABE=my_database'

Is there a way to do the same with DBXTalk?

Regards

  Sebastian Calvo

[Mariano Martinez Peck]

I don't remember. Maybe here is some help: http://forum.world.st/Coming-here-from-the-Pharo-mailing-list-td4641683.html  ?

Maybe Norbert (OpenDBX author) knows. Did you try specifying all the DBXConnectionSettings with the database, username and password? 

Best, 

--
You received this message because you are subscribed to the Google Groups "DBXTalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbxtalk+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mariano
http://marianopeck.wordpress.com

[Guillermo Polito]

The options are the ones you find here:

http://www.linuxnetworks.de/doc/index.php/OpenDBX/Configuration#odbc_backend

But... "dns less"? host less you mean? I don't know much about odbc, just know the minimum to configure and make the tests run :).

Guille

[Jose Sebastian Calvo]

Thank Guillermo, Mariano,

in the odbc_backend documentation there is a reference to a file called "odbc.ini". Do you know about that file? Maybe it's possible to use that file to specify a "dsn less" connection. Sorry I mistake dsn with dns, is DSN for "data source name" and less because you don't need to configure the connection using the odbc manager in windows. See http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer for an example.

Regards

  Sebastian Calvo