>You have the meaing correct. Thanks. There seems to be some difficulty (probably in my understanding.. duh) on what I should be doing. Here is what I have done:
>
>1) DO CABUILDER.PRG
>2) DATABASE TYPE: SQL Server
>3) INTEGER WIDTH: (default)
>4) CLASS NAME: (default)
>5) DIRECTORY: \TEST
>6) SOURCE TYPE: ODBC
>7) PREFIX: (default)
>8) GENERATE NEW VCX FOR EACH TABLE
>8) FIELDS TO EXCLUDE: leave blank, just a test SQL Database.Table
>
>*-- note: I am not able to access the stored procedures area: it is all disabled
>
>9) Click Build. SQL Server Login window shows
>
>10) Click Options
>11) Identify Database
>
>At this point I get an error 1474 or 1476. This is regardless of any setting/combination I use on login, database, etc...
>Am I missing something?

YOu are doing everything correctly. I really can not help on the SQL Server login window because only you know how you have to connect to your SQL Server Database. If you are using a connection string to connect using SQLCONNECT or SQLSTRINGCONNECT, you need to look at those parameters to see what you need to enter in the login form. The easiest way is to create your connection the way you normally do, then issue the following at the Command Window:

? SQLGETPROP(lnHandle, "ConnectString")

Look for parameters like WSID [work station ID], Server and Database.