btrieve error 2301

tchiloh · #1 (**permalink**) 02-05-10, 05:40

i have a error 2301 when i try to connect from oledb to pervasive server.

what do i wrong?

mirtheil · #2 (**permalink**) 02-05-10, 08:18

A 2301 is:

Quote:

2301: The database name is invalid
Not a named database. Verify you have entered a valid database name.

Make sure your connection string is pointing to a correct and valid database name.

tchiloh · #3 (**permalink**) 02-05-10, 09:32

I maked a client database: DATA.

DATA linked to data source name : DEMODATA.
this is my source code:

Code:

            string rdaOleDbConnectString = "Provider=PervasiveOLEDB;"
                                     + @"Data Source=DATA;"
                                     + "Location=SERVER4;"

i have not a password on the database, but i have error 2301

mirtheil · #4 (**permalink**) 02-05-10, 09:58

Is DATA a Pervasive Database Name or ODBC Data Source Name?
Just to be clear, DATA is defined on SERVER 4, correct?
Is this a Web or Windows Application?
What version of PSQL are you using?

tchiloh · #5 (**permalink**) 02-05-10, 10:11

it is a odbc data source name.
DATA are defined on SERVER4
it is a windows application.
i use Pervasive sql 8.6 with fixes for oledb (FTF).

mirtheil · #6 (**permalink**) 02-05-10, 10:39

The "Data Source" parameter needs to be the Database Name not an ODBC DSN. If the DATA ODBC DSN points to the DEMODATA database name, you should use DEMODATA in the connection string.

tchiloh · #7 (**permalink**) 02-05-10, 12:14

now i have this error: Invalid user authorization

mirtheil · #8 (**permalink**) 02-05-10, 12:23

Is that pointing to DEMODATA or your database? If it's your database, you probably have a Username/Password that needs to be sent on the connection string.

tchiloh · #9 (**permalink**) 02-05-10, 12:47

now i have this error: An error has occurred on the computer running IIS.

Code:

string rdaOleDbConnectString = "Provider=PervasiveOLEDB;"
                                     + @"Data Source=DEMODATA;"
                                     + "Location=SERVER4;"
                                     + "User ID=Master;"
                                     + "Password=test;";

mirtheil · #10 (**permalink**) 02-05-10, 12:51

I've never seen that error. Is there anything else to the error?

Keereweer · #11 (**permalink**) 02-15-10, 07:00

Quote:

Originally Posted by tchiloh

now i have this error: An error has occurred on the computer running IIS.

Code:

string rdaOleDbConnectString = "Provider=PervasiveOLEDB;"
                                     + @"Data Source=DEMODATA;"
                                     + "Location=SERVER4;"
                                     + "User ID=Master;"
                                     + "Password=test;";

Try this one (notice the 'dot'):
"Provider=PervasiveOLEDB.;"

Internet Services

Web Development

Digital Marketing

Consumer Tech