I recently upgraded from Access to SQL Server and have successfully imported my databases into SQL using the import function. I can view the tables and their contents in Enterprise Manager. I have also reset CF Adminstrator databases to the new sources and verified. My problem: The tables do not show up when listing db's in localhost. The Databases are listed but the tables don't show. Any suggestions as to a solution?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server Tables
- Thread starter AkronBoy
- Start date
The account that the CF service is running under needs to be an account in the database with rights to the tables. The CF verification only verifies that you connnected to the server, not that you have rights to the objects in any of the databases.
HTH,
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their coversation with Yiddish expressions.
HTH,
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their coversation with Yiddish expressions.
- Thread starter
- #3
I have all rights to the databases. They were written by me to start with. When I originally did the data import a while back, I inadvertently put them in the <default> database. The tables did actually show up at that point. I was told by our SQL experts that I shouldn't have done that, so went back and deleted them from <default> and set up actual databases in the following path: Console Root/SQL Server Group/(local)/Databases/. Really confounded by the problem.....
TruthInSatire
Programmer
I think the CF admin or the server it's on has a username that needs to be setup in the SQL server as well.
A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)
The question is, does the CF service account have rights to the database objects?
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.
- Thread starter
- #6
Thanks to everyone for responding. I finally figured it out.
When I added the SQL datasource using CF Administrator (Add new ODBC Source) I did not enter the DB name in the box next to Login Info. CF could not find the table info because of this omission. I also had to check the "Use Trusted Connection" box and use (local) as my laptop server name. Hope this might help others who have been using MS Access and now must switch to SQL.
When I added the SQL datasource using CF Administrator (Add new ODBC Source) I did not enter the DB name in the box next to Login Info. CF could not find the table info because of this omission. I also had to check the "Use Trusted Connection" box and use (local) as my laptop server name. Hope this might help others who have been using MS Access and now must switch to SQL.
- Status
Similar threads
- Locked
- Question