Get free live demo
Login
Cart
Home
Home
What is VisualCron?
Why choose VisualCron?
Our customers
Testimonials
Search
Social
Technology
Features
GENERAL
Features
Screenshots
API / SDK
Technology
ARCHITECTURE
Tasks
Triggers
Connections
AUTOMATION
General automation
Task Scheduler
FTP / SFTP/ SCP automation
Batch and exe automation
PowerShell automation
Cloud automation
Business Process Automation (BPA)
Encryption automation
SQL / database automation
Web macro recorder automation
Robotic Process Automation (RPA)
Managed File Transfer (MFT)
Extract Transform Load (ETL)
PDF automation and data extraction
XML automation and manipulation
Image automation and manipulation
Office 365, Excel and Macro Automation
Sharepoint automation
Archive automation
Virtual Machine Automation
Document scanning / OCR
ABOUT VISUALCRON
VisualCron is an
Automation
,
Integration
and
Task Scheduling Tool
for
Windows
.
Get free live demo
Download
Download
Change log
Requirements
Get free live demo
Order
Order
License guide
Choosing the right license
Basic vs Pro edition comparison
Cart
Get price quote
Use PO / get invoice
Return policy
Company information
Reseller information
Partners
Get free live demo
Support
Community forum
Documentation
Video tutorials
Maintenance & priority support
Contact us
Get free live demo
My pages
Start
My profile
My contacts
My licenses
My cloud Servers
My orders
Blog
Site map
Community forum
Support
Community forum
Welcome Guest! To enable all features please
Login
or
Register
.
×
Forum
Search
Login
Register
Login
×
User Name or E-Mail Address:
Password:
Caps Lock is on
Remember me
×
Forum
Support
General problem solving
Connection string
Connection string
Previous Topic
Next Topic
Tools
Email this topic
Watch this topic
Print this topic
Dark_Light
No customer
Topic Starter
2008-04-25T13:05:29Z
#1
How should the connection string look? I cant get it to work
Quick Reply
Reply
View All Posts by User
Sponsor
Forum information
Wanna join the discussion?!
Login to your Forum forum account
or Register a new forum account
×
Support
Official support
2008-04-25T16:40:43Z
#2
It depends..check out
http://www.connectionstrings.com/
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
Dark_Light
No customer
Topic Starter
2008-05-06T14:24:18Z
#3
it says:
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Mine looks like:
"Provider=Microsoft.Jet.OLEDB.4.0;Password= ;User ID= ; Data Source=" & Server.MapPath("c:/inetpub/wwwrot/browsergame/db/db12.mdb")
I don't know what's wrong...
Edited by user
2008-05-06T14:24:51Z
|
Reason: Not specified
Quick Reply
Reply
View All Posts by User
Support
Official support
2008-05-06T18:55:46Z
#4
Server.MapPath is a ASP.NET function and cannot be used in a connection string. I would create the connection string in the ODBC/OLEDB editor in Administrive tools. Then you can use the DSN name instead.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
Dark_Light
No customer
Topic Starter
2008-05-06T21:05:08Z
#5
administrative tools? in visualCron?
Quick Reply
Reply
View All Posts by User
Support
Official support
2008-05-06T21:25:54Z
#6
No, control panel in windows
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
Dark_Light
No customer
Topic Starter
2008-05-06T22:42:11Z
#7
how do I find the relevant path? File-DSN?
Quick Reply
Reply
View All Posts by User
Support
Official support
2008-05-06T22:46:44Z
#8
You use system dsn and use the name you want. You should put the name you use into VisualCron.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
Dark_Light
No customer
Topic Starter
2008-05-06T22:47:57Z
#9
what driver should I pick?
Quick Reply
Reply
View All Posts by User
Support
Official support
2008-05-06T22:51:19Z
#10
I don't know what database you use but probably the Microsoft Access driver.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
Dark_Light
No customer
Topic Starter
2008-05-06T23:00:47Z
#11
what should the provider tag contain? what's SQLOLEDB?
Quick Reply
Reply
View All Posts by User
Support
Official support
2008-05-06T23:04:41Z
#12
Actually I don't know as I am no expert on sql strings. But if you can't find it here:
http://www.connectionstrings.com/
I would test to use original string that you posted but with the absolute path to the .mdb file (and not use the ASP.NET function).
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
mars
Paid support
2008-05-07T22:38:45Z
#13
Hi, I have a little hint for you. With an UDL-File you can easy build connectionstrings.
Link to MSDN:
http://msdn.microsoft.com/en-us/library/e38h511e
(VS.71).aspx
After saving the UDL-File you can open the File with a notepad and copy the connectionstring in the SQL Task.
Quick Reply
Reply
View All Posts by User
Similar Topics
SQL - Connection String initialisation
(
API
) by
tom_v
2018-02-19T17:35:51Z
Get connection string from Connection object?
(
General problem solving
) by
DJacobsen
2016-06-02T00:44:01Z
Bug connection string with variables 7.7.6 -> 8.0.0
(
General problem solving
) by
Support
2015-11-26T20:55:08Z
Using Variable to determine connection string used for SQL task [6.1.1]
(
General problem solving
) by
Support
2012-09-19T18:32:07Z
Enhancement Request: Mask the database connection string so that it is not visible in plain text.
(
Feature requests
) by
nirchi
2009-04-23T03:24:52Z
Users browsing this topic
Guest
Forum
Support
General problem solving
Connection string
© VisualCron
Scroll to Top