Book a Demo
« previous next »
Pages: [1]

Author Topic: Problems reverse engineering MSSQL DB  (Read 4153 times)

nexdev

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Problems reverse engineering MSSQL DB
« on: October 13, 2010, 09:57:03 pm »
Hi,

I'm attempting to generate a DB schema by reverse engineering an existing MSSQL DB.

However, when I attempt to import the tables from the DSN I have created I get an "Error retrieving table details" message and the following error is reported in the output window:

Error retrieving columns for table: syscolumns => [Microsoft][ODBC SQL Server Driver][SQL Server]Line 47: Incorrect syntax near 'p'.      

Has anyone come across this error before?

Thanks
Logged

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Problems reverse engineering MSSQL DB
« Reply #1 on: October 15, 2010, 08:09:44 am »
What version of MS SQL
What Driver and version?
Logged
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.

nexdev

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Re: Problems reverse engineering MSSQL DB
« Reply #2 on: October 15, 2010, 08:03:07 pm »
SQL version:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)


Driver version:

Microsoft SQL Server ODBC Driver Version 06.01.7600
Logged

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Problems reverse engineering MSSQL DB
« Reply #3 on: October 18, 2010, 08:20:40 am »
Works fine for me using EA build 863.
Logged
Pages: [1]
« previous next »