Re^5: Database connection issue

To get more information from DBI, use the ->connect call as it is documented in DBI:

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

This should output a bit more information.

Comment on Re^5: Database connection issue Select or Download Code

Replies are listed 'Best First'.
Re^6: Database connection issue by Azard (Initiate) on Nov 16, 2015 at 15:13 UTC
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;` [download] 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.	[reply] [d/l]
Re^7: Database connection issue by Corion (Patriarch) on Nov 16, 2015 at 15:20 UTC
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.	[reply] [d/l]
Re^8: Database connection issue by Azard (Initiate) on Nov 16, 2015 at 15:57 UTC
Okay, I'll have to ask when I see him next. Hopefully it won't be too late, heh. Thanks for all your help!	[reply]