Thanks for the reply Scott.
I realize that you can use either Forms or Views
but it appears that when using SQL Server, all
that is available are the forms (these are the only icons
that appear under the "Tables" view in SQL Enterprise
Actually, I did some more playing around today with SQL
Server and tried to create a DTS (Data Transformation Service)
package and when I examined the completed SQL script I
noted something very odd...... It appears the Notes SQL Driver
returned the Notes Field's HELP DESCRIPTION rather than the
Say I have a field in my Notes form named 'FirstName'
and in the Help Description for this field (in design mode) I type
'Please enter the first name for this customer'. When using
the Notes SQL driver connection with SQL Server and look
at the fields, I DO NOT see FirstName as an available field
but rather the HELP DESCRIPTION:
'Please enter the first name for this customer'
So the auto generated SQL statement looked something like:
"SELECT Please enter the first name for this customer FROM
As you can imagine, this won't work!!!
Why is this happening???
I created another System DSN using the Notes SQL Driver
and mapped it to another Domino database. This one works
fine (I can use the FIELD NAMES in my query and it works). The
only difference I can see here is that I never entered any HELP
DESCRIPTIONS for my fields.
On the original database (the one giving me the problems), I went
into a few of the fields and REMOVED the HELP DESCRIPTION
but despite that, the query STILL FAILS and gives me the following error
"Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'ResourceName'."