AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL connections and Office 2000

1 REPLY 1
Reply
Message 1 of 2
leon
149 Views, 1 Reply

SQL connections and Office 2000

Greetings,

I am a user of Autocad Map 4, NT 4. In the past, i have had no problems performing SQL connections to MS Access 97 files. Recently we have upgraded from Office 97 to Office 2000, and subsequently, when i attempt an SQL connection, i receive the following error message:

"SQL client unable to establish SQL connection, unrecognized database format .....mdb."

Any assistance anyone can provide will be much appreciated.

Best regards,

Leon
1 REPLY 1
Message 2 of 2
Anonymous
in reply to: leon

Change the .udl file provider to Microsoft Jet 4.0
OLE DB Provider

In Advanced options be sure the Persist Security
Info is false

--
Jim Claypool

href="mailto:jclaypool@kc.rr.com">jclaypool@kc.rr.com

 

 


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Greetings,

I am a user of Autocad Map 4, NT 4. In the past, i have had no problems
performing SQL connections to MS Access 97 files. Recently we have upgraded
from Office 97 to Office 2000, and subsequently, when i attempt an SQL
connection, i receive the following error message:

"SQL client unable to establish SQL connection, unrecognized database
format .....mdb."

Any assistance anyone can provide will be much appreciated.

Best regards,

Leon

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

”Boost