Ranorex Studio, Spy, Recorder, and Driver.
-
paracelsus
- Posts: 25
- Joined: Thu Feb 26, 2009 3:21 pm
Post
by paracelsus » Mon Mar 16, 2009 9:32 am
Hello! How can I connect to a database and write data in a table? I try to use the following code:
Code: Select all
Public Sub connectDatabase()
Set cnWorkShop = New ADODB.Connection
With cnWorkShop
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Data Source=ServerName;Initial Catalog=posta;"
.Open
End With
But I got a lot of errors!
-
Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
-
Contact:
Post
by Support Team » Mon Mar 16, 2009 11:09 am
Please, post only Ranorex specifc questions in this forum. It's important to understand that we cannot support questions that do not relate to the Ranorex framework.
Thanks!
Regards,
Alex
Ranorex Support Team
-
paracelsus
- Posts: 25
- Joined: Thu Feb 26, 2009 3:21 pm
Post
by paracelsus » Mon Mar 16, 2009 12:19 pm
I understand it, but I know to do this connection with QTP without problem. I dont understand that why it is wrong in the Ranorex. This is the reason, that I wrote my question in the Ranorex forum.
-
Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
-
Contact:
Post
by Support Team » Mon Mar 16, 2009 1:50 pm
I would like to help you, but you need to post the errors that occur!
Please, have a look on the following website for the right connection string to your database:
http://www.connectionstrings.com/
The "Data Source" needs to specify your server name (e.g. "serverName\instanceName") and the "Initial Catalog" is the name of your database.
Regards,
Alex
Ranorex Support Team