Importing SQL Server Database Schema

Thread View: borland.public.together.integrations

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Natasha Mion Tue, 31 May 2005 14:13

#64

Author: Natasha Mion
Date: Tue, 31 May 2005 14:13

18 lines
1660 bytes

Hi,

I'm trying to import a SQL Server Database Schema into Borland Together 
Architect.   I've browsed the help files, but had no luck there.  What 
should the URL look like?

I am using the SQL Server 2000 drivers for JDBC (mssqlserver.jar).   JDBC 
Driver = sun.jdbc.odbc.JdbcOdbcDriver

We've keep getting the following error message: Failed to connect to MS SQL 
7.0 (ODBC):  Specified URL is not accepted by the driver.

What should the URL pattern look like?  Currently it is 
%prefix%@%host%:%port%/%database% which generates a URL like this: 
jdbc:microsoft:sqlserver:@localhost:1433/ARTSDB

Thanks in advance,
Natasha

Re: Importing SQL Server Database Schema

#65

Author: ElenaA
Date: Wed, 01 Jun 2005 07:45

37 lines
2354 bytes

Tg uses the standard sun.jdbc.odbc.JdbcOdbcDriver delivered with Sun JDK to 
work with MS SQL server... You need to register ODBC data source to be able 
to work with it. Use ODBC Data Source Administrator to register it (Control 
panel/Administrative tools/Data Sources (ODBC)).

In Tg open default profile for MSSQL Server.
JDBC driver should be 'sun.jdbc.odbc.JdbcOdbcDriver '
Leave 'Driver location' field empty.
URL pattern should be %prefix%%database%
Prefix: jdbc:odbc:
Database: specify ODBC datasource name as a database name
Host & Port should be empty (driver will retrieve needed information from 
the ODBC data source)



"Natasha Mion" <nmion@ucssm.com> wrote in message 
news:429c7137@newsgroups.borland.com...
> Hi,
>
> I'm trying to import a SQL Server Database Schema into Borland Together 
> Architect.   I've browsed the help files, but had no luck there.  What 
> should the URL look like?
>
> I am using the SQL Server 2000 drivers for JDBC (mssqlserver.jar).   JDBC 
> Driver = sun.jdbc.odbc.JdbcOdbcDriver
>
> We've keep getting the following error message: Failed to connect to MS 
> SQL 7.0 (ODBC):  Specified URL is not accepted by the driver.
>
> What should the URL pattern look like?  Currently it is 
> %prefix%@%host%:%port%/%database% which generates a URL like this: 
> jdbc:microsoft:sqlserver:@localhost:1433/ARTSDB
>
> Thanks in advance,
> Natasha
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads