Jump to content


Photo
- - - - -

Connecting to sql server with single developer


3 replies to this topic

#1 Anand

Anand

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 22 March 2006 - 06:29 AM

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

#2 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 22 March 2006 - 03:20 PM

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

#3 DARREN

DARREN

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 396 posts
  • Gender:Male
  • Location:Florida,USA

Posted 24 March 2006 - 09:19 PM

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
Things should be made as simple as possible, but not simpler

#4 Matthews Estrice

Matthews Estrice

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 241 posts
  • Gender:Male
  • Location:Henley-on-klip

Posted 26 March 2006 - 10:36 AM

Gentlemen,

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

Thanks ,
R.
Matthews



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users