On Wednesday, December 28, 2011 03:14:30 Sergey Stepanov wrote:
> Hi,
>
> Check parameters that you passing to tests, there is the mess with them.
What is wrong with the parameters? What shall I pass? From looking at the
code, it looks like I should pass a DSN file. Here are the contents of the
file (test-mssql.dsn):
[ODBC]
Description=Test Connection
Driver=TDS
Trace=No
Database=Test
Server=192.168.1.34
Port=1433
..
OK, I've figured out that I can pass a DSN connection string. So passing this
worked:
'DSN=ODBC;UID=username;PWD=password'
Thanks,
Simon
>
> * Simon Walter <[email protected]> [Tue, 27 Dec 2011 19:35:34 -0900]:
> > On Tuesday, December 27, 2011 16:52:04 Simon Walter wrote:
> > > Hi everyone,
> > >
> > > I've got odbc working with unixODBC 2.2.14. I’ve tested it with isql
> >
> > and can
> >
> > > connect to a MS SQL Server running on Windows Server 2003.
> > >
> > > However, I can't get the test soci_odbc_test_mssql
> >
> > (test-odbc-mssql.cpp) to
> >
> > > connect. It seems to accept an argument or use 'test-mssql.dsn' to
> >
> > create
> >
> > > the connection. I've made a dsn as follows - tested and working with
> >
> > isql:
> > > [ODBC]
> > > Description=Test Connection
> > > Driver=TDS
> > > Trace=No
> > > Database=Test
> > > Server=192.168.1.34
> > > Port=1433
> > >
> > > Has anyone successfully connected to a MSSQL server successfully
>
> with
>
> > SOCI
> >
> > > on linux?
> >
> > I forgot to include the error message:
> >
> > SOCI Common Tests:
> >
> > ODBC Error Code: IM002
> > Native Error Code: 0
> > SOCI Message: Error Connecting to database
> > ODBC Message: [unixODBC][Driver Manager]Data source name not found,
>
> and
>
> > no
> > default driver specified
>
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
