Beantreeze

@Roger Cigol Yes, I think I will try compiling to 64-bit and open the database upon creation of the data module and see if that works for me. Otherwise, I'll have to make the changes on my old laptop then recompile 32-bit. Thanks all for the leg up!

I think you hit the nail on the head, @Brian Evans! It apparently does not list a 32-bit driver for Access. I hope I can download one. Thanks so much! I think you're on the right track, but I don't see a solution for this. I'm planning to check my previous laptop once it's charged. <so frustrating>

Applications are 32-bit, but they've always been 32-bit. I cannot even connect to the database within the Connection Editor. Would changing to 64-bit change that? I'll try it. No - did not change the issue in Connection Editor.

Yes, I am able to open and use the file in Access, obvi, but also Excel through ODBC, which is what FireDAC is using, right?

Hello - I recently upgraded to Delphi 12 & Windows 11 upon receiving a new laptop at work. I have some older applications that use Access databases, all with the ".accdb" file extension (most current Access format). The applications are essentially deprecated, as we have new software to manage the data. However, in the meantime, I need to maintain these older applications and their data. With my previous laptop and Delphi 11, I had no trouble using a FireDAC Connection to connect to my Access ".accdb" databases, once I installed the Access Database Engine. However, no such luck with my new laptop. Due to changes in the location of the databases (renaming of server and moving to new domain), I need to recompile these applications. The issue appears to be only due to the version of the database file, as I can convert the .accdb file to an .mdb file and open the .mdb file successfully with FireDAC whether it's on the server or on my local drive. However, I cannot open the .accdb file either place. I get this error: (I will avoid converting all my databases to .mdb, leaving that as a last resort). I'm wondering if it might have to do with 32-bit or 64-bit versions of Office/Access. I thought I had been using 64-bit Office on my former laptop, and I know I'm using 64-bit on my new one. Any suggestions? TIA Teri

I have a great MEA CULPA to issue to Embarcadero. I was told that if I installed Delphi/RAD Studio using "Run as Admin", that my regular account would have full access to Delphi. I thought for sure that I had done that the first time I installed Delphi, but apparently I had not. Before writing a long "diatribe" about how the installation messed up my use of Delphi and access to my SQL Servers, I tried one more time to install, after uninstalling, Delphi, using "Run as Admin". VOILA! Success. I hate when I get in my own way like this. My face will be red for a bit. (In my own defense, I have had trouble in the past not installing using my own credentials, then inputting the admin credentials upon prompting). Teri

Finally resolved the issue! (Though I'm not completely happy with the solution). After installing Delphi 12 Athens using my admin account, I tried running Delphi with my regular-access account, but there were no components, no list of Create New projects, no access to GetIt components. Though Installation help at Embarcadero assured me that any user would be able to use Delphi on my workstation after it was installed using the admin account, that was not the case. As I result, I have been running Delphi under my admin account. However, all of my Windows Credentials were created under my regular account. So, not too happy with Embarcadero right now.

@Die Holländer I tried the Select statement you gave me within SSMS and got this result: data source=ARSMOCOL3AQUARI;initial catalog=CSWQ_Data;trusted_connection=true I also tried using the actual number IP address for the server, but I got the same "... cannot contact a Domain controller..." error message. I'm wondering if I can specify an SPN (Server Principal Name) somewhere within the TFDConnection, or if that would help.

Here's the information from the Info tab: And, do you not understand Windows Credential or that it "seems" to work? It does work, substituting my credentials for the server when I try to attach using Windows authentication on every method except FireDAC. Also, I was able to connect using SQL Server authentication, but that's a non-starter for us, as we must use Windows authentication. Teri

BTW, I'm using Delphi 12 Athens on Windows 11 on my laptop.

Hello - I recently received a new laptop at work, and, for security purposes, the laptop and my credentials are in a different AD tree than my SQL Server. My laptop is under USDA.net, and the SQL Server is in the tree for the University where our offices are located. I've set up a Windows credential that seems to work, as I can connect my laptop to the SQL Server using SSMS, and I successfully set up a DataSource in ODBC using the 'ODBC Driver 18 for SQL Server'. I just have to make sure that the 'Trust Server Certificate' box is checked. However, when I place & test an TFDConnection to my SQL Server in Delphi, I'm receiving the message: The system cannot contact a domain controller to service the authentication request. Please try again later. To mimic the 'Trust Server Certificate' setting, I've added TrustServerCertificate=yes to the ODBCAdvanced setting in the FireDAC Connection Editor. [I get a '...certificate chain not trusted...' error when I omit that]. The connection seems to work for everything except FireDAC, and I'm at a loss as to what to do next. Any ideas?

That was my next move - to check the data types to make sure they're compatible. Also, I'm going to put some code in to output the results of the individual queries to a text file, to make sure they have data. I appreciate your replies.

Thank you for your reply. I am using MS SQL Server 2019. Normally I would not use a timestamp for joining, either, but that is the only unique number in each record of the text files. Also, though the column name is TIMESTAMP, it's actually a date/time value to specified to the minute. Would it be better to somehow add an integer identity column to the temporary tables to join? The only issue I might have with that is, while in theory the records in the values file match the records in the quality file, I should not assume that, I believe.

Hello - I think I must just be missing something, but I wrote some code that creates a list of strings setting up a transaction that writes data to a parent table and several child tables, linked by the key generated from the record in the parent table. (We have text files containing disparate data in a single record, all keyed by location and date/time. It had worked but now is not. I have done some editing of the code and tweaking of the table structures, but none I can think of that would cause the issue. The app loads the data from 2 text files into 2 temporary tables that are then queried in the sequence created in the transaction. I get all the records in the parent table, but none in any of the child tables. I'm at my wits end trying to figure out why it's not working. If someone can point me to something, even if it embarrasses me to no end, I'd be ever grateful. I have attached the generated transaction. Thanks. Teri SQLStr_Append.txt