Connection string - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

Dark_Light
No customer Topic Starter

2008-04-25T13:05:29Z

How should the connection string look? I cant get it to work

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

It depends..check out http://www.connectionstrings.com/

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

Dark_Light
No customer Topic Starter

2008-05-06T14:24:18Z

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

Support
Official support

2008-05-06T18:55:46Z

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!

Dark_Light
No customer Topic Starter

2008-05-06T21:05:08Z

administrative tools? in visualCron?

Support
Official support

2008-05-06T21:25:54Z

No, control panel in windows

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

Dark_Light
No customer Topic Starter

2008-05-06T22:42:11Z

how do I find the relevant path? File-DSN?

Support
Official support

2008-05-06T22:46:44Z

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!

Dark_Light
No customer Topic Starter

2008-05-06T22:47:57Z

what driver should I pick?

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!

Dark_Light
No customer Topic Starter

2008-05-06T23:00:47Z

#11

what should the provider tag contain? what's SQLOLEDB?

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!

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.

ABOUT VISUALCRON

Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Login