Can't get my database tables into sharepoint

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database which I imported into sql server on my sbs 2003
premium sp1 server. This server is also hosting my sharepoint sites.

I'm trying to create a database connection from frontpage 2003 but I don't
get the tables listed for my database on the last step of the wizard. The
only databases that list tables are pubs and northwind. How can I get the
wizard to load the the tables form my database? the database imported into
sql successfully, by the way.
 
Did you import that Access database into the SharePoint DB, or its own DB?
If you imported into the SP DB, stop doing that immediately. Instead,
create a new DB to hold your Access DB, and connect via the usual conenction
settings in your code.
 
I right-clicked in the sql enterprise manager and slected import, and
imported all the tables from my access database to a new sql database called
SCC.

I can see the SCC database in the drop-down menu on the "select dtatabase
and table, view or stored procedure" page of the Configure Database
connection wizard in sharepoint. The problem is it doesn't list the tables
in the database so I can't select any tables to save the connection. This
database doesn't have a password or anything set so I have the connection set
for windows authentication right now, since nothing else gets me even this
far.

Is there something I'm doing wrong?
 
Back
Top