SQL Server Columns

[jamoparisi]

I had been using Microsoft Access as my database, but recently decided that i'll need an SQL Server database to meet my needs. When I was using the Access database I could use the Insert Record feature. After I selected the connection,(In the Insert Record Box) the tables and their respective columns appeared. After that I could just match up the columns with my form fields. Since I've started using SQL Server, I can see the tables in my database, but not the columns. Since I'm not an SQL programmer I heavily relied on this feature. Is there any way I can get the program to see the column of an SQL Server database?

Any help is greatly appreciated!!

Thanks,

James

 

[Cheech]

The recordset popup should enable you to open the tables up by clicking the "+" to see field names.
There was some issues with DWMX not seeing the DSN's on the remote server and we had to install IE 5.5 to get it to work on our dev server.

If not try a reinstall?? The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[ScottNeth]

Check your DNS - I run coldfusion so this may not be applicable to your situation, but I know the CFAdministrator has to have the DNS also - those table columns should show up. Scott Neth
Web Designer/Cyberpunk