SQL ODBC / DSN Error

[Sparky]

Another one with same solution...

http://forum.unitedwebcoders.com/index.php/topic,632.msg4315.html#msg4315

Did anyone notify Alex yet to get his thoughts?

[cozilla]

sorry to be so late but yea it worked like a charm

thanks again

colin

[Paul Nolette]

I have used SQL2000 in the past and currently SQL2005. When using SQL you need to create a SQL user, grant this account db_owner rights to your TTX DB. Then create a System DNS in ODBC Data Source Administrator. The data source basically is the middle man for TTX to make the connection to your SQL Server.

I hope this helps and if you need me to elaborate on creating the SQL user or the ODBC connection let me know.

[gc]

Wow - I'm glad I checked back. Three little letters later, and I'm working like nothing was ever wrong - thanks 4499!

[sperreau]

Thanks too 4499!!!

Three letters changed and now I'm working fine with the SQL module as well:

And I made a change to the TTXMSSQLSetup.pm module here:
#
# Check if any ODBC DSNs defined
#
  my @dsns;
  if ($error eq undef) {
    @dsns = grep {s/^dbi:ODBC://} DBI->data_sources('ODBC');
    $error = "No ODBC DSN records found on this server.<br>Please configure DSN prior to running this program."

For the record I'm running:

• IIS on Windows Server 2003 with Serice Pack 2
• Stawberry Perl V5.10.0
• DBD-ODBC-1.16 - installed into Stawberry Perl

Yah! It works at last! Yah! yah!

[Sparky]

My next two questions...

1.  Should this be a permanent change?  Is there any Windows configuration out there that chokes on the lower-case now?

2.  Has anyone notified Alex of all this?