Kris
|
| Posted: 02/03/2002, 9:42 AM |
|
Can I use a SQL Server View instead of a Table in a form? I created one and I don't see it in the list of tables?
Any ideas?
|
|
|
 |
Nicole
|
| Posted: 02/04/2002, 7:04 AM |
|
Kris,
what type of connection do you use? What 'Type' have you selected on Site->Properties->Database tab. Try to use DSN type connection. In case you use Custom connection type what Provider have you selected in Data Link Properties window?
|
|
|
|
Kris
|
| Posted: 02/04/2002, 4:13 PM |
|
Nicole,
I am using type = DSN and a data source created using SQL Server.
Connection string type: same as design
Join style: ANSI SQL (left join/inner join)
Your help is appreciated !
|
|
|
|
Nicole
|
| Posted: 02/05/2002, 2:45 AM |
|
Kris,
try to play with connection settings. Try to use custom type of connection and select:
1. Microsoft OLE DB Provider for ODBC Drivers on Providers tab of Data Link Properties window
2. Microsoft OLE DB Provider for SQL Server on Providers tab of Data Link Properties window
|
|
|
|
