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

17 years ago

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

17 years ago

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

17 years ago

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 17 years ago | Reason: Not specified

Support
Official support

17 years ago

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

17 years ago

administrative tools? in visualCron?

Support
Official support

17 years ago

No, control panel in windows

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

Dark_Light
No customer Topic Starter

17 years ago

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

Support
Official support

17 years ago

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

17 years ago

what driver should I pick?

Support
Official support

17 years ago

#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

17 years ago

#11

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

Support
Official support

17 years ago

#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

17 years ago

#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.