da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Problem connecting to MSSQL 2005

Forum List » AnyDAC » v 1.x General English

JohnG
User

Fresh Boarder

Posts: 4

Karma: 0

Problem connecting to MSSQL 2005

Posted: 2006/10/02 22:12

On trying to connect to MSSQL 2005 databas I get
[AnyDAC][Phys][ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I can't seem to find the problem. Please help.

Diman

Admin

Posts: 1509

Karma: 20

RE: Problem connecting to MSSQL 2005

Posted: 2006/10/03 03:14

Hello !

1) Do you have specified DriverID ?
2) Could youpost here your connection definition (all parameters) ?

Regards,
Dmitry

JohnG
User

Fresh Boarder

Posts: 4

Karma: 0

RE: Problem connecting to MSSQL 2005

Posted: 2006/10/03 19:50

[MSSQL2005_Demo]
DriverID=MSSQL2005
Server=cyberserver
Database=network
User_Name=admin
Password=admin
MetaDefCatalog=network
MetaDefSchema=dbo

This is how it was setup with the wizard. The server , database,use name,password are correct. I don't know about the others. I am an Oracle boffin not MSSql, but now I have to work with it.

Regards

John

JohnG
User

Fresh Boarder

Posts: 4

Karma: 0

RE: Problem connecting to MSSQL 2005

Posted: 2006/10/03 19:54

[MSSQL2005_Demo]
DriverID=MSSQL2005
Server=cyberserver
Database=network
User_Name=admin
Password=admin
MetaDefCatalog=network
MetaDefSchema=dbo

I used the wizard to enter this info. The parameters look fine to me but I am not an expert on MSSQL, I am an Oracle boffin!

Regards

John

Diman

Admin

Posts: 1509

Karma: 20

RE: Problem connecting to MSSQL 2005

Posted: 2006/10/04 15:33

Hello

Ok.

3) Do you have SQL Native Client installed ? It is required to work with MSSQL 2005.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English