Accessing a SQL DB from the web - ID's

From: Pete Ruby (pete.ruby@carris.net)
Date: 04/04/03 

From: "Pete Ruby" <pete.ruby@carris.net>
Date: Fri, 4 Apr 2003 11:17:31 -0500

I am creating a SQL DB for use w/ ColdFusion MX for the web. How do I go
about setting up a user in the SQL DB to access the DB over the web.
Currently, for all our SQL DB's we are using Windows Authenication. In CF,
I should be able to create an ODBC connection, and specify the
username/password, but it doesn't seem to work. If I look at an ODBC DSN
pointing to the SQL DB, it is using Windows Authentication. If I change it
to SQL, and put in a username password, that I have assigned to the DB, it
fails. So I am thinking I don't have SQL setup correctly in this area.

Thanx,
Pete

Relevant Pages

  • Re: AS400 to Access
    ... I have a vb program that opens an painfully slow ODBC connection to the 400 ... simply do an Insert for each record into our SQL server, ... > and internal employees I think some of the data will be able to be handled ... > adapter then update the Access OLEDB data adapter using the same dataset. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL server vulnerability through ODBC
    ... Look into Application Roles in SQL Server. ... You can grant the necessary select/insert/delete/update privileges to the ... from setting up an ODBC connection or some way in SQL administration to ...
    (microsoft.public.sqlserver.security)
  • Re: Use Group Policy to set ODBC
    ... Is there any way to automate the ODBC connection setup using group policy? ... Both solution can not provide SQL Authentication, ... Cahnge NameofServer + NameofDatabase ... PART "Driver:" EDITTEXT ...
    (microsoft.public.win2000.group_policy)
  • Access FE link to two SQL database using ODBC...
    ... I have an Access FE with tables link to two SQL BE using ODBC connection. ... password for the "other" SQL database. ... "trust Connection" and it works. ...
    (microsoft.public.access.forms)
  • Re: Using Projects saved in an ODBC database
    ... This is the first I've heard of anyone saving to a VFP database. ... The documentation I have only mentions SQL Server and Oracle. ... > error when I try to Open from an VFP8 ODBC connection. ...
    (microsoft.public.project)
Quantcast