UNI Dac Demo with SQL Server
UNI Dac Demo with SQL Server
I am reviewing the demo UNI application from your website. I can log onto Oracle, but I am not able to log into SQL Server.
This is a screen shot of my log in using MS SQL Server Management Studio:
How do I log into the demo app using the above login?[/img]
This is a screen shot of my log in using MS SQL Server Management Studio:
How do I log into the demo app using the above login?[/img]
Hello,
Please try using the following code:, and check if you can connect. If you cannot connect using this code, please specify the exact error that occurs.
Please try using the following code:
Code: Select all
UniConnection.ProviderName := 'SQL Server';
UniConnection.Server := 'JRHEISLER-PC\SQLEXPRESS';
UniConnection.SpecificOptions.Values['Authentication'] := 'auWindows';
UniConnection.LoginPrompt := False;
UniConnection.Open;
BTW, I sent an email to your sales@ email:
My name is Jeff Heisler. I work for a small US company, and we are in the process of converting a large fat client Oracle client (Delphi 7, DOA Oracle Components (dataset/query...))
We purchased RemObjects Data Abstract for our long range cross database support. But right now, we are in a huge time crunch to convert straight to sql server.
My question is, do you have some sort of cross marketing thing with RemObjects, or do I need to purchase your sql server components separately? More importantly, are your components well suited for a component level swap out with DOA components?
We are rather desperate, and extremely time sensitive.
Thank you in advance!
Jeff Heisler
[email protected]
909.589.0303
Is there a way to have a conversation at devart?
My name is Jeff Heisler. I work for a small US company, and we are in the process of converting a large fat client Oracle client (Delphi 7, DOA Oracle Components (dataset/query...))
We purchased RemObjects Data Abstract for our long range cross database support. But right now, we are in a huge time crunch to convert straight to sql server.
My question is, do you have some sort of cross marketing thing with RemObjects, or do I need to purchase your sql server components separately? More importantly, are your components well suited for a component level swap out with DOA components?
We are rather desperate, and extremely time sensitive.
Thank you in advance!
Jeff Heisler
[email protected]
909.589.0303
Is there a way to have a conversation at devart?
We don't have any agreements with RemObjects, you have to buy our components separately.My question is, do you have some sort of cross marketing thing with RemObjects, or do I need to purchase your sql server components separately?
We constantly improve UniDAC and add new functionality to it, so we think you will find our components appropriate for replacing DOA components. UniDAC has a lot of features, you can find more information about them here: http://www.devart.com/unidac/features.htmlMore importantly, are your components well suited for a component level swap out with DOA components?
UniDAC provides unified access to a lot of database servers, such as SQL Server, Oracle, MySQL, InterBase, Firebird, PostgreSQL, SQLite, NexusDB, and others. If you want to use server-specific features of SQL Server and Oracle, it's better to use SDAC and ODAC. You can try using UniDAC, SDAC, and ODAC trial versions to check which components are more suitable for you.
Thanks for the info. We are trying to come up with a single solution for Oracle and SQL Server, so I'll give UniDAC a shot.
Now if I can only get it installed.
I posted this, this am:
http://www.devart.com/forums/viewtopic. ... 13&start=0
Now if I can only get it installed.
I posted this, this am:
http://www.devart.com/forums/viewtopic. ... 13&start=0
I have already answered you there.I posted this, this am:
http://www.devart.com/forums/viewtopic. ... 13&start=0
I finally have the components installed, and have my boss ordering them with source.
I did run into something. If I go to use the UniConnectForm, and leave the username/password blank, I get an error message of:
Project CMStatV6.exe raised exception class EMSError with message 'Login failed for user 'sa'.'. Process stopped. Use Step or Run to continue.
You told me earlier how to log in using SQL Server as:
UniConnection.ProviderName := 'SQL Server';
UniConnection.Server := 'JRHEISLER-PC\SQLEXPRESS';
UniConnection.SpecificOptions.Values['Authentication'] := 'auWindows';
UniConnection.LoginPrompt := False;
UniConnection.Open;
Does this mean I can't use UniConnectForm?
I did run into something. If I go to use the UniConnectForm, and leave the username/password blank, I get an error message of:
Project CMStatV6.exe raised exception class EMSError with message 'Login failed for user 'sa'.'. Process stopped. Use Step or Run to continue.
You told me earlier how to log in using SQL Server as:
UniConnection.ProviderName := 'SQL Server';
UniConnection.Server := 'JRHEISLER-PC\SQLEXPRESS';
UniConnection.SpecificOptions.Values['Authentication'] := 'auWindows';
UniConnection.LoginPrompt := False;
UniConnection.Open;
Does this mean I can't use UniConnectForm?
For the time being TUniConnectForm doesn't support server-specific connection options. We plan to add such functionality in the future, but we cannot provide any timeframe. To avoid this problem, you can write your own connection form. Please take a look at the example of such connection form in the UniDACDemo->ConnectDialog demo.