INI File

[paul102384]

Hi to All PB Programmers:

Looking for some help from the PB gurus out there!

I'm running PB 10.5 as my front-end and MS SQL Server 2005 as my back-end.

The problem is i encounter connection problem when i run my application.

I used INI file named (financial) to connect to MS SQL Server.

Here's the syntax for INI File

[DATABASE]
DBMS = MS SQL Server 6.x
Database=DB1
UserId=sa
dbpass=mgr
logpass=mgr
ServerName=MyServer
logid=sa
Lock=
DbParm=Connectstring='Log=0,SystemProcs=0'
Prompt=0


Also in my powerbuilder application, to get the information in INI file the script is


s_fileopen = 'C:\Sample\financial.INI'

SQLCA.DBMS = ProfileString(s_fileopen,"DATABASE","DBMS","")
SQLCA.Database = ProfileString(s_fileopen,"DATABASE","Database","")
SQLCA.UserId = ProfileString(s_fileopen,"DATABASE","UserId","")
SQLCA.dbpass = ProfileString(s_fileopen,"DATABASE","dbpass","")
SQLCA.logid = ProfileString(s_fileopen,"DATABASE","logid","")
SQLCA.logpass = ProfileString(s_fileopen,"DATABASE","logpass","")
SQLCA.ServerName=ProfileString(s_fileopen,"DATABASE","ServerName","")

when i check the sqlerrtext it says that "DBMS MSS Microsoft SQL Server 6.x is not supported in your current installation."

Thanks in advance,

 

[LunaRoja]

Try this link out:

http://www.sybase.com/detail?id=47750

LR