Hi, this sounds very strange. EOModeler seems to find the "Master"-database, not the database your table "adress" is in. I tested EOModeler's "create model wizard" with a SQL-Server's "master" database: I also got the Information-Schema-views in Eomodeler's table-list. Your URL should look like:
jdbc:microsoft:sqlserver://xx.xx.xx.xx:1433;DatabaseName=MYDATABASE If you skip "DatabaseName", the driver picks the default Database: Master. Good luck! Frank > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > pple.com]O > n Behalf Of Ute Hoffmann > Sent: Sunday, January 29, 2006 6:38 PM > To: [email protected] > Subject: [OT?]Help needed with data access MS SQL Server > 2005/EOModeler > > > Hi, > I need some help with a connection to MSSQL Express 2005. I got a > running install Windows 2000 and in the same network a Mac Os X Tiger > with WO. All seems well, I can somehow access my Database through > monitor.... BUT > > I would like to get the tables I created (in this simple test > install a > table called adress)... but what I see in place when I connect to my > database through EOModeler (in the wizard, where one choses > the tables > one wants to connect to) is a huge number of sys.something and > INFORMATION_SCHEMA.something entries, but nothing of the > table I really > want to access. All those entries look to me like system tables. > > Is there anyone around who has experience with MSSQL Server > and WO who > perhaps can give me a hint what to do to get to the table I want to > connect to. > > Yes, the database exists, the table is in there, the user can > access it > in sqlcmd and select * from tablename gives back the correct data. So > where is this table when connecting by EOModeler? > > Is this a rights problem? I gave that user the rights on the > database. > Do I need to give it access to the table as well? > > It definitely has read access in the sqlcmd...I can see those values! > > Any clues? > > Thanks for any suggestion. > > Regards, > > Ute > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/webobjec ts%40symposion.de This email sent to [EMAIL PROTECTED] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
