The road to learning ASP is a strange one...I have a simple SQL server database that I'm trying to read from...
The following code works perfectly in VFP:
*oConnection = CreateObject("ADODB.Connection")
*oConnection.Open("Driver=SQL Server;Server=SYNECTIC-DJ1HR3;Database=MSCDATA; * USERID = KEVIN; PASSWORD = 90125")
*oRecordSet = CREATEOBJECT("ADODB.Recordset")
*oRecordSet.Open('HierDtl',oConnection)
Once that code executes, I can successfully navigate through
and display values from a field.
However, the following code in an ASP page using VB Script...
*DIM oConnection
*SET oConnection = Server.CreateObject("ADODB.Connection")
*oConnection.ConnectionString = "Driver=SQL Server;
* Server=SYNECTIC-DJ1HR3;Database=MSCDATA; USERID = KEVIN; PASSWORD = 90125"
*oConnection.Open
...generates all types of errors about invalid login, or not associated with a trusted SQL Server, etc.
Same machine, same user logon, same connection string...it works within VFP 6, but not from VBSCRIPT...any ideas? (And if I should be posting this under a different forum, please let me know)
These are the days that make me wish I could pay someone like a JVP or Griver to sit in my office and answer my stupid questions!
Kevin
