Re:Connection to MS-SQL
Go into the BDE Administrator, right-click on "Databases" in the tree-view
and select "New". Choose the "MSSQL" driver. "MSSQL1" will be highlighted in
the tree-view. Type in a name you want for the alias and press enter. On the
right-hand side (the properties window), enter the name of your SQL database
(i.e. "pubs" for the sample publishers database) into the "DATABASE NAME"
property. Enter the name of the SQL server computer into the "SERVER NAME"
property (just put a "." period character if the SQL server is on the local
machine). Click the "Apply" button on the toolbar and you have your MSSQL
alias. Then, double-click on the alias name in the tree-view to test it out.
A login will appear where you can enter your name and password.
Make sure you have the MS SQL client access libraries installed on the
client machine first. You can do this by running the MS SQL setup on the
client and unselecting all the install options except for "Client
Utilities".
Dave Prothero
Quote
Carlos Esparza <carlos_espa...@hotmail.com> wrote in message
news:87pb97$99b2@bornews.borland.com...
Quote
> I have D4 client/server, and I am just starting to use it.
> I've made a connection using the ODBC dirver for SQL Server.
> Maybe you could give me some extra information on using the 2nd option.
> Thank you for the information
> David Prothero <da...@removethenospam.prothero.com> escribi en el mensaje
> de noticias 87hvpk$6...@bornews.borland.com...
> > 2. Use the BDE and the "MSSQL" native BDE SQL Links driver. Requires
> > Client/Server or Enterprise version of Delphi.
