How to make SQL server connection using BDE
Ahmet Netone
administrator. can anybody help us to do this without using ODBC.
thanks in advance
J. M. De Moor
> We wish to define an alias for an sql server database using BDE
> administrator. can anybody help us to do this without using ODBC.
Assuming you have SQL Links (i.e., Delphi Enterprise): In BDE Admin select
Object|New... In the dialog box, change type to MSSQL. In the list view
definition, set DATABASE NAME to the database you wish to connect to, HOST
NAME to the name of your client computer, LANGDRIVER to "Borland ENG
Latin-1, SERVER NAME to the name of the SQL server computer and USER NAME to
a standard default, like "sa." Before saving, rename the object to the
alias you want.
Joe
birisi
We use MS SQL server V7.0 and I think we should use "SQL server" option from
the BDE administrators list. but there is no "server name" option in the
parameters list.
is there a difference between "MSSQL" and "Sql server" options
When we tried to cennect database fallowing your instructions we couldnt see
the list of servers from "server name" combo box, we wrote its name there
but we couldnt apply the changes (there was a red triangle on the left of
the databases name)
Whats wrong, we would be grateful if you help us.
regards.
Kevin Frevert
'MSSQL' is the BDE's SQL link and 'SQL Server' is the ODBC connection.
You will have to type the name of the server (or IP address) into the Server
Name. Once you make a change you will have to click the Apply button
(little blue arrow on the toolbar) to save the changes.
Good luck,
krf
birisi wrote in message <94mjjl$od...@bornews.inprise.com>...
J. M. De Moor
> We use MS SQL server V7.0 and I think we should use "SQL server" option
from
> the BDE administrators list. but there is no "server name" option in the
> parameters list.
The original request from Ahmet said he didn't want to use ODBC, which is
what the SQL Server option is for.
> When we tried to cennect database fallowing your instructions we couldnt
see
> the list of servers from "server name" combo box
BDE does not show a list of server names (well, mine shows DSQUERY, which is
of no use to me). That's why you have to enter one yourself.
> we wrote its name there
> but we couldnt apply the changes (there was a red triangle on the left of
> the databases name)
Did you try Ctrl+A after moving the cursor off of the SERVER NAME property?
The red triangle to which you refer is part of the icon in the tree view.
All paradox and MSSQL databases use this icon. (As opposed to, say, the MS
Access, FoxPro or Excel drivers, which have a little infinity symbol as part
of their icon.)
Joe
Anton Santa
I prefer loading the database-parameters from a file or blob-field of an
authentication (paradox-)table
myDb.Params.LoadFromFile('xx')
the params-file should show like
APPLICATION NAME=
BATCH COUNT=200
BLOB EDIT LOGGING=
BLOB SIZE=1000
BLOBS TO CACHE=32
DATABASE NAME=Gestac
DATE MODE=0
ENABLE BCD=FALSE
ENABLE SCHEMA CACHE=FALSE
HOST NAME=
LANGDRIVER=MSSGRWIN
MAX QUERY TIME=300
MAX ROWS=-1
NATIONAL LANG NAME=
OPEN MODE=READ/WRITE
PASSWORD=Gestac
SCHEMA CACHE DIR=
SCHEMA CACHE SIZE=8
SCHEMA CACHE TIME=-1
SERVER NAME=SABESOFT01
SQLPASSTHRU MODE=SHARED AUTOCOMMIT
SQLQRYMODE=SERVER
TDS PACKET SIZE=4096
USER NAME=Gestac
where you have to set your 'SERVER NAME', 'DATABASE NAME', 'USER NAME' and
'PASSWORD'; assigning the password and setting the 'LoginPrompt' of the
database-component to false prevents the password-dialog; also set
'DriverName = 'MSSQL'' to make it work.
So you can avoid creating an alias on every workstation.
Anton Santa
SABE SOFT
hmet Netone <ae...@netone.com.tr> wrote in message
94k50a$gc...@bornews.inprise.com...