Connection string - VisualCron

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

Login