This question is locked. New answers and comments are not allowed.
I am evaluating DevCraft to work with Advantage Database Server v10.0. Prior to installing DevCraft, I installed the Advantage .NET Data Provider and successfully wrote a test Console program that connected to the Database, Read data, and Updated data. However, I am having trouble creating a Data Access Class Library project choosing 'Populate from Database', choosing 'Advantage Database Server' as my backend, leaving Model name to the default, and then using the same connection string to 'Set Connection Manually'.
It appears to connect to the server, because if I enter the user id or password incorrectly I receive an ADS generated error code, however, once I do enter the connection string (what appears to be correctly), the new Domain Model Wizard either hangs on (Reading Schema) or gives me the following message:
Unable to retrieve the database schema information. Reason: Unable to obtain index column(s) information. This can happen if no password is provided when connecting to a database that is created with a password. Please provide a valid username and password for the connection.
One concern I had was that I was using the wrong Driver from ADS. I downloaded the 9.10 Data Provider from ADS and added to the GAC using gacutil.exe, however, had the same results once this was done.
Does reading the schema require an adssys user id?
I'm admittedly a novice with these tools and with Visual Studio. Any help would be appreciated.
It appears to connect to the server, because if I enter the user id or password incorrectly I receive an ADS generated error code, however, once I do enter the connection string (what appears to be correctly), the new Domain Model Wizard either hangs on (Reading Schema) or gives me the following message:
Unable to retrieve the database schema information. Reason: Unable to obtain index column(s) information. This can happen if no password is provided when connecting to a database that is created with a password. Please provide a valid username and password for the connection.
One concern I had was that I was using the wrong Driver from ADS. I downloaded the 9.10 Data Provider from ADS and added to the GAC using gacutil.exe, however, had the same results once this was done.
Does reading the schema require an adssys user id?
I'm admittedly a novice with these tools and with Visual Studio. Any help would be appreciated.