I am trying to set up MetaTraffic2 and use the Microsoft SQL server that is located on the same server as the ASP page. I created a new database called metatraffic.mdb and when I fill out the setup page with all the information and click to submit it, I get the following error:
MetaTraffic Setup
STEP 1: Connecting to new database...FAILED
There was a database error:
Number: -2147467259
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'metatraffic2.mdb'. Login fails.
Go back and try again.
Any help in getting past this will be greatly appreciated.
Thanks,
Alan
MS SQL Setup Error
Hi Alan,
Why are you calling the database name .mdb, mdb files are usually for MS Access not SQL Server. If you called the database name (not the file name) metatraffic.mdb, then you need to specify that in the setup. Below you state that you created a database called metatraffic.mdb but in the error message it says you specified metatraffic2.mdb as your database name.
When using SQL Server, I would recommend you use database names without a file extension as it is less confusing and there is no need to have the .mdb in the name, that is only required for file names.
Regards,
~Chad