SQL Server 2008.

Question

Post reply

SQL Server 2008.

yusri1423

Valued Member

Points: 72
More actions
March 22, 2010 at 7:18 pm

#231110

SQL Server 2008
Login:sa
Password:12345
ODBC - Am I doing it correctly?

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

Looks fine? what is the question about?

Why are you using the Native Client driver?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

yusri1423 Valued Member Points: 72 More actions · Answer 2

Trying to make this 'Online Ticket System' run.

Kept getting this error.

Using Classic ASP, some say ODBC won't work with it.

Here's the system if wish to test it.

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

'Database coding commence

dim rs, sql, cn, Title, Body, DateTime

'Set connection details

set cn = server.CreateObject("ADODB.Connection")

cn.Open "DSN=Trains;UID=sa;PWD=;DATABASE=Trains"

no password hardcoded in you're asp page code?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

yusri1423 Valued Member Points: 72 More actions · Answer 4

If I add password;

cn.Open "DSN=Trains;UID=sa;PWD=12345;DATABASE=Trains"

Got this error;

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "Trains" requested by the login. The login failed.

/Trains/Main.asp, line 106

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 5

create a special account with the correct permissions to the DB, and

replace the login ID in the authentication with the new ID.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle