Hi, If you want to use DSN file, you should run it in this way:
soci_odbc_test_access.exe FILEDSN=./test-mssql.dsn Tests recieve ODBC connection string as input parameter, see source code * Simon Walter <[email protected]> [Thu, 29 Dec 2011 00:28:28 -0900]: > 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 -- Regards, Stepanov Sergey XMPP: [email protected] ICQ: 200564264 SKYPE: sergey.y.stepanov mobile: +7(921)345-78-22 ------------------------------------------------------------------------------ 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
