Connecting to SQL Server...

[ramyav]

Hi,
Im trying to connect to an SQL Server database. I've set the databasename property, drivername property and the params property for the TDatabase. But Im unable to connect. The help manual says that if I provide these, I needn't provide an aliasname. But this isn't working. Any ideas??? Im using Delphi 3.0 Client/Server Suite.

Thanx.

[ramyav]

anyone???

[selma]

create an alias with BDE and write SQL SErver database name as databasebame,SQL Server name as Servername,SQLserver username as username.
username is generally "sa" if you didnt change it

so apply updates and open alias, if it opens, it meams it is connected to the server

selma

[ramyav]

I dont have a problem connecting to SQL Server from the BDE administrator...its when I try to connect via my code when I have the problem. Im using Delphi 3. Is it compulsory that I use a BDE alias to connect???

[selma]

I dont know any way apart from using BDE or ADO Components to connect SQL Server.
Standart ADO components are in Delphi5.
I use BDE and standart TTable,TQuery not ADO components.

Maybe its useful you try to connect via BDE

take it easy


selma

[ramyav]

thanx selma