ODBC Connection String

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

ODBC Connection String

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

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: ODBC Connection String

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, 

On Sun, May 4, 2014 at 7:36 PM, Jose Sebastian Calvo <[hidden email]> wrote:
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

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.



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

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: ODBC Connection String

Guillermo Polito
The options are the ones you find here:


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


On Wed, May 7, 2014 at 3:18 PM, Mariano Martinez Peck <[hidden email]> wrote:
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, 

On Sun, May 4, 2014 at 7:36 PM, Jose Sebastian Calvo <[hidden email]> wrote:
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

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.



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

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: ODBC Connection String

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


El jueves, 8 de mayo de 2014 13:44:30 UTC-3, Guillermo Polito escribió:
The options are the ones you find here:

<a href="http://www.linuxnetworks.de/doc/index.php/OpenDBX/Configuration#odbc_backend" target="_blank" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fwww.linuxnetworks.de%2Fdoc%2Findex.php%2FOpenDBX%2FConfiguration%23odbc_backend\46sa\75D\46sntz\0751\46usg\75AFQjCNFHN03R2sMWdHVGIRXaxo26ZTprkA';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fwww.linuxnetworks.de%2Fdoc%2Findex.php%2FOpenDBX%2FConfiguration%23odbc_backend\46sa\75D\46sntz\0751\46usg\75AFQjCNFHN03R2sMWdHVGIRXaxo26ZTprkA';return true;">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


On Wed, May 7, 2014 at 3:18 PM, Mariano Martinez Peck <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="ytPFohd4vygJ" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">maria...@...> wrote:
I don't remember. Maybe here is some help: <a href="http://forum.world.st/Coming-here-from-the-Pharo-mailing-list-td4641683.html" target="_blank" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fforum.world.st%2FComing-here-from-the-Pharo-mailing-list-td4641683.html\46sa\75D\46sntz\0751\46usg\75AFQjCNHwbjmYPgSazYyp0GWUrS0txv9Ujg';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fforum.world.st%2FComing-here-from-the-Pharo-mailing-list-td4641683.html\46sa\75D\46sntz\0751\46usg\75AFQjCNHwbjmYPgSazYyp0GWUrS0txv9Ujg';return true;">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, 

On Sun, May 4, 2014 at 7:36 PM, Jose Sebastian Calvo <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="ytPFohd4vygJ" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">fxga...@...> wrote:
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

--
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 <a href="javascript:" target="_blank" gdf-obfuscated-mailto="ytPFohd4vygJ" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">dbxtalk+u...@googlegroups.com.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/optout.



--
Mariano
<a href="http://marianopeck.wordpress.com" target="_blank" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fmarianopeck.wordpress.com\46sa\75D\46sntz\0751\46usg\75AFQjCNF1S5-imMuGTVju-KV_lXzlrdAx0Q';return true;" onclick="this.href='http://www.google.com/url?q\75http%3A%2F%2Fmarianopeck.wordpress.com\46sa\75D\46sntz\0751\46usg\75AFQjCNF1S5-imMuGTVju-KV_lXzlrdAx0Q';return true;">http://marianopeck.wordpress.com

--
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 <a href="javascript:" target="_blank" gdf-obfuscated-mailto="ytPFohd4vygJ" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">dbxtalk+u...@googlegroups.com.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/optout.

--
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 [hidden email].
For more options, visit https://groups.google.com/d/optout.