3 replies to this topic

[Anand]

Hi,
I am new to the world of proiv.
i am using single developer and just cant figure how to connect to sql server.
any help will be highly appreciated.

thank you
@nand

[Joseph Bove]

Anand,

Let me give you some rudiments.

%winroot%\pro4.ini contains all of the environment settings - usually.

If your supporting multiple applications or installs on one box, you can make use of supplementary ini files. The command that indicates the presence of a supplemental ini is:

INIPATH=C:\ATC\PIV\VADDS.INI

This command would typically be found directly below a specific user section:

[USER VADDS]
INIPATH=C:\ATC\PIV\VADDS.INI

Once you figure out if you are using supplemental ini's or not, you need to place the following environment settings in the appropriate file:

SQL_DBNAME=your database
FILETYPE=SQLSERVE
CONNECTION=database user/database password

The final important piece in this puzzle is that you have to setup an ODBC Data Source in Windows. This will match the database name from SQL_DBNAME and elect the server to connect to.

It's a bit tedious to setup the first couple of times, but once you know all the pieces, it's much easier to do and can be somewhat automated.

Hth,

Joseph

[DARREN]

See Chapter 2 of the Windows Environment Guide and Chapter 6 of the Environment Guide for more information. The most important points to make are

Ensure that your collation Sequence is set correctly (see documentation)
Ensure that you set up your ODBC connection as a System (not user) DSN....AND you reference this Name in your connection string

[Matthews Estrice]

Gentlemen,

Would this configuration for ODBC be the same as I would establish connection on Oracle 10g EX on VIP?

Thanks ,
R.
Matthews