RE: [OT?]Help needed with data access MS SQL Server 2005/EOModeler
RE: [OT?]Help needed with data access MS SQL Server 2005/EOModeler
- Subject: RE: [OT?]Help needed with data access MS SQL Server 2005/EOModeler
- From: "Ruenagel, Frank" <email@hidden>
- Date: Sun, 29 Jan 2006 20:02:32 +0100
- Thread-topic: [OT?]Help needed with data access MS SQL Server 2005/EOModeler
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: webobjects-dev-bounces+webobjects=email@hidden
> [mailto:webobjects-dev-bounces+webobjects=symposion.de@lists.a
> pple.com]O
> n Behalf Of Ute Hoffmann
> Sent: Sunday, January 29, 2006 6:38 PM
> To: email@hidden
> 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@hidden)
> Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden