SQL.INI -- Configure to connect to remote SQL Server database

[Vik Chaudhary]

Hello all:

I didn't think that I would be posting a message on the Centura forum (I
used to work at the old Gupta, and I wonder if any of the old-timers there
are still around). Enough reminiscing, on to business...

I just got a product (net.db from Dataline) that allows me to build web
queries against ODBC databases. It uses SQLBase connectivity to connect to
Microsoft SQL Server, and I am trying to configure SQL.INI to talk to the
SQL Server database. Unfortunately, I don't have SQLTalk, so I cannot test
the connectivity (where do I get that gem of a product?).

So here's what I did:

1. SET UP A DSN
I set up a DSN on my machine to connect to a remote SQL Server, connecting
via an IP address (SQL Server is hosted for us on a remote machine). The DSN
name is MYDATABASE

2. ADDED ENTRIES TO SQL.INI
[win32client.dll]
comdll=sqlodb32
comdll=sqlapipe
;comdll=sqlws32 (commented this out)

[odbcrtr]
remotedbname=MYDB,DSN=MYDATABASE
odbctrace=on
odbctracefile=C:\Program Files\Dataline\netdb\odbctrce.log
;longbuffer=2048000 (commented out)
;buffrow=1 (commented out)

Next, I tried to connect, via net.db to the database MYDB and got an Access
Denied. I was able to connect to the database using Microsoft Access.

Any ideas? Thanks!

Vik Chaudhary
415-920-3921

[Pierpaolo Simoncini]

For connection with SQL Server with CTD (I suppose with net.db also) you
MUST specify username and password. For default sa user hava a null
password. Define your login by Sql Enterprise Manager (we use user SYSADM
with password SYSADM without problem)

Regards

Pierpaolo Simoncini
DOLPHIN s.r.l.
ITALY
"Vik Chaudhary" <v...@bizmetric.com> ha scritto nel messaggio
news:lZEUmr#XAHA...@talkto.centurasoft.com...

[Vik Chaudhary]

"Pierpaolo Simoncini" <sim...@dolphin.it> wrote:
> For connection with SQL Server with CTD (I suppose with net.db also) you
> MUST specify username and password. For default sa user hava a null
> password. Define your login by Sql Enterprise Manager (we use user SYSADM
> with password SYSADM without problem)

Thanks for the message. I have specified the username and password in the
System DSN, and I am able to use Microsoft Access to connect to the SQL
Server database using ODBC.

Do I have to set the username and password in my SQL.INI file also? Thanks.

--Vik Chaudhary
v...@bizmetric.com

[Pierpaolo Simoncini]

No, you specify only the keyword remotedbname if you want access with SQL
Talk. The syntax is:

[odbcrtr]
...
...
...
remotedbname=<your name>,DSN=<source name specified in ODBC Admin>

e.g.

remotedbname=ISLAND,DSN=ODBCISLAND

You connect ISLAND from SQL Talk with

CONNECT ISLAND user/password; + ctrl Enter

We use same name for our name and DSN (e.g. remotedbname=ISLAND,DSN=ISLAND)
For your application in CTD set SqlUser and SqlPassword normally.

Regards

Pierpaolo Simoncini
DOLPHIN s.r.l.
ITALY

"Vik Chaudhary" <v...@bizmetric.com> ha scritto nel messaggio

news:4I3#1rGYAH...@talkto.centurasoft.com...