Re^6: Database connection issue

[Azard]

Thanks again, it definitely narrowed the issue down some more. The primary issue now is the following error: "Login failed for user 'myinfo' <SQL-28000> at script.pl line 12." "myinfo" in this case is the login name, including my school, for me to get on my laptop.

 my $data_source = "dbi:ODBC:AJsql";
my $username = "";
my $password = "";

my $dsn = "dbi:ODBC:Driver={SqlServer};SERVER=CND4290H26;Database=Game
+Info;
Trusted_Connection=Yes;";

my $dbh = DBI->connect($data_source, $username, $password)
            or die $DBI::errstr;

I added a bit more and went with the source code. Thing is, I don't have a username or password that are required to access the database. I just open the program and I'm in. Is it instead referring to putting the username and password needed to log onto my computer?

In the spirit of being thorough, I did attempt to put those details into the code (not putting them here for obvious reasons), but the error message is still the Login one.

[Corion]

This means that Perl is now talking to your database. I would now contact the system or database administrator and ask them how to authenticate to the database server. It seems that "integrated login" should work, but you seem to already supply the Trusted_Connection driver parameter. Maybe adding the domain name to your username or leaving it off changes things. Again, the database administrator should be able to look into the logfiles to tell you why your login attempt fails.

[Azard]

Okay, I'll have to ask when I see him next. Hopefully it won't be too late, heh. Thanks for all your help!