Thursday, 12 September 2013

Can I manually create database channel for rattle?

Can I manually create database channel for rattle?

I just got rattle to play around in and the first thing I wanted to do was
get some data from ODBC. There's an input for DSN which I entered but it
doesn't work. Specifically I get [RODBC] ERROR: state 28000, code 18456,
message [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user '' indicating that its trying to login with a blank username field.
I'm using Windows and in the ODBC control panel the user name I need is
already specified so I'm not sure how else I can get rattle to recognize
the correct user name.
I either need a way to create the ODBC channel myself with odbcConnect or
a way to specify the username in rattle. Can this be done?

No comments:

Post a Comment