I'm installing Gossamer Links for a client on a Win2003 dedicated server. I have gotten to the Gossamer Links Setup - SQL Information step.
Up to this point I have install MSSQL Express 2005 under default instance, not SQLEXPRESS instance, enabled sql authentication mode, enable named pipes and TCP/IP access protocols.
I'm rather new to PERL, I have run the following commands from the command prompt, based on the initial error messages:
ppm install DBD::ODBC
ppm install DBI
Now I am getting the following error message:
Error: Could not connect to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)
First question, will MSSQL Express 2005 work or do I need to use MSDE 2000?
Is there another command I need to run under PERL to specify a default driver?
I am currently using:
ActivePerl-5.6.1.638
DBD::ODBC 1.13
DBI 1.48
I have tried using localhost, 127.0.0.1, public IP, and box name in the SQL Hostname field.
Any help would greatly be appreciated.
Up to this point I have install MSSQL Express 2005 under default instance, not SQLEXPRESS instance, enabled sql authentication mode, enable named pipes and TCP/IP access protocols.
I'm rather new to PERL, I have run the following commands from the command prompt, based on the initial error messages:
ppm install DBD::ODBC
ppm install DBI
Now I am getting the following error message:
Error: Could not connect to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)
First question, will MSSQL Express 2005 work or do I need to use MSDE 2000?
Is there another command I need to run under PERL to specify a default driver?
I am currently using:
ActivePerl-5.6.1.638
DBD::ODBC 1.13
DBI 1.48
I have tried using localhost, 127.0.0.1, public IP, and box name in the SQL Hostname field.
Any help would greatly be appreciated.
MSSQL Express 2005 Install