Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
josh2009
Yak Posting Veteran
81 Posts |
 Posted - 2009-06-09 : 14:16:09
|
| Trying to figure out my ODBC connections. I have set up an ODBC data source connection with SQL Server using the System DSN tab for my Crystal reports. After this has been set up, I tested the connection at the end of the set up by clicking on the Test Data Source and I get the message that the tests were successful. I then open up Crystal Reports but when I go to Data Explorer and expand the section for ODBC, when I click on the database, I only get one table. I should be getting a bunch of tables but instead I only get one. This one table that I have access to is a table which I had imported into SQL from Access. Next thing I do is go into MS SQL Server Management Studio and check the properties of my profile. I went into Security section of the database I'm trying gain access to and under the General tab, I have db_owner Database Role membership. I can't think of anything else right now so any help would be greatly appreciated. |
|
|
|
|
|
ODBC Connection for SQL Server