Can't connect to MSSQL or get ODBC connector to work...

[descott]

Hi;

I'm new to the forum & Apatar, but am very excited about the application - I have about 30 CSV files (exported from an old old SQL database) that I need to import to MSSQL and "rewire" primary/foreign key relationships. I think Apatar is exactly what cna handle this monumental task...

I can configure the CSV files fine with the "TextFile" function, but I am having trouble connecting to a MSSQL database (SQL2008R2) - the database is a named instance, and I don't see anywhere I can configure that. I'm getting a connect error.

I also read in this forum about creating an ODBC data source, so I made a System DSN and tested the connection (works fine), but am getting a "Invalid string or buffer length" error - I *think* it's loggin in okay, b/c I'm not getting "login failed."

Any advice from the gurus out there?

Thanks;
Don