Unable to connect .Net application with DSN connection.

Posted By NeerajK over 9 years ago

Hello,

I am trying to connect .net application with DNS connection. I am getting below error message

ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed

Below is my .net application code:

               OdbcCommand cmd;
                OdbcConnection cn;
                string MyString = "SELECT * FROM CI_Item";

                cn = new OdbcConnection("DSN=CR2MAS90; UID=UserId;PWD=Password; Directory=D:\\ACCT\\2014\\MAS90; Prefix=D:\\ACCT\\2014\\MAS90\\SY\\, D:\\ACCT\\2014\\MAS90\\==\\; ViewDLL=D:\\ACCT\\2014\\MAS90\\HOME; Company=CR2; LogFile=\\PVXODBC.LOG; Debug=1; DirtyReads=1; BurstMode=1; StripTrailingSpaces=1; SERVER=NotTheServer");

                cmd = new OdbcCommand(MyString, cn);
                cn.Open();
                Console.WriteLine("Database is connected............");
                cn.Close();

Please guide us....

Parents

0 dlech over 9 years ago

My connection string looks like this:

DSN=SOTAMAS90;Directory={0};CacheSize=4;DirtyReads=1;BurstMode=1;EnforceDouble=1;StripTrailingSpaces=1;SILENT=1;SERVER=NotTheServer;uid={1};company={2};pwd={3}

I use the string.Format () function to substitute the values in the curly braces.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie over 9 years ago in reply to dlech

CacheSize=4;DirtyReads=1;BurstMode=1 This part is really not needed and should be removed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 NeerajK over 9 years ago in reply to BigLouie

Its something with MAS90 ODBC Drivers, I am working on windows 2013 64-bit server and SOTAMAS90 DSN is 32 bit.

Is there 64 bit MAS90 ODBC drivers available?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie over 9 years ago in reply to NeerajK

Yes, it's in another folder on the server. During installation both a 32 and 64 bit are installed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 RobertatSage over 9 years ago in reply to NeerajK

Hi NeerajK, as Big Louie stated, we do have one for versions 2013 and higher (which it looks like you're on based on your "D:\\ACCT\\2014\\MAS90\" path).

The path for the installer is:

..\MAS90\wksetup\Prerequisites\64Bit ODBC
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 RobertatSage over 9 years ago in reply to NeerajK

Hi NeerajK, as Big Louie stated, we do have one for versions 2013 and higher (which it looks like you're on based on your "D:\\ACCT\\2014\\MAS90\" path).

The path for the installer is:

..\MAS90\wksetup\Prerequisites\64Bit ODBC
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 100

Unable to connect .Net application with DSN connection.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING